We are here with you hands in hands to facilitate your learning & don't appreciate the idea of copying or replicating solutions. Read More>>

Looking For Something at vustudents.ning.com? Click Here to Search

www.bit.ly/vucodes

+ Link For Assignments, GDBs & Online Quizzes Solution

www.bit.ly/papersvu

+ Link For Past Papers, Solved MCQs, Short Notes & More

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

a. Horizontal Partitioning
b. Vertical Partitioning
c. Query Optimization
d. 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.

a. Physical location
b. Table
c. Form
d. 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;

a. Projection Statement
b. Selection Statement


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

Select * from relation1 where a = b;

a. Projection Statement
b. 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’?

a. SELECT S_name FROM Supplier WHERE Item_no=’555’
b. SELECT S_name FROM Supplier, Supply WHERE Supplier.S_no=Supply.S_no AND Item_no=’555’
c. SELECT S_name FROM Supplier WHERE S_no EXISTS (SELECT S_no FROM Supply WHERE Item_no=’555’)
d. 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’;

a. The statement has a syntax error
b. The statement only displays the EmpID of those employees whose name is ALI
c. The statement displays the entire fields from emp in which the Empname is ALI
d. 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;

a. The statement displays the entire fields from emp in which the Empname is ALI in ascending order of their age
b. The statement has a syntax error
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 descending order of their age


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

a. COUNT(*)
b. COUNT(expression)
c. SUM(expression)
d. MAX(expression)

+ Click Here To Join also Our facebook study Group.

..How to Join Subject Study Groups & Get Helping Material?..

..How to become Top Reputation, Angels, Intellectual, Featured Members & Moderators?..


See Your Saved Posts Timeline

Views: 4369

.

+ http://bit.ly/vucodes (Link for Assignments, GDBs & Online Quizzes Solution)

+ http://bit.ly/papersvu (Link for Past Papers, Solved MCQs, Short Notes & More)

+ Click Here to Search (Looking For something at vustudents.ning.com?)

Attachments:

Replies to This Discussion

share ur quiz here.. 

++*ANGEL HEART*++  pls bata dain is m kitnai lecture include hn g. Auctully mairai pas to koi announcement ni h is s related

CS403 -  quiz 3

Attachments:

Please all students related this subject Share your online Quizzes here to help each other.thanks

 

Please share the question and their answers of this quiz if anyone has done.
Thanks. 

++*ANGEL HEART*++ gud keep it up & thanks for sharing 

Attention Students: You don’t need to go any other site for this assignment/GDB/Online Quiz solution, Because All discussed data of our members in this discussion are going from here to other sites (Other sites Admins posted with fake IDs at their sites :p ). You can judge this at other sites yourself. So don’t waste your precious time with different links.

cs403 gdb share krden plzzzzzzzzzzzzz

neha g y quiz ki discussion h na. yahan ni ho ga gdb

Well lecture no 31 to 38 include hn gai is m

A mega File of Final Term Solved Papers & Quizzes

Attachments:

thanks Sir May Allah bless u 

RSS

Latest Activity

© 2019   Created by + M.Tariq Malik.   Powered by

Promote Us  |  Report an Issue  |  Privacy Policy  |  Terms of Service