Oracle DBA Online modal Test4

Thank you very much for taking test

Test your caliber

1. Find the ODD datatype out?
VARCHAR2	RECORD
BOOLEAN	RAW

2. Which of the following is not correct about the “TABLE” datatype ?
Can contain any no of columns	Simulates a One-dimensional array of unlimited size
Column datatype of any Scalar type	None of the above

3. Find the ODD one out of the following.
OPEN	CLOSE
simple Program	none

4. Which of the following is not correct about Cursor ?
Cursor is a named Private SQL area	Cursor holds temporary results
Cursor is used for retrieving multiple rows	SQL uses implicit Cursors to retrieve rows

5. Which of the following is NOT VALID in PL/SQL ?
Select … into	Update
Create	Delete

6. Databases overall structure is maintained in a file called_____.
Redolog file	Data file
Control file	All of the above

7. What is the Result of the following ‘VIK’NULL’RAM’ ?
Error	VIK RAM
VIKRAM	NULL

8. A CONTROL BLOCK can sometimes refer to a BASETABLE ?
TRUE	FALSE

9. Is it possible to modify a Datatype of a column when column contains data ?
Yes	No

10. Which of the following is not correct about a View ?
To protect some of the columns of a table from other users	Ocuupies data storage space
To hide complexity of a query	To hide complexity of a calculations

11. Which is not part of the Data Definiton Language ?
CREATE	ALTER
ALTER SESSION	None

12. List of Values (LOV) supports _____.
Single column	Multi column
Single or Multi column	None of the above

13. If an UNIQUE KEY constraint on DATE column is created, will it accept the rows that are inserted with SYSDATE ?
Will	Won’t

14. What are the different events in Triggers ?
Define, Create	Drop, Comment
Insert, Update, Delete	All of the above

15. What built-in subprogram is used to manipulate images in image items ?
Zoom_out	Zoom_in
Image_zoom	Zoom_image

16. Can we pass RECORD GROUP between FORMS ?
Yes	No

17. SHOW_ALERT function returns ____.
Boolean	Number
Character	None of the above

18. What SYSTEM VARIABLE is used to refer DATABASE TIME ?
$$dbtime$$	$$time$$
$$datetime$$	None of the above

19. SYSTEM.EFFECTIVE.DATE varaible is _____ .
Read only	Read & Write
Write only	None of the above

20. How can you CALL Reports from Forms4.0 ?
Run_Report built_in	Call_Report built_in
Run_Product built_in	Call_Product built_in