Saturday, 1 April 2017

IBPS Exam : IT Officer DBMS Questions Quiz - 45

Hello Readers, Here is the very important and expected IT Officer DBMS Questions Quiz for all grade/scheme IBPS Bank Exams and competitive exams. This is the important topic for every Technical Jobs, Entrance test or MHCE exams.

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

Question 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

Question 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

Question 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

Question 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

Question 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

Question 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

Question 8. Which privilege is required to create a database?

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

Question 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

Question 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

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

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

Question 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.

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

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

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

Question 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)

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

Also read these GOLDEN IT Officer Series Quiz Questions and Answers :

No comments:

Post a Comment