Dbms(Computer Science ) Questions and answers for exam Preparation

Question 1. Which SQL statement would add a record to the database?

INSERT INTO Designer VALUES ('SMI01', 'M Smith', 'mail@msmith.com', '01224123456')
INSERT VALUES ('SMI01', 'M Smith', 'mail@msmith.com', 01224123456') INTO Designer
INSERT ('SMI01', 'M Smith', 'mail@msmith.com', '01224123456') INTO Designer
INSERT Designer INTO VALUES (''SMI01', 'M Smith', 'mail@msmith.com', '01224123456')

Explanation:-

Answer: Option A. -> INSERT INTO Designer VALUES ('SMI01', 'M Smith', 'mail@msmith.com', '01224123456')

Question 2. Match SQL language with SQL commands

1-iii,2-i,3-ii,4-iv
1-iii,2-ii,3-iv,4-i
1-ii,2-iii,3-iv,4-i
1-i,2-iii,3-ii,4-iv

Explanation:-

Answer: Option C. -> 1-ii,2-iii,3-iv,4-i

Question 3. DELETE FROM r; where r is relation

Remove relation
Clear relation entries
Delete fields
Delete rows

Explanation:-

Answer: Option B. -> Clear relation entries

Question 4. Which of the following is an example of a DBMS

SQL
Microsoft Office
PHP
Oracle

Explanation:-

Answer: Option D. -> Oracle

Question 5. Collection of information stored in a database at a particular moment is

view
schema
instance
none of the above

Explanation:-

Answer: Option C. -> instance

Question 6. The term "Data independence" refers to____

Data is defined separately and not included in the programs
Programs are not dependent on the logical attributes of the data
Programs are not dependent on the physical attributes of the data
Both B & C

Explanation:-

Answer: Option C. -> Programs are not dependent on the physical attributes of the data

Question 7. Here which of the following displays the unique values of the column?SELECT ________ dept_nameFROM instructor;

from
like
unique
distinct

Explanation:-

Answer: Option D. -> distinct

Question 8. Which one of the following command is used to delete the existing row in a table?

Delete
Update
Insert
None of the above

Explanation:-

Answer: Option A. -> Delete

Question 9. How can you change “Hansen” into “Nilsen” in the “LastName” column in the Persons table?

UPDATE Persons SET LastName=’Hansen’ INTO LastName=’Nilsen’
MODIFY Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’
MODIFY Persons SET LastName=’Hansen’ INTO LastName=’Nilsen’
UPDATE Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’

Explanation:-

Answer: Option D. -> UPDATE Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’

Question 10. Every Boyee-Codd normal form is in

1NF
2Nf
3NF
all the above

Explanation:-

Answer: Option D. -> all the above