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






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?










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 ?



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