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?