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 [su_spoiler title="Answer" style="fancy" icon="arrow-circle-1"] Option: D [/su_spoiler]  
  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 [su_spoiler title="Answer" style="fancy" icon="arrow-circle-1"] Option: D [/su_spoiler]    
  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 [su_spoiler title="Answer" style="fancy" icon="arrow-circle-1"] Option: C [/su_spoiler]    
  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 [su_spoiler title="Answer" style="fancy" icon="arrow-circle-1"] Option: A [/su_spoiler]  
  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 [su_spoiler title="Answer" style="fancy" icon="arrow-circle-1"] Option: C [/su_spoiler]  
  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 [su_spoiler title="Answer" style="fancy" icon="arrow-circle-1"] Option: C [/su_spoiler]  
  1. 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]  
  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 [su_spoiler title="Answer" style="fancy" icon="arrow-circle-1"] Option: B [/su_spoiler]  
  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 [su_spoiler title="Answer" style="fancy" icon="arrow-circle-1"] Option: D [/su_spoiler]  
  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 [su_spoiler title="Answer" style="fancy" icon="arrow-circle-1"] Option: C [/su_spoiler]   Regards Team EP