1z0-082 Practice Test

1z0-082 Practice Test practice questions, page 2 of 7, with answer review and explanations.

Question 6

You have been tasked to create a table for a banking application. One of the columns must meet three requirements: 1. Be stored in a format supporting date arithmetic without using conversion functions 2. Store a loan period of up to 10 years 3. Be used for calculating interest for the number of days the loan remains unpaid Which data type should you use?

  1. INTERVAL YEAR TO MONTH
  2. INTERVAL DAY TO SECOND
  3. TIMESTAMP WITH LOCAL TIMEZONE
  4. TIMESTAMP
  5. TIMESTAMP WITH TIMEZONE

Question 7

In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1. The TNSNAMES.ORA file in $ORACLE_HOME/network/admin in the database home contains: Which statement is true?

  1. Dynamic service registration cannot be used for this database instance
  2. The LREG process registers services dynamically with the LISTENER_1 listener
  3. LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration
  4. There are two listeners named LISTENER and LISTENER_1 running simultaneously using port 1521 on the same host as the database instances
  5. The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registration

Question 8

Which three statements are true concerning logical and physical database structures? (Choose three.)

  1. All tablespaces may have one or more data files
  2. The extents of a segment must always reside in the same datafile
  3. A smallfile tablespace might be bigger than a bigfile tablespace
  4. A segment can span multiple data files in some tablespaces
  5. A segment's blocks can be of different sizes
  6. A segment might have only one extent
  7. Segments can span multiple tablespaces

Question 9

Which two statements are true regarding a SAVEPOINT? (Choose two.)

  1. Rolling back to a SAVEPOINT can undo a CREATE INDEX statement
  2. Rolling back to a SAVEPOINT can undo a TRUNCATE statement
  3. Only one SAVEPOINT may be issued in a transaction
  4. A SAVEPOINT does not issue a COMMIT
  5. Rolling back to a SAVEPOINT can undo a DELETE statement

Question 10

Which three functions are performed by dispatchers in a shared server configuration? (Choose three.)

  1. writing inbound request to the common request queue from all shared server connections
  2. checking for outbound shared server responses on the common outbound response queue
  3. receiving inbound requests from processes using shared server connections
  4. sending each connection input request to the appropriate shared server input queue
  5. broadcasting shared server session responses back to requesters on all connections
  6. sending shared server session responses back to requesters on the appropriate connection