CS312 Quiz 3 by Shahid and Ziddi

Q1. The correct syntax of insert statement is:

1. Insert into database values(value1, value2, ……)
2. Insert values(value1, value2, ……..) into tablename
3. Insert into tablename values(value1, value2, ….)
4. Insert values(value1, value2,…) into database

Correct answer: Insert into tablename values(value1, value2, ….)

Q2. Suppose your company has hired a new employee Ahmad and you are required to add his information in the emp table. Which of the following SQL command will you use for this purpose?

1. Add
2. New
3. Update
4. Insert

Correct answer: Insert

Q3. Which one is relevant for Primary key - foreign key relationship?

1. Integrity constraints
2. Partial Constraints
3. Completeness Constraints
4. Referential Integrity Constraints

Correct answer: Referential Integrity Constraints

Q4. Cascading defines the behavior of _______ when the record from the parent table is deleted or updated.

1. Secondary key
2. Super key
3. Primary key
4. Foreign key

Correct answer: Foreign key

Q5. In which type of Database relationship, foreign key can be added in any participating table?

1. One to Many
2. Many to Many
3. One to One
4. None

Correct answer: Many to Many

Q6. Which one is not a type of Anomalies?

1. Deletion Anomaly
2. Select Anomaly
3. Insertion Anomaly
4. Update Anomaly

Correct answer: Select Anomaly

Q7. ____________ is an artificial key which is not a part of the system. The purpose of the key is to avoid the complexity of the composite primary keys.

1. Unique Key
2. Candidate Key
3. Surrogate Key
4. Foreign Key

Correct answer: Surrogate Key

Q8. In E-R Diagram which one is not possible to show?

1. Entities
2. Relationships
3. Attributes
4. Foreign key relationships

Correct answer: Foreign key relationships