Technical Papers Database Questions: Oracle DBA Questions
Get top class preparation for competitive exams right from your home: 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
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
Why is it better to use an INTEGRITY CONSTRAINT to validate data in a table than to use a STORED
PROCEDURE?
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
Choice a: ENFORCE KEY field characterstic indicates the source of the value that SQL ⚹ FORMS uses to populate the field
Choice b: A field with the ENFORCE KEY characterstic should have the INPUT ALLOWED charaterstic turned off
What is the maximum size of the page?
A FORM is madeup of which of the following objects
For the following statements which is true
1 Page is an object owned by a form
2 Pages are a collection of display information such as constant text and graphics.
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
Name the two files that are created when you generate a form using Forms 3.0
What is a trigger
Which of the folowing is TRUE for a ERASE packaged procedure
All datafiles related to a Tablespace are removed when the Tablespace is dropped
Size of Tablespace can be increased by
Multiple Tablespaces can share a single datafile
A set of Dictionary tables are created
Datadictionary can span across multiple Tablespaces
What is a DATABLOCK
Can an Integrity Constraint be enforced on a table if some existing table data does not satisfy the constraint
A column defined as PRIMARY KEY can have NULL՚s
A Transaction ends
A Database Procedure is stored in the Database
A database trigger doesnot apply to data loaded before the definition of the trigger
Dedicated server configuration is
Which of the following does not affect the size of the SGA
What does a COMMIT statement do to a CURSOR
Which of the following is TRUE
1 Host variables are declared anywhere in the program
2 Host variables are declared in the DECLARE section
Which of the following is NOT VALID is PL/SQL
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?
Which of the following is not correct about an Exception?
Which of the following is not correct about User_Defined Exceptions?
A Stored Procedure is a
Which of the following statement is false
Is it possible to open a cursor which is in a Package in another procedure?
Is it possible to use Transactional control statements in Database Triggers?
Is it possible to Enable or Disable a Database trigger?
PL/SQL supports datatype (s)
Find the ODD datatype out
Which of the following is not correct about the “TABLE” datatype?
Find the ODD one out of the following
Which of the following is not correct about Cursor?
Which of the following is NOT VALID in PL/SQL?
What is the Result of the following ‘VIK’ NULL ‘RAM’
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?
Does the Database trigger will fire when the table is TRUNCATED?
SUBSTR (SQUARE ANS ALWAYS WORK HARD, 14,6) will return
REPLACE ( ‘JACK AND JUE’ ‘J’ ‘BL’ ) will return
TRANSLATE ( ‘333SQD234’ ‘0123456789ABCDPQRST’ ‘9’ ) will return
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
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
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
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?
Can we pass RECORD GROUP between FORMS?
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?
List of Values (LOV) supports
Choice a: Single column
Choice b: Multi column
Choice c: Single or Multi column
Choice d: None of the above
Answer: c
What is Library in Forms 4.0?
Choice a: Collection of External field
Choice b: Collection of built_in packages
Choice c: Collection of PL/SQl functions, procedures and packages
Choice d: Collection of PL/SQL procedures & triggers
Answer: c
Can we use a RESTRICTED packaged procedure in WHEN_TEXT_ITEM trigger?
Choice a: Yes
Choice b: No
Answer: b
Can we use GO_BLOCK package in a PRE_TEXT_ITEM trigger?
Choice a: Yes
Choice b: No
Answer: b
What type of file is used for porting Forms 4.5 applications to various platforms?
Choice a: FMB file
Choice b: FMX file
Choice c: FMT file
Choice d: EXE file
Answer: c
What built_in procedure is used to get IMAGES in Forms 4.5?
Choice a: READ_IMAGE_FILE
Choice b: GET_IMAGE_FILE
Choice c: READ_FILE
Choice d: GET_FILE
Ans A
When a form is invoked with CALL_FORM does Oracle forms issues SAVEPOINT?
Choice a: Yes
Choice b: No
Answer: a
Can we attach the same LOV to different fields in Design time?
Choice a: Yes
Choice b: No
Answer: a
How do you pass values from one form to another form?
Choice a: LOV
Choice b: Parameters
Choice c: Local variables
Choice d: None of the above
Answer: b
Can you copy the PROGRAM UNIT into an Object group?
Can MULTIPLE DOCUMENT INTERFACE (MDI) be used in Forms 4.5?
Choice a: Yes
Choice b: No
Answer: a
When is a. FMB file extension is created in Forms 4.5?
Choice a: Generating form
Choice b: Executing form
Choice c: Save form
Choice d: Run form
Answer: c
What is a Built_in subprogram?
Choice a: Library
Choice b: Stored procedure & Function
Choice c: Collection of Subprograms
Choice d: None of the above
Answer: d
What is a RADIO GROUP?
a Mutually exclusive
b Select more than one column
c Above all TRUE
d Above all FALSE
Answer: a
Identify the Odd one of the following statements?
Choice a: Poplist
Choice b: Tlist
Choice c: List of values
Choice d: Combo box
Answer: c
What is an ALERT?
Choice a: Modeless window
Choice b: Modal window
Choice c: Both are TRUE
Choice d: None of the above
Answer: b
Can an Alert message be changed at runtime?
Choice a: Yes
Choice b: No
Answer: a
Can we create an LOV without an RECORD GROUP?
Choice a: Yes
Choice b: No
Answer: b
How many no of columns can a RECORD GROUP have?
Choice a: 10
Choice b: 20
Choice c: 50
Choice d: None of the above
Answer: d
Oracle precompiler translates the EMBEDDED SQL statemens into
Choice a: Oracle FORMS
Choice b: Oracle REPORTS
Choice c: Oracle LIBRARY
Choice d: None of the above
Answer: d
Kind of COMMENT statements placed within SQL statements?
Choice a: Asterisk (⚹) in column?
Choice b: ANSI SQL style statements (…)
Choice c: C-Style comments (/ ⚹ ________ ⚹ /)
Choice d: All the above
Answer: d
What is TERM?
Choice a: TERM is the terminal definition file that describes the terminal from which you are using R20RUN (Reports run time)
Choice b: TERM is the terminal definition file that describes the terminal from which you are using R20DES (Reports designer)
Choice c: There is no Parameter called TERM in Reports 2.0
Choice d: None of the above
Answer: a
If the maximum records retrieved property of a query is set to 10, then a summary value will
be calculated
Choice a: Only for 10 records
Choice b: For all the records retrieved
Choice c: For all therecords in the referenced table
Choice d: None of the above
Answer: a
With which function of a summary item in the COMPUTE AT optio required?
Choice a: Sum
Choice b: Standard deviation
Choice c: Variance
Choice d:% of Total function
Answer: d
For a field in a repeating frame, can the source come from a column which does not exist in
the datagroup which forms the base of the frame?
Choice a: Yes
Choice b: No
Answer: a
What are the different file extensions that are created by Oracle Reports?
Choice a: RDF file & RPX file
Choice b: RDX file & RDF file
Choice c: REP file & RDF file
Choice d: None of the above
Answer: c
Is it possible to Disable the Parameter form while running the report?
Choice a: Yes
Choice b: No
Answer: a
What are the SQL clauses supported in the link property sheet?
Choice a: WHERE & START WITH
Choice b: WHERE & HAVING
Choice c: START WITH & HAVING
Choice d: WHERE, START WITH & HAVING
Answer: d
What are the types of Calculated columns available?
Choice a: Summary, Place holder & Procedure column
Choice b: Summary, Procedure & Formula columns
Choice c: Procedure, Formula & Place holder columns
Choice d: Summary, Formula & Place holder columns
Answer: d
If two groups are not linked in the data model editor, what is the hierarchy between them?
Choice a: There is no hierarchy between unlinked groups
Choice b: The group that is right ranks higher than the group that is to theleft
Choice c: The group that is above or leftmost ranks higher than the group that is to right or below it
Choice d: None of the above
Answer: c
Sequence of events takes place while starting a Database is
Choice a: Database opened, File mounted, Instance started
Choice b: Instance started, Database mounted & Database opened
Choice c: Database opened, Instance started & file mounted
Choice d: Files mounted, Instance started & Database opened
Answer: b
SYSTEM TABLESPACE can be made off-line
Choice a: Yes
Choice b: No
Answer: b
ENQUEUE_RESOURCES parameter information is derived from
Choice a: PROCESS or DDL_LOCKS & DML_LOCKS
Choice b: LOG BUFFER
Choice c: DB_BLOCK_SIZE
Choice d: DB_BLOCK_BUFFERS
Answer: a
SMON process is used to write into LOG files
Choice a: TRUE
Choice b: FALSE
Answer: b
EXP command is used
Choice a: To take Backup of the Oracle Database
Choice b: To import data from the exported dump file
Choice c: To create Rollback segments
Choice d: None of the above
Answer: a
SNAPSHOTS cannot be refreshed automatically
Choice a: TRUE
Choice b: FALSE
Answer: b
The User can set Archive file name formats
Choice a: TRUE
Choice b: FALSE
Answer: a
The following parameters are optional in init. Ora parameter file DB_BLOCK_SIZE, PROCESS
Choice a: TRUE
Choice b: FALSE
Answer: b
NOARCHIEVELOG parameter is used to enable the database in Archieve mode
Choice a: TRUE
Choice b: FALSE
Answer: b
Constraints cannot be exported through Export command?
Choice a: TRUE
Choice b: FALSE
Answer: b
It is very difficult to grant and manage common priveleges needed by
different groups of database users using roles
Choice a: TRUE
Choice b: FALSE
Answer: b
The status of the Rollback segment can be viewed through
Choice a: DBA_SEGMENTS
Choice b: DBA_ROLES
Choice c: DBA_FREE_SPACES
Choice d: DBA_ROLLBACK_SEG
Answer: d
Explicitly we can assign transaction to a rollback segment
Choice a: TRUE
Choice b: FALSE
Answer: a
What file is read by ODBC to load drivers?
Choice a: ODBC. INI
Choice b: ODBC. DLL
Choice c: ODBCDRV. INI
Choice d: None of the above
Answer: a