Database Management System Practice Questions

Database Management System or DBMS is a system for creation and management of various database systems. The Database Management System is an integral part of many applications of modern computing. In the following section on Database Management System, we have collected practice questions from previous exams based on the concepts of the database. These questions are from the topics like the basics of database management system, types of Database Management System, and the Functions & Purpose of Database Management System.

Browse more Topics under Dbms

• Basics of DBMS
• Types of DBMS
• Function & Purpose of DBMS

Database Management System Practice Questions

Part A

Q1: What is the overall term for creating, editing, formatting, storing, retrieving a text document?    [I B P S   P. O.          2012]

A) Word processing                 B) Spreadsheet design                    C) Web design                 D) Database management        E) Presentation generation

Q2: Which of the following constrains information about a single ‘entity’ in the database like a person, place, event or thing?     [S B I   P. O. 2010]

A) Query               B) Form                 C) Record                    D) Table                E) None of the above

Q3: A program that generally has more user-friendly interface than a D B M S is called a?           [S B I     P. O. 2010]

A) front end                  B) repository               C) back end                    D) form              E) None of the above

Q4: The smallest unit of information about a record in a database is called a?       [Allahbad Bank Clerk, 2008]

A) cell                   B) field                       C) record                   D) query                    E) None of the above

Q5: A collection of conceptual tools for describing data, relationships, semantics and constraints is referred to as?        [I B P S   Clerk  2012]

A) E R mode                    B) Database                  C) Data model                   D) D B M S              E) None of these

Find Your Answers Here

Q1: D), Q2: C), Q3: D), Q4: B), Q5: C)

Part B

Q1: Dr E F Codd represented …….. rules that a database must obey if it has to be considered truly relational.                       [ I B P S   Clerk, 2012]

A) 10               B) 8                  C) 12                      D) 6                       E) 5

Q2: …………… is one reason for problems of data integrity.                     [ I B P S Clerk, 2012]

A) Data availability constraints                       B) Data inconsistency

C) Security constraints                                      D) Unauthorised access of data             E) Data redundancy

Q3: ……………….. provides total solutions to reduce data redundancy, inconsistency, dependence and unauthorized access of data.     [I B P S Clerk 2012]

A) D B M S                     B) Tables              C) Database              D) Protection passwords            E) Centralisation of data

Q4: The database stores information in?             [S B I P. O. 2010]

A) rows and columns                  B) blocks                     C) tracks and sectors                D) All of the above         E) None of the above

Q5: The database administrator’s function in an organization is?               [S B I   P. O. 2010]

A) to be responsible for the technical aspects of managing the information contained in organizational databases.

B) to be responsible for the executive level aspects of decision regarding the information management.

C) to show the relationship among entity classes in a data warehouse.

D) to define which data mining tools must be used to extract data.

E) None of the above.

Q6: The particular field of a record that uniquely identifies each record is called the?      [S B I P. O. 2012]

A) key field                   B) primary field                      C) master field                   D) order field              E) None of the above.

Find Your Answers Here

Q1: C), Q2: A), Q3: D), Q4: A), Q5:A), Q6: A)

Part C

Q1: ……………. are distinct items that don’t have much meaning to you in a given context.      [S B I    P. O. 2012]

A) Fields                      B) Data                     C) Queries                   D) Properties             E) None of the above

Q2: A logical schema….             [S B I   P. O. 2011]

A) is the entire database.                            B) is a standard way of organizing information into the accessible part.

C) describes how data is actually stored on disk                         D) All of the above              E) None of the above

Q3: In the relational modes, cardinality is termed as?            [ I B P S Clerk 2011]

A) number of tuples                     B) number of attributes

C) number of tables                      D) number of constraints                     E) None of the above

Q4: To locate a data item for storage is?               [I B P S    P. O. 2012]

A) field                B) feed                   C) database                  D) fetch                 E) None of these

Q5: An E R diagram is a graphical method of presenting?            [I B P S     Clerk 2011]

A) primary keys and their relationships                     B) primary keys and their relationships to instances.

C) entity classes and their relationships                     D) entity classes and their relationships to primary keys.                        E) None of the above

Q6: A computer checks the ………… of username and password for a match before granting access.     [S B I Clerk 2011]

A) website                  B) network              C) backup file                D) database            E) None of these.

Q7: An entity set that does not have sufficient attributes to form a primary key, is a?       [I B P S Clerk 2011]

A) strong entity set                   B) weak entity set                   C) simple entity set                  D) primary entity set            E) None of these

Find Your Answers Here

Q1: A), Q2: B), Q3: A), Q4: D), Q5: C), Q6: D), Q7: B)