vu cs403 Final Term - Quiz No.2
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: Who is responsible for authorizing access to the database, for coordinating and monitoring its use ?
Database Designers
Database Administrators
End Users
Application Programmers
Question 2: Which of the following is true about application programs?
develop before the database design
Tools selection is made after the development database
meant to perform different operations by the user
must to design before the designing and developing database
Question 3: Which of the following is NOT a component of a DFD?
Dataflow
Datastore
External entities
Relationship between external entities
Question 4: Which of the following SQL commands deletes a record of an employee with the employee_id 12345, from atable named PERSON.
DELETE FROM person WHERE employee_id = ‘12345'
DELETE WHERE person FROM employee_id = 12345
DROP FROM person WHERE employee_id = 12345
DELETE WHERE person WHERE employee_id = 12345
Question 5: Which of the following is an example of volatile memory?
RAM
ROM
Flash memory
CPU
Question 6: Which of the following is not a form of optical disk?
CD ROM
WORM
Erasable Optical
EEPROM
Question 7: Which of the following is disadvantage of chaining technique to handle the collisions?
Unlimited Number of elements
Fast re-hashing
Overhead of multiple linked lists
Maximum number of elements must be known
Question 8: A collection of concepts that can be used to describe the structure of a database
Database
DBMS
Data model
Data
Question 9: A collection of related data is
Logical model
Database
Data
Relational model
Question 10: The information regarding 'views' and 'Integrity constraints' are found in
Both Data Dictionary and System Catalog
System Catalog
Data Dictionary
Indexes
