Database Management System MCQ Set 4

1. Which is the subset of SQL commands used to manipulate Oracle Database Structures, including tables?

A) Data Definition Language
B) Data Manipulation Language
C) Data Described Language
D) Data Retrieval Language


2. The SQL statement SELECT SUBSTR('123456789', INSTR('abcabcabc','b'), 4) FROM EMP; prints

A) 6789
B) 2345
C) 1234
D) 456789


3. Which of the following SQL command can be used to modify existing data in a database table?

A) MODIFY
B) UPDATE
C) CHANGE
D) NEW


4. When SQL statements are embedded inside 3GL, we call such a program as ..........

A) nested query
B) nested programming
C) distinct query
D) embedded SQL


5. ................ provides option for entering SQL queries as execution time, rather than at the development stage.

A) PL/SQL
B) SQL*Plus
C) SQL
D) Dynamic SQL

6) ......... is critical in formulating database design.

A. row column order
B. number of tables
C. functional dependency
D. normalizing


7) A primary key if combined with a foreign key creates

A. Parent-Child relationship between the tables that connect them
B. Many to many relationship between the tables that connect them
C. Network model between the tables that connect them
D. None of the above


8) A ............. represents the number of entities to which another entity can be associated

A. mapping cardinality
B. table
C. schema
D. information


9) Which two files are used during operation of the DBMS

A. Query languages and utilities
B. DML and query language
C. Data dictionary and transaction log
D. Data dictionary and query language


10) A ........... is a set of column that identifies every row in a table.

A. composite key
B. candidate key
C. foreign key
D. super key

Answers

1.a

2.b

3.b

4.d

5.d

6.c

7.a

8.a

9.c

10.d