CS403 Quiz 3 2023

CS403 - CS403 - Database

Management Systems (Quiz No. 3)

Normalization is a process of restructuring a relation to Select the correct optionmake it of uniform sizeallow addition of dataminimize duplication of data in a databasemaximize duplication of data to ensure reliability

The correct option for the process of normalization is:

Minimize duplication of data in a database. Creating the relationships between new tables and their predecessors through the use of foreign keys is general requirements of__________. Select the correct optionFirst normal formThird normal formSecond normal formFourth normal form The correct option for creating relationships between new tables and their predecessors through the use of foreign keys is: Second normal form.

The database design prevents some data from being stored due to _______.Select the correct optionDeletion anomaliesInsertion anomaliesRedundancyUpdate anomalies The correct option for the situation where the database design prevents some data from being stored is: Insertion anomalies.

Identify the language which is used to specify database schema. Select the correct optionTCLDCLDMLDDL

The correct option for the language used to specify database schema is:

DDL (Data Definition Language).

Which of the following normal form deals with multivalued dependency?Select the correct option1NF3NF2NF4NF The correct option for the normal form that deals with multivalued dependency is: 4NF (Fourth Normal Form). The maximum PL/SQL size of data type “VARCHAR2” in DBMS is _____________ bytes. Select the correct option32767427672876752767

The correct option for the maximum PL/SQL size of the data type "VARCHAR2" in DBMS is:

32767 bytes.

SQL stand for?Select the correct optionStandard query languageStructure query languageStructure query listStandard query list

The correct option for the abbreviation SQL is:

Structured Query Language.

With the help of _____________ technique data values with the smaller sized codes can further reduce the space needed by the data for storage in the database. Select the correct optionExtensionExpansionsNegationCompression The correct option for the technique that can help reduce the space needed for data storage in the database by using smaller-sized codes is: Compression.

Which of the following is NOT the valid data type in SQL?Select the correct optionSmallintTextCapitalintMoney

The correct option for the data type that is NOT valid in SQL is:

Capitalint.

Which of the following is NOT related to data manipulation language?Select the correct optionRetrieval of informationInsertion of informationControl access to the informationModification to the information The correct option for the item that is NOT related to data manipulation language is: Control access to the information.