Search Header Logo

RDBMSQUIZ_1(06/02/2023)

Authored by RR ASSOCIATES

Computers

University

Used 2+ times

RDBMSQUIZ_1(06/02/2023)
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

20 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

What is a relation in RDBMS?

Key

Table

Row

Data Types

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is the correct option for the given query?

SELECT DISTINCT name FROM RDBMS WHERE ID IS NOT NULL;

a) The query gives all the possible RDBMS names where a finite value exists for ID

b) The query gives the RDBMS names where a finite value exists for ID and it excludes identical names

c) The query gives the names of the RDBMS that have a null ID and it also excludes identical names

d) The query is syntactically wrong

3.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

Which of the following is the correct output for the given query?

(SELECT databaseid FROM RDBMS WHERE SECTION = 'c') EXCEPT (SELECT databaseid FROM RDBMS WHERE id < 10);

a) All the values of the databaseid for which section is c and id > 10

b) All the values of the databaseid for which section not c and id > 10

c) All the values of the databaseid for which section is c and id < 10

d) All the values of the databaseid for which section not c and id < 10

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following commands do we use to delete a relation (RDBMS) from a database?

a) delete table RDBMS

b) drop table RDBMS

c) delete from RDBMS

d) drop relation RDBMS

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is the property of transaction that protects data from system failure?

Atomicity

Isolation

Consistency

Durability

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

During transaction before commit which of the following statement is done automatically in case of shutdown?

Rollback

Commit

View

Flashback

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

A relational database developer refers to a record as?

Relation

Tuple

Data

Column

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?