wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

RDBMS Quiz

Total questions: 40

Worksheet time: 20mins

Name
Class
Date
1.

Which of the following is a feature of RDBMS?

a)

Stores data in files

b)

Stores data in tables with rows and columns

c)

Stores data in arrays

d)

Does not support relationships

2.

In an RDBMS, a row is also called:

a)

Attribute

b)

Tuple

c)

Column

d)

Field

3.

In an RDBMS, a column is also called:

a)

Tuple

b)

Field

c)

Attribute

d)

Relation

4.

Which key uniquely identifies a row in a table?

a)

Foreign Key

b)

Composite Key

c)

Primary Key

d)

Candidate Key

5.

A relation in RDBMS is represented as:

a)

A table

b)

A column

c)

A row

d)

A schema

6.

Which of these is NOT a type of database key?

a)

Primary Key

b)

Foreign Key

c)

Duplicate Key

d)

Candidate Key

7.

What is the full form of RDBMS?

a)

Relational Data Basic Management System

b)

Relational Database Management System

c)

Reliable Database Management Software

d)

Relational Data Backup Management System

8.

Which normal form eliminates partial dependency?

a)

1NF

b)

2NF

c)

3NF

d)

BCNF

9.

Which language is used to query data in RDBMS?

a)

HTML

b)

SQL

c)

XML

d)

C++

10.

Referential integrity in RDBMS ensures:

a)

Primary key values are unique

b)

Foreign key values match with primary key values

c)

Tables are normalized

d)

Duplicate records are avoided

11.

Which of the following is NOT an RDBMS?

a)

Oracle

b)

MySQL

c)

MongoDB

d)

SQL Server

12.

Which operation combines rows from two or more tables based on a related column?

a)

Projection

b)

Join

c)

Selection

d)

Union

13.

Which of the following is true about RDBMS?

a)

Data is stored in files

b)

Data is stored in key-value pairs

c)

Data is stored in objects

d)

Data is stored in tables

14.

Which SQL clause is used to remove duplicate rows from the result set?

a)

DISTINCT

b)

UNIQUE

c)

GROUP BY

d)

ORDER BY

15.

Which of the following is an example of a DQL command?

a)

SELECT

b)

INSERT

c)

UPDATE

d)

DELETE

16.

Which of the following is a DDL command?

a)

INSERT

b)

UPDATE

c)

CREATE

d)

DELETE

17.

Which DDL command is used to remove a table permanently?

a)

REMOVE

b)

DROP

c)

DELETE

d)

ERASE

18.

Which DDL command is used to change the structure of a table?

a)

CHANGE

b)

MODIFY

c)

ALTER

d)

UPDATE

19.

Which command is used to rename a table?

a)

ALTER

b)

UPDATE

c)

RENAME

d)

MODIFY

20.

What does the TRUNCATE command do?

a)

Removes a table permanently

b)

Deletes all rows from a table but keeps structure

c)

Deletes selected rows

d)

Changes schema of a table

21.

Which of the following commands can roll back?

a)

DROP

b)

TRUNCATE

c)

DELETE

d)

CREATE

22.

Which DDL command is used to define a database schema?

a)

ALTER

b)

CREATE

c)

INSERT

d)

UPDATE

23.

Which of the following will delete all rows and free the space?

a)

DELETE

b)

TRUNCATE

c)

DROP

d)

REMOVE

24.

To add a new column to an existing table, which command is used?

a)

CREATE

b)

ALTER

c)

INSERT

d)

UPDATE

25.

Which of the following is true for TRUNCATE?

a)

Slower than DELETE

b)

Cannot be rolled back

c)

Works with WHERE clause

d)

Only removes one row

26.

Which command is used to remove a column from a table?

a)

DELETE COLUMN

b)

ALTER DROP COLUMN

c)

ERASE COLUMN

d)

REMOVE COLUMN

27.

Which command creates a new empty table using another table’s structure?

a)

CREATE TABLE … LIKE …

b)

CREATE TABLE … COPY …

c)

CREATE TABLE … STRUCTURE …

d)

CREATE TABLE … AS EMPTY …

28.

Which of the following is a DML command?

a)

CREATE

b)

ALTER

c)

INSERT

d)

DROP

29.

Which command is used to remove selected rows from a table?

a)

TRUNCATE

b)

DELETE

c)

DROP

d)

REMOVE

30.

Which DML command is used to modify existing records?

a)

CHANGE

b)

ALTER

c)

UPDATE

d)

MODIFY

31.

Which DML command adds data into a table?

a)

INSERT

b)

ADD

c)

APPEND

d)

CREATE

32.

DELETE command can use:

a)

WHERE clause

b)

ORDER BY clause

c)

GROUP BY clause

d)

DISTINCT clause

33.

Which command is faster for removing all rows in a table?

a)

DELETE

b)

TRUNCATE

c)

DROP

d)

ERASE

34.

Which statement is true about UPDATE command?

a)

Cannot be used with WHERE clause

b)

Updates all rows if WHERE is not given

c)

Only works for primary keys

d)

Cannot update NULL values

35.

Which of the following is NOT a DML command?

a)

UPDATE

b)

DELETE

c)

SELECT

d)

ALTER

36.

To insert values into all columns of a table:

a)

Specify only values

b)

Must specify column names

c)

Cannot be done

d)

Requires ALTER

37.

Which of the following can remove duplicate records from a table?

a)

DELETE with DISTINCT

b)

DELETE with GROUP BY

c)

DELETE with ROWID

d)

TRUNCATE

38.

Which of these is an example of a DML statement with subquery?

a)

INSERT INTO table SELECT …

b)

CREATE TABLE AS SELECT …

c)

DROP TABLE …

d)

ALTER TABLE …

39.

Which of the following is true for DELETE command?

a)

Removes table structure

b)

Removes selected rows

c)

Faster than TRUNCATE

d)

Removes only last row

40.

Which DML command can change multiple rows at once?

a)

UPDATE with WHERE

b)

INSERT

c)

ALTER

d)

DROP

Similar Resources on Wayground

Concrete & Structural Laboratory Cover Sheet

40 questions

Concrete & Structural Laboratory Cover Sheet

quiz

Worksheet

•

University

Linux Commands Quiz - Basic 01 to Basic 02

40 questions

Linux Commands Quiz - Basic 01 to Basic 02

quiz

Worksheet

•

University

C programming Basics

40 questions

C programming Basics

quiz

Worksheet

•

University

Irrigation Engg Quiz 2 (Module 3 and 4)

35 questions

Irrigation Engg Quiz 2 (Module 3 and 4)

quiz

Worksheet

•

University

PARTIE I – VOCABULAIRE

36 questions

PARTIE I – VOCABULAIRE

quiz

Worksheet

•

University

Level 4 Engineering knowledge check

43 questions

Level 4 Engineering knowledge check

quiz

Worksheet

•

University

ECE420 - IoT Quiz

40 questions

ECE420 - IoT Quiz

quiz

Worksheet

•

University

Exploring Trees and Graphs

45 questions

Exploring Trees and Graphs

quiz

Worksheet

•

University