vu cs403 Final Term - Quiz No.10
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 is a feature of PRIMARY KEY constraint?
unique identifier for a row within a database table.
allow any actions that would destroy links between tables
limit the values that can be placed in a column.
enforces that the column will only accept null values.
Question 2: Which of the following is NOT a feature of a good interface?
Consistency
Process based
Data structure based
User friendly
Question 3: Which of the given techniques is/are used to improve query performance in database?
Good File organization
Indexing
Both Indexing and Good File organization
Select only one record per query
Question 4: Partitions may become unbalanced in:
Range partitioning
Hash partitioning
List partitioning
Vertical partitioning
Question 5: Which of the following is one of the purposes of using DDL commands?
inserting records into databases
updating records into databases
manipulating databases
creating and destroying databases
Question 6: Which of the following gives all the fields from employee table named as EMP?
SELECT * from EMP;
SELECT emp* from EMP'
SELECT emp_id where EMP;
SELECT * where EMP;
Question 9: Identify which of the above statements is/are correct.
Only A
Only B
Only B and C
Only A and B
Question 10: Which of the following is NOT a feature of Context DFD?
one process (which represents the entire system)
all sources/sinks (external entities)
data flows linking the process to the sources and sinks (external entities)
sub-processes (which explain and decomposed the major process into small processes)
