Oracle DBA Questions Database and SQL Multiple choice questions from Placement Paper
Part 3
What is Library in Forms 4.0 ?
a Collection of External field
b Collection of built_in packages
c Collection of PL/SQl functions, procedures and packages
d Collection of PL/SQL procedures & triggers
Ans : C
Can we use a RESTRICTED packaged procedure in WHEN_TEXT_ITEM trigger ?
a Yes
b No
Ans : B
Can we use GO_BLOCK package in a PRE_TEXT_ITEM trigger ?
a Yes
b No
Ans : B
What type of file is used for porting Forms 4.5 applications to various platforms ?
a . FMB file
b . FMX file
c . FMT file
d . EXE file
Ans : C
What built_in procedure is used to get IMAGES in Forms 4.5 ?
a READ_IMAGE_FILE
b GET_IMAGE_FILE
c READ_FILE
d GET_FILE
Ans A
When a form is invoked with CALL_FORM does Oracle forms issues SAVEPOINT ?
a Yes
b No
Ans : A
Can we attach the same LOV to different fields in Design time ?
a Yes
b No
Ans : A
How do you pass values from one form to another form ?
a LOV
b Parameters
c Local variables
d None of the above
Ans : B
Can you copy the PROGRAM UNIT into an Object group ?
a Yes
b No
Ans : B
100. Can MULTIPLE DOCUMENT INTERFACE (MDI) be used in Forms 4.5 ?
a Yes
b No
Ans : A
Can MULTIPLE DOCUMENT INTERFACE (MDI) be used in Forms 4.5 ?
a Yes
b No
Ans : A
When is a .FMB file extension is created in Forms 4.5 ?
a Generating form
b Executing form
c Save form
d Run form
Ans : C
What is a Built_in subprogram ?
a Library
b Stored procedure & Function
c Collection of Subprograms
d None of the above
Ans : D
What is a RADIO GROUP ?
a Mutually exclusive
b Select more than one column
c Above all TRUE
d Above all FALSE
Ans : A
Identify the Odd one of the following statements ?
a Poplist
b Tlist
c List of values
d Combo box
Ans : C
What is an ALERT ?
a Modeless window
b Modal window
c Both are TRUE
d None of the above
Ans : B
Can an Alert message be changed at runtime ?
a Yes
b No
Ans : A
Can we create an LOV without an RECORD GROUP ?
a Yes
b No
Ans : B
How many no of columns can a RECORD GROUP have ?
a 10
b 20
c 50
d None of the above
Ans D
Oracle precompiler translates the EMBEDDED SQL statemens into
a Oracle FORMS
b Oracle REPORTS
c Oracle LIBRARY
d None of the above
Ans : D
Kind of COMMENT statements placed within SQL statements ?
a Asterisk(*) in column ?
b ANSI SQL style statements(…)
c C-Style comments (/*……*/)
d All the above
Ans : D
What is TERM ?
a TERM is the terminal definition file that describes the terminal from which you are using R20RUN
( Reports run time )
b TERM is the terminal definition file that describes the terminal from which you are using R20DES
( Reports designer )
c There is no Parameter called TERM in Reports 2.0
d None of the above
Ans : A
If the maximum records retrieved property of a query is set to 10, then a summary value will
be calculated
a Only for 10 records
b For all the records retrieved
c For all therecords in the referenced table
d None of the above
Ans : A
With which function of a summary item in the COMPUTE AT optio required ?
a Sum
b Standard deviation
c Variance
d % of Total function
Ans : 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 ?
a Yes
b No
Ans : A
What are the different file extensions that are created by Oracle Reports ?
a . RDF file & .RPX file
b . RDX file & .RDF file
c . REP file & .RDF file
d None of the above
Ans : C
Is it possible to Disable the Parameter form while running the report?
a Yes
b No
Ans : A
What are the SQL clauses supported in the link property sheet ?
a WHERE & START WITH
b WHERE & HAVING
c START WITH & HAVING
d WHERE, START WITH & HAVING
Ans : D
What are the types of Calculated columns available ?
a Summary, Place holder & Procedure column
b Summary, Procedure & Formula columns
c Procedure, Formula & Place holder columns
d Summary, Formula & Place holder columns
Ans.: D
If two groups are not linked in the data model editor, what is the hierarchy between them?
a There is no hierarchy between unlinked groups
b The group that is right ranks higher than the group that is to theleft
c The group that is above or leftmost ranks higher than the group that is to right or below it
d None of the above
Ans : C
Sequence of events takes place while starting a Database is
a Database opened, File mounted, Instance started
b Instance started, Database mounted & Database opened
c Database opened, Instance started & file mounted
d Files mounted, Instance started & Database opened
Ans : B
SYSTEM TABLESPACE can be made off-line
a Yes
b No
Ans : B
ENQUEUE_RESOURCES parameter information is derived from
a PROCESS or DDL_LOCKS & DML_LOCKS
b LOG BUFFER
c DB_BLOCK_SIZE
d DB_BLOCK_BUFFERS
Ans : A
SMON process is used to write into LOG files
a TRUE
b FALSE
Ans : B
EXP command is used
a To take Backup of the Oracle Database
b To import data from the exported dump file
c To create Rollback segments
d None of the above
Ans : A
SNAPSHOTS cannot be refreshed automatically
a TRUE
b FALSE
Ans : B
The User can set Archive file name formats
a TRUE
b FALSE
Ans : A
The following parameters are optional in init.ora parameter file DB_BLOCK_SIZE, PROCESS
a TRUE
b FALSE
Ans : B
NOARCHIEVELOG parameter is used to enable the database in Archieve mode
a TRUE
b FALSE
Ans : B
Constraints cannot be exported through Export command?
a TRUE
b FALSE
Ans : B
It is very difficult to grant and manage common priveleges needed by
different groups of database users using roles
a TRUE
b FALSE
Ans : B
The status of the Rollback segment can be viewed through
a DBA_SEGMENTS
b DBA_ROLES
c DBA_FREE_SPACES
d DBA_ROLLBACK_SEG
Ans : D
Explicitly we can assign transaction to a rollback segment
a TRUE
b FALSE
Ans : A
What file is read by ODBC to load drivers ?
a ODBC.INI
b ODBC.DLL
c ODBCDRV.INI
d None of the above
Ans : A
What is Library in Forms 4.0 ?
a Collection of External field
b Collection of built_in packages
c Collection of PL/SQl functions, procedures and packages
d Collection of PL/SQL procedures & triggers
Ans : C
Can we use a RESTRICTED packaged procedure in WHEN_TEXT_ITEM trigger ?
a Yes
b No
Ans : B
Can we use GO_BLOCK package in a PRE_TEXT_ITEM trigger ?
a Yes
b No
Ans : B
What type of file is used for porting Forms 4.5 applications to various platforms ?
a . FMB file
b . FMX file
c . FMT file
d . EXE file
Ans : C
What built_in procedure is used to get IMAGES in Forms 4.5 ?
a READ_IMAGE_FILE
b GET_IMAGE_FILE
c READ_FILE
d GET_FILE
Ans A
When a form is invoked with CALL_FORM does Oracle forms issues SAVEPOINT ?
a Yes
b No
Ans : A
Can we attach the same LOV to different fields in Design time ?
a Yes
b No
Ans : A
How do you pass values from one form to another form ?
a LOV
b Parameters
c Local variables
d None of the above
Ans : B
Can you copy the PROGRAM UNIT into an Object group ?
a Yes
b No
Ans : B
100. Can MULTIPLE DOCUMENT INTERFACE (MDI) be used in Forms 4.5 ?
a Yes
b No
Ans : A
Can MULTIPLE DOCUMENT INTERFACE (MDI) be used in Forms 4.5 ?
a Yes
b No
Ans : A
When is a .FMB file extension is created in Forms 4.5 ?
a Generating form
b Executing form
c Save form
d Run form
Ans : C
What is a Built_in subprogram ?
a Library
b Stored procedure & Function
c Collection of Subprograms
d None of the above
Ans : D
What is a RADIO GROUP ?
a Mutually exclusive
b Select more than one column
c Above all TRUE
d Above all FALSE
Ans : A
Identify the Odd one of the following statements ?
a Poplist
b Tlist
c List of values
d Combo box
Ans : C
What is an ALERT ?
a Modeless window
b Modal window
c Both are TRUE
d None of the above
Ans : B
Can an Alert message be changed at runtime ?
a Yes
b No
Ans : A
Can we create an LOV without an RECORD GROUP ?
a Yes
b No
Ans : B
How many no of columns can a RECORD GROUP have ?
a 10
b 20
c 50
d None of the above
Ans D
Oracle precompiler translates the EMBEDDED SQL statemens into
a Oracle FORMS
b Oracle REPORTS
c Oracle LIBRARY
d None of the above
Ans : D
Kind of COMMENT statements placed within SQL statements ?
a Asterisk(*) in column ?
b ANSI SQL style statements(…)
c C-Style comments (/*……*/)
d All the above
Ans : D
What is TERM ?
a TERM is the terminal definition file that describes the terminal from which you are using R20RUN
( Reports run time )
b TERM is the terminal definition file that describes the terminal from which you are using R20DES
( Reports designer )
c There is no Parameter called TERM in Reports 2.0
d None of the above
Ans : A
If the maximum records retrieved property of a query is set to 10, then a summary value will
be calculated
a Only for 10 records
b For all the records retrieved
c For all therecords in the referenced table
d None of the above
Ans : A
With which function of a summary item in the COMPUTE AT optio required ?
a Sum
b Standard deviation
c Variance
d % of Total function
Ans : 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 ?
a Yes
b No
Ans : A
What are the different file extensions that are created by Oracle Reports ?
a . RDF file & .RPX file
b . RDX file & .RDF file
c . REP file & .RDF file
d None of the above
Ans : C
Is it possible to Disable the Parameter form while running the report?
a Yes
b No
Ans : A
What are the SQL clauses supported in the link property sheet ?
a WHERE & START WITH
b WHERE & HAVING
c START WITH & HAVING
d WHERE, START WITH & HAVING
Ans : D
What are the types of Calculated columns available ?
a Summary, Place holder & Procedure column
b Summary, Procedure & Formula columns
c Procedure, Formula & Place holder columns
d Summary, Formula & Place holder columns
Ans.: D
If two groups are not linked in the data model editor, what is the hierarchy between them?
a There is no hierarchy between unlinked groups
b The group that is right ranks higher than the group that is to theleft
c The group that is above or leftmost ranks higher than the group that is to right or below it
d None of the above
Ans : C
Sequence of events takes place while starting a Database is
a Database opened, File mounted, Instance started
b Instance started, Database mounted & Database opened
c Database opened, Instance started & file mounted
d Files mounted, Instance started & Database opened
Ans : B
SYSTEM TABLESPACE can be made off-line
a Yes
b No
Ans : B
ENQUEUE_RESOURCES parameter information is derived from
a PROCESS or DDL_LOCKS & DML_LOCKS
b LOG BUFFER
c DB_BLOCK_SIZE
d DB_BLOCK_BUFFERS
Ans : A
SMON process is used to write into LOG files
a TRUE
b FALSE
Ans : B
EXP command is used
a To take Backup of the Oracle Database
b To import data from the exported dump file
c To create Rollback segments
d None of the above
Ans : A
SNAPSHOTS cannot be refreshed automatically
a TRUE
b FALSE
Ans : B
The User can set Archive file name formats
a TRUE
b FALSE
Ans : A
The following parameters are optional in init.ora parameter file DB_BLOCK_SIZE, PROCESS
a TRUE
b FALSE
Ans : B
NOARCHIEVELOG parameter is used to enable the database in Archieve mode
a TRUE
b FALSE
Ans : B
Constraints cannot be exported through Export command?
a TRUE
b FALSE
Ans : B
It is very difficult to grant and manage common priveleges needed by
different groups of database users using roles
a TRUE
b FALSE
Ans : B
The status of the Rollback segment can be viewed through
a DBA_SEGMENTS
b DBA_ROLES
c DBA_FREE_SPACES
d DBA_ROLLBACK_SEG
Ans : D
Explicitly we can assign transaction to a rollback segment
a TRUE
b FALSE
Ans : A
What file is read by ODBC to load drivers ?
a ODBC.INI
b ODBC.DLL
c ODBCDRV.INI
d None of the above
Ans : A
Also See the Part 1 and Part 2 of Oracle DBA DBMS & SQL Questions for Placement Paper