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

Question 1 of 25

Uncategorized

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

Divisible

Constant

Different

Indivisbile

Question 1 of 25

Question 2 of 25

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

Compiler

Query

Structural

Relational

Question 2 of 25

Question 3 of 25

3. A Database Management System (DBMS) is?

Collection of data describing one particular enterprise

Collection of interrelated data

All of the above

Collection of programs to access data

Question 3 of 25

Question 4 of 25

4. Which of the following is not an Schema?

Database Schema

Critical Schema

Physical Schema

Logical Schema

Question 4 of 25

Question 5 of 25

5. In an Entity-Relationship Diagram Rectangles represents?

Tables

Attributes

Database

Entity sets

Question 5 of 25

Question 6 of 25

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

Domain relational calculus

Query language

Tuple relational calculus

Relational algebra

Question 6 of 25

Question 7 of 25

7. A relational database consists of a collection of?

Keys

Fields

Records

Tables

Question 7 of 25

Question 8 of 25

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

Join

Intersection

Select

Union

Question 8 of 25

Question 9 of 25

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

Instance

Field

Tuple

Attribute

Question 9 of 25

Question 10 of 25

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

Critical Level

Logical Level

Physical Level

View Level

Question 10 of 25

Question 11 of 25

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

Key

Column

Row

Entry

Question 11 of 25

Question 12 of 25

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

Set difference

Join

Intersection

Cartesian product

Question 12 of 25

Question 13 of 25

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

Logical Manager

Transaction Manager

File Manager

Buffer Manager

Question 13 of 25

Question 14 of 25

14. Disadvantages of File systems to store data is?

All of the above

Difficulty in accessing data

Data redundancy and inconsistency

Data isolation

Question 14 of 25

Question 15 of 25

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

Tuple

Record

Column

Key

Question 15 of 25

Question 16 of 25

16. Which of the following is Database Language?

All of the above

Data Definition Language

Query Language

Data Manipulation Language

Question 16 of 25

Question 17 of 25

17. Data Manipulation Language enables users to?

Deletion of information from the database

Insertion of new information into the database

Retrieval of information stored in database

All of the above

Question 17 of 25

Question 18 of 25

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

Attributes of distinct

Tuple of distinct

Attributes of common

Tuple of common

Question 18 of 25

Question 19 of 25

19. Which of the following is a Data Model?

Entity-Relationship model

Object-Based data model

Relational data model

All of the above

Question 19 of 25

Question 20 of 25

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

Constant

Same

Sorted

Any

Question 20 of 25

Question 21 of 25

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

Dept

Tot_cred

ID

Name

Question 21 of 25

Question 22 of 25

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

Tuple, Relation

Attributes, Relation

Relations, Attribute

Tuple, Attributes

Question 22 of 25

Question 23 of 25

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

Relation

Set

Domain

Schema

Question 23 of 25

Question 24 of 25

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

Instance, Schema

Relation, Schema

Schema, Instance

Relation, Domain

Question 24 of 25

Question 25 of 25

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

Routine Maintenance

Network Maintenance

Schema Definition

Authorization for data access

Question 25 of 25

Test Instructions
Test Name	:	Database Management System MCQs
Subject	:	Computer General
Test Type	:	Mcqs
Total Question	:	25
Total Marks	:	50
Total Time	:	20 Minutes

Gotest

Database Management System (DBMS) Quiz Online Test Mcqs

Test Instructions

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

Uncategorized

You Might Also Like