vu cs403 Final Term - Quiz No.13
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: Identify the factor which enforces a relation in 3NF?
Every non-key attribute is fully functionally dependent on primary key
Every non-key attribute is partially dependent on super key
The domain of attribute must include only atomic values.
Every non-key attribute is non-transitively dependent on primary key.
Question 2: Which of the following is not a type of user interface?
Graphical User Interface (GUI)
Forms
DB tables
Text based
Question 3: Which of the following constraints enforces entity integrity?
PRIMARY KEY
FOREIGN KEY
CHECK
NOT NULL
Question 4: Which of the following statements are Data Definition Language command?
INSERT
UPDATE
GRANT
TRUNCATE
Question 5: While recovering data, which of the following files does a recovery manager examines at first?
A system file
Log file
Data dictionary
Metadata
Question 6: Which of the following is not true regarding Indexes?
Index can be defined even when there is no data in the table
It support Range selections
It can be created using ‘Create Index' statement
It can not be created on composite attributes
Question 7: Which one is true regarding relation?
Every attribute value Non atomic
Attribute in table may not have unique name
table order of the column is relevant
the order of the rows is irrelevant
Question 8: Which of the following constraints enforces referential integrity?
FOREIGN KEY
CHECK
PRIMARY KEY
UNIQUE
Question 9: The main memory of a computer system is also known as
ROM
RAM
PROM
Hard disk
Question 10: Which of the following are the general activities, which are performed during the development of application programs?
Data input programs
Editing
Display
All of the given
