Oracle 1Z0-082 Online Practice Questions and Exam Preparation

Oracle 1Z0-082 Online Questions & Answers

• Question 71:

  Which two are true about shrinking a segment online? (Choose two.)

  A. It is not possible to shrink either indexes or Index Organized Tables (IOTs)
  B. It always eliminates all migrated rows if any exist in the table
  C. To shrink a table it must have a PRIMARY KEY constraint
  D. To shrink a table it must have a UNIQUE KEY constraint
  E. To shrink a table it must have row movement enabled
  F. It must be in a tablespace that uses Automatic Segment Space Management (ASSM)
  E. To shrink a table it must have row movement enabled
  F. It must be in a tablespace that uses Automatic Segment Space Management (ASSM)

  ---

  Explanation/Reference:

  Reference: https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_3001.htm

• Question 72:

  Which two statements are true about the ORDER BY clause when used with a SQL statement containing a SET operator such as UNION? (Choose two.)

  A. Column positions must be used in the ORDER BY clause
  B. Only column names from the first SELECT statement in the compound query are recognized
  C. The first column in the first SELECT of the compound query with the UNION operator is used by default to sort output in the absence of an ORDER BY clause
  D. Each SELECT statement in the compound query must have its own ORDER BY clause
  E. Each SELECT statement in the compound query can have its own ORDER BY clause
  B. Only column names from the first SELECT statement in the compound query are recognized
  C. The first column in the first SELECT of the compound query with the UNION operator is used by default to sort output in the absence of an ORDER BY clause

  ---

  Explanation/Reference:

  select employee_id,last_name "Last Name" FROM employees where employee_id=101 union select employee_id EMP_NO, last_name from employees where employee_id=113; C is correct.

• Question 73:

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

  A. writing inbound request to the common request queue from all shared server connections
  B. checking for outbound shared server responses on the common outbound response queue
  C. receiving inbound requests from processes using shared server connections
  D. sending each connection input request to the appropriate shared server input queue
  E. broadcasting shared server session responses back to requesters on all connections
  F. sending shared server session responses back to requesters on the appropriate connection
  A. writing inbound request to the common request queue from all shared server connections
  C. receiving inbound requests from processes using shared server connections
  F. sending shared server session responses back to requesters on the appropriate connection

  ---

  Explanation/Reference:

  Ref: https://docs.oracle.com/cd/B28359_01/server.111/b28310/manproc001.htm#ADMIN11168 An ***idle shared server process picks up*** the virtual circuit from the common queue

• Question 74:

  Which two statements are true about the ORDER BY clause? (Choose two.)

  A. Only columns that are specified in the SELECT list can be used in the ORDER BY clause.
  B. Numeric values are displayed in descending order if they have decimal positions.
  C. NULLS are not included in the sort operation.
  D. Column aliases can be used in the ORDER BY clause.
  E. In a character sort, the values are case-sensitive.
  D. Column aliases can be used in the ORDER BY clause.
  E. In a character sort, the values are case-sensitive.

  ---

  Explanation/Reference:

• Question 75:

  Examine the description of the PROMOTIONS table:

  

  You want to display the unique promotion costs in each promotion category.

  Which two queries can be used? (Choose two.)

  A. SELECT promo_cost, promo_category FROM promotions ORDER BY by 1;
  B. SELECT DISTINCT promo_cost || ' in ` || DISTINCT promo_category FROM promotions ORDER BY 1;
  C. SELECT DISTINCT promo_category || ` has ` || promo_cost AS COSTS FROM promotions ORDER BY 1;
  D. SELECT promo_category, DISTINCT promo_cost FROM promotions ORDER BY 2;
  E. SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1;
  C. SELECT DISTINCT promo_category || ` has ` || promo_cost AS COSTS FROM promotions ORDER BY 1;
  E. SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1;

• Question 76:

  Which compression method is recommended for Direct-Path Insert operations?

  A. COLUMN STORE COMPRESS BASIC
  B. COLUMN STORE COMPRESS ADVANCED
  C. ROW STORE COMPRESS BASIC
  D. ROW STORE COMPRESS ADVANCED
  C. ROW STORE COMPRESS BASIC

  ---

  Explanation/Reference:

• Question 77:

  Examine the description of the CUSTOMERS table: You must determine if any customers' details have been entered more than once using a different CUSTINO, by listing all duplicate names.

  

  Which two methods can you use to get the required result? (Choose two.)

  A. subquery
  B. self join
  C. LEFT OUTER JOIN with self join
  D. RIGHT OUTER JOIN With self join
  E. FULL OUTER JOIN with self join
  A. subquery
  B. self join

  ---

  Explanation/Reference:

• Question 78:

  Your database instance is started with an SPFILE.

  A PFILE is also available.

  You execute this command:

  ALTER SYSTEM SET DB_CACHE_SIZE=100K;

  Where is the value changed?

  A. in the SPFILE, SPFILE, and memory
  B. in the SPFILE and in memory
  C. only in the SPFILE
  D. in the SPFILE and PFILE
  E. only in memory
  B. in the SPFILE and in memory

  ---

  Explanation/Reference:

• Question 79:

  Which three are types of segments in an Oracle Database? (Choose three.)

  A. undo
  B. index
  C. stored procedures
  D. sequences
  E. tables
  F. clusters
  A. undo
  B. index
  E. tables

  ---

  Explanation/Reference:

  Reference: http://www.adp-gmbh.ch/ora/concepts/segments.html

• Question 80:

  Which three statements are true about time zones, date data types, and timestamp data types in an Oracle database? (Choose three.)

  A. The CURRENT_TIMESTAMP function returns data without time zone information
  B. A TIMESTAMP WITH LOCAL TIMEZONE data type column is stored in the database using the time zone of the session that inserted the row
  C. A TIMESTAMP data type column contains information about year, month, and day
  D. The DBTIMEZONE function can return an offset from Universal Coordinated Time (UTC)
  E. The SESSIONTIMEZONE function can return an offset from Universal Coordinated Time (UTC)
  B. A TIMESTAMP WITH LOCAL TIMEZONE data type column is stored in the database using the time zone of the session that inserted the row
  D. The DBTIMEZONE function can return an offset from Universal Coordinated Time (UTC)
  E. The SESSIONTIMEZONE function can return an offset from Universal Coordinated Time (UTC)

  ---

  Explanation/Reference:

  https://docs.oracle.com/database/121/NLSPG/ch4datetime.htm#GUID-CD2954CE-45E2-4938-A599-CCB96879510F