1z0-062 Exam Dumps | In your multitenant container database (CDB) containing pluggable database (PDBs), the HR user executes

<< Prev Question Next Question >>

Question 69/220

In your multitenant container database (CDB) containing pluggable database (PDBs), the HR user executes the following commands to create and grant privileges on a procedure:
CREATE OR REPLACE PROCEDURE create_test_v (v_emp_id NUMBER, v_ename VARCHAR2, v_SALARY NUMBER, v_dept_id NUMBER) BEGIN INSERT INTO hr.test VALUES (V_emp_id, V_ename, V_salary, V_dept_id); END;
/
GRANT EXECUTE ON CREATE_TEST TO john, jim, smith, king;
How can you prevent users having the EXECUTE privilege on the CREATE_TEST procedure from inserting values into tables on which they do not have any privileges?

A. Create the CREATE_TEST procedure with definer's rights.

B. Grant the EXECUTE privilege to users with GRANT OPTION on the CREATE_TEST procedure.

C. Create the CREATE_TEST procedure with invoker's rights.

D. Create the CREATE_TEST procedure as part of a package and grant users the EXECUTE privilege the package.

Question List (220q): Question 1: You wish to enable an audit policy for all database users, e...; Question 2: Examine the commands executed to monitor database operations...; Question 3: Which two statements are true about standard database auditi...; Question 4: The performance of your database degrades between 11:00 AM a...; Question 5: You executed a DROP USER CASCADE on an Oracle 11g release 1 ...; Question 6: Your multitenant container database (CDB) contains pluggable...; Question 7: Your database is open and the listener LISTENER is up. You i...; Question 8: You plan to create a database by using the Database Configur...; Question 9: Which two are true concerning a multitenant container databa...; Question 10: You notice a performance change in your production Oracle da...; 1 commentQuestion 11: Backup requirements for a database: * Level 0 backup on Sund...; Question 12: The persistent configuration settings for RMAN have default ...; Question 13: Which three statements are true about Database Resource Mana...; Question 14: To enable faster incremental backups, you enabled block chan...; Question 15: You enabled block change tracking for faster incremental bac...; Question 16: What is a requirement for creating a remote database schedul...; Question 17: Examine the query and its output executed In an RDBMS Instan...; Question 18: In your database, the STATISTICS_LEVELparameter is set to TY...; Question 19: Which two statements are true concerning dropping a pluggabl...; Question 20: You are connected using SQL* Plus to a multitenant container...; Question 21: In your database, you want to ensure that idle sessions that...; Question 22: Which three factors influence the optimizer's choice of an e...; Question 23: The HRuser updates the salary of one of the employees in the...; Question 24: You want to distribute a set of structured data to your cust...; Question 25: Identify two situations in which the alert log file is updat...; Question 26: You executed the following command to create a password file...; Question 27: Which three statements are true about adaptive SQL plan mana...; Question 28: Which statement is true about profiles?...; Question 29: Examine the command to perform a data pump export operation ...; Question 30: In order to exploit some new storage tiers that have been pr...; Question 31: Your database instance has started using an SPFILE. Examine ...; Question 32: In which two scenarios do you use SQL* Loader to load data? ...; Question 33: Which two actions does an incremental checkpoint perform? (C...; Question 34: Which three statements are true about Flashback Database? (C...; Question 35: Your database has archive logging enabled and RMAN backups a...; Question 36: Which two statements are true about the Oracle Direct Networ...; Question 37: Which three statements are true about naming methods? (Choos...; Question 38: You want to create a table, DAILY_ORDERS, for an OLTP applic...; Question 39: Your production database uses file system storage. You want ...; Question 40: You support Oracle Database 12c Oracle Database 11g, and Ora...; Question 41: You execute the following piece of code with appropriate pri...; Question 42: Tape streaming is not happening while performing RMAN tape b...; Question 43: Which two partitioned table maintenance operations support a...; Question 44: A database is open READ WRITE and the instance has multiple ...; Question 45: One of your databases has archive logging enabled and RMAN b...; Question 46: Examine the contents of SQL loader control file: (Exhibit) W...; Question 47: Identify two prerequisites for configuring Enterprise Manage...; Question 48: In your Oracle 12c database, you plan to execute the command...; Question 49: What is the effect of setting the STATISTICS_LEVEL initializ...; Question 50: Examine the following impdp command to import a database ove...; Question 51: You upgraded from a previous Oracle database version to Orac...; Question 52: You want to prevent a group of users in your database from p...; Question 53: Your database is configured for ARCHIVELOGmode, and a daily ...; Question 54: Which three statements are true about Oracle Data Pump? (Cho...; Question 55: Which statement is true about the Database as a Service (DBa...; Question 56: Which four operations performed after the Oracle Restart ins...; Question 57: Which statement is true about the Log Writer process?...; Question 58: Examine the resources consumed by a database instance whose ...; Question 59: Which component resides in the System Global Area (SGA) of a...; Question 60: Which are two ways for a database service to be recognized b...; Question 61: You upgraded your database from pre-12c to a multitenant con...; Question 62: You want to create a role that: - is protected from unauthor...; Question 63: Examine the parameters for a database instance: (Exhibit) Yo...; Question 64: Your database instance has the following parameter setting: ...; Question 65: You are administering a database and you receive a requireme...; Question 66: Which two statements are true about Oracle Data Pump export ...; Question 67: You Execute the Following command to create a password file ...; Question 68: Which two statements are true about initialization parameter...; Question 69: In your multitenant container database (CDB) containing plug...; Question 70: Which three statements are true about automated maintenance ...; Question 71: Which four are true about creating and running a remote data...; Question 72: You plan to install the Oracle Database 12c software. You wa...; Question 73: An application accesses a small lookup table frequently. You...; Question 74: Automatic Shared Memory Management is enabled for your datab...; Question 75: Examine the following command: SQL> DBMS_STATS. SET_TABLE...; Question 76: Which statement is true about the Oracle central inventory d...; Question 77: What action must you take to ensure complete database recove...; Question 78: You create a locally managed tablespace ORDERS_TBS with auto...; Question 79: What is the result of executing a TRUNCATE TABLE command on ...; Question 80: Which three operations can be performed as multipartition op...; Question 81: Your database is in ARCHIVELOG mode and you want to automate...; Question 82: The HR schema exists in two databases, BOSTON and DENVER, an...; Question 83: Examine the query and its output: (Exhibit) What might have ...; Question 84: Which two statements are true about Oracle network connectio...; Question 85: On your Oracle 12c database, you invoked SQL *Loader to load...; Question 86: In your Database, the TBS PERCENT USED parameter is set to 6...; Question 87: You must track all transactions that modify certain tables i...; Question 88: You execute this command: (Exhibit) Which two statements are...; Question 89: You want to schedule a job to rebuild a table's indexes afte...; Question 90: Which three statements are true about user account administr...; Question 91: You notice a high number of waits for the db file scattered ...; Question 92: Identify the persistent configuration setting for the target...; Question 93: In your multitenant container database (CDB) containing same...; Question 94: You create an Oracle 12c database and then import schemas th...; Question 95: The HRuser owns the BONUSEStable. HRgrants privileges to the...; Question 96: You want to flash back a test database by five hours. You is...; Question 97: A user establishes a connection to a database instance by us...; Question 98: You have altered a non-unique index to be invisible to deter...; Question 99: Which three activities are supported by the Data Recovery Ad...; Question 100: You want to capture column group usage and gather extended s...; Question 101: Which two statements are true? (Choose two.)...; Question 102: What can be automatically implemented after the SQL Tuning A...; Question 103: Which three are activities performed by SMON? (Choose three....; Question 104: In your database instance, the UNDO_RETENTIONparameter is se...; Question 105: You configure your database Instance to support shared serve...; Question 106: Which three statements are true concerning the multitenant a...; Question 107: Examine the command: SQL> CONNECT hr/hr@orcl Which two co...; Question 108: To implement Automatic Management (AMM), you set the followi...; Question 109: You set the following parameters in the parameter file and r...; Question 110: You notice a performance change in your production Oracle 12...; Question 111: Which three tasks can be automatically performed by the Auto...; Question 112: Which set of statements is true about data dictionary views?...; Question 113: You have successfully taken a database backup by using the c...; Question 114: Which two statements are true about Oracle Managed Files (OM...; Question 115: You find this query being used in your Oracle 12c database: ...; Question 116: You plan to install the Oracle Database 12c software on a ne...; Question 117: Examine the details of the uncompressed, non-partitioned hea...; Question 118: Identify three situations in which messages are written to t...; Question 119: Your multitenant container (CDB) containing three pluggable ...; Question 120: A database instance is started by using an SPFILE. The datab...; Question 121: Examine the details of the Top 5 Timed Events in the followi...; Question 122: Which three statements are true when the listener handles co...; Question 123: You configured the flash recovery area in the database. Whic...; Question 124: The ORCL database is configured to support shared server mod...; Question 125: In your database, USERSis the default permanent tablespace. ...; Question 126: The HR user executes the following query on the EMPLOYEES ta...; Question 127: The following parameter are set for your Oracle 12c database...; Question 128: Which three statements are true about Oracle Data Pump? (Cho...; Question 129: Examine the following commands for redefining a table with V...; Question 130: What is the benefit of running the catctl.plscript during an...; Question 131: Your database is in NOARCHIVELOG mode. You want to enable ar...; Question 132: Oracle Grid Infrastructure for a stand-alone server is insta...; Question 133: Which task is performed by a background process in a databas...; Question 134: Your database instance has Automatic Memory Management enabl...; Question 135: Which statement is true about Enterprise Manager (EM) expres...; Question 136: Which two statements are true about variable extent size sup...; Question 137: In your multitenant container database (CDB) containing plug...; Question 138: You want a job that performs a bulk insert as soon as the lo...; Question 139: Unified auditing is enabled in your database. The HR_ADMINan...; Question 140: Which three statements are true about a job chain? (Choose t...; Question 141: You want to create a locally managed tablespace called NEWTB...; Question 142: You are about to plug a multi-terabyte non-CDB into an exist...; Question 143: Which three statements are true about space usage alerts? (C...; Question 144: Which statement is true about using the Database Upgrade Ass...; Question 145: Identify two correct statements about multitenant architectu...; Question 146: Which two statements are true about the Automatic Database D...; Question 147: Which three statements are true about Automatic Workload Rep...; Question 148: When is the UNDO_RETENTIONparameter value ignored by a trans...; Question 149: Which three statements are true concerning unplugging a plug...; Question 150: Which three statements are true about windows? (Choose three...; Question 151: You use the segment advisor to help determine objects for wh...; Question 152: Which three features work together, to allow a SQL statement...; Question 153: You have a production Oracle 12c database running on a host....; Question 154: Which three statements are true about Oracle Restart? (Choos...; Question 155: Your database supports a DSS workload that involves the exec...; Question 156: Which two statements are true about the (PMON) background pr...; Question 157: You configured the Fast Recovery Area (FRA) for your databas...; Question 158: You plan to implement the distributed database system in you...; Question 159: Which three statements are true about Oracle checkpoint proc...; Question 160: You want to reduce fragmentation and reclaim unused space fo...; Question 161: What should you do to ensure that a job stores minimal job m...; Question 162: Identify three valid methods of opening, pluggable databases...; 1 commentQuestion 163: You want to create a file watcher and an event-based job for...; Question 164: Examine the parameter for your database instance: (Exhibit) ...; Question 165: You administer an online transaction processing (OLTP) syste...; Question 166: Which two statements correctly describe the relationship bet...; Question 167: What is a pre-requisite to alter a role?...; Question 168: Which three statements are true about SQL plan directives? (...; Question 169: You are administering a database stored in Automatic Storage...; Question 170: Which two statements are true about the Database Configurati...; Question 171: Which two are prerequisites for performing a flashback trans...; Question 172: What must you use to read data from a table in your database...; Question 173: What happens if a maintenance window closes before a job tha...; Question 174: Which three statements are true about using flashback databa...; Question 175: SMD is a smallfile locally managed tablespace with manual se...; Question 176: Your database is open and the LISTENER listener running. You...; Question 177: Your database is configured in ARCHIVELOGmode. Examine the R...; Question 178: Which statement is true about redo log files during instance...; Question 179: You execute the following commands to audit database activit...; Question 180: Which statement is true regarding the DEFAULT profile?...; Question 181: Which two statements are true about the logical storage stru...; Question 182: Examine this command executed on a client that is remote fro...; Question 183: You created a new database using the "create database" state...; Question 184: Which statement is true about the loss of a data file belong...; Question 185: Identify three valid options for adding a pluggable database...; Question 186: You have installed two 64G flash devices to support the Data...; Question 187: Which two statements are true about SQL *Loader Express Mode...; Question 188: In your production database, data manipulation language (DML...; Question 189: Which three statements are true about the working of system ...; Question 190: A redaction policy was added to the SAL column of the SCOTT....; Question 191: Which task would you recommend before using the Database Upg...; Question 192: Examine the structure of the sales table, which is stored in...; Question 193: You create a new pluggable database, HR_PDB, from the seed d...; Question 194: You want to create a test database as a replica of your prod...; Question 195: Which three functions can be performed by the SQL Tuning Adv...; Question 196: You perform RMAN backups for your database and use a recover...; Question 197: Examine the following query output: (Exhibit) You issue the ...; Question 198: Which three statements are true about the Pre-Upgrade Inform...; Question 199: Which two files must you copy from the Oracle home of the da...; Question 200: Which two statements are true about Automatic Storage Manage...; Question 201: Your production database PRODuses file system storage. You w...; Question 202: You determine that database performance is sub-optimal due t...; Question 203: As part of a manual upgrade of your database to Oracle Datab...; Question 204: Which two statements are true about a server parameter file ...; Question 205: You are connected to a pluggable database (PDB) as a common ...; Question 206: Which two services may you see on the My Service Dashboard p...; Question 207: In which situations does the Database Writer process (DBWn) ...; Question 208: You want to import the schema objects of the HRuser from the...; Question 209: Which two statements are true about Automatic Database Diagn...; Question 210: Which four actions are possible during an Online Data file M...; Question 211: What is the effect of specifying the "ENABLE PLUGGABLE DATAB...; Question 212: Which three statements are true about checkpointing? (Choose...; Question 213: Which three statements are true about server-generated alert...; Question 214: You use a recovery catalog for maintaining your database bac...; Question 215: You want to create a database and you have the following: - ...; Question 216: An application repeatedly accesses small lookup tables, caus...; Question 217: Your database is configured in ARCHIVELOGmode, and a daily f...; Question 218: To enable the Database Smart Flash Cache, you configure the ...; Question 219: You install Oracle Grid Infrastructure standalone server and...; Question 220: Which statement is true regarding the startup of a database ...

Question 69/220

LEAVE A REPLY

Download PDF File