CS403-Database Management System Solution Semester Quiz Spring 2021

 

Semester Quiz 
Spring 2021

Question No 1:

UPDATE command (Raise For Success) belongs to which type of classification.

• DML Correct
• DDL
• DCL
• DQL

Question No 2:

The _________ function (Raise For Success) helps reduce the need to use multiple OR conditions.

• Like
• IN Correct
• AND
• Between

Question No 3:

Which of the flowing (Raise For Success) clauses allows to sort the records in result set?

• Where
• Order by Correct
• From
• Having

Question No 4:

In SQL queries, (Raise For Success) while creating tables or relations in database, key columns may be specified by

• Null
• Not Null Correct
• Data Type
• None of the above

Question No 5:

Identify the (Raise For Success) language, which is used to specify database schema.

• DCL
• DML
• DDL Correct
• Non of the above

Question No 6:

_______ Operators (Raise For Success) are the ones that require two operands on both sides of the operator.

• Double
• Tow Sided
• Binary Correct
• None of the given options

Question No 7:

What happened if the (Raise For Success) Where clause is omitted from a Delete Statement?

• All record from the table are deleted Correct
• No record from the tables will be deleted
• First record of the tables will be deleted
• The statement will not be executed and will give a syntax error

Question No 8:

Which of the (Raise For Success) following is a String function in SQL

• Count
• LEN Correct
• SQRT
• SIN

Question No 9:

Revoke is (Raise For Success) a __________ Statement.

• Data Definition
• Control Access Correct
• Data Manipulation
• Data Description

Question No 10:

Truncate command response time is ____ as compared to Delete (Raise For Success) command.

Select correct option:

• Poor
• Same
• Better Correct
• Worst

Question No 11:

Which of the following (Raise For Success) syntax of the functions in SQL is used to add column values?

• COUNT (*)
• COUNT (expression)
• MAX (expression)
• SUM (expression) 

Question No 12:

SQL is used (Raise For Success) for:

• Creating, managing and deleting tables and manage the relationships among the stored date.
• Generating queries, organizing, managing and retrieving data stored in a database.
• Maintaining data integrity and coordinate data sharing.
• All of the above Correct

Question No 13:

Which of the (Raise For Success) following is used to filter rows according to some condition(s)?

• Select
• From
• Where Correct
• Update

Question No 14:

Which language is (Raise For Success) used to permit or prohibit access to a table?

• DCL Correct
• DDL
• DML
• All of the above.

Question No 15:

Data Manipulation Language (DML) is the set of commands (Raise For Success) used to maintain and query a database including updating, inserting, modifying and retrieving data.

• True Correct
• False

Question No 16: 

Which of the (Raise For Success) following is NOT a DDL command?

• Create DB
• Create table
• Delete Correct
• Drop

Question No 17:

Which of the following (Raise For Success) function falls in the category of aggregate functions.

• SUM
• MIN
• MAX
• All of the above Correct

Question No 18:

Value of a function (Raise For Success) in SQL is always determined by the input parameters

• True Correct
• False

Question No 19:

Consider the following two relations.

Supplier(S_no, S_name, Contact_No, Address ) and

Supply (S_no, item_no).

Which of the following statements given (s) a list of supplier (Raise For Success) names supplying the item with item_no ‘555’?

• SELECT_name FROM Supplier WHERE item_no=’5’
• SELECT S_name FROM Supplier, SUPPLY WHERE Supplier.S_no=Supply.S_no AND item_no=’555’
• SELECT S_name FROM Supplier, SUPPLY WHERE Supplier S_no EXISTS (SELECT S_no FROM Supply WHERE Item_no=’555’)
• SELECT S_name FROM Supplier, WHERE S_name EXISTS (SELECT S_name FROM Supply WHERE Item_no=’555’)

Question No 20:

Cache is a portion of memory made of high speed  ________ instead (Raise For Success) of the slower and cheaper _______ used for main memory.

• RAM,ROM
• ROM,RAM
• PROM,EPROM
• Static RAM (SRAM), DRAM Correct

Question No 21:

Forms are used in (Raise For Success) application programs, how many types of forms are available _______?

• Four
• Five
• One
• Two

Question No 22:

When the power (Raise For Success) is turned off content of _______, it lost.

• Non-Volatile storage
• Volatile storage Correct
• Permanent storage
• Hard Disk storage

Question No 23:

Which language (Raise For Success) is used to permit or prohibit access to a table?

• DCL
• DDL
• DML Correct
• All of the above 

Question No 24:

Consider a table named “emp” having field’s empname, EmpID, Age, and Salary. Which of the following is true if the (Raise For Success) following SQL statement tries to execute?

SELECT*

FROM emp

WHERE Empname =’ALI’:

• The statement has a syntax error
• The statement only displays the EmpID of those employees whose name is ALI
• The statement displays the entire fields from emp in which the Empname is ALI
• The statement must have an ORDERBY clause

Question No 25:

According to his /her (Raise For Success) level of knowledge/understanding, how many types of units are there ______?

• Three
• Four
• Six
• Two

Question No 26:

Data Manipulation Language is the set of commands used to maintain (Raise For Success) and query a database including updating, inserting, modifying and retrieving data.

• True Correct
• False

Question No 27:

A __________ is established when the value of one attribute is (Raise For Success) dependent on the value of another attribute.

• Primary key
• Data anomaly
• Dependency Correct
• Transitive relationship

Question No 28:

Which of the (Raise For Success) following is a service provided by a DBMS?

•  It ensures and enforces data integrity at all levels
•  It maintains an environment in which security is created and enforced
•  It manages the metadata in the data dictionary
•  All of the above are services of a DBMS Correct

Question No 29:

Value of a function (Raise For Success) in SQL is always determined by the input parameters.

• True Correct
• False

Question No 30:

Which of the (Raise For Success) following function falls in the category of aggregate functions.

Select correct option:

• SUM
• MIN
• MAX
• All of the above Correct