1Z0-514 試験問題を無料オンラインアクセス

Which two statements arc true regarding object privileges? (Choose two.)

• A.Objectprivileges can begranted only by the owner of the object.
• B.Object privileges can be granted by both owner of the object and the DBA
• C.The DBA can revoke object privileges from the owner of the object.
• D.A user automatically has all the object privileges on all the objects contained in his or her schema.

Your application has a need to allow managers to see all sales records owned by sales reps in their entire territory, and for the sales reps to see only the sales records they own. What technology should be used to implement this type of security?

• A.Audit Vault option
• B.Advanced Security Option
• C.Database Security option
• D.Data Manger Pack for Enterprise Manger
• E.Label Security

Which two statements are true regarding point-in-time recovery? (Choose two.)

• A.It uses only online redo logs.
• B.It requires the control file.
• C.It uses both archivelog and online redo logs.
• D.It requires the SPFILE.

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.

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

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