CS403 Database Management System Quiz No 3 2024

The keyword used to sort the output is:

• Sort by
• Order by
• Group by
• Having

Which of the following is not a valid data type in SQL?

• Text
• Money
• Smallint
• Capitalint

Which of the following commands is used to create a database in SQL?

• CREATE DATABASE IMDB;
• CREATE TABLE IMDB;
• MAKE DATABASE IMDB;
• NEW DATABASE IMDB;

Which of the following is a mechanism used in databases to restrict the input values for a particular attribute within a defined range?

• Default Value
• Range Control
• Referential Integrity
• Null Value Control

The process of intentionally adding redundancy to a database to improve the speed of read queries is called:

• Normalization
• Index optimization
• Query rewriting
• Performance

The keyword used in SQL to eliminate duplicate rows from the result set of a SELECT query is:

• UNIQUE
• SET
• DISTINCT
• NO DUPLICATES

In denormalization, you typically merge a table that has a _____ relationship with the table on the “many” side of the relationship.

• One to one
• One to many
• Many to many
• Many to one

The acronym DML stands for:

• Database Management Language
• Data Modification Language
• Data Manipulation Language
• Data Modeling Language

The SQL keyword used to filter the results from an SQL statement is:

• HAVING
• FILTER
• WHERE
• CONDITION

Which of the following is not a DML operation?

• Retrieving rows from a table
• Adding new rows to tables
• Modifying the rows of tables
• Altering a table definition