CS403 Quiz 3 Solved by Munir | Final term Preparation
Question 1:
For third normal form we concentrate on relations with one _________key, and we eliminate transitive dependencies.
Options:
A) Primary key
B) Composite key
C) Candidate key
D) Super key
Answer: C) Candidate key
Question 2:
In which normal form, we convert composite attributes into individual attributes?
Options:
A) 2NF
B) 1NF
C) 3NF
D) 4NF
Answer: B) 1NF
Question 3:
_____________ are used by database administrators in situations where we have a large number of records and wastage of a small amount of space in each record can lead to the loss of a huge amount of data storage space.
Options:
A) Variables
B) Symbols
C) Codes
D) Special characters
Answer: C) Codes
Question 4:
Which of the following is associated with a specific attribute and can help us to reduce the chances of inserting incorrect values in the attribute space?
Options:
A) Null Value Control
B) Range Control
C) Default Value
D) Referential Integrity
Answer: B) Range Control
Contact Us for Paid GDB's Click Here
Question 5:
Which of the following normal forms deals with possible lossless decompositions?
Options:
A) 4NF
B) 2NF
C) 3NF
D) 5NF
Answer: D) 5NF
Question 6:
SQL stands for?
Options:
A) Standard query language
B) Structure query list
C) Standard query list
D) Structure query language
Answer: D) Structure query language
Question 7:
While converting to 2NF all the columns are deleted from the original table except for the determinant which will serve as a ____________key.
Options:
A) Foreign key
B) Primary key
C) Composite key
D) Super key
Answer: B) Primary key
Question 8:
In which of the following situations clustering is more suitable _______.
Options:
A) Relatively dynamic situations
B) Relatively static situations
C) Where efficiency does not matter
D) Access of data is not frequent
Answer: B) Relatively static situations
Question 9:
Given the following relation it is not 3NF because Student (roll no, name, course no, course max. marks, year of study, address), where roll no is PK
Options:
A) It does not have a composite key
B) It has more than 3 non-key attributes
C) It is not in 2NF non-key attributes course no and course max. marks are functionally dependent
Answer: C) It is not in 2NF non-key attributes course no and course max. marks are functionally dependent
Question 10:
The maximum PL/SQL size of the data type “BLOB” in DBMS is _____________.
Options:
A) 12 Gigabytes
B) 8 Gigabytes
C) 10 Gigabytes
D) 4 Gigabytes
Answer: D) 4 Gigabytes