ITPub博客

（186）User A executes the following command to drop a large table in your database: SQL> DROP TABLE trans;While the drop table operation is in progress, user B executes the following command on the same table: SQL> DELETE FROM trans WHERE tr_type='SL';Which statement is true regarding the DE...

（185）User SCOTT executes the following command on the EMP table but has not issued COMMIT, ROLLBACK, or any data definition language (DDL) command:SQL> SELECT ename FROM emp2 WHERE job='CLERK' FOR UPDATE OF empno;SCOTT has opened another session to work with the database instance.Wh...

（184）You suspect unauthorized data manipulation language (DML) operations on a particular table.You want to track users who are performing the transactions and the values used in the transactions.You also plan to transfer these values to another table for analysis.How would you achieve ...

（183）The HR user creates a stand-alone procedure as follows and grants the EXECUTE privilege on the procedure to many database users:CREATE OR REPLACE PROCEDURE create_dept(v_deptno NUMBER, v_dname VARCHAR2, v_mgr NUMBER, v_loc NUMBER)BEGIN&nbsp...

（182）Which two statements are true regarding a PL/SQL package body? (Choose two.)A.It cannot be created without a package specification.B.It cannot invoke subprograms defined in other packages.C.It can contain only the subprograms defined in the package specification.D.It can be chang...

（181）View the Exhibit and examine the PL/SQL package and procedure.You made changes to the COMPUTE_TAX function inside the EMP_ADMIN package body.Which statement is true after you recompile the EMP_ADMIN package body?A. The USE_P procedure remains valid.B. The USE_P procedure bec...

（170）A constraint in a table is defined with the INITIALLY IMMEDIATE clause.You executed the ALTER TABLE command with the ENABLE VALIDATE option to enable the constraint that was disabled.What are the two effects of this command? (Choose two.)A. It fails if any existing row violates the...

（169）You have two tables with referential integrity enforced between them. You need to insert data to the child table first because it is going to be a long transaction and data for the parent table will be available in a later stage,which can be inserted as part of the same transactio...

（168）You execute this command to drop the ITEM table, which has the primary key referred in the ORDER table:SQL> DROP TABLE scott.item CASCADE CONSTRAINTS PURGE;Which two statements are true about the effect of the command? (Choose two.)A.No flashback is possible to bring back the ITEM ...

（167）Which three descriptions are correct about the effects of the TRUNCATE command on a  table? (Choose three.)A. The corresponding indexes for the table are also truncated.B. Delete triggers on the table are fired during the execution of the TRUNCATE command.C. The child table is...

（166）View the Exhibit and examine the setting for a table.Which statement is true about the PCTFREE setting for the table?A. It sets the minimum percentage of a data block to be reserved to contain chained rows from other blocks.B. It sets the minimum percentage of a data block to be res...

（165）You have an ORDERS table with the following structure:The table has data in the ODATE column for all rows. Many orders are placed in a single day.You need to ensure that the ODATE column must contain data for every order in future.Which method would serve the purpose?A. Mod...

（164）Examine the command that is used to create a table:SQL> CREATE TABLE orders(oid NUMBER(6) PRIMARY KEY, odate DATE, ccode NUMBER(6), oamt NUMBER(10,2)) TABLESPACE users;Which two statements are true about the effect of the above command? (Choose two.)A. A CHECK constraint is created...

（163）You want to access employee details contained in flat files as part of the EMPLOYEE table. You plan to add a new column to the EMPLOYEE table to achieve this.Which data type would you use for the new column?A. CLOBB. BLOBC. BFILED. LONG RAW答案：（C）...

（162）You created a profile APP_USER and assigned it to the users. After a month, you decide to drop the profile.Some user sessions are currently connected to the database instance and are using the APP_USER profile.This command is used to drop the profile:SQL> DROP PROFILE app_user; Whi...

（161）In your database instance, the user sessions are connected to the database server from the remote machines.You want to achieve the following for these users:1: The user account must be locked after four unsuccessful login attempts.2: The user must be prompted to change the password...

（160）View the Exhibit to observe the roles assigned to the SLP_REP user.Which statement is true about the assignment of the SELECT_CATALOG_ROLE role to the SLP_REP user?A. The user must enable the role explicitly.B. The user can grant the role to other users.C. The user cannot use...

（159）View the Exhibit and examine the user information.The user has been granted CONNECT and RESOURCE roles and no individual system privileges.The SL_REP user executes this command to create a table:SQL> CREATE TABLE orders(oid number(6), odate date, ccode number(4), oamt number(10,2)) ...

（158）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. Cre...

（157）Examine the commands executed in the following sequence:1: SQL> CREATE ROLE mgrrole;2: SQL> GRANT create user,select any table,connect,resource TO mgrrole;3: SQL> GRANT select,update ON sh.sales TO mgrrole;4: SQL> CREATE ROLE ceo IDENTIFIED BY boss;5: SQL> GRANT mgrrole,dro...