Menu

Question Discussion & Solution

MCQ

Q.

Find the error in the the above statement.

A

Return type missing

B

Dept_name is mismatched

C

Reference relation is not mentioned

D

All of the mentioned

Community Discussion

No discussions yet. Be the first to start!

You must be logged in to participate in the discussion.

Login to Discuss

Similar Questions

MCQ

1.

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

Discussion

MCQ

2.

a)

A

Any row in the subquery meets the condition only

B

All rows in the subquery fail the condition only

C

Both of these two conditions are met

D

Neither of these two conditions is met

Discussion

MCQ

3.

A Delete command operates on ______ relation.

A

One

B

Two

C

Several

D

Null

Discussion

MCQ

4.

Some of these insert statements will produce an error. Identify the statement.

A

Insert into employee values

B

Insert into employee values

C

Insert into employee values

D

None of the mentioned

Discussion

MCQ

5.

In the query given above which one of the following is a temporary relation?

A

Budget

B

Department

C

Value

D

Max_budget

Discussion

More Database Management System Topics

Miscellaneous or General

71 MCQs

Relational Algebra

3 MCQs

Database Systems

49 MCQs

Data Models

16 MCQs

The Relational Database Model

58 MCQs

Entity Relationship (ER) Modeling

59 MCQs

Advanced Data Modeling

1 MCQs

Normalization

58 MCQs

Structured Query Language (SQL)

7 MCQs

Advanced SQL

90 MCQs

Database Design

2 MCQs

Transaction and Concurrency

10 MCQs

Data Warehouses

10 MCQs

Database Administration

1 MCQs

Mixed

10 MCQs