vu cs403 Final Term - Quiz No.11
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: DML commands are used for:
inserting data into databases
creating databases
destroying databases
creating DB objects
Question 2: Incase of Context-level Diagram, the system is represented by __________.
One process atleast
Two processes atleast
One process only
Any number of processes
Question 3: Which of the following is the correct description of cache hit?
When data is found in the cache
When data is removed in the cache
The number of times the cache is accessed directly by the processor
When data is lost from the cache
Question 5: Views are generally used to focus, simplify, and customize the perception each user has of the __________.
Database
program
Operating system
View
Question 6: Which of following is not the feature of Indexes?
consume storage space
must be refreshed when the data in their master tables changes
improve the performance of SQL execution when they are used for query rewrites
can be accessed directly using a SELECT statement
Question 8: Suppose there are 4 fields in a table named CUST (customer_id, first_name, last_name, phone). Which of thefollowing gives all the information of the customers in the table whose last name is ALI?
SELECT * FROM CUST WHERE last_name='ALI';
SELECT * FROM CUST WHERE last_name=ALI;
SELECT * FROM CUSTOMER WHERE name=ALI;
SELECT * FROM CUSTOMER WHERE last_name=ALI;
Question 9: The index which has some of the key value is classified as __________.
Linear index
Dense index
Non dense index
Cluster index
Question 10: A __________ relationship exists when an association is maintained within a single entity.
unary
ternary
binary
weak
