CS403 Quiz No.2 Shared by HU

Question # 1 of 10 ( Start time: 10:24:12 AM ) Total Marks: 1
Identify the basic part(s) of a SELECT statement?
Select correct option:
SELECT
FROM
Both SELECT and FROM
DISTINCT


Question # 2 of 10 ( Start time: 10:24:45 AM ) Total Marks: 1
Which of the following is a correct way of selecting all the columns from a table called PERSONS?
Select correct option:
SELECT FROM * Persons
SELECT * FROM Persons SELECT * WHERE Persons
SELECT WHERE * Persons


Question # 3 of 10 ( Start time: 10:25:23 AM ) Total Marks: 1
Which of the following is used with INSERT command to insert values in a DB table?
Select correct option:
ONTO
INTO
UPTO
WITH


Question # 4 of 10 ( Start time: 10:25:44 AM ) Total Marks: 1
SQL is used for:
Select correct option:
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


Question # 5 of 10 ( Start time: 10:26:12 AM ) Total Marks: 1
General reasoning for horizontal or vertical partitioning is.
Select correct option:
Increasing the consistency
Decreasing the query response time
Smaller tables are more efficient to process as compared to the larger tables. 
All of the above


Question # 6 of 10 ( Start time: 10:26:40 AM ) Total Marks: 1
DML does not used to :
Select correct option:
add new rows to tables
retrieve rows from table
modify the rows of tables
alter a table definition


Question # 7 of 10 ( Start time: 10:27:40 AM ) Total Marks: 1
 The _________ function helps reduce the need to use mutiple OR conditions.
Select correct option:
Like
IN
AND
BETWEEN


Question # 8 of 10 ( Start time: 10:29:07 AM ) Total Marks: 1
The ________ operator allows to use wild cards in the where clause of an SQL statement.
Select correct option:
IN
FROM
LIKE
None of the above.


Question # 9 of 10 ( Start time: 10:29:32 AM ) Total Marks: 1
Objective of an order by clause is to display or arrange output of a select statement in a particular order.
Select correct option :
True
False


Question # 10 of 10 ( Start time: 10:29:51 AM ) Total Marks: 1
In vertical partitioning if we divide a table into two vertical partitions then efficiency of those applications will be reduced which used to .
Select correct option:
Access data from both the vertical partitions.
Access data from first vertical partition.
Access data from second vertical partition
None of the above.