CS403 Quiz 3 Set 2 by VU Topper RM

Q1. Vu-Topper RM (1 marks)

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

Q2. Vu-Topper RM (1 marks)

Indexes are built on _________to improve query performance. A. Tables B. Records

C. Columns Page 193

D. Relationships

Q3. Vu-Topper RM (1 marks)

A relation is said to be in BCNF when A. It has overlapping composite keys

B. It has no composite keys

C. It has no multivalued dependencies D. It has no overlapping composite keys which have related attributes

Q4. Vu-Topper RM (1 marks)

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

A. 4 gigabytes

B. 8 gigabytes C. 10 gigabytes D. 12 gigabytes

Q5. Vu-Topper RM (1 marks)

At which design level de-normalization will take place?

1. Conceptual design
2. Logical design
3. Physical design
4. All of the above

Correct answer: Physical design

Q6. Vu-Topper RM (1 marks)

In ____________ the domains of attributes of a relation are atomic, that is they consist of single units that cannot be broken down further.

A. First normal form Page 167

B. Second normal form C. Third normal form D. Augmentation

Q7. Vu-Topper RM (1 marks)

Which of the following is NOT the purpose of SQL?

1. Write information
2. Read information
3. Remove information
4. Transmission of information

Correct answer: Transmission of information

Q8. Vu-Topper RM (1 marks)

Which of the following is used to keep the input values for a specific attribute in specific limits in comparison to any other attribute of the same or any other relation?

1. Default Value
2. Range Control
3. Null Value Control
4. Referential Integrity Page 186

Correct answer: Referential Integrity Page 186

Q9. Vu-Topper RM (1 marks)

A relational table is in third normal form (3NF) if it is already in 2NF and every non-key column is non-transitively dependent upon its

A. Super Key B. Foreign Key

C. Primary Key Page 171

D. Candidate Key

Q10. Vu-Topper RM (1 marks)

The maximum length for an identifier can be __________. A. 192 characters B. 512 characters

C. 256 characters Page 196

D. 128 characters

Q11. Vu-Topper RM (1 marks)

A fully normalized database schema can fail to provide applicable system response time due to ________. A. Excessive query execution B. Use of sub queries C. Removal of redundant data

D. Excessive table join operations Page 188

Q12. Vu-Topper RM (1 marks)

While converting to 2NF all the columns are deleted from the original table except for the determinant which will serve as a ____________key. A. Super key B. Primary key

C. Foreign key Page 173

D. Composite Key