IBPS SO IT Officer Professional Knowledge Quiz – DBMS – 2

Hello and welcome to exampundit. Here is a set of IBPS SO IT Officer Professional Knowledge Quiz on Data Base Management System (DBMS) for IBPS IT Officer Mains exam 2018.

IBPS SO IT Officer Professional Knowledge Quiz

  1. 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) None of the above

Answer

Option: D

 

  1. Which of the following packaged procedure is UNRESTRICTED?

(a) CALL_INPUT

(b) CLEAR_BLOCK

(c) EXECUTE_QUERY

(d) USER_EXIT

(e) None of the above

Answer

Option: D

 

 

  1. Databases overall structure is maintained in a file called

(a) Redolog file

(b) Data file

(c) Control file

(d) All of the above

(e) None of the above

Answer

Option: C

 

 

  1. EMPNO ENAME SAL

A822 RAMASWAMY 3500

A812 NARAYAN 5000

A973 UMESH 2850

A500 BALAJI 5750

Use these data for the following Question

Declare a number := 5;

b number := null;

c number := 10;

Begin

if a > b AND a ( Select count(*) from Emp E2 where E1.SAL

> E2.SAL )

will retrieve

(a) 3500,5000,2500

(b) 5000,2850

(c) 2850,5750

(d) 5000,5750

(e) None of the above

Answer

Option: A

 

  1. Dedicated server configuration is

(a) One server process – Many user processes

(b) Many server processes – One user process

(c) One server process – One user process

(d) Many server processes – Many user processes

(e) None of the above

Answer

Option: C

 

  1. How can you CALL Reports from Forms4.0 ?

(a) Run_Report built_in

(b) Call_Report built_in

(c) Run_Product built_in

(d) Call_Product built_in

(e) None of the above

Answer

Option: C

 

  1. The Data Manipulation Language statements are

(a) INSERT

(b) UPDATE

(c) SELECT

(d) All of the above

(e) None of the above

Answer

Option: D

 

  1. Sequence of events takes place while starting a Database is

(a) Database opened, File mounted, Instance started

(b) 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

Answer

Option: B

 

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

(d) Summary, Formula & Place holder columns

(e) None of the above

Answer

Option: D

 

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

(a) Zoom_out

(b) Zoom_in

(c) Image_zoom

(d) Zoom_image

(e) None of the above

Answer

Option: C

 

Regards

Team EP