Oracle Financials Set 2

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

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

Your performance has been rated as %%RATING%%

Your answers are highlighted below.

Question 1

Which of the following segment is destroyed when the SQL statement is finished?

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

Question 2

What are the valid Oracle database schemas?

A	Logical Schema
B	Physical Schema
C	Logical and Physical Schema
D	None of the Above

Question 3

Which of the following components comprise an Oracle architecture?

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

Question 4

In the below given query, which expression is evaluated first? SELECT id_number, (quantity – 100 / 0.15 – 35 * 20) FROM inventory

A	0.15-35
B	quantity – 100
C	35*20
D	100 / 0.15

Question 5

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 6

Which processes is an instance made of Oracle?

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

Question 7

Oracle database’s design is also called as_____________

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

Question 8

A _____________ is a set of tables physically stored together as one table that shares a common column

A	Index
B	Object
C	Datafiles
D	Cluster

Question 9

Which area of PGA stores binding variables and run-time buffers information?

A	SQL area
B	Private SQL area
C	Stack space
D	Session area

Question 10

Which schema object instructs Oracle to connect to remotely access an object of a database?

A	Sequence
B	Remote Link
C	Database Link
D	Data Link

Question 11

Map entities, attributes and relations in Oracle is represented by___________

A	Conceptual Schema
B	Logical Schema
C	Physical Schema
D	All of the Above

Question 12

Where is data dictionary kept?

A	SYSTEM Tablespace
B	Stack Space
C	Data File
D	None of the Above

Question 13

Collection of information stored in database at particular instance of time is called as ____________

A	Instance of Database
B	Objects in Databases
C	Data structure
D	Database Schema

Question 14

The ____________ contains a set of tables and views that Oracle uses as a reference to the database.

A	PGA
B	Library cache
C	Data dictionary
D	SGA

Question 15

How we can force a log switch?

A	By using ALTER SYSTEM LOG
B	By using ALTER SYSTEM SWITCH LOGFILE
C	By using ALTER SYSTEM SWITCH LOGS
D	By using ALTER SYS LOGFILES

Question 16

The ORDER BY clause can only be used in ___________

A	SELECT queries
B	INSERT queries
C	GROUP BY queries
D	HAVING queries

Question 17

What is the use of an index?

A	Retrieve data more quickly and efficiently
B	Related data requires much less I/O overhead if accessed simultaneously
C	Simplify the user’s perception of data access
D	All of the Above

Question 18

Which of the following object types below cannot be replicated?

A	Data
B	Trigger
C	View
D	Sequence

Question 19

A _______________ is used to logically group data together

A	Database
B	Tablespace
C	Datafiles
D	Object

Question 20

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

A	Data Block
B	Segment
C	Extent
D	Data File

Question 21

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 TRACE_ENABLED parameter to TRUE
B	Set the threshold for the Current Logons Count metric
C	Set the LOG_CHECKPOINT_TO_ALERT parameter to TRUE
D	Set the SESSIONS_PER_USER limit in the profiles used by users

Question 22

What is the use of Library cache?

A	Contains User information, such as user privileges
B	Used to store shared SQL
C	Log of changes made to the database
D	All of the Above

Question 23

The Oracle environment of database is called as ___________

A	Database Schema
B	Database Instances
C	Data Structure
D	All of the Above

Question 24

Which of the following segment is destroyed when the SQL statement is finished?

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

Question 25

The redo log buffer and Shared pool are elements of?

A	PGA
B	Buffer cache
C	PGA and Buffer cache
D	SGA

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 1

NEXT SET 3

Study Zone

MCQ » Oracle Financials Set 2

Oracle Financials Set 2

Important Links