Advanced SQL Questions

MCQ bookmark_border

1.

The language used in application programs to request data from the DBMS is referred to as the

A

DML

B

DDL

C

VDL

D

SDL

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

2.

The statement in SQL which allows to change the definition of a table is

A

Alter

B

Update

C

Create

D

select

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

3.

Which of the following is an advantage of view?

A

Data security

B

Derived columns

C

Hiding of complex queries

D

All of the above

Correct Answer: D

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

4.

Which of the following database object does not physically exist?

A

base table

B

index

C

view

D

none of the above

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

5.

. Which one of the following is not true for a view:

A

View is derived from other tables.

B

View is a virtual table.

C

A view definition is permanently stored as part of the database.

D

View never contains derived columns.

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

6.

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.

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

7.

_________ is a virtual table that draws its data from the result of an SQL SELECT statement.

A

View

B

Synonym

C

Sequence

D

TrAnsaction

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

8.

Which one of the following is not true for a view:

A

View is derived from other tables.

B

View is a virtual table.

C

A view definition is permanently stored as part of the database.

D

View never contains derived columns.

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

9.

A _____ indicates an absent value that may exist but be unknown or that may not exist at all.

A

Empty tuple

B

New value

C

Null value

D

Old value

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

10.

The predicate in a where clause can involve Boolean operations such as and. The result of true and unknown is_______ false and unknown is _____ while unknown and unknown is _____

A

Unknown, unknown, false

B

True, false, unknown

C

True, unknown, unknown

D

Unknown, false, unknown

Correct Answer: D

None.

Check Answer report_problem Report forum Discussion