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

Dear Students

This is to inform that quiz 01 will be opened on Monday, December 14, 2015 and last date to attempt quiz will be Tuesday, December 15, 2015.

  • Quiz will be based on Multiple Choice Questions (MCQs). Covering video lectures 1 to 11.

+ 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: 1427

.

+ 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?)

Replies to This Discussion

New quiz

Attachments:

Today Quiz CS403 Quiz #2

15 December 2015

 

Question # 1 of 10 ( Start time: 06:34:33 PM )          Total Marks: 1

Suppose we have two entities department and University. What type of dependency exists between these two entities?

 Select correct option:

 

Question # 2 of 10 ( Start time: 06:36:02 PM )          Total Marks: 1

Which of the following is INCORRECT about naming entities?

Select correct option:

           

Singular nouns are used

           

Write in capitals

           

Organization specific names can be used

           

Always use abbreviations as they are convenient

 

 

 

Question # 3 of 10 ( Start time: 06:36:59 PM )          Total Marks: 1

Which of the following is an advantage of using the Traditional File Organization?

Select correct option:

           

Time consuming

           

Data security

           

Simplicity

           

Efficiency

 

 

Question # 4 of 10 ( Start time: 06:37:58 PM )          Total Marks: 1

Data inconsistency leads to a number of problems such as

Select correct option:

           

loss of information and incorrect results

           

less secure data

           

redundant data

           

Slow database development

 

Question # 5 of 10 ( Start time: 06:38:50 PM )          Total Marks: 1

The most widely used conceptual model is the ____ model.

Select correct option:

           

implementation

           

ER

           

Object Oriented

           

internal

 

Question # 6 of 10 ( Start time: 06:39:48 PM )          Total Marks: 1

Which of the following describe best describe the data security in DBMS?

Select correct option:

           

Efficient check on all users’ access

           

Multiple users accessing the data at the same time

           

User can access his previously stored data even if some website is hacked

           

Changes made to one location are automatically updated to another location

 

Question # 7 of 10 ( Start time: 06:40:38 PM )          Total Marks: 1

A patient can be an outdoor or indoor. Analyze this statement and tell what type of constraint will be applied on patient?

Select correct option:

           

Total completeness

           

Partial Completeness

           

Total Disjoint

           

Partial Disjoint

 

 

Question # 8 of 10 ( Start time: 06:41:25 PM )          Total Marks: 1

Data about data is database

Select correct option:

           

True

           

False

           

Partially True

           

None of the Above

 

Question # 9 of 10 ( Start time: 06:42:13 PM )          Total Marks: 1

In an ERD, the focus is on the ____ and the relationships between them.

Select correct option:

           

attributes

           

entities

           

keys

           

indexes

 

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

Entities enrolled in a relationship are called

Select correct option:

           

Roles

           

Participants

           

Instances

           

Symbols

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

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

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