Oracle-OCP
文章平均质量分 76
bitko
这个作者很懒,什么都没留下…
展开
-
20151122 ocp 052(01-10)解析
1.you need to load information about new customers from the new_cust table into the tables cust and cust_special ,if a new customer has a credit limit greater than 10000,then the details have to be原创 2015-11-22 14:36:31 · 684 阅读 · 0 评论 -
20160104 ocp 053 20-110
22.which two statements are true about encrypting rman backup?a.the transparent encryption of backups uses the encryption walletc.the password encryption is configured only uses the password while原创 2016-01-04 22:31:52 · 293 阅读 · 0 评论 -
20151219 ocp examA(60-70) examB(1-20)
64.view the exhibit button and examine the structures of orders and order_iten tables.in the orders table.order_id is the primary key and in the order_iterms table ,order_id and line_item_id form th原创 2015-12-19 21:01:27 · 385 阅读 · 0 评论 -
20151220 OCP 047 b 20-50
24.a subquery is called a single-row subquery when a.the inner query returns a single value to the main query顾名思义,对于主查询只返回一个值34.evaluate the following statement;insert all when order_total原创 2015-12-20 21:19:32 · 528 阅读 · 0 评论 -
examine c 1-20 执行计划的一些概念
2.which statements are true ?a.the data dictionary is created and maintained by the database administrtor多少次了,是由oracle服务器创建和维护的(除了审计相关的数据字典aud$开头的,这些表示可以修改的)b.the data dictionary views can consi原创 2015-12-21 21:30:15 · 634 阅读 · 0 评论 -
047 exam c 20-end
22.which three statements are turea.only one long column can be used per tableoracle只允许每个表中有一个long类型的列b.a timestamp data type column stores only time values wqith fractinal secondsstimestamp类型原创 2015-12-22 23:32:09 · 340 阅读 · 0 评论 -
047出错的一些题 记录一下
1.which statements are true regarding the usage of the with cluase in complex correlated subqueeiresa.it can be used only with the select cluasewith 必须紧跟sleect使用,这是必须的2.view the exhibit and exam原创 2015-12-23 23:07:31 · 458 阅读 · 0 评论 -
20151228 ocp 053 1-30
4.which two statements about the sql management base(SMB) are true ?c.it is part of the data dictionary and stored in the syssaux tablespacee.it contains the statement log,the plan history,plan ba原创 2015-12-28 19:40:52 · 544 阅读 · 0 评论 -
20151229 053 30-60
31.which of the following is a benifit of asm fast disk resync?a.failed disks are taken offline immeidately but are not droppedASM快速镜像重新同步可以显著减少重新同步临时故障磁盘所需要的时间,如果某个磁盘因临时故障而脱机ASM将跟踪在中断期间发生修改的区,临原创 2015-12-29 21:08:03 · 332 阅读 · 0 评论 -
20151230 053 60-b20
61.report need backup days 5;即所列的文件需要5天以前的归档日志,也就是说5天内没有备份过62.retention plicy是指rman备份保留策略configure retention policy to redundancy 1;表示备份的冗余度为1,就是保留最近一次的备份(可以做数据库恢复需要的一次备份,比如全备)conf原创 2015-12-30 20:15:14 · 332 阅读 · 0 评论 -
20160103 ocp 180-end 1-20
1.the recyclebin parameter is set to on for your database .you drop a table,products,from the scott schemawhich two statements are true regarding the outcome of this action?/a.all the related inde原创 2016-01-03 20:24:12 · 363 阅读 · 0 评论 -
ocp 053 exam c 1-30
3.what dynamic performance view can you query to list the supported platforms for transportable tablespaces?a.v$transportable_platform4.you issue following command to enable block change tracking原创 2016-01-07 20:23:59 · 835 阅读 · 0 评论 -
OCP 053 exam c 30-60
31.after you register a database from a recovery catalog ,what happeens to the backup metadata in the recovery catalog?b.the backup metadata is maintained in the controlfile for a number of days spe原创 2016-01-08 21:15:47 · 767 阅读 · 0 评论 -
ocp 053 exam c 60-90
62.you are querying v$backup_async_io determine which files are the bottleneck during rman backups.what columns should you use to identify cottlenecks?d.divide log_waits by io_cout and look for a lk原创 2016-01-09 21:20:21 · 817 阅读 · 0 评论 -
ocp 053 exam c 90-120
91.oracle database .wants to specify a number of locations to which the redo logs should be archived before an error occurswhich og the following will used.log_archive_min_succeed_dest93.you wor原创 2016-01-11 21:36:53 · 719 阅读 · 0 评论 -
ocp exam c 120-150
121.your database initialization parameter file has the following entry;sec_max_failed_login_attenpts=3which statement is true regarding this setting?a.it drops the connnection after the specifi原创 2016-01-12 21:01:14 · 439 阅读 · 0 评论 -
ocp 053 examb 150-end
151.which three functions are perfored by the sql tuning advisor?a.bulding the sql profilec.checking query objects for missing and state stasticse.recommendinmg restructuring sql qurries that ar原创 2016-01-06 21:22:40 · 330 阅读 · 0 评论 -
20151218 OCP 047 30-60
31.select to_char(list_price,$0,999") from product_information;which two statements would be true regarding the outpput for this sql statement?这道题考查的是格式化输出/format'$9,999'的意思是以$开头,显示四位整数,位数超过全部为#原创 2015-12-18 21:06:44 · 437 阅读 · 0 评论 -
20151217 OCP047 新题库 1-30
2.evaluate the following create table command;create table order_item(order_id number(3),item_id number(2),aty number(4),constraint ord_itm_id_pk primary key (order_id,item_id)using index(原创 2015-12-17 22:05:22 · 646 阅读 · 0 评论 -
20151125 ocp(50-70)
51.you plan to move data from a flat(直接的) file to a table in your database.you decide to use SQL_LOADER direct path load method to perform this task.the table in which you plan to load data is an im原创 2015-11-25 20:04:27 · 363 阅读 · 0 评论 -
20151124 ocp(30-50)
33.identify two situations in which the block header grows in a data block.a.when row directions need more row entriesd.when morwe transation slots are required than initially configured块头:块头包含段原创 2015-11-24 20:22:23 · 604 阅读 · 0 评论 -
20151123 ocp 052(10-30)
12.the database instance is currently using spfile,view the exhibit and examain the error that you reseived while runing the DB strunctre integrity checkgiven below are the steps to recover from原创 2015-11-23 19:14:56 · 703 阅读 · 0 评论 -
20151126 ocp052 卷2 1-20
3.examine the following steps performed on a database:1.the DBA grants the create table system privilege to the SKD user with ADMIN OPTION2.the SKD user creats a table3.the SKD user grants the C原创 2015-11-26 19:28:38 · 355 阅读 · 0 评论 -
OCP 052卷2 20-40
23.you want to import schema objects of the HR user using ORACLE DATA pump from the development databaseDEVDB,to the production database, PRODDB.a databse link devdb.us.oracle.com is created between原创 2015-11-27 19:45:47 · 354 阅读 · 0 评论 -
OCP 052 卷2 40-60
41.view the exhibit 1,which shows the options that are seelcted the user SL_REP. view the exhibit2 and examine the contents of DATABASE_PROPERTIES.which two statements are true regarding this user原创 2015-11-28 21:11:50 · 374 阅读 · 0 评论 -
20151201 ocp 卷3 1-30
1.examine the following statement that is used to modify the primary key constraint on the sales tablesql>alter table sales midify constraint pk disable validate;a.the constraint remains calidb.原创 2015-12-02 20:17:09 · 302 阅读 · 0 评论 -
20151202 ocp 卷3 30-55
24.which statement is true about loading data using the conventional path of sql*loaderc.no exclusive locks are acquired when the conventional path loads are performed常规路径加载通过执行sql insert 语句,将表填充到原创 2015-12-02 20:26:00 · 372 阅读 · 0 评论 -
20151203 ocp 052 卷3 55-70
56.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;sql>alter database open;which two statements原创 2015-12-03 22:02:53 · 372 阅读 · 0 评论 -
20151204 ocp模拟机测试成果
117.view the exhibit and examine the initialization parameter settingwhich three initliazation parameters are to be set manually as they are not automatically tuned?a.log_buffere.DB_16K_CH原创 2015-12-04 21:02:27 · 613 阅读 · 0 评论 -
20151207 ocp 052出错题 总结
2.which two statements are true about the automatic workload repository(AWR)?c.the snapshots collected by the AWR are accessible theough data dictionary viewsd.the snapshots collected by the AWR a原创 2015-12-07 20:02:24 · 1408 阅读 · 0 评论 -
20151209 OCP 047 1-40
6.which two statements are true?a.the user_sysnonyyms view can provide information about privite synoyms.对,无论是共有同义词还是私有同义词都可以提供b.the user system owns all the base tables and user-accessible view原创 2015-12-09 19:25:20 · 405 阅读 · 0 评论 -
20151211 OCP 047 40-60
41.view the exhibit and examine the structure of the emp table .you executed the following command to add a primary key to the emp table ;alter table emp add constraint emp_id_pk primary key(emp_i原创 2015-12-11 20:21:39 · 399 阅读 · 0 评论 -
20151212 OCP047 60-80d.d.
63.which create table statemenbt is vaild?d.create table ord_details(ord_no number(2),item_no numnber(3),ord_data data default sysdate not null需要注意的几个点,一个字段有多个限制的时候需要用空格隔开而不是逗号,default后面要加默认原创 2015-12-12 20:39:56 · 619 阅读 · 0 评论 -
20151216 OCP 047 100-120meta character syntaxes and the
102.evaluate the dollowing command;CREATE TABLE employees( employee_id number(2) PRIMARY KEY,last_name varchar2(25) not null,department_id number(2),job_id varchar2(8),salary number(10,2))原创 2015-12-16 20:32:03 · 634 阅读 · 0 评论 -
ocp exam 150-end
154.which statement is true about a scheduler-generated event?b.it indicates state changes that occur within the scheduler itself158.which two statements are true about an image copy backup?a.it原创 2016-01-13 21:11:55 · 447 阅读 · 0 评论