Online Access Free 1Z0-514 Practice Test

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

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

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 give an error because multiple listeners cannot run simultaneously.
• B.It would start the second listener without affecting 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 start the second listener and terminate all the current sessions.

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

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

View the exhibit.

You plan to load the customer information that has been brought from a non Oracle database in the CUSTOMERS table in your database using the "Enterprise Manager - Load Data From User File" option. Which files should you create before using this option?

• A.data file and control file
• B.only data file
• C.data file and log file
• D.data file and dump file

A customer recently had a security audit, when they were told that their test and developmentenvironment contained test data, which was the copy of production data, yet was not properly protected. What technology should be used to quickly bring these environments into compliance?

• A.Advanced Security Option
• B.Database Vault
• C.Data Masking Pack tor Enterprise Manager
• D.Audit Vault
• E.Label Security