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

Can we attach the same LOV to different fields in Design time ?



DCL Provides Commands To Perform Actions Like _____________





The three language components of a database management system (DBMS) like DDL, DCL, DML. Two different types of people (users and practitioners) are concerned with them. Which of them do users of a DBMS usually deal with?





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





DCL stands for





Size of Tablespace can be increased by





A transaction completes its execution is said to be





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



What does DLL stand for ?





What are the SQL clauses supported in the link property sheet ?





Identify the RESTRICTED packaged procedure from the following





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





Which of the SQL statements is correct?





Databases overall structure is maintained in a file called





The Data Manipulation Language statements are





In SQL, which command is used to add new rows to a table?





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



What are the types of Calculated columns available ?





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



Which of the following does not affect the size of the SGA





Constraints cannot be exported through Export command?



A database trigger doesnot apply to data loaded before the definition of the trigger



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





What are the different file extensions that are created by Oracle Reports ?





Is it possible to Enable or Disable a Database trigger ?



Transactions per rollback segment is derived from





What is a RADIO GROUP ?





Multiple Tablespaces can share a single datafile



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



A Stored Procedure is a





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