ARA-C01 Exam Dumps | The following statements have been executed successfully: USE ROLE SYSADMIN; CREATE OR REPLACE DATABASE

<< Prev Question Next Question >>

Question 6/107

The following statements have been executed successfully:
USE ROLE SYSADMIN;
CREATE OR REPLACE DATABASE DEV_TEST_DB;
CREATE OR REPLACE SCHEMA DEV_TEST_DB.SCHTEST WITH MANAGED ACCESS;
GRANT USAGE ON DATABASE DEV_TEST_DB TO ROLE DEV_PROJ_OWN;
GRANT USAGE ON SCHEMA DEV_TEST_DB.SCHTEST TO ROLE DEV_PROJ_OWN;
GRANT USAGE ON DATABASE DEV_TEST_DB TO ROLE ANALYST_PROJ;
GRANT USAGE ON SCHEMA DEV_TEST_DB.SCHTEST TO ROLE ANALYST_PROJ;
GRANT CREATE TABLE ON SCHEMA DEV_TEST_DB.SCHTEST TO ROLE DEV_PROJ_OWN;
USE ROLE DEV_PROJ_OWN;
CREATE OR REPLACE TABLE DEV_TEST_DB.SCHTEST.CURRENCY (
COUNTRY VARCHAR(255),
CURRENCY_NAME VARCHAR(255),
ISO_CURRENCY_CODE VARCHAR(15),
CURRENCY_CD NUMBER(38,0),
MINOR_UNIT VARCHAR(255),
WITHDRAWAL_DATE VARCHAR(255)
);
The role hierarchy is as follows (simplified from the diagram):
* ACCOUNTADMIN## DEV_SYSADMIN## DEV_PROJ_OWN## ANALYST_PROJ
Separately:
* ACCOUNTADMIN## SYSADMIN## MAPPING_ROLE
Which statements will return the records from the table
DEV_TEST_DB.SCHTEST.CURRENCY? (Select TWO)

A. USE ROLE DEV_PROJ_OWN;
GRANT SELECT ON DEV_TEST_DB.SCHTEST.CURRENCY TO ROLE ANALYST_PROJ;
USE ROLE ANALYST_PROJ;
SELECT * FROM DEV_TEST_DB.SCHTEST.CURRENCY;

B. USE ROLE DEV_PROJ_OWN;
SELECT * FROM DEV_TEST_DB.SCHTEST.CURRENCY;

C. USE ROLE SYSADMIN;
SELECT * FROM DEV_TEST_DB.SCHTEST.CURRENCY;

D. USE ROLE MAPPING_ROLE;
SELECT * FROM DEV_TEST_DB.SCHTEST.CURRENCY;

E. USE ROLE ACCOUNTADMIN;
SELECT * FROM DEV_TEST_DB.SCHTEST.CURRENCY;

Question 6/107

LEAVE A REPLY

Download PDF File