随笔分类 -  ocp-command

1 2 下一页
053-28
摘要：You have a range-partitioned table in your database. Each partition in the table contains thesales data for a quarter. The partition related to the cu 阅读全文
posted @ 2018-01-05 18:20 巴啦啦大魔王 阅读(124) 评论(0) 推荐(0)
053-17
摘要：The INV_HISTORY table is created using the command:SQL>CREATE TABLE INV_HISTORY (inv_no NUMBER(3), inv_date DATE, inv_amt NUMBER(10,2))partition by ra 阅读全文
posted @ 2018-01-04 14:43 巴啦啦大魔王 阅读(220) 评论(0) 推荐(0)
053-7
摘要：You need to configure fine-grained access control to external network resources from within yourdatabase. You create an access control list (ACL) usin 阅读全文
posted @ 2017-12-18 18:00 巴啦啦大魔王 阅读(140) 评论(0) 推荐(0)
053-5
摘要：Examine the section of the Health Check report given below:DBMS_HM.GET_RUN_REPORT('HM_RUN_1061') Run Name : HM_RUN_1061 Run Id : 1061 Check Name : Dat 阅读全文
posted @ 2017-12-18 17:27 巴啦啦大魔王 阅读(129) 评论(0) 推荐(0)
053-3
摘要：Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which contains one redo member. When you attempt to start the databa 阅读全文
posted @ 2017-12-18 17:16 巴啦啦大魔王 阅读(144) 评论(0) 推荐(0)
052-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> SELE 阅读全文
posted @ 2017-12-15 14:38 巴啦啦大魔王 阅读(138) 评论(0) 推荐(0)
052-183
摘要：The HR user creates a stand-alone procedure as follows and grants the EXECUTE privilege on theprocedure to many database users:CREATE OR REPLACE PROCE 阅读全文
posted @ 2017-12-15 14:26 巴啦啦大魔王 阅读(155) 评论(0) 推荐(0)
052-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 阅读全文
posted @ 2017-12-15 13:54 巴啦啦大魔王 阅读(101) 评论(0) 推荐(0)
052-180
摘要：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 f 阅读全文
posted @ 2017-12-15 13:46 巴啦啦大魔王 阅读(161) 评论(0) 推荐(0)
052-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 阅读全文
posted @ 2017-12-15 10:35 巴啦啦大魔王 阅读(110) 评论(0) 推荐(0)
052-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 lon 阅读全文
posted @ 2017-12-15 10:31 巴啦啦大魔王 阅读(145) 评论(0) 推荐(0)
052-168
摘要：You execute this command to drop the ITEM table, which has the primary key referred in the ORDERtable:SQL> DROP TABLE scott.item CASCADE CONSTRAINTS P 阅读全文
posted @ 2017-12-14 18:35 巴啦啦大魔王 阅读(195) 评论(0) 推荐(0)
052-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 ar 阅读全文
posted @ 2017-12-14 18:30 巴啦啦大魔王 阅读(138) 评论(0) 推荐(0)
052-165
摘要：You have an ORDERS table with the following structure:Name Null? Type OID NUMBER(6)ODATE DATECCODE NUMBER(6)OAMT NUMBER(10,2)The table has data in the 阅读全文
posted @ 2017-12-14 18:05 巴啦啦大魔王 阅读(183) 评论(0) 推荐(0)
052-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) 阅读全文
posted @ 2017-12-14 18:02 巴啦啦大魔王 阅读(101) 评论(0) 推荐(0)
052-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 e 阅读全文
posted @ 2017-12-14 15:50 巴啦啦大魔王 阅读(80) 评论(0) 推荐(0)
052-145
摘要：Examine the commands executed in a DBA session:SQL> CREATE BIGFILE TABLESPACE MRKT2 DATAFILE '/u01/app/oracle/oradata/orcl/mrkt.dbf' size 10M LOGGING3 阅读全文
posted @ 2017-12-14 13:40 巴啦啦大魔王 阅读(96) 评论(0) 推荐(0)
052-121
摘要：After performing a clean shut down of the database instance for maintenance, you mount the database and then execute a command to open the database:SQ 阅读全文
posted @ 2017-12-12 16:39 巴啦啦大魔王 阅读(126) 评论(0) 推荐(0)
052-101
摘要：You want to move all objects of the APPS user in the test database to the DB_USER schema of the production database. Which option of IMPDP would you u 阅读全文
posted @ 2017-12-11 14:51 巴啦啦大魔王 阅读(107) 评论(0) 推荐(0)
052-40
摘要：You have statistics collected for some selected tables. Your requirement is that the statistics for the tables and all dependent indexes must not be o 阅读全文
posted @ 2017-12-05 16:43 巴啦啦大魔王 阅读(87) 评论(0) 推荐(0)

1 2 下一页