Database Management System Mock Test 7

10%

Question 1 of 10

1. Pipelines can be executed in

Question 1 of 10

Question 2 of 10

2. If an index is _________________ the metadata and statistics continue to exists

Dropping

Altering

Disabling

Both Disabling and Dropping

Question 2 of 10

Question 3 of 10

3. The Average case occur in linear search algorithm

When Item is the last element in the array

When Item is somewhere in the middle of the array

When Item is the last element in the array or is not there at all

When Item is not in the array at all

Question 3 of 10

Question 4 of 10

4. How many join types in join condition:

Question 4 of 10

Question 5 of 10

5. Which of the following schemas does define a view or views of the database for particular users?

Physical schema

Internal schema

Conceptual schema

External schema

Question 5 of 10

Question 6 of 10

6. The relationship between DEPARTMENT and EMPLOYEE is a

Many-to-many relationship

Many-to-one relationship

One-to-one relationship

One-to-many relationship

Question 6 of 10

Question 7 of 10

7. Incase the indices values are larger, index is created for these values of the index. This is called

Multiple index

Multilevel index

Pointed index

Sequential index

Question 7 of 10

Question 8 of 10

8. In B+ tree the node which points to another node is called

Final node

External node

Leaf node

Internal node

Question 8 of 10

Question 9 of 10

9. A tablespace is further broken down into ________

Segments

Tablespace

Blocks

Extents

Question 9 of 10

Question 10 of 10

10. The goal of hashing is to produce a search that takes

O(n log n ) time

O(1) time

O(log n ) time

O(n2 )time

Question 10 of 10