1Z0-514 무료 덤프문제 온라인 액세스

In your database, the SQL Tuning Advisor is running automatically during the system maintenancewindow as a maintenance task.
Which of its recommendations would be implemented automatically?

• A.refreshing optimizerstatistic\
• B.restructuring SQL statements
• C.creation of new Indexes
• D.creation or modification of a SQL Profile

There are two listeners, LISTENER1 and LISTENER2, and one service name ORCL available for your database.The database is running and currently only LISTENERI has been started. You issue the following command:
$lsnrctl start listener2
What would be the outcome?

• A.It would start the second listener without affecting the current sessions.
• B.It would start the second listener and terminate all the current sessions.
• C.It would give an error because multiple listeners can run simultaneously only if there are multiple net service names.
• D.It would give an error because multiple listeners cannot run simultaneously.

Which two statements correctly differentiate undo and redo data? (Choose two.)

• A.Redo protects against inconsistent reads, whereas undo protects against data loss.
• B.Undo reverses a change, whereas redo re-creates a change.
• C.Undo protects against inconsistent reads, whereas redo protects against data loss.
• D.Redo reverses a change, whereas undo re-creates a change.

Choose three areas for which Oracle Database 11g Release 2 and Enterprise Manager offer tools that can recommended solutions on optimal implementation.

• A.Availability
• B.Indexes
• C.Compression
• D.Data block size
• E.CPU usage
• F.Data recovery

View the exhibit above.

Which two statements ore true regarding the status of data file backups after31 days?
(Choose two)

• A.In Rash recovery area, they are deleted immediately.
• B.In non flash recovery area, they are marked as obsolete but retained and deleted automatically when space is required.
• C.In non lash recovery area, they .ire marked as obsolete and have to be deleted manually.
• D.In flash recovery area, they are marked as obsolete but retained and deleted automatically when space is required.