多项选择题
Examine the code:
CREATE ROLE readonly IDENTIFIES USING app.chk_readwrite ; CREATE ROLE readwrite IDENTIFIED USING app.chk_readwrite ;
CREATE OR REPLACE PROCEDURE app.chk_readwrite
AUTHID CURRENT_USER IS
ipchk STRING(30);
BEGIN
IF sys_context(‘USERENV’,’ISDBA’)=’TRUE’
THEN DBMS_SESSION.SET_ROLE‘READWRITE’) ;
ELSE DBMS_SESSION.SET_ROLE(‘READONLY’) ;
END; /
Which three statements correctly describe the Secure Application role definition?()
A.No user or application has to remember or hide a password.
B.It prevents everyone except a true DBA session from acquiring the READWRITE role.
C.app.chk_readwrite is called whenever a user tries to access rows protected by the READONLY or READWRITE label.
D.app.chk_readwrite is called by users or applications when they want to enable the READONLY or READWRITE role.
相关考题
-
单项选择题
Consider this RMAN command: RMAN> CONFIGURE RETENTION POLICY CLEAR; What is the effect of this command?()
A.Backups will never expire.
B.It removes any retention policy.
C.The DELETE OBSOLETE command will fail with an error.
D.It sets the retention policy to the default of REDUNDANCY 1. -
单项选择题
Examine the command: ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS; What does the command accomplish?()
A.Creates an additional copy of the database online redo log files.
B.Stores the primary key column values of each row involved in a DML operation in the online redo log files.
C.Stores the primary key column values of each row involved in a DML operation in the supplemental log files.
D.Stores the old and new primary key column values of each row involved in a DML operation only when the primary key is modified in the online redo log files. -
单项选择题
Howcanyoumakeasharedserver-sideinitializationparameterfileavailabletoallinstancesofaRealApplicationClustersdatabase?()
A.Include an SPFILE parameter in each instance-specified initialization file.
B.Create an SPFILE copy on each client from which the instance will be started.
C.Store the SPFILE in a raw partition with a vendor-specifies location and name.
D.Use a single client to start the instances and create the SPFILE on this client.
