vu cs403 Final Term - Quiz No.9
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: Which of the following serves as a milestone or reference point in the log file?
Constraints
Relations
Check points
Transactions identities
Question 2: The Entity Relation Model models
Entities, Relationships and Processes
Entities and Relationships
Relationships
Entities
Question 3: Which of the following statements creates a database named COMPANY.
CREATE DATABASE company
CREATE DB company
ADD DATABASE copmany
CREATE company DATABASE
Question 4: __________ records data by burning microscopic holes in the surface of the disk with a laser.
Hard disk
RAM
Optical disk
Floppy disk
Question 5: Which of the following is CORRECT about database management system's languages?
Data definition languages are used to specify the conceptual schema only.
Data manipulation languages are used to create the databases
Data manipulation languages are used for retrieval, insertion, deletion and modification of data
Data definition langauges are only used to update data in the DBMS.
Question 6: A __________ entity has a primary key that is partially or totally derived from the parent entity in the relationship.
strong
weak
business
relationship
Question 7: Which of the following is Advantage of Re-Hashing technique to handle the collisions?
Collisions don't use primary table space
Unlimited number of elements
Fast access through use of main table space
Overhead of multiple linked lists
Question 8: Description on particular collection of data using data model
Schema
Relation
Data base
None of the above
Question 9: The ER- data model is an example of:
Physical database
Logical database
Relational database
Conceptual database
Question 10: Which of the following statements are Data Manipulation Language command?
INSERT
GRANT
TRUNCATE
CREATE
