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
[su_spoiler title="Answer" style="fancy" icon="arrow-circle-1"]
Option: D
[/su_spoiler]
- 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
[su_spoiler title="Answer" style="fancy" icon="arrow-circle-1"]
Option: D
[/su_spoiler]
- 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
[su_spoiler title="Answer" style="fancy" icon="arrow-circle-1"]
Option: C
[/su_spoiler]
- 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
[su_spoiler title="Answer" style="fancy" icon="arrow-circle-1"]
Option: A
[/su_spoiler]
- 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
[su_spoiler title="Answer" style="fancy" icon="arrow-circle-1"]
Option: C
[/su_spoiler]
- 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
[su_spoiler title="Answer" style="fancy" icon="arrow-circle-1"]
Option: C
[/su_spoiler]
- The Data Manipulation Language statements are
(a) INSERT
(b) UPDATE
(c) SELECT
(d) All of the above
(e) None of the above
[su_spoiler title="Answer" style="fancy" icon="arrow-circle-1"]
Option: D
[/su_spoiler]
- 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
[su_spoiler title="Answer" style="fancy" icon="arrow-circle-1"]
Option: B
[/su_spoiler]
- 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
[su_spoiler title="Answer" style="fancy" icon="arrow-circle-1"]
Option: D
[/su_spoiler]
- 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
[su_spoiler title="Answer" style="fancy" icon="arrow-circle-1"]
Option: C
[/su_spoiler]
Regards
Team EP