Home › Quizzes › Oracle Database and Forms Administration

Oracle Database and Forms Administration

Practice test covering Oracle database administration topics including PL/SQL, SQL*Plus, storage management, archiving, security, privileges, and Oracle Forms development.

21 Questions Published
Play Quiz Practise this topic out loud

Questions

Question 1 Multiple Choice (Single Answer)

What command is used to encrypt a PL/SQL application?

  1. DB_ENCRYPT
  2. DBMS_ENCRYPT
  3. DBMS_WRAP
  4. WRAP
Question 2 Multiple Choice (Single Answer)

When could an index decrease the speed of a query?

  1. The column is used in a WHERE clause.
  2. The column contains a wide range of values.
  3. The table is small.
  4. The column contains a large number of null values.
Question 3 Multiple Choice (Single Answer)

The LOG_ARCHIVE_START initialization parameter for NOARCHIVELOG mode database is set to 'TRUE'. The ARCn processes are not automatically copying the online redo log files. While troubleshooting, it was verified that valid archived redo log file destinations are provided using the LOG_ARCHIVE_DEST_n initialization parameters, yet no files are written to these destinations. What should be done next?

  1. Refresh the current online redo log files.
  2. Switch the database from NOARCHIVELOG to ARCHIVELOG mode.
  3. Issue the 'ALTER SYSTEM ARCHIVE LOG START' statement to activate the ARCn processes.
  4. Shut down and restart the database to activate the ARCn processes.
Question 4 Multiple Choice (Single Answer)

Which of the following statements is true when connecting to the Oracle instance using the multithreaded server configuration?

  1. The User Global Area (UGA) may only contain sort areas
  2. The UGA may be accessible to dedicated servers.
  3. The UGA components may reside in the large pool.
  4. The UGA components may reside in the buffer cache.
Question 5 Multiple Choice (Single Answer)

What are the two types of tables involved in producing a star schema?

  1. Fact tables and user tables
  2. Dimension tables and error tables
  3. Fact tables and dimension tables
  4. User tables and error tables
Question 6 Multiple Choice (Single Answer)

MARY used an ALTER DATABASE statement on her database to perform an online control file backup. In which mode is her database operating?

  1. FAILOVER
  2. FASTBACK
  3. ARCHIVELOG
  4. NOARCHIVELOG
Question 7 Multiple Choice (Single Answer)

Which parameters should be set, to limit the number of transactions that can simultaneously make changes to data in a block, and increase the frequency with which Oracle returns a block back on the free list?

  1. INITRANS and PCTUSED
  2. MAXTRANS and PCTFREE
  3. INITRANS and PCTFREE
  4. MAXTRANS and PCTUSED
Question 8 Multiple Choice (Single Answer)

When using SQL*Plus, Oracle commands, column names, table names and all other database elements ____.

  1. are case insensitive
  2. are case sensitive
  3. must always be in lower case
  4. must always be in upper case
Question 9 Multiple Choice (Single Answer)

A database has several simultaneous long-running insert transactions. The following statement was issued to ensure that multiple server processes are used to roll back uncommitted transactions:
ALTER SYSTEM SET FAST_START_PARALLEL_ROLLBACK = 5;
What is the result?

  1. Upto five rollback processes may be activated simultaneously.
  2. The parameter will be ignored because the maximum number of rollback processes is four.
  3. The parameter will be ignored because it is set to an invalid value.
  4. This parameter will be ignored unless the RECOVERY_PARALLELISM parameter is used.
Question 10 Multiple Choice (Single Answer)

A table is being imported and it must be ensured that the table is put into a single contiguous area. There is not a single contiguous area large enough for the entire space allocated to the table. What should be done to achieve this?

  1. Use the cascade option.
  2. Use the constraint option.
  3. Use the primary key option.
  4. Coalesce the tablespace the table is using.
Question 11 Multiple Choice (Single Answer)

Which of the following privileges is an object privilege?

  1. INDEX
  2. CREATE SESSION
  3. DROP USER
  4. BACKUP ANY TABLE
Question 12 Multiple Choice (Single Answer)

Examine the syntax for creating a DEPARTMENT table:

CREATE TABLE department(

Deptno NUMBER(4),

Dname VARCNAR2(30),

mgr NUMBER(6),

Loc NUMBER(4))

STORAGE(INITIAL 200K NEXT 200K

PCTINCREASE 50 MINEXTENTS 1 MAXEXTENTS 5)

TABLESPACE userdata;

What is the size defined for the fifth extent?

  1. 200 K
  2. 300 K
  3. 450 K
  4. 675 K
Question 13 Multiple Choice (Single Answer)

Which ALTER TABLE statement should be used to add a PRIMARY KEY constraint on the MANUFACTURER_ID column of the PRODUCT table?

  1. ALTER TABLE product
    ADD PRIMARY KEY (manufacturer_id);
  2. ALTER TABLE product
    MODIFY CONSTRAINT PRIMARY KEY manufacturer_id;
  3. ALTER TABLE product
    MODIFY manufacturer_id CONSTRAINT PRIMARY KEY;
  4. ALTER TABLE product
    ADD CONSTRAINT manufacturer_id PRIMARY KEY;
Question 14 Multiple Choice (Single Answer)

How many database resource plans can be active at the same time at the database instance level?

  1. One
  2. All
  3. None
  4. Up to 2
  5. Up to 4
Question 15 Multiple Choice (Single Answer)

Five roles were created using the statements shown:

CREATE ROLE payMANAGER;

CREATE ROLE oeclerk IDENTIFIED BY salary;

CREATE ROLE hr_manager IDENTIFIED EXTERNALLY;

CREATE ROLE genuser IDENTIFIED GLOBALLY;

CREATE ROLE dev IDENTIFIED USING dev_test;

Whichof the following statements indicates that a user must be authorized to use the role by the enterprise directory service before the role is enabled?

  1. CREATE ROLE payclerk;
  2. CREATE ROLE genuser IDENTIFIED GLOBALLY;
  3. CREATE ROLE oeclerk IDENTIFIED BY salary;
  4. CREATE ROLE dev IDENTIFIED USING dev_test;
  5. CREATE ROLE hr_manager IDENTIFIED EXTERNALLY;
Question 16 Multiple Choice (Single Answer)

Which file is part of the Oracle database?

  1. Control file
  2. Password file
  3. Parameter file
  4. Archived log file
Question 17 Multiple Choice (Single Answer)

An Application was created based on the Employees Personal Information and the Department in which they work. It consists of two blocks. The first one is the Database Data block based on the Employees Personal Information like Name and Address and the other is non database data block based on the Employees Department Information. At runtime, the cursor is initially in the non database data block, the user clicks the Enter Query toolbar button and tries to search the Personal Information record of Employee whose Name is TOM. What would be the result?

  1. Query would execute and the Record providing the Department Information of the Employee matching the criteria would be displayed.
  2. Query would execute and the Record providing the Personal Information of the Employee matching the criteria would be displayed.
  3. Query would not execute as in the Enter query mode user is not allowed to navigate to other block so user can't even provide the search criteria of Employee Name in the Database data block.
Question 18 Multiple Choice (Single Answer)

What does the TRUNCATE statement do?

  1. Removes the table
  2. Removes all rows from a table
  3. Shortens the tale to 10 rows
  4. Removes all columns from a table
Question 19 Multiple Choice (Single Answer)

JOHN is running a multiple-form application. The Customers Form invoked the Orders Form. When the Orders Form launches, it displays orders for only the active customer from the Customers form. Forms exchange data with the GLOBAL.CUSTOMER_ID variable. The Orders Form should be restricted to the orders for the current customer only when the query is issued for the first time after invoking the Orders form. Which built-in helps him do this by setting the ONETIME_WHERE property to refer dynamically to the GLOBAL.CUSTOMER_ID?

  1. SET_APPLICATION_PROPERTY
  2. SET_FORM_PROPERTY
  3. SET_BLOCK_PROPERTY
  4. SET_RECORD_PROPERTY
Question 20 Multiple Choice (Single Answer)

All the buttons in a form should have the same values for several properties as the Exit button has. How can a property class be created and used to implement this?

  1. Click Create with the Property Classes node selected in the Object Navigator
    Open the Property Palette for the new property class
    Click Add Property
    Control-click the Exit button and in the Property Palette selected the properties to add
    Multiselect all the other buttons in the Object Navigator and open their Property Palette
    Click Property Class
  2. Open the Property Palette for the Exit button and multiselect the desired properties
    Click Property Class
    Multiselect all the other buttons in the Object Navigator and open their Property Palette
    Set the Subclass Information property to the name of the new property class
  3. Open the Property Palette for the Exit button and multiselect the desired properties
    Click Property Class
    Multiselect all other buttons in the Object Navigator and open their Property Palette
    Click Inherit
  4. Open the Property Palette for the Exit button and multiselect the desired properties
    Click Copy Properties
    Select the Property Class node in the Object Navigator and click Create
    Open the Property Palette for the new Property Class
    Click Paste Properties
    Multiselect all the other buttons in the Object Navigator and open their Property Palette
    Set the Subclass Information property to the name of the new property class
← Back to Quizzes