Search Header Logo

CLASS TEST 1 DBMS

Authored by Mohit Sajwan

Other

University

Used 6+ times

CLASS TEST 1 DBMS
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

18 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Select the primary key characteristics/s?

Unique Constraint

None

Unique and Not Null Constraint

Not Null Constraint

2.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

WHICH OF THE FOLLOWING IS TRUE?

PRIMARY KEY IS THE SUPERSET OF CANDIDATE KEY

CANDIDATE KEY IS THE SUPERSET OF SUPER KEY

SUPERKEY IS THE SUBSET OF CANDIDATE KEY

PRIMARY KEY IS THE SUBSET OF CANDIDATE KEY

3.

MULTIPLE SELECT QUESTION

45 sec • 1 pt

Media Image

More than one answer are correct

a is a super key

a is a composite key

a is a partial key

a is the candidate key

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

A network model schema:

permits many to many relationship

restricts one to many relationship

stores data in a table

restricts many to one relationship

5.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Media Image

select the correct option?

1000

3000

4000

5000

6.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

which of the following is not false?

selection is a complete set

natural join can be implemented with the help of cartesian product and projection operation

minimum cardinality in case of selection operator is 0

projection is binary operator

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

if in redundant file common fields are not matching then it results in _______

data integrity problem

data inconsistancy

data isolation

data redundancy

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?