CS403 Final Term MCQs by VU Topper RM

Q1. Vu-Topper RM (1 marks)

Columns used to uniquely identify individual rows of a given table, may be specified to be not NULL.

True Page 203

False.

Q2. Vu-Topper RM (1 marks)

Which of the following is true about creating database in MS Access?

1. Click on the file menu, select database option and then click it
2. After running MS Access, create database option is selected directly
3. Go to the tool option of MS Access and select create Database option with suitable name
4. First we will run MS Access and select New option from the file. Next it will askthe name of database

Correct answer: First we will run MS Access and select New option from the file. Next it will askthe name of database

Q3. Vu-Topper RM (1 marks)

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’ ORDERBY Age; A. The statement has a syntax error B. The statement displays the entire fields from emp in which the Empname is ALI in any order C. The statement displays the entire fields from emp in which the Empname is ALI in descending order of their age D. The statement displays the entire fields from emp in which the Empname is ALI in ascending order of their age

Q4. Vu-Topper RM (1 marks)

Truncate is an alternative of Delete command.

True

False

Q5. Vu-Topper RM (1 marks)

__________ User Interface is preferred over ________ User Interface with respect to user. A. Easy to understand, efficient B. Hard to understand, efficient

C. Easy to understand, effective

D. Hard to understand, effective

Q6. Vu-Topper RM (1 marks)

When the power is turned off content of ________________ is lost.

A. Volatile Storage Page 255

B. Nonvolatile Storage C. Permanent Storage D. Hard disk Storage

Q7. Vu-Topper RM (1 marks)

Data Manipulation Language (DML) is the set of commands used to maintain and query a database including updating, inserting, modifying and retrieving data.

True

False

Q8. Vu-Topper RM (1 marks)

SQL stands for ______________. I - Structured Query Language II – Standard Query Language lllStatus Query Language

A. Only I

B. Only II C. Only lll D. NONE

Q9. Vu-Topper RM (1 marks)

DML does not used to : A. Add new rows to tables. B. Retrieve rows from table C. Modify the rows of tables.

D. Alter a table definition

Q10. Vu-Topper RM (1 marks)

Which of the following is the Correct SQL statement for creating table in Microsoft SQL server?

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

Correct answer: CREATE TABLE Customer (SID integer PRIMARY KEY, Last_Name varchar(30),

Q11. Vu-Topper RM (1 marks)

What happens if the WHERE clause is omitted from a DELETE statement?

1. All records from the table are deleted
2. No record from the table will be deleted
3. First record of the table will be deleted
4. The statement will not be executed and will give a syntax error

Correct answer: All records from the table are deleted

Q12. Vu-Topper RM (1 marks)

An effective user interface minimizes the----------- users require to learn and implement the system. A. Space

B. Time Page 239

C. Complexity D. Efficiency