CS403 Quiz 4 Set 2 by VU Topper RM

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

True Page 203

False

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

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

Truncate is an alternative of Delete command.

True

False

__________ 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

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

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

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

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

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),

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

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

B. Time Page 239

C. Complexity D. Efficiency

REVOKE is a ______________ statement. A. Data Definition

B. Control Access

C. Data Manipulation D. Data Description

Text based & Graphical User Interface (GUI) most commonly called as Forms, are two different types of -------------. A. Language

B. user interface Page 240

C. system programs D. Application programs