Querying database part 3 - DBMS Questions and Answers

1.

____________ requires that data should be made available to only authorized users.

   A.) Data integrity
   B.) Privacy
   C.) Security
   D.) None of the Mentioned

Answer: Option 'C'

​Security

2.

___________ is a combination of two of more attributes used as a primary key

   A.) Composite Key
   B.) Alternate Key
   C.) Candidate Key
   D.) Foreign Key

Answer: Option 'A'

Composite Key

3.

___________ is a special type of stored procedure that is automatically invoked whenever the data in the table is modified.

   A.) Procedure
   B.) Trigger
   C.) Curser
   D.) None of the Mentioned

Answer: Option 'B'

Trigger

4.

Which of the following is not the function of client?

   A.) Compile queries
   B.) Query optimization
   C.) Receive queries
   D.) Result formatting and presentation

Answer: Option 'B'

Query optimization

5.

_____________ joins are SQL server default

   A.) Outer
   B.) Inner
   C.) Equi
   D.) None of the Mentioned

Answer: Option 'B'

Inner

Querying database part 3 - DBMS Questions and Answers Download Pdf