Name:  

Email:  

1. A Cartesian product is:
   1. a group function
   2. Produced as a result of a join select statement with no where clause
   3. The result fuzzy logic
   4. A special feature of Oracle server

2. Which of the following choices is the strongest indicator of a parent/child relationship?
   1. Two tables in the database are named VOUCHER and VOUCHER_ITEM, respectively.
   2. Two tables in the database are named EMPLOYEE and PRODUCTS, respectively
   3. Two tables in the database were created on the same day.
   4. Two tables in the database contain none of the same columns.

3. The transaction control that prevents more than one user from updating data in a table is which of the following?
   1. Locks
   2. Commits
   3. Rollbacks
   4. Savepoints

4. Which of the following statements is true about roles? (Choice Three)
   1. Roles can be granted to other roles.
   2. Privileges can be granted to roles.
   3. roles can be granted to users.
   4. roles can be granted to synonyms.

5. Developer Janet receives an error due to the following statement in the declaration section:

   pi constant number;

   The problem is because of which of the following causes?
   1. There is not enough memory in the program for the constant.
   2. There is no value associated with the constant.
   3. There is no datatype associated with the constant.
   4. Pi is a reserved word

6. You are determining the appropriate program flow for your PL/SQL application. Which of the following statements are true about while loops?
   1. Explicit exit statements are required in while loops.
   2. Counter variables are required in while loops.
   3. An if-then statement is needed to signal when a while loop should end.
   4. All exit conditions for while loops are handled in the exit when clause.

7. To control the allocation of additional extents for a table or index, which of the following choices is most appropriate?
   1. Make the next extent be allocated as high as possible
   2. Specify a high pctused
   3. Specify a low pctfree
   4. Make the initial segment allocated be large enough to accommodate all data plus growth

8. In order to improve the hit ratio on your library cache, you will want to configure Oracle in such a way that which of the following statistics decreases?
   1. reloads
   2. physical reads
   3. gets
   4. getmisses
   5. consistent gets
   6. pins
   7. db block gets

9. You are about to configure sorting operations on your database. Before using sort direct writes, the DBA should first ensure that which of the following conditions are met?
   1. SORT_AREA_SIZE is larger than DB_BLOCK_BUFFERS
   2. SORT_DIRECT_WRITES is greater than 10
   3. SORT_TEMP_TABLESPACES contains the name of the tablespaces holding temporary segments
   4. All temporary segments are placed in the SYSTEM tablespace
   5. There is enough real memory to store a number of bytes equal to or greater than SORT_WRITE_BUFFERS * SORT_WRITE_BUFFER_SIZE

10. You are designing an application's data change operations and trying to determine which changes would be less invasive for concurrency purposes. The type of lock obtained by an update process is which of the following?
    1. Share lock
    2. Exclusive lock
    3. Share-row-exclusive lock
    4. Row-share lock
    5. Row-exclusive lock

11. An excerpt of the contents of a trace file is listed as follows:

    (c770) nsprecv: packet dump
    (c770) nsprecv: 00 72 00 00 06 00 00 00 |.r......|
    (c770) nsprecv: 00 00 04 00 00 00 00 F5 |........|
    (c770) nsprecv: 03 00 00 00 00 02 00 00 |........|
    (c770) nsprecv: 00 18 00 00 00 00 21 00 |......!.|
    (c770) nsprecv: 00 00 00 00 00 00 00 00 |........|
    (c770) nsprecv: 00 00 00 00 00 00 00 00 |........|
    (c770) nsprecv: 00 00 00 00 31 00 00 01 |....1...|
    (c770) nsprecv: 00 00 00 36 4F 52 41 2D |...6ORA-|
    (c770) nsprecv: 30 31 30 31 33 3A 20 75 |01013: u|
    (c770) nsprecv: 73 65 72 20 72 65 71 75 |ser requ|
    (c770) nsprecv: 65 73 74 65 64 20 63 61 |ested ca|
    (c770) nsprecv: 6E 63 65 6C 20 6F 66 20 |ncel of |
    (c770) nsprecv: 63 75 72 72 65 6E 74 20 |current |
    (c770) nsprecv: 6F 70 65 72 61 74 69 6F |operatio|
    (c770) nsprecv: 6E 0A 00 00 00 00 00 00 |n.......|
    (c770) nsprecv: normal exit
    

    What Net8 network-layer component produced this output?
    1. Two-Task Common
    2. Network Interface
    3. Network Session
    4. Network Transport
    5. Network Authentication

12. What parameter is used to carry a message into the queue with the enqueue( ) procedure?
    1. message
    2. msgid
    3. queue_data
    4. payload