单项选择题
You want the user APP_DBA to administer the Oracle database from a remote machine. APP_DBA is granted the SYSDBA privilege to perform administrative tasks on the database. Which file is used by the Oracle database server to authenticate APP_DBA?()
A.control file
B.password file
C.listener controller file
D.control file and password file
相关考题
-
多项选择题
WhichtwostatementsaretrueabouttherolesintheOracledatabase?()
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.
