1 - Table (relation) size reduces due to ______________.

1. Horizontal Partitioning
2. Vertical Partitioning
3. Query Optimization
4. Replication

2 – Consider the following relation,

Relation-X (stId, sName, sAdr, sPhone, cgpa, prName, school, mtMrks, mtSubs, clgName,intMarks, intSubs, dClg, bMarks, bSubs)

R1 (stId, sName, sAdr, sPhone, cgpa, prName)

R2 (sId, school, mtMrks, mtSubs, clgName, intMarks, intSubs, dClg, bMarks,

bSubs)

Which type of partitioning is performed on Relation-X?

a.       Horizontal Partitioning

b.      Vertical Partitioning

c.       Replication

d.      None of above

3 - If we place records from different tables in adjacent ____________, it would increase efficiency of a database.

1. Physical location
2. Table
3. Form
4. empty location

4 - Truncate command response time is ______ as compared to Delete command.

a.       Poor

b.      Same

c.       Better

d.      Worst

5 - The following SQL statement reflects as _________ in relational algebra.

Select * from relation1;

1. Projection Statement
2. Selection Statement

6 - The following SQL statement reflects as ______________ in relational algebra.

Select * from relation1 where a = b;

1. Projection Statement
2. Selection Statement

7 - 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 WHERE Item_no=’555’
2. SELECT S_name FROM Supplier, Supply WHERE Supplier.S_no=Supply.S_no AND Item_no=’555’
3. SELECT S_name FROM Supplier WHERE S_no EXISTS (SELECT S_no FROM Supply WHERE Item_no=’555’)
4. SELECT S_name FROM Supplier WHERE S_name EXISTS (SELECT S_name FROM Supply WHERE Item_no='555')

8 - 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’;

1. The statement has a syntax error
2. The statement only displays the EmpID of those employees whose name is ALI
3. The statement displays the entire fields from emp in which the Empname is ALI
4. The statement must have an ORDERBY clause

9 - 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;

1. The statement displays the entire fields from emp in which the Empname is ALI in ascending order of their age
2. The statement has a syntax error
3. The statement displays the entire fields from emp in which the Empname is ALI in any order
4. The statement displays the entire fields from emp in which the Empname is ALI in descending order of their age

10 - Which of the following syntax of the functions in SQL is used to add column values?

1. COUNT(*)
2. COUNT(expression)
3. SUM(expression)
4. MAX(expression)

Quiz [Lecture 23 - 31]

* All questions are mandatory.