CS312 MID TERM SOLVED MCQs || PAST PAPERS || GROUP-1 || DATABASE MODELING DESIGN || VuTech
Visit Website For More Solutions
www.vutechofficial.blogspot.com
CS312
Database Modeling and Design
Solved Mid Term Past Papers
______________________________
MCQs
______________________________
Group-1
Question No: 1
In which type of Database relationship, foreign key can be added in any participating table?
a) One to Many
b) Many to Many
c) One to One
d) None
Correct Answer:
The correct answer is 'a'.
Question No: 2
A database must be ________ of the application that uses it.
a) Independent
b) Relative
c) Similar
d) Dependent
Correct Answer:
The correct answer is 'a'.
Question No: 3
Which one is relevant for Primary key - foreign key relationship?
a) Completeness Constraints
b) Integrity constraints
c) Partial Constraints
d) Referential Integrity Constraints
Correct Answer:
The correct answer is 'd'.
Visit Website For More Solutions
www.vutechofficial.blogspot.com
Question No: 4
The command which is responsible for granting or revoking access to data in database, belongs to ______
a) DDL
b) DCL
c) DML
d) DRL
Correct Answer:
The correct answer is 'b'.
Question No: 5
In SQL language, DML stands for ?
a) Data Manipulation Language
b) Data Mining Language
c) Digital Manipulation Language
d) Digital Mining Language
Correct Answer:
The correct answer is 'a'.
Visit Website For More Solutions
www.vutechofficial.blogspot.com
Question No: 6
_________ is used to ADD data in SQL tables.
a) Insert
b) Create
c) Add
d) Put
Correct Answer:
The correct answer is 'a'.
Question No: 7
Which one is not relevant for SQL?
a) DCL
b) DDL
c) DML
d) DFL
Correct Answer:
The correct answer is 'd'.
Question No: 8
In SQL language, DCL stands for ?
a) Data Command Language
b) Data Control Language
c) Digital Control Language
d) Digital Command Language
Correct Answer:
The correct answer is 'b'.
Visit Website For More Solutions
www.vutechofficial.blogspot.com
Question No: 9
_________ 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.
a) Foreign Key
b) Candidate Key
c) Unique Key
d) Surrogate Key
Correct Answer:
The correct answer is 'd'.
Question No: 10
The SQL command "ALTER" comes under _____
a) DML
b) DRL
c) DDL
d) DCL
Correct Answer: