多项选择题

Which two statements are true about the roles in the Oracle database？（）

A.A role can be granted to itself.
B.Roles are owned by the SYS user.
C.Roles can be granted to other roles.
D.A role cannot be assigned external authentication.
E.A role can contain both system and object privileges.

<上一题目录下一题>

热门试题

单项选择题Youareworkingonanonlinetransactionprocessing（OLTP）system.YounoticethataPL SQLproceduregotexecutedtwiceat2）00p.m.ThishasincorrectlyupdatedtheEMP_SALtable.Howwouldyourevertthetabletoitsstateat2）00p.m.？（）

A.Perform point-in-time recovery to 2： 00 p.m.
B.Use Flashback Table feature to revert the changes.
C.Restore the entire database from the recent backup and open it.
D.Issue the rollback statement with system change number （SCN）.

单项选择题YourtestdatabaseisrunninginNOARCHIVELOGmode.Whataretheimplicationsofthis？（）

A.You can perform open database backups.
B.You can perform closed database backups.
C.You cannot perform schema-level logical backups.
D.You can perform the backup of only the SYSTEM tablespace when the database is open.

单项选择题TheSAVE_AMTcolumnintheACCOUNTStablecontainsthebalancedetailsofcustomersinabank.Aspartoftheyear-endtaxandinterestcalculationprocess，alltherowsinthetableneedtobeaccessed.Thebankauthoritieswanttotrackaccesstotherowscontainingbalanceamountsexceeding$200，000，andthensendanalertmessagetotheadministrator.Whichmethodwouldyousuggesttothebankforachievingthistask？（）

A.implementing value-based auditing by using triggers
B.implementing fine-grained auditing with audit condition and event handler
C.performing standard database auditing to audit object privileges by setting the AUDIT_TRAIL parameter to EXTENDED
D.performing standard database auditing to audit SQL statements with granularity level set to ACCESS

单项选择题YouareusingthebackupschedulerinEnterpriseManager（EM）toscheduleabackupofyourdatabase.Whichtypeofscriptdoesthebackupschedulergenerate？（）

A.SQL script
B.PL/SQL script
C.Operating System （OS） script
D.Enterprise Manager （EM） script
E.Recovery Manager （RMAN） script

单项选择题You suspect unauthorized data manipulation language （DML） operations on a particular table. You want to track users who are performing the transactions and the values used in the transactions. Also， you plan to transfer these values to another table for analysis. How would you achieve this？（）

A.by using triggers
B.by using external tables
C.by using anonymous PL/SQL blocks
D.by auditing all DML operations on the table