Which of the following is not correct about a view in Oracle?

PAPER: ORACLE  PLACEMENT PAPER (SQL, PL/SQL)

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

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

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

  4. Declare
fvar number := null; svar number := 5
Begin
goto << fproc>>
if fvar is null then
<< fproc>>
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

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

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

  7. 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 environments
d] All of the above

  Ans : D

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

  9. Is it possible to open a cursor which is in a Package in another procedure ?

a] Yes
b] No

  Ans : A

  10. Is it possible to use Transactional control statements in Database Triggers ?

a] Yes
b] No

  Ans : B

  11. Is it possible to Enable or Disable a Database trigger ?

a] Yes
b] No

  Ans : A

  12. PL/SQL supports datatype(s)

a] Scalar datatype
b] Composite datatype
c] All of the above
d] None of the above

  Ans C

  13. Find the ODD data type out

a] VARCHAR2
b] RECORD
c] BOOLEAN
d] RAW

  Ans : B

  14. Which of the following is not correct about the "TABLE" data type ?

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

  15. Find the ODD one out of the following

a] OPEN
b] CLOSE
c] INSERT
d] FETCH

  Ans C

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

  18. Which of the following is NOT VALID in PL/SQL ?

a] Select ... into
b] Update
c] Create
d] Delete

  Ans : C

  19. What is the Result of the following 'VIK'||NULL||'RAM' ?

a] Error
b] VIK RAM
c] VIKRAM
d] NULL

  Ans : C

  20. Declare
a number := 5; b number := null; c number := 10;
Begin
if a > b AND a < c then
a := c * a;
end if;
End;
What will be the value of 'a' after execution ?
a] 50
b] NULL
c] 5
d] None of the above

  Ans : C

21. Does the Database trigger will fire when the table is TRUNCATED ?

a] Yes
b] No

  Ans : B

  22. SUBSTR(SQUARE ANS ALWAYS WORK HARD,14,6) will return

a] ALWAY
b} S ALWA
c] ALWAYS
Ans : C

  23. REPLACE('JACK AND JUE','J','BL') will return

a] JACK AND BLUE
b] BLACK AND JACK
c] BLACK AND BLUE
d] None of the above

  Ans : C

  24. TRANSLATE('333SQD234','0123456789ABCDPQRST','0123456789') will return

a] 333234
b] 333333
c] 234333
d] None of the above

  Ans : A

  25.. EMPNO ENAME SAL
A822 RAMASWAMY 3500
A812 NARAYAN 5000
A973 UMESH 2850
A500 BALAJI 5750

  Use these data for the following Questions

  Select SAL from EMP E1 where 3 > ( 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

  26. Is it possible to modify a Data type of a column when column contains data ?

a] Yes
b] No

  Ans B

  27. Which of the following is not correct about a View ?

a] To protect some of the columns of a table from other users
b] Occupies data storage space
c] To hide complexity of a query
d] To hide complexity of a calculations

  Ans : B

  28. Which is not part of the Data Definition Language ?

a] CREATE
b] ALTER
c] ALTER SESSION

    Ans : C

  29. The Data Manipulation Language statements are

a] INSERT
b] UPDATE
c] SELECT
d] All of the above

  Ans : D

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

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

    32. What are the different events in Triggers ?

a] Define, Create
b] Drop, Comment
c] Insert, Update, Delete
d] All of the above

  Ans : C

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

  34. Can we pass RECORD GROUP between FORMS ?

a] Yes
b] No

  Ans : A

  36. SHOW_ALERT function returns

a] Boolean
b] Number
c] Character
d] None of the above

  Ans : B

  37. What SYSTEM VARIABLE is used to refer DATABASE TIME ?

a] $$dbtime$$
b] $$time$$
c] $$datetime$$
d] None of the above

  Ans : A

  38. :SYSTEM.EFFECTIVE.DATE varaible is

a] Read only
b] Read & Write
c] Write only
d] None of the above

  Ans : C

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

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

  40. What is built_in Subprogram ?

a] Stored procedure & Function
b] Collection of Subprogram
c] Collection of Packages
d] None of the above

  Ans : D

  41. GET_BLOCK property is a

a] Restricted procedure
b] Unrestricted procedure
c] Library function
d] None of the above

Which of the following is not true about view in Oracle?

Which of the following is not correct about a view?

Which is not true about view in SQL?

Which of the following is correct about Oracle?