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

Quiz No.2

Dear Students

Quiz # 2 will start from Tuesday, 18th August, 2015 and will remain open for two days the last day will be Wednesday, 19th August, 2015. The lectures included in this quiz will be from Lecture # 23 to Lecture # 32.

Read the following instructions carefully before attempting the Quiz.

Quiz will be based upon Multiple Choice Questions.
You have to attempt the quiz online.
You can start attempting the quiz any time within given date(s) of a particular subject by clicking the link for Quiz in LMS.
It will be opened only for Two days (48 Hours). All overseas students should manage their quiz time according to Pakistan Standard Time (PST).
The time to attempt the Quiz is limited. Once you login to attempt the quiz, the countdown will start and you have to complete the quiz in given amount of time. So always keep an eye on the remaining time.
Attempting quiz is unidirectional. Once you move forward to the next question, you cannot come back to the previous one. Therefore before moving to the next question, make sure that you have selected the best option.
If due to any reason, access to internet is lost (like power failure or disconnection of internet), you will be able to attempt the quiz again from the position where you left in last attempt. But remember that you have to complete the quiz before expiry of the deadline.

If any student failed to attempt the quiz in given time then no re-take or offline quiz will be held.

+ Click Here To Join also Our facebook study Group.

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


See Your Saved Posts Timeline

Views: 491

.

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

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

Replies to This Discussion

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. 

CS403 Quiz # 2 Lecture 23_32 Spring 2015-08-19

Question # 1 of 10 ( Start time: 09:42:12 PM )  Total Marks:  1 

Functions in SQL return a single value

Select correct option: 

  • True
  • False

 Question # 2 of 10 ( Start time: 09:43:15 PM )  Total Marks:  1 

Which language is used to permit or prohibit access to a table?

Select correct option: 

  • DCL
  • DDL
  • DML
  • All of the above.

 Question # 3 of 10 ( Start time: 09:44:30 PM )  Total Marks:  1 

GRANT is a ______________ Command. 

Select correct option: 

  • DDL
  • DML
  • DCL  
  • None of the above

 Question # 4 of 10 ( Start time: 09:45:47 PM )  Total Marks:  1 

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; 

Select correct option: 

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

Question # 5 of 10 ( Start time: 09:47:18 PM )  Total Marks:  1 

Which of the following SQL statements used to control access to the data and to the database?

Select correct option: 

  • GRANT
  • REVOKE
  • Both GRANT and REVOKE
  • SELECT

Question # 6 of 10 ( Start time: 09:48:08 PM )  Total Marks:  1 

Which of the following clauses allows sorting the records in result set?

Select correct option: 

  • where
  • order by
  • from
  • having

Question # 7 of 10 ( Start time: 09:48:49 PM )  Total Marks:  1 

Which of the following is a correct way of selecting all the columns from a table called PERSONS?

Select correct option:

  • SELECT FROM * Persons
  • SELECT * FROM Persons
  • SELECT * WHERE Persons
  • SELECT WHERE * Persons

Question # 8 of 10 ( Start time: 09:49:52 PM )  Total Marks:  1 

__ User Interface is preferred over ________ User Interface with respect to user. 

Select correct option: 

  • Easy to understand, efficient
  • Hard to understand, efficient
  • Easy to understand, effective
  • Hard to understand, effective

Question # 9 of 10 ( Start time: 09:51:14 PM )  Total Marks:  1 

Which of the following prevents duplicate values to be displayed as a result of an SQL statement?

Select correct option: 

  • DISTINCT
  • DELETE
  • UPDATE
  • ALTER

Question # 10 of 10 ( Start time: 09:52:32 PM )  Total Marks:  1 

In SQL queries, while creating tables or relations in database, key columns may be specified by

Select correct option: 

  • Null
  • Not Null
  • Data Type
  • None of the above 

RSS

Today Top Members 

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

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