CS312 Midterm Quizzes 2023 by Danish Hanif

Paid Services Available 10/10 Marks Guarantee · CS312 Quiz File · 6/7/2023 10:11:27 PM

Q1. 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: One to Many

Q2. A database must be ______of the application that uses it.

1. Independent
2. Relative
3. Similar
4. Dependent

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

1. Completeness Constraints
2. Integrity constraints
3. Partial Constraints
4. Referential Integrity Constraints
5. The command which is responsible for granting or revoking access to data in database, belongs to _______

1. DDL
2. DCL
3. DML
4. DRL

Q5. In SQL language, DML stands for ______?

1. Data Manipulation Language
2. Data Mining Language
3. Digital Manipulation Language
4. Digital Mining Language

Q6. _____________ is used to ADD data in SQL tables.

1. Insert
2. Create
3. Add
4. Put

Q7. Which one is not relevant for SQL?

1. DCL
2. DDL
3. DML
4. DFL

Q8. In SQL language, DCL stands for ______?

1. Data Command Language
2. Data Control Language
3. Digital Control Language
4. Digital Command Language
5. ____________ 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. Foreign Key
2. Candidate Key
3. Unique Key
4. Surrogate Key

Q10. The SQL command "ALTER" comes under ______

1. DML