CS403 Quiz No.4 Shared by Saira Ali

Question # 1 of 10 ( Start time: 04:22:31 PM ) Total Marks: 1
Which of the following syntax of the functions in SQL is used to add column values?
Select correct option:
COUNT(*)
COUNT(expression)
MAX(expression)
SUM(expression)


Question # 2 of 10 ( Start time: 04:23:49 PM ) Total Marks: 1
__________ User Interface is preferred over ________ User Interface with respect to user.
Select correct option:
Easy to understand, efficient        ok
Hard to understand, efficient
Easy to understand, effective
Hard to understand, effective


Question # 3 of 10 ( Start time: 04:24:42 PM ) Total Marks: 1
The _________ function helps reduce the need to use mutiple OR conditions.
Select correct option:
Like
IN        ok
AND
BETWEEN


Question # 4 of 10 ( Start time: 04:25:18 PM ) Total Marks: 1
Truncate command response time is ______ as compared to Delete command.
Select correct option:
Poor
Same
Better        ok
worst


Question # 5 of 10 ( Start time: 04:25:54 PM ) Total Marks: 1
Which of the following is not a part of an INSERT statement?
Select correct option:
INTO
VALUES
INSERT
MODIFY        ok


Question # 7 of 10 ( Start time: 04:38:41 PM ) Total Marks: 1
Which of the following is used to filter rows according to some condition(s)?
Select correct option:
SELECT
FROM
WHERE        ok
UPDATE


Question # 8 of 10 ( Start time: 04:39:35 PM ) Total Marks: 1
Is the given SQL Statement prompt error? Select * from relation1;
Select correct option:
Logical Error
No Error        ok
Parameter Error
Time out Error


Question # 9 of 10 ( Start time: 04:40:32 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 wh



Question # 10 of 10 ( Start time: 04:41:54 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