1z0-082 sample questions

Question 1

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

Accepted Answer

To shrink a table it must have a PRIMARY KEY constraint

Accepted Answer

To shrink a table it must have row movement enabled.

Answer

It is not possible to shrink either indexes or Index Organized Tables (IOTs)

Answer

It always eleminates all migrated ows if any exist in the table

Answer

To shrink a table it must have a UNIQUE KEY constraint

Answer

It must be in a tablespace that uses Automatic Segment Space Management (ASSM)

Question 2

Which three statements are true about dropping and unused columns in an Oracle database? (Choose three.)

Accepted Answer

a primary key column referenced by another column as a foreign key can be dropped if using the CASCADE option.

Accepted Answer

An UNUSED column’s space is reclaimed automatically when the block containing that column is next queried.

Answer

An UNUSED column’s space is reclaimed automatically when the row containing that column is next queried.

Answer

Partition key columns cannot be dropped.

Answer

A DROP COLUMN command can be rolled back

Answer

a column that is set to UNUSED still counts towards the limit of 1000 columns per table

Question 3

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 4

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 5

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 6

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 7

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 8

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 9

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 10

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

Top vendors

Top exams

Free 1z0-082 sample questions

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

Which three statements are true about dropping and unused columns in an Oracle database? (Choose three.)

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

10 more free samples are waiting