Free Oracle 1Z1-060 Exam Dumps Questions & Answers

Examine the following query output:

You issue the following command to import tables into the hr schema:
$ > impdp hr/hr directory = dumpdir dumpfile = hr_new.dmp schemas=hr
TRANSFORM=DISABLE_ARCHIVE_LOGGING: Y
Which statement is true?

• A.None of the operations against the master table used by Oracle Data Pump to coordinate its activities are logged.
• B.All database operations performed by the impdp command are logged.
• C.Only CREATE TABLE and ALTER TABLE statements generated by the import are logged.
• D.Only CREATE INDEX and CREATE TABLE statements generated by the import are logged.

Examine the query and its output executed In an RDBMS Instance:

Which three statements are true about the users (other than sys) in the output?

• A.The C # # C_ADMIN user can perform the data guard operation with Data Guard Broker.
• B.The C # # D_ADMIN user can perform backup and recovery operations for Automatic Storage Management (ASM).
• C.The C # # A_ADMIN user can perform wallet operations.
• D.The C # # B_ADMIN user can perform all backup and recovery operations using RMAN only.
• E.The C# # B_ADMIN user can perform all backup and recovery operations using RMAN or SQL* Plus.

You are the DBA for an Oracle Database 11g Release 1 data warehouse database running on Oracle Linux with little endianness.
You want to plug in a transportable tablespace with a 16K blocksize from an Oracle Database
10g database that is running on a SPARC-based Oracle Solaris system with big endianness.
The data warehouse database has the following parameters set:

The following parameters are not explicitly set:

What action must you perform on the data warehouse database to prepare it for the transportable tablespace plug in operation?

• A.Do nothing, because Automatic Memory Management will size DB_16K_CACHE_SIZE automatically
• B.Set ALTER SYSTEM SET DB_16K_CACHE_SIZE=8M and leave other parameters set to their current settings.
• C.Do nothing, because you cannot transport a tablespace between databases with different endian formats.
• D.Do nothing, because Automatic Shared Memory Management will size DB_16K_CACHE_SIZE automatically.
• E.Set ALTER SYSTEM SET DB_CACHE_SIZE=192M followed by ALTER SYSTEM SET DB_16K_CACHE_SIZE=8M;

Which two statements are true regarding the count function?

• A.The count function can be used only for CHAR, VARCHAR2, and NUMBER data types.
• B.A select statement using the COUNT function with a DISTINCT keyword cannot have a where clause.
• C.Count (*) returns the number of rows including duplicate rows and rows containing null value in any of the columns.
• D.Count (cust_id) returns the number of rows including rows with duplicate customer IDs and NULL value in the CUST_ID column.
• E.Count (distinct inv_amt) returns the number of rows excluding rows containing duplicates and NULL values in the INV_AMT column.

You notice that the elapsed time for an important database scheduler job is unacceptably long.
The job belongs to a scheduler job class and runs in a scheduler window.
Which two actions could reduce the job's elapsed time?

• A.Increasing the job's relative priority within the Job class to which it belongs
• B.Increasing the priority of the scheduler window to which the job belongs
• C.increasing resource allocation for the consumer group mapped to the job class in the resource manager plan associated with the scheduler window
• D.Moving the job to an existing higher priority scheduler window with the same schedule and duration
• E.Increasing the value of the JOB_QUEUE_PROCESSES parameter