Online Access Free 1Z0-514 Practice Test

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

Which two statements are true regarding undo data records? (Choose two.)

• A.I hey are not required if Flashback features are enabled.
• B.Undo records contain copies of data as it appears after a change is made.
• C.They are retained until the session making the changes ends.
• D.They are required to support Flashback features.
• E.Undo records contain copies of data as it appears before a change is made.

Your database is down. You log in as the user SYS and issue the following command:
SQL>STARTUP
Which stops occur and in what order as a result of executing this command?

• A.Only the instance is started.
• B.Instance is started, then the database is opened and finally mounted.
• C.Instance is started and then database is mounted but not opened.
• D.Instance is started, then the database is mounted and finally opened.

Which two statements are true regarding views? (Choose two)

• A.Views provide an additional level of security by restricting access to a predetermined set of rows and columns of a table
• B.Views on one or more tables can be used to update the columns specified in the views.
• C.Views contain no data
• D.Views can be created only on tables in the same schema.

View the exhibit.

You are creating a database by using Database Configuration Assistant (DHCIA). You have chosen the File System option as the storage mechanism. What would be the result of choosing this option?

• A.DBCA would not save the database files by using Optimal File Architecture (OFA).
• B.The database files would be managed by the operating system's file system.
• C.Disk mirroring and striping would be done automatically.
• D.The data files are automatically spread across all available storage devices to optimize performance and resource utilization.