Basic Structure of SQL Queries Quiz Questions and Answers PDF Download eBook p. 412

MCQ: The query for finding the Distinct department names of all instructors, would be

1. select distinct dept_name from instructor;
2. select dept_name distinct from instructor;
3. define dept_name distinct from instructor;
4. define distinct dept_name from instructor;

MCQ: SQL statements can be embedded with in general-purpose programming languages, like

1. C
2. C++
3. JAVA
4. All of the Above

MCQ: A relation may include the primary key of another relation, among its attributes, known as

1. Neighbor key
2. Foreign key
3. Candidate key
4. Super key

MCQ: The basic operations of relational algebra includes Select, project, union, set difference, Cartesian product, and

1. Rename operation
2. Dimensional operations
3. OLAP operations
4. Cube operation

MCQ: When multiple transactions update the system concurrently, to ensure the consistency of the database, is the responsibility of

1. Concurrency-control manager
2. File manager
3. Buffer manager
4. Authorization manager