DBMS - (U18CA404) Remedial Coaching Test1

Select * from employee where country=‘India’ .This query is used to ___________.

• Update
• delete
• retrieve
• both A and B

Data about data is called _____________.

• database
• metadata
• data dictionary
• both A and C

In the database system _______________ Operations are performed.

• datele
• retrieve
• insert
• all the above

The following ____________ type is one of the relationship.

• many-to-many
• one-to-many
• one-to-one
• all the above

Which of the following is an advantage of using database system?

• security enforcement
• avoidance of redundancy
• reduced inconsistency
• all of these

A record is a collection of ______________.

• entity
• fields
• files
• all the above

____________are very important component of DBMS.

• backup
• recovery
• Both A and B
• None of them

Network failure occurs where _________ database servers are connected to common network.

• Single
• Multiple
• Both A and B
• None of them

Vertical fragment group together ____________ in a relation

• attribute
• record
• data
• information

What SQL clause is used to restrict the rows returned by a query?

• AND
• WHERE
• HAVING
• FROM