Structured Query Language (SQL) Questions

MCQ bookmark_border

1.

DML is provided for

A

Description of logical structure of database.

B

Addition of new structures in the database system.

C

Manipulation & processing of database.

D

Definition of physical structure of database system.

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

2.

A

Selection operation.

B

Rename operation.

C

Join operation.

D

Projection operation.

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

3.

. The database schema is written in

A

HLL

B

DML

C

DDL

D

DCL

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

4.

The language which has recently become the defacto standard for interfacing application programs with relational database system is

A

Oracle

B

SQL

C

DBase

D

4GL

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

5.

Count function in SQL returns the number of

A

values

B

distinct values

C

groups

D

columns

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

6.

It is possible to define a schema completely using

A

VDL and DDL.

B

DDL and DML.

C

SDL and DDL.

D

VDL and DML.

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

7.

The full form of DDL is

A

Dynamic Data Language

B

Detailed Data Language

C

Data Definition Language

D

Data Derivation Language

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion