Institute of Banking Personnel Selection (IBPS) is an autonomous agency in India, which started its operation in 1975 as Personnel Selection Services (PSS).

IBPS is envisioned as self-governed academic and research oriented Institute, with a mission of enhancing human-resource development through personnel assessment.

As per your demand here I am providing you Questions related to DBMS of IBPS Exam

1. Which type of file is part of the Oracle database?
A.) Control file
B.) Password file
C.) Parameter files
D.) Archived log files


2. Which statements are use to UNLOCK the user?
A.) Alter user Scott account lock;
B.) Modified user Scott account unlock;
C.) Alter user Scott account unlock;
D.) Alter user Scott unlock

3. For which two constraints are indexes created when the constraint is added?
A.) Check
B.) Unique
C.) Not null
D.) Primary key
E.) Foreign key

4. What type of failure occurs when Oracle fails due to an operating system or computer hardware failure?
A.) Application failure
B.) Instance Failure
C.) Media Failure
D.) Rollback failure

5. What Oracle backup and recovery file contains user and system data?
A.) Control file
B.) Datafile
C.) OnLine ReDo file
D.) Offline ReDo file

6. 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
D.) When the instance is started
E.) When a server process is started

7. Which password management feature ensures a user cannot reuse a password for a specified time interval?
A.) Account Locking
B.) Password History
C.) Password Verification
D.) Password Expiration and Aging

8. Which privilege is required to create a database?
A.) SYSDBA
B.) DBA
C.) SYSOPER
D.) RESOURCE

9. What is the type of Oracle backup in which all uncommitted changes have been removed from the datafiles?
A.) Full backup
B.) Consistent backup
C.) Inconsistent backup
D.) Differential backup

10. Which three are the physical structures that constitute the Oracle database? (Choose three.)
A.) Table
B.) Extent
C.) Segment
D.) Data file
E.) Log file
F.) Tablespace
G.) Control file

11. What is the maximum size of the page ?
A.) Characters wide & 265 characters length
B.) Characters wide & 265 characters length
C.) Characters wide & 80 characters length
D.) None of the above

12. Relational calculus is a
A) Procedural language.
B) Non- Procedural language.
C) Data definition language.
D) High level language.

13. The view of total database content is
A) Conceptual view.
B) Internal view.
C) External view.
D) Physical View.

14. DML is provided for
A) Description of logical structure of database.
B) Addition of new structures in the database system.
C) Manipulation & processing of database.
D) Definition of physical structure of database system.

15. ‘AS’ clause is used in SQL for
A) Selection operation.
B) Rename operation.
C) Join operation.
D) Projection operation.

16. ODBC stands for
A) Object Database Connectivity.
B) Oral Database Connectivity.
C) Oracle Database Connectivity.
D) Open Database Connectivity.

17. In the architecture of a database system external level is the
A) Physical level.
B) Logical level.
C) Conceptual level
D) View level.

18. In an E-R diagram attributes are represented by
A) rectangle.
B) Square.
C) Ellipse.
D) Triangle.

19. A logical schema
A) Is the entire database.
B) Is a standard way of organizing information into accessible parts?
C) Describes how data is actually stored on disk.
D) Both (A) and (C)

20. The database environment has all of the following components except:
A) Users.
B) Separate files.
C) Database.
D) Database administrator