vu cs403 Final Term - Quiz No.7
vu cs403 Database Management Systems Quiz
This quiz belongs to book/course code vu cs403 Database Management Systems of vu organization. We have 18 quizzes available related to the book/course Database Management Systems. This quiz has a total of 10 multiple choice questions (MCQs) to prepare and belongs to topic Final Term. NVAEducation wants its users to help them learn in an easy way. For that purpose, you are free to prepare online MCQs and quizzes.
NVAEducation also facilitates users to contribute in online competitions with other students to make a challenging situation to learn in a creative way. You can create one to one, and group competition on an topic of a book/course code. Also on NVAEducation you can get certifications by passing the online quiz test.
Question 1: What is the alternate name of Data Dictionary?
Index
Metadata
Data
System Catalog
Question 2: Which of the following is true about TRUNCATE?
Can be Rolled back.
Activates Triggers
is DML Command.
Resets identity of the table
Question 4: In which of the following, Materialized Views are suitable
Data warehousing
Decision support
Mobile computing
All of the Given
Question 5: In SQL queries, while creating tables or relations in database, key columns may be specified by
Data type
Null
Not Null
Owner
Question 6: Which of the following is not true with respect to denormalization ?
A denormalized data model is not the same as a data model that has not been normalized
Denormalization takes place before the normalization process
It is an attempt to optimize the performance of database
Denormalization process can not be initiated before the Database design
Question 7: User rights information is stored in
Physical database
Catalog
Logical database
Buffer
Question 8: __________ provides rapid, non-sequential, direct access to records.
Hashing
Collision handling
Non Hashing
sequential
Question 9: Which of the following is NOT one of the ways of resolving deadlocks?
Undoing all the updates made by the particular transaction which is the cause of deadlock.
A message is passed to the victim and depending on the system the transaction may or may not bestarted again automatically
Picking a list of all previously completed transactions and undoing all the updates.
Rollback `victim' transaction and restart it
Question 10: Which of the following is a correct way of selecting all the columns from a table called PERSONS?
SELECT FROM * Persons
SELECT * FROM Persons
SELECT * WHERE Persons
SELECT WHERE * Persons
