CS403 Quiz No.3 Shared by Arzoe

Question # 1 of 10 ( Start time: 03:19:42 PM )     Total Marks: 1
Identify the language which is used to specify database schema.
Select correct option:
    DCL
    DML
    DDL
    Non of the above


Question # 2 of 10 ( Start time: 03:21:00 PM )     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.


Question # 3 of 10 ( Start time: 03:21:56 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 # 4 of 10 ( Start time: 03:22:07 PM )     Total Marks: 1
The ________ condition allows to retrieve values within a specific range.
Select correct option:
    AND
    LIKE
    BETWEEN        ok
    FROM


Question # 5 of 10 ( Start time: 03:22:17 PM )     Total Marks: 1
Which of the following is not DML command?
Select correct option:
    Select
    Update
    Delete
    Truncate        ok


Question # 6 of 10 ( Start time: 03:23:14 PM )     Total Marks: 1
Consider a table named “emp” having fields Empname, EmpID, Age, salary. Which of the following is true if the following SQL statement tries to execute? SELECT * FROM emp WHERE Empname=’ALI’;
Select correct option:
    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        ok
    The statement must have an ORDERBY clause


Question # 7 of 10 ( Start time: 03:23:59 PM )     Total Marks: 1
Suppose we have two tables T1 and T2. Tuples of T1 that do not match some row in T2 will not appear in
Select correct option:
    Outer Join
    Inner Join        ok
    Both I and II
    None of the above


Question # 8 of 10 ( Start time: 03:24:37 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.        ok
    None of the above.


Question # 9 of 10 ( Start time: 03:24:55 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 # 10 of 10 ( Start time: 03:25:03 PM )     Total Marks: 1
UPDATE command belongs to which type of Classification
Select correct option:
    DML        ok
    DDL
    DCL
    DQL