ITPub博客

课程内容介绍：■ Oracle Virtual Private Database（VPD）允许在行和列级别创建安全策略■ 它的本质是对应用了VPD安全策略的数据库表、视图、同义词上执行的SQL语句添加了动态的WHERE子句■ VPD可以在更细的粒度上强制实现安全策略，它直接作用于表、视图和同义词■ 当用户直接或间接地访问受VPD保护的表、视图和...

到此，Oracle 11G 1Z0-052的所有题目的解析都给大家总结完了。大家在我的博文目录中，可以看到所有题目的解析。希望大家参考、练习、顺利通过OCP考试！

（188）You receive complaints  from users  regarding the high waiting time for their transactions.On investigation, you find that some users are not committing their transactions though they are not performing any activity for a long time.As a result, SQL statements need to wait for...

（187）Which two statements describe good practices for an application developer to reduce locking conflicts in Oracle database? (Choose two.)A. Avoid coding unnecessary long-running transactions.B. Allow the database to handle locks in default locking mode.C. Always explicitly code the loc...

（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...

passwd的文件[@:/] name passwdvarsadmpkgSUNWcsrsavepspoolSUNWcsrrelocetcdefaultpasswdvarsadmpkgSUNWcsrsavepspoolSUNWcsrrelocetcpasswdetcwebminpasswdetcpasswdetcdefaultpasswdusrsfwlibwebmincalderapasswdusrsfwlibwebminpasswdusrsfwlibwebminblue-themepasswdusrbi...

win7的,而后开启Win7控制面板   Telnet服务器和Telnet服务器# 在运行窗口输入# 右键 # 从虚拟机用, 根据提示输入宿主机rootS1011$ telnet192168610Trying ......Connected to ....Escape character is .Welcome to Microsoft Telnet Service login administrator:&n...

（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...