Database Management System (DBMS) Quiz Online Test Mcqs Questions with Answers Objective Type

1. A relational database consists of a collection of?
 
 
 
 

 

2. For each attribute of a relation, there is a set of permitted values, called the ________ of that attribute?
 
 
 
 

 

3. Which one of the following is a procedural language ?
 
 
 
 

 

4. The result which operation contains all pairs of tuples from the two relations, regardless of whether their attribute values match?
 
 
 
 

 

5. Which of the following is not a Storage Manager Component?
 
 
 
 

 

6. A domain is atomic if elements of the domain are considered to be ____________ units?
 
 
 
 

 

7. Disadvantages of File systems to store data is?
 
 
 
 

 

8. Database __________ , which is the logical design of the database, and the database _______,which is a snapshot of the data in the database at a given instant in time?
 
 
 
 

 

9. The term _______ is used to refer to a row?
 
 
 
 

 

10. Data Manipulation Language enables users to?
 
 
 
 

 

11. The tuples of the relations can be of ________ order?
 
 
 
 

 

12. Student(ID, name, dept name, tot_cred)
In this query which attribute form the primary key?
 
 
 
 

 

13. Which of the following in not a function of DBA?
 
 
 
 

 

14. Which of the following is not an Schema?
 
 
 
 

 

15. Which of the following is Database Language?
 
 
 
 

 

16. Which of the following is not a level of data abstraction?
 
 
 
 

 

17. In an Entity-Relationship Diagram Rectangles represents?
 
 
 
 

 

18. Which of the following is a Data Model?
 
 
 
 

 

19. Department (dept name, building, budget) and Employee (employee_id , name, dept name,salary)
Here the dept_name attribute appears in both the relations .Here using common attributes in relation schema is one way of relating ___________ relations?
 
 
 
 
 
20. Using which language can a user request information from a database ?
 
 
 
 

 

21. A Database Management System (DBMS) is?
 
 
 
 

 

22. The_____ operation allows the combining of two relations by merging pairs of tuples, one from each relation, into a single tuple?
 
 
 
 

 

23. A ________ in a table represents a relationship among a set of values?
 
 
 
 

 

24. Course(course_id,sec_id,semester)
Here the course_id,sec_id and semester are __________ and course is a _________ ?
 
 
 
 

 

25. He term attribute refers to a ___________ of a table?
 
 
 
 
(Visited 92 times, 1 visits today)

Comments

comments

Leave a Reply