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)



Leave a Reply