CS403 Quiz 4 by VU Topper RM

WORM: Stands for--------------------------------------. A. write only memory B. Write on, Read memory

C. write-once, read-many

D. Read only memory

Which file organization is allowed by a direct access storage device?

1. indexed and direct only
2. sequential only
3. Direct only
4. sequential, indexed and direct,

Correct answer: sequential, indexed and direct,

____________are the structure defined for placing data in the attributes while designing physical design of database. A. Objects B. Variables C. Attributes

D. Data types

In which normal form, we convert composite attributes into individual attributes?

1. 4NF
2. 3NF
3. 2NF
4. 1NF

Correct answer: 1NF

Which of the following is NOT the type of horizontal partitioning?

1. List Petitioning
2. Limit partitioning
3. Range Petitioning
4. Hash Petitioning

Correct answer: Limit partitioning

Replication is the form of_______. A. Denormalization B. Relational calculus C. Normalization

D. Partitioning

Given the following relation it is not 3 NF because Student (roll no, name, course no, course max. marks, year of study, address), where roll no is PK A. it has more than 3 non-key attributes

B. non-key attributes course no and course max. marks are functionally dependent

C. it is not in 2 NF D. it does not have composite key

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

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