Practice Rdbms Multiple Choice Questions with Answers Quiz-3 - MCQGeeks.com

Q.1.

.......... is used to reduce the data duplication.

1 NF
2 NF
3 NF
4 NF

Q.2.

................. form disallows the multi-valued attribute, composite attribute, and their combinations.

1 NF
2 NF
3 NF
4 NF

Q.3.

.......... is the process of organizing the data in the database.

Schema
Normalization
Instance
Transaction

Q.4.

........... is the process of minimizing redundancy from a relation or set of relations.

Normalization
Data redundancy
Data consistency
Schema

Q.5.

Which of the following function cannot be performed by SQL ?

Setting permissions on tables
Creating views in a database
Updating records
Creating Complex UI
Delete database

Q.6.

Which of the following is NOT a type of SQL constraint?

Primary Key
Foreign Key
Alternate Key
Unique
NOT NULL

Q.7.

Which of the following is valid SQL for an Index?

CREATE INDEX ID;
CHANGE INDEX ID;
ADD INDEX ID;
REMOVE INDEX ID;
DELETE INDEX ID;

Q.8.

The HAVING clause does which of the following?

Acts like a WHERE clause but is used for groups rather than columns.
Acts like a WHERE clause but is used for rows rather than columns.
Acts like a WHERE clause but is used for columns rather than groups.
Acts EXACTLY like a WHERE clause.
Acts like a WHERE clause but is used for groups rather than rows.

Q.9.

The DROP TABLE statement:

deletes the table structure only.
deletes the table structure along with the table data.
works whether or not referential integrity constraints would be violated.
is not an SQL statement.
deletes the data only.