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.
- 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
- 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
- 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
- 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
- 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
- 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
- The Data Manipulation Language statements are
(a) INSERT
(b) UPDATE
(c) SELECT
(d) All of the above
(e) None of the above
- 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
- 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
- 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
Regards
Team EP