Menu

Question Discussion & Solution

MCQ

Q.

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.

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.

If we do want to eliminate duplicates, we use the keyword ______in the aggregate expression.

A

Distinct

B

Count

C

Avg

D

Primary key

Discussion

MCQ

2.

The ____ connective tests for set membership, where the set is a collection of values produced by a select clause. The ____ connective tests for the absence of set membership.

A

Or, in

B

Not in, in

C

In, not in

D

In, or

Discussion

MCQ

3.

Which of the following function is used to find the column count of the particular resultset?

A

getMetaData

B

Metadata

C

getColumn

D

get Count

Discussion

MCQ

4.

The____condition allows a general predicate over the relations being joined.

A

On

B

Using

C

Set

D

Where

Discussion

MCQ

5.

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

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