Oracle Financials Set 1

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 1 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 1.

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

Your performance has been rated as %%RATING%%

Your answers are highlighted below.

Question 1

In Oracle, which of below are types of segments?

A	Data Segment
B	Permanent Segment
C	Object Segment
D	All of the Above

Question 2

Which is the smallest unit of storage in an Oracle database?

A	Segment
B	Data Block
C	Extent
D	Data File

Question 3

Oracle database’s design is also called as_____

A	Database Instance
B	Database Abstraction
C	Database Schema
D	None of the Above

Question 4

Is the size and content of the PGA independent on the Oracle server options installed ?

A	Yes
B	No
C	both A and B
D	None of the Above

Question 5

You can create any cluster and associated cluster index in any tablespace that is ___

A	CURRENTLY ONLINE
B	OFFLINE
C	CLOSED
D	OPEN

Question 6

What is the type of Oracle backup in which all uncommitted changes have been removed from the datafiles?

A	Inconsistent backup
B	Consistent backup
C	Full backup
D	Differential backup

Question 7

How many layers does the Oracle database have?

A	1
B	2
C	3
D	4

Question 8

Where is the data dictionary kept?

A	Stack Space
B	Data file
C	SYSTEM tablespace
D	None of the Above

Question 9

Which prefixes are available to Oracle triggers?

A	:new
B	:old
C	both A and B
D	None of the Above

Question 10

Insert & Update are DML Statements?

A	Yes
B	No
C	both A and B
D	None of the Above

Question 11

Which processes is an instance made of Oracle?

A	Memory processes
B	Oracle background processes
C	Data processes
D	All of the Above

Question 12

Which of the following scenarios ends an Oracle transaction?

A	User disconnects from Oracle
B	COMMIT or ROLLBACK is issued
C	User process terminates abnormally
D	All of the Above

Question 13

Which of the following is a collection of one or more replicated objects (typically tables) that are administrated together?

A	Replication group
B	Replica group
C	Replication
D	Replica

Question 14

which is the extension of an Oracle SQL*Plus file ?

A	.sql
B	.txt
C	.pls
D	.ora

Question 15

What do the schema objects comprise of?

A	Table
B	Index
C	Cluster
D	All of the Above

Question 16

Which of the following is true in this scenario?

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

Question 17

Which of the following components comprise an Oracle architecture?

A	Database related background processes
B	Datafiles
C	Tablespaces
D	All of the Above

Question 18

A ______ is used to logically group data together

A	Object
B	Datafiles
C	Tablespace
D	Database

Question 19

Modification schema of oracle database in one level without affecting the schema in high level is called as _______

A	Data Migration
B	Data Isolation
C	Data Independence
D	Data Abstraction

Question 20

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 21

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 22

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 23

What Oracle backup and recover file contains user and system data?

A	Datafile
B	Control file
C	OnLine ReDo file
D	Offline ReDo file

Question 24

What is the use of extent in Oracle?

A	Stores rollback information used when data must be rolled back
B	Minimize the amount of wasted (empty) storage
C	Stores user data within the database
D	None of the Above

Question 25

Which processes is an instance made of Oracle?

A	Memory processes
B	Oracle background processes
C	Data processes
D	All of the Above

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

NEXT SET 2

Study Zone

MCQ » Oracle Financials Set 1

Oracle Financials Set 1

Important Links