1Z0-060 Online Practice Questions and Answers

Examine the following steps of privilege analysis for checking and revoking excessive, unused privileges granted to users:

1.

Create a policy to capture the privilege used by a user for privilege analysis.

2.

Generate a report with the data captured for a specified privilege capture.

3.

Start analyzing the data captured by the policy.

4.

Revoke the unused privileges.

5.

Compare the used and unused privileges' lists.

6.

Stop analyzing the data.

Identify the correct sequence of steps.

A. 1, 3, 5, 6, 2, 4

B. 1, 3, 6, 2, 5, 4

C. 1, 3, 2, 5, 6, 4

D. 1, 3, 2, 5, 6, 4

E. 1, 3, 5, 2, 6, 4

You are the DBA supporting an Oracle 11g Release 2 database and wish to move a table containing several DATE, CHAR, VARCHAR2, and NUMBER data types, and the table's indexes, to another tablespace.

The table does not have a primary key and is used by an OLTP application.

Which technique will move the table and indexes while maintaining the highest level of availability to the application?

A. Oracle Data Pump

B. An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD to move the indexes.

C. An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD ONLINE to move the indexes

D. Online Table Redefinition

E. Edition-Based Table Redefinition

Examine the contents of SQL loader control file:

Which three statements are true regarding the SQL* Loader operation performed using the control file?

A. An EMP table is created if a table does not exist. Otherwise, if the EMP table is appended with the loaded data.

B. The SQL* Loader data file myfile1.dat has the column names for the EMP table.

C. The SQL* Loader operation fails because no record terminators are specified.

D. Field names should be the first line in the both the SQL* Loader data files.

E. The SQL* Loader operation assumes that the file must be a stream record format file with the normal carriage return string as the record terminator.

You configure your database Instance to support shared server connections.

Which two memory areas that are part of PGA are stored in SGA instead, for shared server connection?

A. User session data

B. Stack space

C. Private SQL area

D. Location of the runtime area for DML and DDL Statements

E. Location of a part of the runtime area for SELECT statements

Your multitenant container database (CDB) contains pluggable databases (PDBs), you are connected to the PDB HR_PDB. You execute the following command:

What is the result?

A. It executes successfully and creates an UNDO tablespace in HR_PDB.

B. It falls and reports an error because there can be only one UNDO tablespace in a CDB.

C. It fails and reports an error because the CONTAINER=ALL clause is not specified in the command.

D. It fails and reports an error because the CONTAINER=CURRENT clause is not specified in the command.

E. It executes successfully but neither tablespace nor the data file is created.

Which two statements are true when row-archival management is enabled? (Choose two.)

A. The ORA_ARCHIVE_STATE column is updated manually or by a program that can reference activity tracking columns, to indicate that a row is no longer considered active.

B. Visibility of the ORA_ARCHIVE_STATE column is controlled by the ROW ARCHIVAL VISIBILITY session parameter.

C. The ROW ARCHIVAL VISIBILITY session parameter defaults to all rows.

D. The ORA_ARCHIVE_STATE column is visible if it is referenced in the select list of a query.

E. The ORA_ARCHIVE_STATE column is updated automatically by the database based on activity tracking columns, to indicate that a row is no longer considered active.

In your database, the TBS PERCENT USED parameter is set to 60 and the TBS PERCENT FREE parameter is set to 20.

Which two storage-tiering actions might be automated when using information Lifecycle Management (ILM) to automate data movement?

A. The movement of all segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED

B. The movement of some blocks to a target tablespace with a lower degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED

C. The movement of some segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED

D. Setting the target tablespace to read-only after the segments are moved

E. Taking the target tablespace offline after the segments are moved

Which three are amongst the categories into which column definitions are classifies by the Database Migration Assistant for Unicode (DMU)?

A. alphanumeric columns that will have invalid binary representation after converting to the chosen Unicode character set

B. alphanumeric columns that need conversion to a different binary representation before converging to the chosen Unicode character set

C. date columns that will have invalid binary representation after converting to the chosen Unicode character set

D. numeric columns that will have invalid binary representation after converting to the chosen Unicode character set

E. numeric columns that will exceed the column size limit after converting to the chosen Unicode character set

F. alphanumeric columns that need no conversion

Which three statements are true about adaptive SQL plan management?

A. It adds new; bettor plans automatically as fixed plans to the baseline.

B. The non-accepted plans are automatically accepted and become usable by the optimizer if they perform better than the existing accepted plans.

C. It automatically performs verification or evolves non-accepted plans, in COMPREHENSIVE mode when they perform better than existing accepted plans.

D. The non-accepted plans in a SQL plan baseline are automatically evolved, in COMPREHENSIVE mode, during the nightly maintenance window and a persistent verification report is generated.

Which three statements are true about the use of the query result cache? (Choose three.)

A. Results obtained from a query rewrite to a materialized view may be stored in the query result cache.

B. Stale results may still be obtained from the query result cache, if the query session's query_rewrite_integrity parameter is set to stale_tolerated.

C. Results obtained from a join between a table and a view may be stored in the query result cache.

D. Results from distributed queries are never stored in the query result cache.

E. Results may not be obtained from the query result cache, when the query_rewrite_enabled parameter is set to false.

F. Results from remote queries may sometimes be stored in the query result cache.