View of Data MCQs (Multiple Choice Questions) PDF Download - 106

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

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

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

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

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

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;