The HR user creates a stand-alone procedure as follows and grants the EXECUTE privilege on theprocedure to many database users:
CREATE OR REPLACE PROCEDURE create_dept ( v_deptno NUMBER, v_dname VARCHAR2, v_mgr NUMBER, v_loc NUMBER) BEGIN
INSERT INTO hr.departments VALUES (v_deptno, v_dname, v_mgr, v_loc); END;
The users having permission to execute the procedure are able to insert records into the
DEPARTMENTStable even though they do not have the INSERT privilege on the table. You want only those users whohave privileges on the DEPARTMENTS table to be able to execute the procedure successfully.
What would you suggest to the PL/SQL developers to achieve this()
A.Create the procedure with definer’s right.
B.Create the procedure with invoker’s right.
C.Grant the EXECUTE privilege with GRANT OPTION on the procedure to selected users.
D.Create the procedure as part of a PL/SQL package and grant the EXECUTE privilege on the package to selected users
您可能感兴趣的试卷
你可能感兴趣的试题
You made changes to the COMPUTE_TAX function inside the EMP_ADMIN package body.
Whichstatement is true after you recompile the EMP_ADMIN package body()
A.The USE_P procedure remains valid.
B.The USE_P procedure becomes invalid.
C.The SHOW_DETAIL procedure becomes invalid.
D.The EMP_ADMIN package specification becomes invalid and needs to be recompiled
User SCOTT wants to perform a bulk insert operation in the EMP_DEP table. SCOTT receives thefollowing error after the INSERT statement is issued and few rows are inserted: INSERT INTO EMP_DEP (emp_id,name,salary,dep_name,mgr_id) *
ERROR at line 1:
ORA-01653: unable to extend table SCOTT.EMP_DEP by 128 in tablespace USERS Identify two actions either of which will help you resolve this problem.()
A.Grant the RESOURCE role to SCOTT.
B.Add data files to the USERS tablespace.
C.Grant the CREATE ANY TABLE privilege to SCOTT.
D.Increase the space for SCOTT on the USERS tablespace.
E.Increase the size of the data file associated with the USERS tablespace
The TRANS_SUMMARY table contains product-wise transaction details that get updated with everytransaction in the system. Each row has cumulative transaction details of a single product and everyproduct is identified by a product code, which is the primary key.
As part of the archival process, the company wants to transfer the rows in the TRANS_SUMMARY tableto the TRANS_SUMMARY_DUP table at the end of every quarter of the year. Along with existing products,the company deals with many new products during every quarter.
Which method is best suited for this quarterly data transfer()
A.using the MERGE command
B.using the SQL*Loader utility
C.using the correlated UPDATE command
D.using the INSERT command to perform bulk operation
All the database users are presently connected to the database instance and working. The HR userhas opened three database sessions and executed the following command in one of his sessions: SQL> UPDATE persons SET ccode=’U031’ WHERE ccode=’U029’; 123 rows updated.
SQL> DELETE FROM persons WHERE exp=’Y’; 3 rows deleted.
The SYS user opens a new session after HR executed the above commands.
Which sessions can seethe effect of the UPDATE and DELETE commands ()
A.all sessions of the HR user only
B.all sessions of the HR user and the SYS user
C.the session of the HR user that executed the commands
D.all the sessions for which the database users have access privilege to the PERSONS table
You executed this command to create a temporary table:
SQL> CREATE GLOBAL TEMPORARY TABLE report_work_area (startdate DATE, enddate DATE, class CHAR(20))ON COMMIT PRESERVE ROWS;
Which statement is true about the rows inserted into the REPORT_WORK_AREA table during atransaction ()
A.The rows stay in the table only until session termination.
B.The rows stay in the table only until the next transaction starts on the table.
C.The rows are visible to all current sessions after the transaction is committed.
D.The rows stay available for subsequent sessions after the transaction is committed
A.The leaf blocks in the index are doubly linked.
B.The leaf node stores a bitmap for each key value.
C.The rows with NULL value in key columns also have entries in the index.
D.The deletion of a row from the table causes a logical deletion in index leaf block and the space becomes available for the new leaf entry.
A.An update in a leaf row takes place.
B.The index becomes invalid after the update.
C.The leaf block containing the row to be updated is marked as invalid.
D.A row in the leaf block of the index for the key value is logically deleted and a new leaf row is inserted
The session of user SCOTT receives the following error after executing an UPDATE command onthe EMP table:
ERROR at line 1:
ORA-00060: deadlock detected while waiting for resource
On investigation, you find that a session opened by user JIM has a transaction that caused the deadlock.
two statements are true regarding the session of SCOTT in this scenario()
A.The session is terminated after receiving the error and JIM can continue with his transaction.
B.SCOTT should perform a COMMIT or ROLLBACK to allow JIM to continue with his transaction.
C.The session is rolled back after receiving the error and JIM can continue with his transaction.
D.SCOTT has to reexecute the last command in the transaction after he commits the transaction.
The table contains a million rows for zonewise analysis in the DSS system. DML operations areperformed very rarely on the table. You decide to prepare an index on the ZONE column to enhance theperformance of the queries on the ZONE column.
Which type of index would you select in this scenario()
A.Bitmap index
B.Reverse key index
C.Normal B-Tree index
D.Function-based index
You have two tables with referential integrity enforced between them. You need to insert data to
thechild table first because it is going to be a long transaction and data for the parent table will be available ina later stage, which can be inserted as part of the same transaction. View the Exhibit to examine the commands used to create tables.
Which action would you take to delay the referential integrity checking until the end of the transaction()
A.Set the constraint to deferred before starting the transaction.
B.Alter the constraint to NOVALIDATE state before starting the transaction.
C.Enable the resumable mode for the session before starting the transaction.
D.Set the COMMIT_WAIT parameter to FORCE_WAIT for the session before starting the transaction.
最新试题
Why does performance degrade when many UPDATE, INSERT, or DELETE statements are issued on a tablethat has an associated Bitmap index()
You are working on a database that must be functioning 24 hours a day, 7 days a week. The database isconfigured in ARCHIVELOG mode. Which two options do you have for performing user-managed backups()
Which statements regarding the server parameter file (SPFILE) are true()
View the Exhibit and examine the privileges granted to the SL_REP user. The EMP table is owned by theSCOTT user. The SL_REP user executes the following command:SQL> GRANT SELECT ON scott.emp TO hr;Which statement describes the outcome of the command()
All the database users are presently connected to the database instance and working. The HR user hasopened three database sessions and executed the following command in one of his sessions:SQL> UPDATE persons SET ccode=’U031’ WHERE ccode=’U029’; 123 rows updated.SQL> DELETE FROM persons WHERE exp=’Y’;3 rows deleted.The SYS user opens a new session after HR executed the above commands. Which sessions can see theeffect of the UPDATE and DELETE commands()
Which kinds of failures make the Data Recovery Advisor (DRA) generate a manual checklist?()
View the Exhibit and examine the attributes of an undo tablespace. In an OLTP system, the user SCOTT hasstarted a query on a large table in the peak transactional hour that performs bulk inserts. The query runs formore than 15 minutes and then SCOTT receives the following error:ORA-01555: snapshot too oldWhat could be the reason for this error()
Examine the following statement that is used to modify the primary key constraint on the SALES table:SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE;Which three statements aretrue regarding the above command()
You execute the following command to change the status of the SALES tablespace:SQL> ALTER TABLESPACE sales OFFLINE;Which statements describe the effect of the command()
Which statements are correct about temporary tables()