Database Management System (DBMS) Quiz Online Test Mcqs

Photo of Maan Ali Maan AliLast Updated: January 29, 2021

The Database Management System (DBMS) is a software designed for handling the tasks like storage, recovery and update of data in a computer system. Some famous DBMS are Oracle, Sybase, Microsoft SQL Server and MySQL. Attempt the following quiz in order to learn more about its usage, benefits and important functions.

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

  • Uncategorized
 

Question 1 of 25

Uncategorized

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

Question 1 of 25

Question 2 of 25

2. 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?

Question 2 of 25

Question 3 of 25

3. 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?

Question 3 of 25

Question 4 of 25

4. Which of the following is Database Language?

Question 4 of 25

Question 5 of 25

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

Question 5 of 25

Question 6 of 25

6. Disadvantages of File systems to store data is?

Question 6 of 25

Question 7 of 25

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

Question 7 of 25

Question 8 of 25

8. Using which language can a user request information from a database ?

Question 8 of 25

Question 9 of 25

9. Which of the following is a Data Model?

Question 9 of 25

Question 10 of 25

10. A relational database consists of a collection of?

Question 10 of 25

Question 11 of 25

11. He term attribute refers to a ___________ of a table?

Question 11 of 25

Question 12 of 25

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

Question 12 of 25

Question 13 of 25

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

Question 13 of 25

Question 14 of 25

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

Question 14 of 25

Question 15 of 25

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

Question 15 of 25

Question 16 of 25

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

Question 16 of 25

Question 17 of 25

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

Question 17 of 25

Question 18 of 25

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

Question 18 of 25

Question 19 of 25

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

Question 19 of 25

Question 20 of 25

20. In an Entity-Relationship Diagram Rectangles represents?

Question 20 of 25

Question 21 of 25

21. Which of the following is not an Schema?

Question 21 of 25

Question 22 of 25

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

Question 22 of 25

Question 23 of 25

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

Question 23 of 25

Question 24 of 25

24. Data Manipulation Language enables users to?

Question 24 of 25

Question 25 of 25

25. A Database Management System (DBMS) is?

Question 25 of 25


 

You Can Learn and Gain more Knowledge through our Online Quiz and Testing system Just Search your desired Preparation subject at Gotest.
Photo of Maan Ali Maan AliLast Updated: January 29, 2021
Photo of Maan Ali

Maan Ali

Hey there! I'm Maan Ali, your online test prep pal. Join me in the adventure of acing exams with ease. I'll share tricks, practice tests, and all you need to rock your studies. Let's make learning fun and success a sure thing!

Your Related

CCNA Quiz Online Test Mcqs

Computer MS PowerPoint Shortcuts Keys Quiz 1 Online Important Questions Answers

Computer MS Windows OS Quiz 2 Online GK Questions and Answers

MS Windows 7 Shortcuts Keys Information Quiz Online Important Question Answers

Important Internet Basic Info Quiz Online GK Questions Test

WordPress Joomla Quiz Online Test Mcqs

Show 2 comments

2 Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

© Copyright 2024, All Rights Reserved  |  Gotest
Back to top button
error: