DBMS TEST2

1.

1 point

Which of the following is/are the Database server functions?
i) Data management ii) Transaction management
iii) Compile queries iv) Query optimization

C) ii, iii and iv only

A) i, ii, and iv only

D) All i, ii, iii, and iv

B) i, ii and iii only

2.

1 point

……………… table store information about database or about the system.

C) System

B) Nested

A) SQL

D) None of these

3.

1 point

......... command can be used to modify a column in a table

A. alter

B. update

C. set

D. create

Set

Updtae

Create

Alter

4.

1 point

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

B) SQL*Plus

C) SQL

D) Dynamic SQL

A) PL/SQL

5.

1 point

…………… database is used as template for all databases created.

D) None of the above

C) Tempdb

B) Model

A) Master

6.

1 point

………………….. operator is basically a join followed by a project on the attributes of first relation.

A) Join

C) Full Join

D) Inner Join

B) Semi-Join

7.

1 point

In SQL, which command is used to issue multiple CREATE TABLE, CREATE VIEW and GRANT statements in a single transaction?

A) CREATE PACKAGE

C) CREATE CLUSTER

B) CREATE SCHEMA

D) All of the above

8.

1 point

The database schema is written in

HLL

DDL

DML

DCL

9.

1 point

What are the different events in Triggers?

C) Insert, Update, Delete

A) Define, Create

B) Drop, Comment

D) Select, Commit

10.

1 point

State true or false.
i) Select operator is not a unary operator.
ii) Project operator chooses subset of attributes or columns of a relation.

A) i-True, ii-False

D) i-False, ii-False

C) i-False, ii-True

B) i-True, ii-True

11.

1 point

A primary key if combined with a foreign key creates

B. Many to many relationship between the tables that connect them

A. Parent-Child relationship between the tables that connect them

D. None of the above

C. Network model between the tables that connect them

12.

1 point

The language that requires a user to specify the data to be retrieved without specifying exactly how to get it is

A. Procedural DML

D. Non-Procedural DDL

B. Non-Procedural DML

C. Procedural DDL

13.

1 point

……………… clause is an additional filter that is applied to the result.

A) Select

B) Group-by

C) Having

D) Order by

Order by

Select

Group by

having

14.

1 point

……………..specifies a search condition for a group or an aggregate.

C) FROM Clause

D) WHERE Clause

A) GROUP BY Clause

B) HAVING Clause

15.

1 point

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

C) Data Described Language

D) Data Retrieval Language

A) Data Definition Language

B) Data Manipulation Language

16.

1 point

Grant and revoke are ....... statements.

DCL

TCL

DDL

DML

17.

1 point

......... keyword is used to find the number of values in a column.

D. SUM

B. COUNT

A. TOTAL

C. ADD

18.

1 point

……………… defines rules regarding the values allowed in columns and is the standard mechanism for enforcing database integrity.

C) Index

A) Column

D) Trigger

B) Constraint

19.

1 point

What operator tests column for the absence of data?

B) ASSIGNMENT operator

A) IS NULL operator

D) NOT operator

C) LIKE operator

20.

1 point

Which of the syntax is correct for insert statement?
i) insert into values
ii) insert into (column list) values

D) None of them

A) i-only

C) Both of them

B) ii-only