CS403 Quiz 3 Set 2

Q1. Which of the following is NOT related to partitioning and placement in database?

1. Balance workload
2. Reduce workload
3. Speed up the rate of useful work
4. Speed up data transmission

Correct answer: Speed up data transmission

Q2. The Select operation works horizontally on the table, on the other hand the ___________________ operates on a single table vertically.

1. Select Operator
2. Binary operator
3. Project operator
4. Join operation

Correct answer: Project operator

Q3. By default, a non-key attribute in a relation can have __________________ value.

1. Binary
2. Character
3. Null
4. Integer

Correct answer: Null

Q4. Which of the following is true regarding foreign keys?

1. There can be as many foreign keys as needed
2. Each table in database must have a foreign key
3. There can only be one foreign key in a relation
4. Foreign key is not a super key

Correct answer: There can be as many foreign keys as needed

Q5. Which of the following is a correct syntax of selecting all the columns from a table called PERSONS?

1. SELECT FROM * Persons
2. SELECT * FROM Persons
3. SELECT WHERE * Persons
4. SELECT * WHERE Persons

Correct answer: SELECT * FROM Persons

Q6. Which of the following Greek letter is used to denote the select operation?

1. π
2. σ
3. Ω
4. £

Correct answer: σ

Q7. How many different types of joins exist in DBMS?

1. 5
2. 3
3. 4
4. 2

Correct answer: 4

Q8. The maximum PL/SQL size of data type “BLOB” in DBMS is _____________.

1. 8 Gigabytes
2. 4 Gigabytes
3. 10 Gigabytes
4. 12 Gigabytes

Correct answer: 4 Gigabytes

Q9. While mapping many-to-many relationship, __________ table(s) are created.

1. Three
2. Two
3. Four
4. One

Correct answer: Three

Q10. Which of the following constraint is included in the definition of the table?

1. Domain
2. Default value
3. Foreign Key
4. Null

Correct answer: Foreign Key