Menu

Question Discussion & Solution

MCQ

Q.

The ________ keyword is used to access attributes of preceding tables or subqueries in the from clause.

A

In

B

Lateral

C

Having

D

With

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.

Inorder to give only 10 rank on the whole we should use

A

Limit 10

B

Upto 10

C

Only 10

D

Max 10

Discussion

MCQ

2.

Which of the following statements creates a new table temp instructor that has the same schema as an instructor.

A

create table temp_instructor

B

Create table temp_instructor like instructor

C

Create Table as temp_instructor

D

Create table like temp_instructor

Discussion

MCQ

3.

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

Discussion

MCQ

4.

Domain constraints, functional dependency and referential integrity are special forms of _________

A

Foreign key

B

Primary key

C

Assertion

D

Referential constraint

Discussion

MCQ

5.

Which of the following creates a temporary relation for the query on which it is defined?

A

With

B

From

C

Where

D

Select

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