Database - Oracle - Oracle Test

Test Instructions :

1. The Test is 1hr duration.
2. The Test Paper consists of 30 questions. The maximum marks are 30.
3. All the questions are multiple choice question type with three options for each question.
4. Out of the three options given for each question, only one option is the correct answer.
5. Each question is allotted 1 mark for each correct response.
6. 0.25 will be deducted for incorrect response of each question.
Start Test

   Time Left : 00 : 30    : 00

What is a DATABLOCK

  

  

  

  

SNAPSHOT is used for

  

  

  

  

Which command defines its columns, integrity constraint in create table:

  

  

  

  

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

  

  

  

  

Which is not part of the Data Definiton Language ?

  

  

  

What does DLL stand for ?

  

  

  

  

The Data Manipulation Language statements are

  

  

  

  

The packaged procedure that makes data in form permanent in the Database is

  

  

  

  

It is very difficult to grant and manage common priveleges needed by different groups of database users using roles.

  

  

Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?

  

  

  

  

SYSTEM.EFFECTIVE.DATE varaible is

  

  

  

  

Identify the Odd one of the following statements ?

  

  

  

  

Identify the RESTRICTED packaged procedure from the following

  

  

  

  

Databases overall structure is maintained in a file called

  

  

  

  

Why is it better to use an INTEGRITY CONSTRAINT to validate data in a table than to use a STORED PROCEDURE ?

  

  

  

Which of the following is not correct about a View ?

  

  

  

  

What is the maximum size of the page ?

  

  

  

  

The User can set Archive file name formats

  

  

What are the types of Calculated columns available ?

  

  

  

  

Find the temperature in increasing order of all cities

  

  

  

  

Which of the following is not correct about User_Defined Exceptions ?

  

  

  

  

Find the ODD one out of the following

  

  

  

  

A transaction completes its execution is said to be

  

  

  

  

Which of the following keyword is used with Data Control Language (DCL) statements?

  

  

  

  

For the following statements which is true 1. Page is an object owned by a form 2. Pages are a collection of display information such as constant text and graphics.

  

  

  

  

A column defined as PRIMARY KEY can have NULL's?

  

  

If the maximum records retrieved property of a query is set to 10, then a summary value will be calculated

  

  

  

  

In SQL, which command is used to SELECT only one copy of each set of duplicable rows

  

  

  

  

A set of Dictionary tables are created

  

  

  

  

Is it possible to open a cursor which is in a Package in another procedure ?

  

  

Note:
  • Click the 'Submit Test' button given in the bottom of this page to Submit your answers.
  • Test will be submitted automatically if the time expired.
  • Don't refresh the page.