Oracle Financials Set 3

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Free Online Best Oracle Financials MCQ Questions for improve your basic knowledge of Oracle Financials. This Oracle Financials set 3 test that contains 25 Multiple Choice Questions with 4 options. You have to select the right answer to a question.

Start

Congratulations - you have completed Oracle Financials Set 3.

You scored %%SCORE%% out of %%TOTAL%%.

Your performance has been rated as %%RATING%%

Your answers are highlighted below.

Question 1

What will be the value of svar after execution?

A	Error
B	10
C	5
D	4

Question 2

While the database instance is up and running, you receive an out-of-memory error due to the under-sizing of the shared pool. You checked the trace file and observed that the following error was always recorded during peak hours: ORA-04031: unable to allocate 4000 bytes of shared memory On investigation, you found that SGA_MAX_SIZE was larger than the sum of the sizes of all System Global Area (SGA) components and you do not have the scope to increase it further. Identify a solution to reduce the probability of getting this error in future___

A	Set the PRE_PAGE_SGA parameter to TRUE
B	Set the LOCK_SGA initialization parameter to TRUE
C	Implement Automatic Shared Memory Management
D	Set the SGA_TARGET initialization parameter to zero

Question 3

What is the result of the following ‘PAN’NULL’KAJ’?

A	Error
B	PAN KAJ
C	PANKAJ
D	NULL

Question 4

When a transaction modifies the database, Oracle copies the original data before modifying it. The original copy of the modified data is called

A	Undone Data
B	Archive Data
C	Redo Data
D	Undo Data

Question 5

Which statement is correct regarding undo management?

A	The database can have more than one undo tablespaces
B	The undo data must be purged manually when the transaction is over
C	The UNDO_TABLESPACE parameter is valid only if the UNDO_MANAGEMENT parameter is set AUTO OFF
D	Undo management is automatic by default even if the UNDO_MANAGEMENT initialization parameter is set to NULL

Question 6

POST-BLOCK trigger is also a ?

A	Navigational Trigger
B	Key Trigger
C	Transaction Trigger
D	All of the Above

Question 7

What is the purpose of SMON (System Monitor Process) background process?

A	Performs crash recovery when a failed instance starts up again
B	Performs recovery when a user process fails
C	Writes redo log entries to disk
D	All of the Above

Question 8

What is SQL * FORMS ?

A	SQL * FORMS is a 4GL tool for developing and executing Oracle based interactive based application
B	SQL * FORMS is a 3GL tool for connecting to a Database
C	SQL * FORMS is a reporting tool
D	None of the Above

Question 9

You want to be warned automatically when more than 100 sessions are opened with your database instance.Identify the action that would help you achieve this___

A	Set the SESSIONS_PER_USER limit in the profiles used by users
B	Set the TRACE_ENABLED parameter to TRUE
C	Set the threshold for the Current Logons Count metric
D	Set the LOG_CHECKPOINT_TO_ALERT parameter to TRUE

Question 10

You created a new user on the database by executing the following command: SQL> CREATE USER user01 IDENTIFIED BY user01 DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp; Then you granted the following privileges to user01 by executing the following command: SQL> GRANT CREATE SESSION, CREATE TABLE TO user01; Which of the following is true in this scenario?

A	The user can not create tables
B	The user can create tables
C	The user cannot query any tables
D	None of the Above

Question 11

A clerk from ABC Inc. receives a customer receipt that does not have sufficient Information to identify the customer or invoice. Which is the correct method of entering the receipt In Oracle Accounts Receivable?

A	Enter the receipt as an unapplied receipt
B	Enter the receipt as an unidentified receipt
C	Enter the receipt as an on-account receipt
D	Enter the receipt as a miscellaneous receipt

Question 12

Which of the following statement is false ?

A	Any procedure can raise a error and return an user message and error number
B	Error number is ranging from 20000 to 20999 are reserved for user defined messages
C	Oracle checks Uniqueness of User defined errors
D	Raise_Application_error is used for raising an user defined error

Question 13

In Oracle, which of the following package procedure is UNRESTRICTED ?

A	CALL_INPUT
B	CLEAR_BLOCK
C	EXECUTE_QUERY
D	USER_EXIT

Question 14

Below is the EMP table EMPNO ENAME SALARY A29 PANKAJ 10000 A23 SAHIL 20000 A48 ABHYUDAY A83 KRISHNA 30000 Select count(SALARY) from EMP; will result in___

A	0
B	1
C	2
D	3

Question 15

What does DLL stand for ?

A	Dynamic Link Library
B	Dynamic Language Library
C	Dynamic Load Library
D	None of the Above

Question 16

Which of the following queries displays the sum of all employee salaries for those employees not making commission, for each job, including only those sums greater than 2500?

A	select job, sum(Sal) from Emp where sum(Sal) > 2500 and comm is null;
B	select job, sum(Sal) from Emp where comm is null group by job having sum(Sal) > 2500;
C	select job, sum(Sal) from Emp where sum(Sal) > 2500 and comm is null group by job;
D	select job, sum(Sal) from Emp group by job having sum(Sal) > 2500 and comm is not null;

Question 17

The system variable that records the select statement that SQL * FORMS most recently used to populate a block is __________

A	SYSTEM.LAST_RECORD
B	SYSTEM.CURSOR_RECORD
C	SYSTEM.CURSOR_FIELD
D	SYSTEM.LAST_QUERY

Question 18

What SYSTEM VARIABLE is used to refer DATABASE TIME ?

A	$$dbtime$$
B	$$time$$
C	$$datetime$$
D	$$dtime$$

Question 19

A client wants to configure Oracle AP to perform prepayments for matched invoices. You have been hired as the implementation consultant and have been given the assignment. To complete this assignment, choose the option that applies____

A	Set up the prepayment terms
B	Enable Allow prepayments in the Financial Options form
C	Enable the Oracle Payables Enable Prepayments profile option
D	No additional configuration is required. Users must set up the prepayment when the invoice is created

Question 20

Which operations can be performed using the Data Recovery Ad-visor?

A	Diagnosing data failure
B	It is a percentage of rows in which the statistics are collected incrementally for partitions
C	Presenting appropriate repair options
D	Generating reports for possible causes of failure

Question 21

Recycle bin can be turned on or off this. This parameter is stored in which of the below file?

A	PARAMETER FILE
B	PARFILE
C	DATAFILES
D	PFILE

Question 22

You notice that the database instance takes a long time to start up after the instance crash. How will you resolve the problem?

A	Increase the size of the redo log files
B	Decrease the number of redo log members
C	Set LOG_CHECKPOINT_TO_ALERT to TRUE
D	Decrease the value for the FAST_START_MTTR_TARGET initialization parameter

Question 23

Oracle server configuration is dedicated for____

A	One server process – Many user processes
B	Many server processes – One user process
C	One server process – One user process
D	Many server processes – Many user processes

Question 24

Which of the following rule below are categories of index?

A	Column and Functional
B	Multiple Column and Functional
C	To create an index in another schema
D	None of the Above

Question 25

A user receives the following error while executing a query____ ORA-01555: snapshot too old Predict one way to avoid such errors in near future

A	Increase the size of redo log files
B	Increase the size of the undo tablespace
C	Increase the size of the Database Buffer Cache
D	Increase the size of the default temporary tablespace

Once you are finished, click the button below. Any items you have not completed will be marked incorrect. Get Results

There are 25 questions to complete.

←

List

→

Return

Shaded items are complete.

1	2	3	4	5
6	7	8	9	10
11	12	13	14	15
16	17	18	19	20
21	22	23	24	25
End

Return

BACK SET 2

NEXT SET 4

Study Zone

MCQ » Oracle Financials Set 3

Oracle Financials Set 3

Important Links