Placement Papers: Oracle DBA Questions

Glide to success with Doorsteptutor material for competitive exams : get questions, notes, tests, video lectures and more- for all subjects of your exam.

SNAPSHOT is used for [DBA]

We can create SNAPSHOTLOG for [DBA]

Transactions per rollback segment is derived from [DBA]

ENQUEUE resources parameter information is derived from [DBA]

LGWR process writes information into

SET TRANSACTION USE ROLLBACK SEGMENT is used to create user objects in a particular Tablespace

Databases overall structure is maintained in a file called

These following parameters are optional in init. Ora parameter file DB_BLOCK_SIZE, PROCESSES

Constraints cannot be exported through EXPORT command

It is very difficult to grant and manage common privileges needed by different groups of database users using the roles

What is difference between a DIALOG WINDOW and a DOCUMENT WINDOW regarding moving the window with respect to the application window

What is the difference between a MESSAGEBOX and an ALERT

A messagebox can be used only by the system and cannot be used in user application while an alert can be used in user application also.

A alert can be used only by the system and cannot be use din user application while an messagebox can be used in user application also.

An alert requires an response from the userwhile a messagebox just flashes a message

and only requires an acknowledment from the user

An message box requires an response from the userwhile a alert just flashes a message an only

requires an acknowledment from the user Ans: C

Which of the following is not an reason for the fact that most of the processing is done at the server?

Can a DIALOG WINDOW have scroll bar attached to it?

Which of the following is not an advantage of GUI systems?

What is the difference between a LIST BOX and a COMBO BOX?

In a CLIENT/SERVER environment, which of the following would not be done at the client?

a User interface part, b Data validation at entry line, c Responding to user events.

d None of the above Ans: D

Why is it better to use an INTEGRITY CONSTRAINT to validate data in a table than to use a STORED

Which of the following is not an advantage of a client/server model?

What does DLL stands for?

POST-BLOCK trigger is a

The system variable that records the select statement that SQL ⚹ FORMS most recently used

to populate a block is

Which of the following is TRUE for the ENFORCE KEY field

What is the maximum size of the page?

A FORM is madeup of which of the following objects

The packaged procedure that makes data in form permanent in the Database is

Which of the following is TRUE for the SYSTEM VARIABLE $ $ date $ $

Which of the following packaged procedure is UNRESTRICTED?

Identify the RESTRICTED packaged procedure from the following

What is SQL ⚹ FORMS

Is it possible to modify a Datatype of a column when column contains data?

Which of the following is not correct about a View?

Which is not part of the Data Definiton Language?

The Data Manipulation Language statements are

Select count (sal) from Emp will retrieve

If an UNIQUE KEY constraint on DATE column is created, will it accept the rows that are inserted with

SYSDATE?

What are the different events in Triggers?

What built-in subprogram is used to manipulate images in image items?

SHOW_ALERT function returns

What SYSTEM VARIABLE is used to refer DATABASE TIME?

SYSTEM. EFFECTIVE. DATE varaible is

How can you CALL Reports from Forms4.0?

When do you get a. PLL extension?

What is built_in Subprogram?

GET_BLOCK property is a

A CONTROL BLOCK can sometimes refer to a BASETABLE?

What do you mean by CHECK BOX?

What is Library in Forms 4.0?

What type of file is used for porting Forms 4.5 applications to various platforms?

What built_in procedure is used to get IMAGES in Forms 4.5?

When a form is invoked with CALL_FORM does Oracle forms issues SAVEPOINT?

How do you pass values from one form to another form?

Can you copy the PROGRAM UNIT into an Object group?

Can MULTIPLE DOCUMENT INTERFACE (MDI) be used in Forms 4.5?

When is a. FMB file extension is created in Forms 4.5?

What is a Built_in subprogram?