多选题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（‘

题目

多选题

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？（）

No user or application has to remember or hide a password.

It prevents everyone except a true DBA session from acquiring the READWRITE role.

app.chk_readwrite is called whenever a user tries to access rows protected by the READONLY or READWRITE label.

app.chk_readwrite is called by users or applications when they want to enable the READONLY or READWRITE role.

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

相似问题和答案

第1题：

Which statement creates a new user?（）

A、CREATE USER susan;
B、CREATE OR REPLACE USER susan;
C、CREATE NEW USER susan DEFAULT;
D、CREATE USER susan IDENTIFIED BY blue;
E、CREATE NEW USER susan IDENTIFIED by blue;
F、CREATE OR REPLACE USER susan IDENTIFIED BY blue;

正确答案:D

第2题：

Which procedure should be used to configure the system to prevent all users from using the ’at’ command（）？

A、Create a /var/adm/cron/at.allow file with no entries
B、Create a /var/adm/cron/at.deny file with ’*’ as the only entry
C、Create a /var/adm/at/at.deny file with ’ALL’ as the only entry
D、Create a /var/adm/at/at.allow file with ’NONE’ as the only entry

正确答案:A

第3题：

You need to perform these tasks:1. Create and assign a MANAGER role to Blake and Clark2. Grant CREATE TABLE and CREATE VIEW privileges to Blake and ClarkWhich set of SQL statements achieves the desired results? （）

A. CREATE ROLE manager; GRANT create table, create view TO manager; GRANT manager TO BLACK, CLARK;

B. CREATE ROLE manager; GRANT create table, create voew TO manager; GRANT manager ROLE TO BLACK, CLARK;

C. GRANT manager ROLE TO BLACK, CLARK; GRANT create table, create voew TO BLACK CLARK; ***MISSING***

参考答案：A

第4题：

Which statement creates a new user?（）

A、CREATIVE USER susan;
B、CREATIVE OR REPLACE USER susan;
C、CREATE NEW USER susan DEFAULT
D、CREATE USER susan IDENTIFIED BY blue;
E、CREATE NEW USER susan IDENTIFIED BY blue;
F、CREATE OR REPLACE USER susan IDENTIFIED BY blue;

正确答案:D

第5题：

You want to create a role to meet these requirements： 1：The role is to be protected from unauthorized usage. 2：The password of the role is not to be embedded in the application source code or stored in a table. Which method would you use to restrict enabling of such roles（）

A、Create the role with global authentication.
B、Create the role with external authentication.
C、Create the role as a secure application role.
D、Create the role as a password-protected role.
E、Create a role and use Fine-Grained Access Control （FGAC） to secure the role.

正确答案:C

第6题：

A storage specialist needs to create a new host connection using the DSCLI. Which of the following parameters identifies the host（）

A、hosttype
B、volume group
C、ioports
D、WWPN

正确答案:D

第7题：

You want to schedule a job to rebuild all indexes on the SALES table after the completion of a bulk load operation. The bulk load operation must also be a scheduled job that executes as soon as the first file that contains data arrives on the system. How would you create these jobs?（）

A、Create both jobs by using events raised by the scheduler
B、Create both jobs by using events raised by the application
C、Create a job to rebuild indexes by using events arised by the application and then create another job to perform bulk load by using events raised by the scheduler
D、Create a job to rebuild indexes by using events arised by the Scheduler and then create another job to perform bulk load by using events raised by the application

正确答案:D

第8题：

Which statement creates a new user? ()

A. CREATIVE USER susan;

B. CREATIVE OR REPLACE USER susan;

C. CREATE NEW USER susan DEFAULT

D. CREATE USER susan IDENTIFIED BY blue;

E. CREATE NEW USER susan IDENTIFIED BY blue;

F. CREATE OR REPLACE USER susan IDENTIFIED BY blue;

参考答案：D

第9题：

When should you create a role? （）

A、To simplify the process of creating new users using the CREATE USER xxx IDENTIFIED by yyy statement.
B、To grant a group of related privileges to a user.
C、When the number of people using the database is very high.
D、To simplify the process of granting and revoking privileges.
E、To simplify profile maintenance for a user who is constantly traveling.

正确答案:C,D

第10题：

You perform a backup using the following BACKUP command: RMAN> BACKUP AS COMPRESSED BACKUPSET DATABASE,Which statement is true of this command?（）

A、A different procedure is required to restore a database from compressed backups
B、The AS COMPRESSED clause of the BACKUP command provided by RMAN is used to create compressed backup sets and image copies.
C、Using this command to create backups minimizes the bandwidth consumed.
D、Using this command to create backups improves the performance of the backup process

正确答案:C

多选题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（‘

题目

相似问题和答案

更多相关问题

相关内容