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

A Database Language Concerned With The Definition Of The Whole Database Structure And Schema Is ________

  

  

  

  

The status of the Rollback segment can be viewed through

  

  

  

  

If two groups are not linked in the data model editor, what is the hierarchy between them?

  

  

  

  

Which of the following is not correct about the |TABLE| datatype ?

  

  

  

  

A Stored Procedure is a

  

  

  

  

TRUNCATE statement in SQL is a

  

  

  

  

SET TRANSACTION USE ROLLBACK SEGMENT is used to create user objects in a particular Tablespace

  

  

A set of Dictionary tables are created

  

  

  

  

What is SQL * FORMS ?

  

  

  

  

What is a Built_in subprogram ?

  

  

  

  

These following parameters are optional in init.ora parameter file DB_BLOCK_SIZE, PROCESSES

  

  

What is the maximum size of the page ?

  

  

  

  

POST-BLOCK trigger is also a ?

  

  

  

  

Which of the following is not included in DML (Data Manipulation Language)

  

  

  

  

Can we use GO_BLOCK package in a PRE_TEXT_ITEM trigger ?

  

  

SNAPSHOTS cannot be refreshed automatically

  

  

_________commands in SQL allow controlling access to data within database.

  

  

  

  

  

GET_BLOCK property is a

  

  

  

  

Which of the following is TRUE for the ENFORCE KEY field a. ENFORCE KEY field characterstic indicates the source of the value that SQL*FORMS uses to populate the field b. A field with the ENFORCE KEY characterstic should have the INPUT ALLOWED charaterstic turned off

  

  

  

  

What does a COMMIT statement do to a CURSOR

  

  

  

  

Identify the RESTRICTED packaged procedure from the following

  

  

  

  

Is it possible to use Transactional control statements in Database Triggers?

  

  

The language used application programs to request data from the DBMS is referred to as __________

  

  

  

  

When do you get a .PLL extension ?

  

  

  

  

The User can set Archive file name formats

  

  

Which of the following is not a type of SQL statement?

  

  

  

  

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

  

  

  

  

SYSTEM.EFFECTIVE.DATE varaible is

  

  

  

  

Can we pass RECORD GROUP between FORMS ?

  

  

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.