DBMS MCQ 05

1.      Which is one of the major important components of the relational database:

a.       Query execution

b.      Query process

c.       Query optimizer

d.      Query transaction

2.      Which is refers to the process of restoring the data that has been stored in a compter:

a.      Retrieve

b.      Backup

c.       Recovery

d.      Deadlock

3.      Query processing refers to technique of maintaining managing and manipulating data stored with in the computer system by using____ queries:

a.       DBMS

b.      RDBMS

c.       SQL

d.      None of these

4.      How many major stages of query processing:

a.       1

b.      2

c.       3

d.      4

5.      Which are the major stages of query processing:

a.       Query execution

b.      Query optimizer

c.       Both

d.      None

6.      In query processor which ordering is related to hash joins by SQL server 7.0:

a.      Interesting ordering

b.      Index intersection

c.       Index joins

d.      Parallel queries

7.      Which Microsoft SQL server makes selection of the most appropriate index every table even if there are many predicates in the query:

a.       Microsoft SQL server6.0

b.      Microsoft SQL server6.5

c.       Microsoft SQL server7.0

d.      Microsoft SQL server7.5

8.      Which is implement it to the index intersection in index joins:

a.       SQL server6.0

b.      SQL server6.5

c.       SQL server7.0

d.      SQL server7.5      

9.      Which server can joins the indexes when only multiple indexes combined can cover the query:

a.      SQL

b.      DBMS

c.       RDBMS

d.      All of these

10.  How many types of disk I/O:

a.       1

b.      2

c.       3

d.      4

11.  In which is types of I/O disk:

a.       Random I/O

b.      Sequential I/O

c.       Both

d.      None

12.  Choosing for large and non-indexed tables, specifically for intermediate results can be termed as__________:

a.      Hashing

b.      Parallelism

c.       Disk

d.      Deadlock

13.  SMP stands for:

a.       System multi-processing

b.      Server multi-processing

c.       Symmetric multi-processing

d.      Securing multi-processing

14.  Which in the database which is a software component in the RDBMS that carries out analysis of SQL statement for finding the best way for its execution:

a.        Query execution

b.      Query process

c.       Query optimizer

d.      Query transaction

15.  Which can be defined as the method in which the selected plan is executed at the query optimization stages:

a.      Query execution

b.      Query process

c.       Query optimizer

d.      Query transaction

16.  Which refers to technique of maintaining, managing and manipulating data store within the computer system by using SQL queries:

a.       Query execution

b.      Query processing

c.       Query optimizer

d.      Query transaction

17.  Which is the method of processing the plan selected throughout query optimization:

a.      Query execution

b.      Query process

c.       Query optimizer

d.      Query transaction

18.  Which refers to a property of computer to run several operation simultaneously and possible as computers await response of each other:

a.      Concurrency

b.      Deadlock

c.       Backup

d.      Recovery

19.  Which is refers to a stalemate situation due to which no further progress is possible as computer await response of each other:

a.       Concurrency

b.      Deadlock

c.       Backup

d.      Recovery

20.  Which is a duplicate copy of a file program that is stored on a different storage media than the original location:

a.       Concurrency

b.      Deadlock

c.       Backup

d.      Recovery

21.  Which is duplication of computer operations and routine backups to combat any unforeseen problems:

a.       Concurrency

b.      Deadlock

c.       Backup

d.      Recovery

22.  Optimization that is basically related to the rewriter module is termed as__________:

a.      Semantic query optimization

b.      Global query optimization

c.       Both

d.      None

23.  Optimization basically related to the Rewrite module is termed as_______:

a.      Semantic query optimization

b.      Global query optimization

c.       Both

d.      None

24.  Database security helps organizations to protect data from_____:

a.       Internal users

b.      External users

c.       Non-external users

d.      Non internal users

25.  Copying files to secondary or specific devices is known as______:

a.       Retrieve

b.      Backup

c.       Recovery

d.      Deadlock

26.  How many types of recovery control techniques:

a.      2

b.      3

c.       4

d.      5

27.  Which are types of recovery control techniques:

a.       Deferred update

b.      Immediate update

c.       Both

d.      None