Menu

Question Discussion & Solution

MCQ

Q.

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.

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 a following statement is a prepared statements?

A

Insert into department values

B

Insert into department values

C

SQLSetConnectOption

D

SQLTransact

Discussion

MCQ

2.

Which of the following is used at the end of the view to reject the tuples which do not satisfy the condition in where clause?

A

With

B

Check

C

With check

D

All of the mentioned

Discussion

MCQ

3.

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

Discussion

MCQ

4.

a)

A

Value

B

Not null

C

Check

D

Check

Discussion

MCQ

5.

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

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