On account of the disruption in education due to the corona pandemic, we're are providing a 7-day Free trial of our platform to teachers. Know More →

IBPS

Explore popular questions from DBMS (Database management system) for IBPS. This collection covers DBMS (Database management system) previous year IBPS questions hand picked by experienced teachers.

Select Subject

Quantitative Aptitude

General Awareness

English Language

Computer Awareness

Reasoning

Hindi Language

DBMS (Database management system)

Correct Marks 1

Incorrectly Marks -0.25

Q 1. Which of the following is a database administrator's function?

A

database design

B

backing up the database

C

performance monitoring

D

user coordination

All of the above

Correct Marks 1

Incorrectly Marks -0.25

Q 2. Primitive operations common to all record management systems include

A

Print

B

Sort

Look-up

D

All of the above

E

None of the above

Correct Marks 1

Incorrectly Marks -0.25

Q 3. Each of data files has a ....... that describe the way the data is stored in the file.

File structure

B

Records

C

Fields

D

Database

E

None of the above

Correct Marks 1

Incorrectly Marks -0.25

Q 4. What is the language used by most of the DBMSs for helping their users to access data?

A

High level language

Query language

C

SQL

D

4GL

E

None of the above

Correct Marks 1

Incorrectly Marks -0.25

Q 5. Data item characteristics that are important in data management include

A

Punctuation

B

Language

C

Spelling

Width

E

None of the above

Correct Marks 1

Incorrectly Marks -0.25

Q 6. A locked file can be

accessed by only one user

B

modified by users with the correct password

C

is used to hide sensitive information

D

both (b) and (c)

E

None of the above

Correct Marks 1

Incorrectly Marks -0.25

Q 7. If the record management system allows you to edit values before they are recorded on disk, you can

correct spelling changes before they are recorded

B

change the name of a field

C

change the width of a field

D

All of the above

E

None of the above

Correct Marks 1

Incorrectly Marks -0.25

Q 8. Which command is used to remove an index from the database in SQL?

A

DELETE INDEX

DROP INDEX

C

REMOVE INDEX

D

ROLL BACK INDEX

E

None of the above

Correct Marks 1

Incorrectly Marks -0.25

Q 9. What is the name given to the database management system which is able to handle full text data, image data, audio and video?

A

Full media

B

Graphics media

Multimedia

D

Hypertext

E

None of the above

Correct Marks 1

Incorrectly Marks -0.25

Q 10. When using a database management system, the first thing that you must do is to

A

create a database file

B

activate file editor

load the software into your microcomputer

D

keep a floppy disk in readiness

E

None of the above

Correct Marks 1

Incorrectly Marks -0.25

Q 11. If the record management system allows you to edit values before they are recorded on disk, you can

correct spelling changes before they are recorded

B

change the name of a field

C

change the width of a field

D

All of the above

E

None of the above

Correct Marks 1

Incorrectly Marks -0.25

Q 12. The relational model uses some unfamiliar terminology. A tuple is equivalent to a:

Record

B

Field

C

File

D

Data base

E

Data item

Correct Marks 1

Incorrectly Marks -0.25

Q 13. Which command is used to remove an index from the database in SQL?

A

DELETE INDEX

DROP INDEX

C

REMOVE INDEX

D

ROLL BACK INDEX

E

None of the above

Correct Marks 1

Incorrectly Marks -0.25

Q 14. Which privilege is required to create a database?

SYSDBA

B

DBA

C

SYSOPER

D

RESOURCE

E

None of the above

Correct Marks 1

Incorrectly Marks -0.25

Q 15. What is the type of Oracle backup in which all uncommitted changes have been removed from the datafiles?

A

Full backup

Consistent backup

C

Inconsistent backup

D

Differential backup

E

None of the above

Correct Marks 1

Incorrectly Marks -0.25

Q 16. Which type of file is part of the Oracle database?

Control file

B

Password file

C

Parameter files

D

Archived log files

E

None of the above

Correct Marks 1

Incorrectly Marks -0.25

Q 17. When is the SGA created in an Oracle database environment?

A

When the database is created

B

When a user process is started

C

When the database is mounted

When the instance is started

E

None of the above

Correct Marks 1

Incorrectly Marks -0.25

Q 18. Which of the following packaged procedure is UNRESTRICTED?

A

CALL_INPUT

B

CLEAR_BLOCK

C

EXECUTE_QUERY

USER_EXIT

E

None of the above

Correct Marks 1

Incorrectly Marks -0.25

Q 19. Dedicated server configuration is

A

One server process - Many user processes

B

Many server processes - One user process

One server process - One user process

D

Many server processes - Many user processes

E

None of the above

Correct Marks 1

Incorrectly Marks -0.25

Q 20. How can you CALL Reports from Forms4.0 ?

A

Run_Report built_in

B

Call_Report built_in

Run_Product built_in

D

Call_Product built_in

E

None of the above

Correct Marks 1

Incorrectly Marks -0.25

Q 21. The Data Manipulation Language statements are

A

INSERT

B

UPDATE

C

SELECT

All of the above

E

None of the above

Correct Marks 1

Incorrectly Marks -0.25

Q 22. Sequence of events takes place while starting a Database is

A

Database opened, File mounted, Instance started

Instance started, Database mounted & Database opened

C

Database opened, Instance started & file mounted

D

Files mounted, Instance started & Database opened

E

None of the above

Correct Marks 1

Incorrectly Marks -0.25

Q 23. What are the types of Calculated columns available ?

A

Summary, Place holder & Procedure column

B

Summary, Procedure & Formula columns

C

Procedure, Formula & Place holder columns

Summary, Formula & Place holder columns

E

None of the above

Correct Marks 1

Incorrectly Marks -0.25

Q 24. What built-in subprogram is used to manipulate images in image items ?

A

Zoom_out

B

Zoom_in

Image_zoom

D

Zoom_image

E

None of the above

Correct Marks 1

Incorrectly Marks -0.25

Q 25. Attributes can be defined for

entity

B

switch board

C

macro

D

pages

E

None of the above