Oracle Placement Paper 2009 (DBA Questions & SQL Questions)

A Transaction ends
a Only when it is Committed
b Only when it is Rolledback
c When it is Committed or Rolledback
d None of the above
Ans : C

A Database Procedure is stored in the Database
a In compiled form
b As source code
c Both A & B
d Not stored
Ans : C

A database trigger doesnot apply to data loaded before the definition of the trigger
a TRUE
b FALSE
Ans : A

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
Ans : C

Which of the following does not affect the size of the SGA
a Database buffer
b Redolog buffer
c Stored procedure
d Shared pool
Ans : C

What does a COMMIT statement do to a CURSOR
a Open the Cursor
b Fetch the Cursor
c Close the Cursor
d None of the above
Ans : D

Which of the following is TRUE
1 Host variables are declared anywhere in the program
2 Host variables are declared in the DECLARE section
a Only 1 is TRUE
b Only 2 is TRUE
c Both 1 & 2are TRUE
d Both are FALSE
Ans : B

Which of the following is NOT VALID is PL/SQL
a Bool boolean;
b NUM1, NUM2 number;
c deptname dept.dname%type;
d date1 date := sysdate
Ans : B

Declare
fvar number := null; svar number := 5
Begin
goto <<>>
if fvar is null then
<<>>
svar := svar + 5
end if;
End;
What will be the value of svar after the execution ?
a Error
b 10
c 5
d None of the above
Ans : A

Which of the following is not correct about an Exception ?
a Raised automatically / Explicitly in response to an ORACLE_ERROR
b An exception will be raised when an error occurs in that block
c Process terminates after completion of error sequence.
d A Procedure or Sequence of statements may be processed.
Ans : C

Which of the following is not correct about User_Defined Exceptions ?
a Must be declared
b Must be raised explicitly
c Raised automatically in response to an Oracle error
d None of the above
Ans : C

A Stored Procedure is a
a Sequence of SQL or PL/SQL statements to perform specific function
b Stored in compiled form in the database
c Can be called from all client environmets
d All of the above
Ans : D

Which of the following statement is false
a Any procedure can raise an error and return an user message and error number
b Error number ranging from 20000 to 20999 are reserved for user defined messages
c Oracle checks Uniqueness of User defined errors
d Raise_Application_error is used for raising an user defined error.
Ans : C

Is it possible to open a cursor which is in a Package in another procedure ?
a Yes
b No
Ans : A

Is it possible to use Transactional control statements in Database Triggers?
a Yes
b No
Ans : B

Is it possible to Enable or Disable a Database trigger ?
a Yes
b No
Ans : A

PL/SQL supports datatype(s)
a Scalar datatype
b Composite datatype
c All of the above
d None of the above
Ans C

Find the ODD datatype out
a VARCHAR2
b RECORD
c BOOLEAN
d RAW
Ans : B

Which of the following is not correct about the “TABLE” datatype ?
a Can contain any no of columns
b Simulates a One-dimensional array of unlimited size
c Column datatype of any Scalar type
d None of the above
Ans : A

Find the ODD one out of the following
a OPEN
b CLOSE
c INSERT
d FETCH
Ans C

Which of the following is not correct about Cursor ?
a Cursor is a named Private SQL area
b Cursor holds temporary results
c Cursor is used for retrieving multiple rows
d SQL uses implicit Cursors to retrieve rows
Ans : B

Which of the following is NOT VALID in PL/SQL ?
a Select … into
b Update
c Create
d Delete
Ans : C

What is the Result of the following ‘VIK’NULL’RAM’ ?
a Error
b VIK RAM
c VIKRAM
d NULL
Ans : C

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
Ans : A

Is it possible to modify a Datatype of a column when column contains data ?
a Yes
b No
Ans B

Which of the following is not correct about a View ?
a To protect some of the columns of a table from other users
b Ocuupies data storage space
c To hide complexity of a query
d To hide complexity of a calculations
Ans : B

Which is not part of the Data Definiton Language ?
a CREATE
b ALTER
c ALTER SESSION
Ans : C

The Data Manipulation Language statements are
a INSERT
b UPDATE
c SELECT
d All of the above
Ans : D

EMPNO ENAME SAL
A822 RAMASWAMY 3500
A812 NARAYAN 5000
A973 UMESH
A500 BALAJI 5750
Using the above data
Select count(sal) from Emp will retrieve
a 1
b 0
c 3
d None of the above
Ans : C

If an UNIQUE KEY constraint on DATE column is created, will it accept the rows that are inserted with
SYSDATE ?
a Will
b Won’t
Ans : B

What are the different events in Triggers ?
a Define, Create
b Drop, Comment
c Insert, Update, Delete
d All of the above
Ans : C

What built-in subprogram is used to manipulate images in image items ?
a Zoom_out
b Zoom_in’
c Image_zoom
d Zoom_image
Ans : C

Can we pass RECORD GROUP between FORMS ?
a Yes
b No
Ans : A

SHOW_ALERT function returns
a Boolean
b Number
c Character
d None of the above
Ans : B

What SYSTEM VARIABLE is used to refer DATABASE TIME ?
a $$dbtime$$
b $$time$$
c $$datetime$$
d None of the above
Ans : A

SYSTEM.EFFECTIVE.DATE varaible is
a Read only
b Read & Write
c Write only
d None of the above
Ans : C

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
Ans : C

When do you get a .PLL extension ?
a Save Library file
b Generate Library file
c Run Library file
d None of the above
Ans : A

What is built_in Subprogram ?
a Stored procedure & Function
b Collection of Subprogram
c Collection of Packages
d None of the above
Ans : D

GET_BLOCK property is a
a Restricted procedure
b Unrestricted procedure
c Library function
d None of the above
Ans : D

A CONTROL BLOCK can sometimes refer to a BASETABLE ?
a TRUE
b FALSE
Ans : B

What do you mean by CHECK BOX ?
a Two state control
b One state control
c Three state control
d none of the above
Ans : C - Please check the Correcness of this Answer ( The correct answeris 2 )

List of Values (LOV) supports
a Single column
b Multi column
c Single or Multi column
d None of the above
Ans : C