Oracle Database MCQs - CSE MCQs Questions and Answers

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL

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

Data Migration

Data Isolation

Data Independence

Data Abstraction

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL

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

Diagnosing data failure

It is a percentage of rows in which the statistics are collected incrementally for partitions

Presenting appropriate repair options

Generating reports for possible causes of failure

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL

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.

Set the TRACE_ENABLED parameter to TRUE

Set the threshold for the Current Logons Count metric

Set the LOG_CHECKPOINT_TO_ALERT parameter to TRUE

Set the SESSIONS_PER_USER limit in the profiles used by users

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL

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

Data Segment

Object Segment

Temporary Segment

All of the Mentioned

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL

What is the use of an index?

Retrieve data more quickly and efficiently

Related data requires much less I/O overhead if accessed simultaneously

Simplify the user's perception of data access

All of the Mentioned

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL

Which of the following statement is false ?

Any procedure can raise a error and return an user message and error number

Error number is ranging from 20000 to 20999 are reserved for user defined messages

Oracle checks Uniqueness of User defined errors

Raise_Application_error is used for raising an user defined error

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL

What is the result of the following 'PAN'NULL'KAJ'?

Error

PAN KAJ

PANKAJ

NULL

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL

Which of the following object types below cannot be replicated?

Data

Trigger

View

Sequence

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL

The ORDER BY clause can only be used in ___________

SELECT queries

INSERT queries

GROUP BY queries

HAVING queries