CS403 Quiz No.3 Shared by Ikram

Question # 1 of 10 ( Start time: 02:55:16 PM )     Total Marks: 1
Which of the fllowing clauses allows to sort the records in result set?
Select correct option:
    where
    order by        ok
    from
    having


Question # 2 of 10 ( Start time: 02:55:48 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        ok
    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 # 3 of 10 ( Start time: 02:57:19 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        ok
    suitable to relatively static situations.
    It is a process, which means to place records from different tables to place in adjacent physical locations


Question # 4 of 10 ( Start time: 02:57:47 PM )     Total Marks: 1
Which of the following prevents duplicate values to be displayed as a result of an SQL statement?
Select correct option:
    DISTINCT        ok
    DELETE
    UPDATE
    ALTER


Question # 5 of 10 ( Start time: 02:58:02 PM )     Total Marks: 1
Data Manipulation Language (DML) is the set of commands used to maintain and query a database including updating, inserting, modifying and retrieving data.
Select correct option:
    True        ok
    False


Question # 6 of 10 ( Start time: 02:58:53 PM )     Total Marks: 1
Which of the following SQL statements used to control access to the data and to the database?
Select correct option:
    GRANT
    REVOKE
    Both GRANT and REVOKE        ok
    SELECT


Question # 7 of 10 ( Start time: 02:59:16 PM )     Total Marks: 1
In SQL, which command is used to delete rows from table.
Select correct option:
    DELETE        ok
    REMOVE
    TRUNCATE
    Both I and II


Question # 8 of 10 ( Start time: 02:59:41 PM )     Total Marks: 1
The ________ condition allows to retrieve values within a specific range.
Select correct option:
    AND
    LIKE
    BETWEEN        ok
    FROM


Question # 9 of 10 ( Start time: 02:59:59 PM )     Total Marks: 1
Functions in SQL return a single value
Select correct option:
    True        ok
    False


Question # 10 of 10 ( Start time: 03:00:22 PM )     Total Marks: 1
Correct statement for creating table in Microsoft SQL server is.
Select correct option:
    CREATE TABLE Customer (SID integer PRIMARY KEY, Last_Name varchar(30), First_Name varchar(30));        ok
    CREATE TABLE Customer (SID integer, Last_Name varchar(30), First_Name varchar(30))
    CREATE Customer (SID integer, Last_Name varchar(30), First_Name varchar(30));
    All of the above