Advanced SQL Questions

MCQ bookmark_border

31.

How can you find rows that do not match some specified condition?

A

EXISTS

B

Double use of NOT EXISTS

C

NOT EXISTS

D

None of the mentioned

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

32.

A Delete command operates on ______ relation.

A

One

B

Two

C

Several

D

Null

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

33.

The above command

A

Deletes a particular tuple from the relation

B

Deletes the relation

C

Clears all entries from the relation

D

All of the mentioned

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

34.

Which one of the following deletes all the entries but keeps the structure of the relation.

A

Delete from r where P

B

Delete from instructor where dept name

C

Delete from instructor where salary between 13000 and 15000

D

Delete from instructor

Correct Answer: D

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

35.

The____condition allows a general predicate over the relations being joined.

A

On

B

Using

C

Set

D

Where

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

36.

Which of the join operations do not preserve non matched tuples?

A

Left outer join

B

Right outer join

C

Inner join

D

Natural join

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

37.

Which of the following creates a virtual relation for storing the query?

A

Function

B

View

C

Procedure

D

None of the mentioned

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

38.

Which of the following is the syntax for views where v is view name?

A

Create view v as

B

Create

C

Create view v as

D

Create view

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

39.

Here the tuples are selected from the view.Which one denotes the view.

A

Course_id

B

Watson

C

Building

D

physics_fall_2009

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

40.

Materialised views make sure that

A

View definition is kept stable

B

View definition is kept up

C

View definition is verified for error

D

View is deleted after specified time

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion