Oracle Oracle Certifications 1Z0-082 Questions & Answers

• Question 121:

  In one of your databases, you create a user, HR, and then execute this command:

  GRANT CREATE SESSION TO hr WITH ADMIN OPTION;

  Which three actions can HR perform? (Choose three.)

  A. Revoke the CREATE SESSION privilege from other users

  B. Revoke the CREATE SESSION privilege from user HR

  C. Log in to the database instance

  D. Grant the CREATE SESSION privilege with ADMIN OPTION to other users

  E. Execute DDL statements in the HR schema

  F. Execute DML statements in the HR schema

  Correct Answer: ABCD

  Reference: https://docs.oracle.com/cd/B28359_01/network.111/b28531/authorization.htm#DBSEG224

• Question 122:

  An Oracle database session has an uncommitted transaction in progress which updated 5000 rows in a table. Which three situations does the transaction complete thereby committing the updates?

  A. when a DBA issues a successful SHUTDOWN TRANSACTIONAL statement and the user then issues a COMMIT

  B. when a CREATE INDEX statement is executed successfully in the same session

  C. when a COMMIT statement is issued by the same user from another session in the same database instance

  D. when the session logs out successfully

  E. when a DBA issues a successful SHUTDOWN IMMEDIATE statement and the user then issues a COMMIT

  F. when a CREATE TABLE AS SELECT statement is executed unsuccessfully in the same session

  Correct Answer: ABD

• Question 123:

  Which three activities are recorded in the database alert log? (Choose three.)

  A. Data Definition Language (DDL) statements

  B. non-default database parameters

  C. block corruption errors

  D. deadlock errors

  E. session logins and logouts

  Correct Answer: BCD

  All internal errors (ORA-600), block corruption errors (ORA-1578), and deadlock errors (ORA-60) that occur The values of all initialization parameters that had nondefault values at the time the database and instance start

  https://docs.oracle.com/cd/B28359_01/server.111/b28310/monitoring001.htm#ADMIN11247

• Question 124:

  You want to use table compression suitable for OLTP that will:

  1.

  2.

  Compress rows for all DML statements on that table

  3.

  Minimize the overheads associated with compression

  Which compression option is best suited for this?

  A. COLUMN STORE COMPRESS FOR QUERY LOW

  B. ROW STORE COMPRESS BASIC

  C. COLUMN STORE COMPRESS FOR ARCHIVE LOW

  D. COLUMN STORE COMPRESS FOR ARCHIVE HIGH

  E. ROW STORE COMPRESS ADVANCED

  Correct Answer: E

  Reference: https://www.oracle.com/technetwork/database/options/compression/advanced-compression-wp-12c-1896128.pdf

• Question 125:

  Which three statements are true about table data storage in an Oracle Database? (Choose three.)

  A. Data block headers contain their own Data Block Address (DBA)

  B. A table row piece can be chained across several database blocks

  C. Multiple row pieces from the same row may be stored in different database blocks

  D. Multiple row pieces from the same row may be stored in the same block

  E. Data block free space is always contiguous in the middle of the block

  F. Index block free space is always contiguous in the middle of the block

  Correct Answer: ACD

  Reference: https://books.google.com.pk/books?id=lNtVjrmbzckCandpg=PA267andlpg=PA267anddq=Multiple+row+pieces+from+the+same+row+may+be+stored+in+different+database +blocksandsource=blandots=lEIhFe2Q52andsig=ACfU3U1TETJPy194pARxfIJ5ROaQdySCMQandhl=enandsa=Xandved=2ahUKEwivveLa97_mAhWOzaQKHahYAVEQ6AEwAnoECAoQAQ#v=onepageandq=Multiple%20row%20pieces%20from%20the% 20same%20row%20may%20be%20stored%20in%20different%20database%20blocksandf=false/

• Question 126:

  Examine the description of the CUSTOMERS table:

  

  You want to display details of all customers who reside in cities starting with the letter D followed by at least two characters.

  Which query can be used?

  A. SELECT * FROM customers WHERE city LIKE `D_%';

  B. SELECT * FROM customers WHERE city = `%D_';

  C. SELECT * FROM customers WHERE city LIKE `D_';

  D. SELECT * FROM customers WHERE city = `D_%';

  Correct Answer: A

• Question 127:

  Which four statements are true regarding primary and foreign key constraints and the effect they can have on table data? (Choose four.)

  A. A table can have only one primary key but multiple foreign keys

  B. A table can have only one primary key and one foreign key

  C. The foreign key columns and parent table primary key columns must have the same names

  D. It is possible for child rows that have a foreign key to remain in the child table at the time the parent row is deleted

  E. It is possible for child rows that have a foreign key to be deleted automatically from the child table at the time the parent row is deleted

  F. Only the primary key can be defined at the column and table level

  G. Primary key and foreign key constraints can be defined at both the column and table level

  Correct Answer: ADEG

• Question 128:

  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;

  Correct Answer: CE

• Question 129:

  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

  Correct Answer: ACF

  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 130:

  Which two statements are true about segment types in an Oracle Database?

  A. Table segments always have two or more extents.

  B. Temporary segments are only stored in a temporary tablespace.

  C. Undo segments are only stored in an undo tablespace.

  D. Cluster segments may contain data from multiple tables.

  E. Index segments always have two or more extents.

  Correct Answer: B