CS403 Quiz No.2 Shared by Abbas

Question # 1 of 10 ( Start time: 02:51:49 PM ) 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 # 2 of 10 ( Start time: 02:52:33 PM ) 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 # 3 of 10 ( Start time: 02:52:58 PM ) Total Marks: 1
The _________ function helps reduce the need to use mutiple OR conditions.
Select correct option:
 Like
 IN
 AND
 BETWEEN

Question # 4 of 10 ( Start time: 02:53:18 PM ) Total Marks: 1
Which of the following is the correct syntax for adding a new column into an existing table.
Select correct option:
 ALTER TABLE table_name { ALTER [COLUMN] column type [(size)] [DEFAULT default] }
 ALTER TABLE table_name { ADD [COLUMN] column type [(size)] [DEFAULT default] }
 Both I and II.
 None of the above.


Question # 5 of 10 ( Start time: 02:53:40 PM ) Total Marks: 1
Columns used to uniquely identify individual rows of a given table, may be specified to be not NOT NULL.
Select correct option:
 True
 False

Question # 6 of 10 ( Start time: 02:54:03 PM ) Total Marks: 1
What happens if the WHERE clause is omitted from a DELETE statement?
Select correct option:
 All records from the table are deleted
 No record from the table will be deleted
 First record of the table will be deleted
 The statement will not be executed and will give a syntax error

Question # 7 of 10 ( Start time: 02:54:56 PM ) 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 # 8 of 10 ( Start time: 02:55:57 PM ) Total Marks: 1
Which of the following is used to filter rows according to some condition(s)?
Select correct option:
 SELECT
 FROM
 WHERE
 UPDATE

Question # 9 of 10 ( Start time: 02:56:46 PM ) 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 # 10 of 10 ( Start time: 02:57:29 PM ) Total Marks: 1
Which of the following is not true regarding clustering?
Select correct option:
 It increases the efficiency since related records are placed close to each other
 Clustering makes records, difficult to access
 suitable to relatively static situations.
 It is a process, which means to place records from different tables to place in adjacent physical locations