CS403 Quiz 4 by HB

computers.

a. five · b. four · c. Two · d. three · a. Programs · b. language · c. forms · d. interface · The index which has some of the key value is classified as · a. Non dense index · b. Cluster index · c. Dense index · d. Linear index

WORM: Stands for--------------------------------------.

a. Read only memory · b. Write on, Read memory · c. write-once, read-many · d. write only memory

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

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

Is the given SQL Statement prompt error?

1. Logical Error
2. Time out Error
3. Parameter Error
4. No Error

Consider the two relations,

Supplier (S_no, S_name, Contact_No, Address) and

Supply (S_no, Item_no).

Which of the following statements give(s) a list of supplier names supplying the item with Item_no „555‟?

1. SELECT S_name FROM Supplier, Supply WHERE Supplier.S_no=Supply.S_no AND

Item_no=‟555‟

b. SELECT S_name FROM Supplier WHERE S_no EXISTS (SELECT S_no FROM Supply

WHERE Item_no=‟555‟)

c. SELECT S_name FROM Supplier WHERE S_name EXISTS (SELECT S_name FROM

Supply WHERE Item_no='555')

d. SELECT S_name FROM Supplier WHERE Item_no=‟555‟ 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 descending order of their age c. The statement displays the entire fields from emp in which the Empname is ALI in any order d. The statement displays the entire fields from emp in which the Empname is ALI in ascending order of their age

Functions in SQL return a single value · a. True · b. False

c. d.