Friday, 4 December 2015

Database Management System - DBMS MCQs Quiz - 60

Dear MM readers. This is new DBMS Multiple Choice Questions (MCQ Questions) for All IBPS Bank Jobs, Bank PO and Clerk SBI PO and Clerk RRB and RBI Exams. with bold Answer on the Category of Database Management System (DBMS). In these Question set you will get 20 Objective type Questions with bold Answer related to DBMS (Database Management System). Four options are given to the each question and only one options is the correct one. Prepare your exam.All the best.

1. This is a type of program that lets one or more computer users create, manage, and access data in a database.
a. B2B
c. multidimensional database
d. None

2. In a relational database, this is a data structure that organizes the information about a single topic into rows and columns.
a. block
b. record
c. tuple
d. table

3. This is a family of relational database management system products from IBM that serve a number of different operating system platforms.
a. Cognos
b. DB2
c. ADO
d. Universal Data Access

4. This is a central repository for all or significant parts of the data that an enterprise's various business systems collect.
a. data warehouse
b. business information warehouse
c. knowledge warehouse
d. None

5. This is the job title of someone who directs or performs all activities related to maintaining a successful database environment.
a. DBA
c. PHP
d. RFC

6. This is a common standard language used to update and get information from a database.
a. VB
c. PHP
d. SQL

7. This is a file format that contains the values in a table in which column values are separated by a comma and each row starts a new line.
b. CSV file
c. virtual organization
d. None

8. In a relational database, this is the data structure that holds a single piece of data,such as first name or phone number.
a. catalog
b. field
c. entity
d. object

9. This is an organized selection of data from a database that allows you to look at it from a particular perspective.
a. Venn diagram
b. Gantt chart
c. view
d. splay tree

10. This a program tool allows you to reorganize and summarize selected columns and rows of data in a spreadsheet or database table to obtain a desired report.
a. pivot table
b. PERT chart
c. quad tree

11. At this level of normalization, each column in a table that is not a determiner of the contents of another column, must itself be a function of the other columns in the table.
a) 1NF
b) 2NF
c) 3NF

12. This method of online analytical processing stores data in both a relational and a multi dimensional database.

13. Which technology was Microsoft's first attempt at an object-oriented database interface?
a) MQSeries
b) ADO
c) DAO
d) UDA

14. What concept would a data modeler NOT be expected to know?
a) class
b) object
c) UML
d) FMP

15. Which of the following tree structures is unique in that the tree organization varies depending on which nodes are most frequently accessed?
a) B-tree
b) binary tree
c) quad tree
d) splay tree

16. The basic unit of this SQL variant is called a block.
b) XQL

17. The acronym ACID is typically used in reference to:
a) transactions
b) CRM analytics
c) data integrity
d) stubs

18. A Database Management System (DBMS) may be used by, or combined with, this type of transaction manager.
a) DB2
c) Oracle
d) Cognos

19. Encapsulation, types, classes, inheritance, overriding combined with late binding, and extensibility are all features of this type of database.
a) multidimensional database
b) relational database
c) object-oriented
d) open source

20. A programmer using this type of middleware might need the Interface Definition Language (IDL).
a) RPC
b) ORB
c) MUD
d) EAI

Read All :

Computer Awareness MCQs for Govt.Jobs Exam


  1. This technical post helps me to improve my skills set, thanks for this wonder article I expect your upcoming blog, so keep sharing.
    cognos Certification|Best COGNOS Training Institute in Chennai

  2. This is really great news. Thank you for sharing it with us!
    oracle training in chennai