CS403 Final Term Quiz 4 July 2023 Set 2 by Miss Mehwish

We also provide Past papers for Mids. and Finals Cross Check your answers befo re submitting directly from the file. We are not responsible for 100% correction as human error exists

Q1. 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' ORDER BY Age;

A) The statement displays the entire fields from emp in which the Empname is ALI in ascending order of their age. B) The statement displays the entire fields from emp in which the Empname is ALI in any order. C) The statement has a syntax error. D) The statement displays the entire fields from emp in which the Empname is ALI in descending order of their age.

Correct option: A) The statement displays the entire fields from emp in which the Empname is ALI in ascending order of their age.

Q2. An effective user interface minimizes the __________ users require to learn and implement the system.

1. efficiency
2. space
3. complexity
4. time

Correct option: C) complexity.

Q3. Which of the following is used to retrieve and insert information from the database?

1. DCL
2. Both DML and DDL
3. DDL
4. DML

Correct option: D) DML (Data Manipulation Language).

Q4. Which of the following is the correct SQL statement for creating a table in Microsoft SQL Server?

1. CREATE Customer (SID integer, Last_Name varchar(30), First_Name varchar(30));
2. CREATE TABLE Customer (SID integer, Last_Name varchar(30), First_Name varchar(30))
3. CREATE TABLE Customer (SID integer PRIMARY KEY, Last_Name varchar(30), First_Name varchar(30));
4. All of the above.

Correct option: B) CREATE TABLE Customer (SID integer, Last_Name varchar(30), First_Name varchar(30))

Q5. Value of a function in SQL is always determined by the input parameters.

1. False
2. True

Correct option: B) True.

Q6. Which of the following is not a part of an INSERT statement?

1. MODIFY
2. INTO