1z0-082 sample questions

Question 1

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.)

Accepted Answer

Revoke the CREATE SESSION privilege from other users

Accepted Answer

Revoke the CREATE SESSION privilege from user HR

Answer

Log in to the database instance

Answer

Grant the CREATE SESSION privilege with ADMIN OPTION to other users

Answer

Execute DDL statements in the HR schema

Answer

Execute DML statements in the HR schema

Question 2

Which three Oracle database space management features will work with both Dictionary and Locally managed tablespaces? (Choose three.)

Accepted Answer

Oracle Managed Files (OMF)

Accepted Answer

Automatic data file extension (AUTOEXTEND)

Answer

Online table segment shrink

Answer

Online index segment shrink

Answer

Capacity planning growth reports based on historical data in the Automatic workload Repository (AWR)

Question 3

You want to a pply the principle of Least Privilege in all your live databases.

One of your requirements is to revoke unnecessary privileges from all users who have them using Privilege Analysis.

Which three types of analyses can be done using the DBMS_PRMLEGE_CAPTURE package? (Choose three.)

Accepted Answer

analysis of all privileges used by all users including administrative users in the database

Accepted Answer

analysis of privileges that a user has on their own schema objects that they did not use

Accepted Answer

analysis of privileges granted indirectly to a role that are then used by a user who has been granted that role

Answer

analysis of all privileges used by all users but excluding administrative users in the database

Answer

analysis of privileges that a user has on their own schema objects that they did use

Answer

analysis of privileges granted directly to a role that are then used by a user who has been granted that role

Question 4

In one of your databases, the user HR has the password HRMGR.

You want to connect to a database instance whose listener listens on port 1531 by using this statement:

CONNECT HR/HRMGR@orcl

No name server is used.

Which statement is true about ORCL?

Accepted Answer

it must be the name of the server running the database to whose instance HR wishes to connect

Answer

it must be the value of the SERVICE_NAMES parameter on the client side

Answer

it must resolve to a valid connect descriptor in the server’s tnsnames.ora file

Answer

it must resolve to a valid connect descriptor in the client’s tnsnames.ora file

Answer

it must be the name of the database to whose instance HR wishes to connect

Question 5

Which two statements are true regarding Oracle database space management within blocks managed by Automatic Segment Space Management (ASSM)? (Choose two.)

Accepted Answer

ted for rowsC. Update operations always attempt to find blocks with free space appropriate to the length of the row being updated

Accepted Answer

A block will always be eligible for inserts if the row is short enough to fit into the block

Answer

PCTFREE defaults to 10% for all blocks in all segments for all compression methods

Answer

ASSM assigns blocks to one of four fullness categories based on what percentage of the block is all

Answer

Insert operations always attempt to find blocks with free space appropriate to the length of the row being inserted

Question 6

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

•Compress rows for all DML statements on that table
•Minimize the overheads associated with compression

Which compression option is best suited for this?

Accepted Answer

ROW STORE COMPRESS ADVANCED

Answer

COLUMN STORE COMPRESS FOR QUERY LOW

Answer

ROW STORE COMPRESS BASIC

Answer

COLUMN STORE COMPRESS FOR ARCHIVE LOW

Answer

COLUMN STORE COMPRESS FOR ARCHIVE HIGH

Question 7

Evaluate these commands which execute successfully:

Which two statements are true about the ORDJTEMS table and the ORD_SEQ sequence? (Choose two.)

Accepted Answer

Any user inserting rows into table ORDJTEMS must have been granted access to sequence ORD_SEQ

Accepted Answer

Sequence ORD_SEQ is guaranteed not to generate duplicate numbers

Answer

If sequence ORD_SEQ is dropped then the default value for column ORD_NO will be NULL for rows inserted into ORDJTEMS

Answer

Column ORD_NO gets the next number from sequence ORDJBEQ whenever a row is inserted into ORDJTEMS and no explicit value is given for ORD_NO

Answer

Sequence ORD_SEQ cycles back to 1 after every 5000 numbers and can cycle 20 times

Question 8

The INVOICE table has a QTY_SOLD column of data type NUMBER and an INVOICE_DATE column of data type DATA.

NLS_DATE_FORMAT is set to DD-MON-RR.

Which two are true about data type conversions involving these columns in query expressions? (Choose two.)

Accepted Answer

invoice_date = ’15-march-2019’: uses implicit conversion

Accepted Answer

qty_sold BETWEEN ‘101’ AND ’110’: uses implicit conversion

Answer

CONCAT (qty_sold, invoice_date): requires explicit conversion

Answer

invoie_date ) ’01-02-2019’: uses implicit conversion

Answer

qty_sold = ‘0554982’ uses implicit conversion

Question 9

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?

Accepted Answer

SELECT * FROM customers WHERE city LIKE ‘D_%’;

Answer

SELECT * FROM customers WHERE city = ‘%D_’;

Answer

SELECT * FROM customers WHERE city LIKE ‘D_’;

Answer

SELECT * FROM customers WHERE city = ‘D_%’;

Question 10

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

Accepted Answer

writing inbound request to the common request queue from all shared server connections

Accepted Answer

receiving inbound requests from processes using shared server connections

Answer

checking for outbound shared server responses on the common outbound response queue

Answer

sending each connection input request to the appropriate shared server input queue

Answer

brA. dcasting shared server session responses back to requesters on all connections

Answer

sending shared server session responses back to requesters on the appropriate connection

Free 1z0-082 sample questions

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.)

Which three Oracle database space management features will work with both Dictionary and Locally managed tablespaces? (Choose three.)

You want to a pply the principle of Least Privilege in all your live databases. One of your requirements is to revoke unnecessary privileges from all users who have them using Privilege Analysis. Which three types of analyses can be done using the DBMS_PRMLEGE_CAPTURE package? (Choose three.)

In one of your databases, the user HR has the password HRMGR. You want to connect to a database instance whose listener listens on port 1531 by using this statement: CONNECT HR/HRMGR@orcl No name server is used. Which statement is true about ORCL?

Which two statements are true regarding Oracle database space management within blocks managed by Automatic Segment Space Management (ASSM)? (Choose two.)

You want to use table compression suitable for OLTP that will: •Compress rows for all DML statements on that table •Minimize the overheads associated with compression Which compression option is best suited for this?

Evaluate these commands which execute successfully: Which two statements are true about the ORDJTEMS table and the ORD_SEQ sequence? (Choose two.)

The INVOICE table has a QTY_SOLD column of data type NUMBER and an INVOICE_DATE column of data type DATA. NLS_DATE_FORMAT is set to DD-MON-RR. Which two are true about data type conversions involving these columns in query expressions? (Choose two.)

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?

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

10 more free samples are waiting