View of Data MCQs with Answers PDF Download – Test 106

MCQ 526: The term that describes the database design at the physical level, is known as:

1. Logical schema
2. Physical Schema
3. View Schema
4. Virtual Schema

MCQ 527: In A4 search algorithm, selection operation can specify an equality condition by using a:

1. Secondary index
2. Clustered index
3. Nonclustered index
4. Primary index

MCQ 528: The schema of the database can be expressed graphically by a/an:

1. Relational diagram
2. Object-based diagram
3. Semi-structured diagram
4. Entity relationship diagram

MCQ 529: The recursive queries should not use not exists on a recursive view used by:

1. Subdomain
2. Subset
3. Subquery
4. Subprocess

MCQ 530: The query for finding the department names of all instructors, with duplicates would be:

1. define all dept name from instructor;
2. select dept name all from instructor;
3. define dept name all from instructor;
4. select all dept name from instructor;