1z0-082 Free 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.)