1Z1-060 무료 덤프문제 온라인 액세스

Oracle Grid Infrastructure for a stand-alone server is installed on your production host before installing the Oracle Database server. The database and listener are configured by using Oracle Restart.
Examine the following command and its output:

What does this imply?

• A.When you create a database service by modifying the SERVICE_NAMES initialization parameter, it is automatically added to the Oracle Restart configuration.
• B.When a database instance is started by using the SRVCTL utility and listener startup fails, the instance is still started.
• C.When a database is created by using SQL* Plus, it is automatically added to the Oracle Restart configuration.
• D.When you start an instance on a high with SQL *Plus dependent listeners and ASM disk groups are automatically started.

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 INDEX and CREATE TABLE statements generated by the import are logged.
• D.Only CREATE TABLE and ALTER TABLE statements generated by the import are logged.

Your database supports an online transaction processing (OLTP) application. The application is undergoing some major schema changes, such as addition of new indexes and materialized views. You want to check the impact of these changes on workload performance.
What should you use to achieve this?

• A.SQL Access Advisor
• B.Database replay
• C.SQL Tuning Advisor
• D.Automatic Workload Repository compare reports
• E.SQL Performance Analyzer

Which three statements are true about Flashback Database?

• A.Flashback Database can recover a database to the state that it was in before a reset logs operation.
• B.Flashback Database uses a restored control file to recover a database.
• C.Flashback logs are used to restore to the blocks' before images, and then the redo data may be used to roll forward to the desired flashback time.
• D.Flashback Database can recover a data file that was dropped during the span of time of the flashback.
• E.Flashback logs are written sequentially, and are archived.
• F.The Oracle database automatically creates, deletes, and resides flashback logs in the Fast Recovery Area.

You are administering a database stored in Automatic Storage management (ASM). The files are stored in the DATA disk group. You execute the following command:

What is the result?

• A.The file `+data.231.45678' is renamed as `myfile.dbf', and copied to `+data/prod'.
• B.The file `+data.231.45678' is physically relocated to `+data/prod' and renamed as `myfile.dbf'.
• C.The file `myfile.dbf' is created in `+data/prod' and the reference to `+data.231.45678' in the data dictionary removed.
• D.The file `+data.231.45678' remains in the same location andasynonym'myfile.dbf' is created.