12 2017 档案

053-11
摘要：View the Exhibit to examine the metrics with a threshold. Which statement is true regarding the Number of Transactions (per second) metric? A. Oracle 阅读全文
posted @ 2017-12-20 16:54 巴啦啦大魔王 阅读(114) 评论(0) 推荐(0)
051-20
摘要：Which three statements are true regarding the data types in Oracle Database 10g/11g? (Choose three.)A. Only one LONG column can be used per table.B. A 阅读全文
posted @ 2017-12-20 15:48 巴啦啦大魔王 阅读(186) 评论(0) 推荐(0)
051-17
摘要：View the E xhibit and examine the data in the EMPLOYEES table.You want to generate a report showing the total compensation paid to each employee to da 阅读全文
posted @ 2017-12-20 15:42 巴啦啦大魔王 阅读(136) 评论(0) 推荐(0)
051-15
摘要：View the Exhibit and examine the data in the CUSTOMERS table.Evaluate the following query:SQL> SELECT cust_name AS "NAME", cust_credit_limit/2 AS MIDP 阅读全文
posted @ 2017-12-20 15:33 巴啦啦大魔王 阅读(112) 评论(0) 推荐(0)
排序算法
摘要：边看书边学习，这个链接中的博主写的一目了然，就不做重复的工作了。 [Data Structure & Algorithm] 七大查找算法 [经典排序算法][集锦] 经典排序算法 - 桶排序Bucket sort 经典排序算法 - 基数排序Radix sort 阅读全文
posted @ 2017-12-19 16:53 巴啦啦大魔王 阅读(121) 评论(0) 推荐(0)
数据结构数组、链表和游标
摘要：C/C++中数组要定义好边界；为了灵活用指针式的链表；而很多语言是不能操纵指针，所以用游标数组，那么问题又回到了原点又有边界了。以多项式为例,设多项式为P=A1Xn1+A2Xn2+···AiXni数组数组中存储多项式是一个对象P中有数组B[MAXDEGREE+1](存储多项式的系数A),C(存储多项 阅读全文
posted @ 2017-12-19 16:29 巴啦啦大魔王 阅读(240) 评论(0) 推荐(0)
053-9
摘要：Which statement describes the information returned by the DBMS_SPACE.SPACE_USAGE procedure for LOB space usage?A. It returns space usage of only Basic 阅读全文
posted @ 2017-12-18 18:25 巴啦啦大魔王 阅读(153) 评论(0) 推荐(0)
053-8
摘要：Which statement is true regarding online redefinition for the migration of BasicFile LOBs to SecureFile LOBs?A. It cannot be done in parallel. B. It c 阅读全文
posted @ 2017-12-18 18:09 巴啦啦大魔王 阅读(144) 评论(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 巴啦啦大魔王 阅读(143) 评论(0) 推荐(0)
053-6
摘要：You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the user RCO11. The INST1 database contains 阅读全文
posted @ 2017-12-18 17:36 巴啦啦大魔王 阅读(139) 评论(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)
053-2
摘要：You plan to have a larger moving window size for the default system-defined moving window baselinebecause you want to use the adaptive threshold.Which 阅读全文
posted @ 2017-12-18 17:10 巴啦啦大魔王 阅读(175) 评论(0) 推荐(0)
053-1
摘要：1.While deploying a new application module, the software vendor ships the application software along with appropriate SQL plan baselines for the new S 阅读全文
posted @ 2017-12-18 17:04 巴啦啦大魔王 阅读(131) 评论(0) 推荐(0)
多项式ADT笔记（数据结构c版）
摘要：项式ADT笔记设多项式为P=A1Xn1+A2Xn2+···AiXni c/c++ 传统数组的缺点使用链表实现 用游标实现链表 阅读全文
posted @ 2017-12-18 09:54 巴啦啦大魔王 阅读(289) 评论(0) 推荐(0)
052-188
摘要：You receive complaints from users regarding the high waiting time for their transactions. On investigation, you find that some users are not committin 阅读全文
posted @ 2017-12-15 14:51 巴啦啦大魔王 阅读(159) 评论(0) 推荐(0)
052-187
摘要：Which two statements describe good practices for an application developer to reduce locking conflicts in Oracle database? (Choose two.)A.Avoid coding 阅读全文
posted @ 2017-12-15 14:48 巴啦啦大魔王 阅读(107) 评论(0) 推荐(0)
052-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 阅读全文
posted @ 2017-12-15 14:41 巴啦啦大魔王 阅读(134) 评论(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 巴啦啦大魔王 阅读(139) 评论(0) 推荐(0)
052-184
摘要：You suspect unauthorized data manipulation language (DML) operations on a particular table. Youwant to track users who are performing the transactions 阅读全文
posted @ 2017-12-15 14:31 巴啦啦大魔王 阅读(110) 评论(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 巴啦啦大魔王 阅读(103) 评论(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-177
摘要：Which three statements are correct about temporary tables? (Choose three.)A.Indexes and views can be created on temporary tables.B.Both the data and t 阅读全文
posted @ 2017-12-15 11:28 巴啦啦大魔王 阅读(124) 评论(0) 推荐(0)
052-176
摘要：You executed this command to create a temporary table:SQL> CREATE GLOBAL TEMPORARY TABLE report_work_area (startdate DATE, enddate DATE, class CHAR(20 阅读全文
posted @ 2017-12-15 11:24 巴啦啦大魔王 阅读(103) 评论(0) 推荐(0)
052-175
摘要：What can you achieve by implementing reverse key index?A.Reverse the bytes of each column indexed including the row ID.B.Store a bitmap for each key v 阅读全文
posted @ 2017-12-15 11:21 巴啦啦大魔王 阅读(141) 评论(0) 推荐(0)
052-174
摘要：Which two statements are true regarding B-tree index? (Choose two.)A.The leaf blocks in the index are doubly linked.B.The leaf node stores a bitmap fo 阅读全文
posted @ 2017-12-15 11:13 巴啦啦大魔王 阅读(129) 评论(0) 推荐(0)
052-173
摘要：Which statement describes the effect on an index, when the indexed column for the rows is updated in the base table?A.An update in a leaf row takes pl 阅读全文
posted @ 2017-12-15 11:10 巴啦啦大魔王 阅读(148) 评论(0) 推荐(0)
052-172
摘要：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 阅读全文
posted @ 2017-12-15 11:05 巴啦啦大魔王 阅读(189) 评论(0) 推荐(0)
052-171
摘要：View the Exhibit and examine the command used to create the ZONEDATA table. The table contains a million rows for zonewise analysis in the DSS system. 阅读全文
posted @ 2017-12-15 10:49 巴啦啦大魔王 阅读(184) 评论(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 巴啦啦大魔王 阅读(148) 评论(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 巴啦啦大魔王 阅读(196) 评论(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 巴啦啦大魔王 阅读(140) 评论(0) 推荐(0)
052-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 阅读全文
posted @ 2017-12-14 18:11 巴啦啦大魔王 阅读(111) 评论(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 巴啦啦大魔王 阅读(184) 评论(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-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 achie 阅读全文
posted @ 2017-12-14 17:59 巴啦啦大魔王 阅读(133) 评论(0) 推荐(0)
052-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 阅读全文
posted @ 2017-12-14 17:56 巴啦啦大魔王 阅读(134) 评论(0) 推荐(0)
052-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 thes 阅读全文
posted @ 2017-12-14 17:53 巴啦啦大魔王 阅读(130) 评论(0) 推荐(0)
052-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 th 阅读全文
posted @ 2017-12-14 17:46 巴啦啦大魔王 阅读(136) 评论(0) 推荐(0)
052-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_RE 阅读全文
posted @ 2017-12-14 15:54 巴啦啦大魔王 阅读(140) 评论(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-156
摘要：Examine the following steps performed on a database instance:1: The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION.2: 阅读全文
posted @ 2017-12-14 14:57 巴啦啦大魔王 阅读(117) 评论(0) 推荐(0)
052-155
摘要：The user HR owns the EMP table. The user HR grants privileges to the user SCOTT by using this command:SQL> GRANT SELECT,INSERT,UPDATE ON emp TO scott 阅读全文
posted @ 2017-12-14 14:52 巴啦啦大魔王 阅读(89) 评论(0) 推荐(0)
052-154
摘要：View the Exhibit and examine the privileges granted to the MGR_ROLE role. The user SKD has been granted the CONNECT and RESOURCE roles only. The datab 阅读全文
posted @ 2017-12-14 14:46 巴啦啦大魔王 阅读(117) 评论(0) 推荐(0)
052-153
摘要：The database instance has the following parameter setting:OS_AUTHENT_PREFIX = OPS$OS_ROLES = FALSEREMOTE_OS_AUTHENT = FALSEREMOTE_OS_ROLES = FALSETIME 阅读全文
posted @ 2017-12-14 14:40 巴啦啦大魔王 阅读(181) 评论(0) 推荐(0)
052-151
摘要：View the Exhibit1, which shows the options that are selected to create the user SL_REP. View the Exhibit2 and examine the contents of DATABASE_PROPERT 阅读全文
posted @ 2017-12-14 14:31 巴啦啦大魔王 阅读(104) 评论(0) 推荐(0)
052-150
摘要：The user HR receives the following error while inserting data into the TTK table:ERROR at line 1:ORA-01653: unable to extend table HR.TTK by 128 in ta 阅读全文
posted @ 2017-12-14 14:24 巴啦啦大魔王 阅读(160) 评论(0) 推荐(0)
052-149
摘要：You executed the following command to create a tablespace called SALES_DATA:SQL> CREATE TABLESPACE sales_data DATAFILE SIZE 100MSEGMENT SPACE MANAGEME 阅读全文
posted @ 2017-12-14 14:14 巴啦啦大魔王 阅读(132) 评论(0) 推荐(0)
052-148
摘要：View the Exhibit. Which statements are true regarding the USERS tablespace? (Choose all that apply.)A.A bitmap is used to record free extents.B.Free e 阅读全文
posted @ 2017-12-14 13:51 巴啦啦大魔王 阅读(112) 评论(0) 推荐(0)
052-147
摘要：View the Exhibit. You want to create a tablespace to contain objects with block size 16 KB. But while configuring thestorage you find that the block s 阅读全文
posted @ 2017-12-14 13:47 巴啦啦大魔王 阅读(157) 评论(0) 推荐(0)
052-146
摘要：Identify three situations in which you would NOT be able to drop a tablespace. (Choose three.)A.when the tablespace is onlineB.when the tablespace has 阅读全文
posted @ 2017-12-14 13:41 巴啦啦大魔王 阅读(136) 评论(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-144
摘要：You execute the following command to change the status of the SALES tablespace:SQL> ALTER TABLESPACE sales OFFLINE;Which statements describe the effec 阅读全文
posted @ 2017-12-14 13:32 巴啦啦大魔王 阅读(157) 评论(0) 推荐(0)
052-143
摘要：You execute a command to resize a data file, sales.dbf, of size 200 MB in your database:ALTER DATABASE DATAFILE '/remorse/sales.dbf' RESIZE 150M;Which 阅读全文
posted @ 2017-12-14 13:27 巴啦啦大魔王 阅读(146) 评论(0) 推荐(0)
oracle关联查询问题
摘要：--关联查询时爆了a.id无效然后测试了一下 --错误 select a.id, b.id, c.id from t1 a ,t2 b left join t3 c on c.id=a.id where a.id=b.id --正确 select a.id, b.id, c.id from t1 a left join t3 c on c.id=a.id , t2 b where a... 阅读全文
posted @ 2017-12-14 10:43 巴啦啦大魔王 阅读(130) 评论(0) 推荐(0)
oracle 分组查询
摘要：a、row_number() over() row_number()over(partition by col1 order by col2)表示根据col1分组，在分组内部根据col2排序，而此函数计算的值就表示每组内部排序后的顺序编号（组内连续的唯一的）。 与rownum的区别在于：使用rown 阅读全文
posted @ 2017-12-14 09:50 巴啦啦大魔王 阅读(184) 评论(0) 推荐(0)
052-141
摘要：Which tablespaces are mandatory in an Oracle database for it to be operational? (Choose all that apply.)A.Undo tablespaceB.USERS tablespaceC.SYSAUX ta 阅读全文
posted @ 2017-12-13 15:45 巴啦啦大魔王 阅读(152) 评论(0) 推荐(0)
052-140
摘要：Identify two situations in which the block header grows in a data block. (Choose two.)A.when row directories need more row entriesB.when there is row 阅读全文
posted @ 2017-12-13 15:42 巴啦啦大魔王 阅读(124) 评论(0) 推荐(0)
052-139
摘要：Which two statements are true regarding a tablespace? (Choose two.)A.It can span multiple databases.B.It can consist of multiple data files.C.It can c 阅读全文
posted @ 2017-12-13 15:37 巴啦啦大魔王 阅读(133) 评论(0) 推荐(0)
052-138
摘要：Your database is configured in shared server mode. However, your senior DBA asks you to modify the value of the PRIVATE_SGA limit in the profile of th 阅读全文
posted @ 2017-12-13 15:31 巴啦啦大魔王 阅读(171) 评论(0) 推荐(0)
052-137
摘要：Your database instance is currently configured to support 1,500 connections. The Web application that uses the database allows a large number of users 阅读全文
posted @ 2017-12-13 15:28 巴啦啦大魔王 阅读(147) 评论(0) 推荐(0)
052-135
摘要：In which situation would you use static database registration for a listener?A.when multiple databases are to be registered with the listenerB.when DB 阅读全文
posted @ 2017-12-13 15:19 巴啦啦大魔王 阅读(149) 评论(0) 推荐(0)
052-134
摘要：View the Exhibit and examine the output. A. The ORCL instance is registered dynamically with the listener.B. The ORCL instance is registered staticall 阅读全文
posted @ 2017-12-13 15:17 巴啦啦大魔王 阅读(151) 评论(0) 推荐(0)
052-133
摘要：Your database is open and the LISTENER listener is running. The new DBA of the system stops the listener by using the command: LSNRCTL> STOPWhat happe 阅读全文
posted @ 2017-12-13 15:13 巴啦啦大魔王 阅读(133) 评论(0) 推荐(0)
052-132
摘要：The tnsnames.ora file has an entry for the service alias ORCL as follows:ORCL =( DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 10.156.24.216)(PORT = 阅读全文
posted @ 2017-12-13 15:11 巴啦啦大魔王 阅读(176) 评论(0) 推荐(0)
052-131
摘要：Which naming method uses the tnsnames.ora file to store the connect descriptor used by the client while connecting to the database instance from a rem 阅读全文
posted @ 2017-12-13 15:08 巴啦啦大魔王 阅读(141) 评论(0) 推荐(0)
oralce正则
摘要：--1.正则判断,适用于10g以上版本 --非正整数 select 字段 from 表 where regexp_replace(字段,'\d','') is not null; --非数值类型 select 字段 from 表 where regexp_replace(字段,'^[-\+]?\d+(\.\d+)?$','') is not null; --2.自定义函数,判断非值类型 cre... 阅读全文
posted @ 2017-12-13 14:35 巴啦啦大魔王 阅读(172) 评论(0) 推荐(0)
052-130
摘要：Which two statements are true regarding listeners? (Choose two.)A.Listeners use only the TCP/IP protocol.B.Multiple listener processes can run simulta 阅读全文
posted @ 2017-12-12 18:34 巴啦啦大魔王 阅读(118) 评论(0) 推荐(0)
052-129
摘要：A database user SMITH tries to query the V$SESSION view and fails to access it as follows:SQL> connect smith/smithConnected. SQL> SELECT * FROM v$sess 阅读全文
posted @ 2017-12-12 18:33 巴啦啦大魔王 阅读(271) 评论(0) 推荐(0)
052-128
摘要：Which statements listed below describe the data dictionary views?1. These are stored in the SYSTEM tablespace2. These are the based on the virtual tab 阅读全文
posted @ 2017-12-12 18:18 巴啦啦大魔王 阅读(201) 评论(0) 推荐(0)
052-126&127
摘要：Identify the two situations in which the alert log file is updated with details. (Choose two.)A. Running a query on a table returns "ORA-600: Internal 阅读全文
posted @ 2017-12-12 17:50 巴啦啦大魔王 阅读(192) 评论(0) 推荐(0)
052-125
摘要：You want to check the details of few errors that users have reported. You search for the alert log file and execute few commands to find the location 阅读全文
posted @ 2017-12-12 17:26 巴啦啦大魔王 阅读(103) 评论(0) 推荐(0)
052-124
摘要：You executed the following commands to find the location of the alert log file:SQL> SHOW PARAMETER BACKGROUND_DUMP_DESTNAME TYPE VALUE background_dump 阅读全文
posted @ 2017-12-12 17:15 巴啦啦大魔王 阅读(131) 评论(0) 推荐(0)
052-123
摘要：You used the IMMEDIATE option to shut down your database instance. Consider the steps that may occur when a database instance is started and database 阅读全文
posted @ 2017-12-12 16:55 巴啦啦大魔王 阅读(191) 评论(0) 推荐(0)
052-122
摘要：View the Exhibit and note the files available in the $ORACLE_HOME/dbs folder. The ASM instance is already running. You used the following steps to sta 阅读全文
posted @ 2017-12-12 16:51 巴啦啦大魔王 阅读(137) 评论(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 巴啦啦大魔王 阅读(127) 评论(0) 推荐(0)
052-120
摘要：For which database operation would you need the database to be in the MOUNT state?A.renaming the control filesB.re-creating the control filesC.droppin 阅读全文
posted @ 2017-12-12 16:27 巴啦啦大魔王 阅读(101) 评论(0) 推荐(0)
052-119
摘要：View the Exhibit and examine the output of the query. What do you infer from this?A.The SGA_TARGET is a static parameter.B.The instance is started, bu 阅读全文
posted @ 2017-12-12 16:20 巴啦啦大魔王 阅读(149) 评论(0) 推荐(0)
052-118
摘要：Which three statements regarding the server parameter file (SPFILE) are true? (Choose three.) A.An SPFILE is a binary file.B.An SPFILE cannot reside o 阅读全文
posted @ 2017-12-12 16:14 巴啦啦大魔王 阅读(145) 评论(0) 推荐(0)
052-117
摘要：View the Exhibit and examine the initialization parameter settings. Which three initialization parameters are to be set manually as they are not autom 阅读全文
posted @ 2017-12-12 15:49 巴啦啦大魔王 阅读(149) 评论(0) 推荐(0)
052-116
摘要：Your database instance is started using the server parameter file (SPFILE). You executed a command to change the value of the LOG_BUFFER initializatio 阅读全文
posted @ 2017-12-12 15:41 巴啦啦大魔王 阅读(126) 评论(0) 推荐(0)
052-115
摘要：View the Exhibit. You are creating an additional database by using the Database Configuration Assistant (DBCA). You opted to create a General Purpose 阅读全文
posted @ 2017-12-12 15:29 巴啦啦大魔王 阅读(143) 评论(0) 推荐(0)
052-114
摘要：You plan to implement the distributed database system in your company. You invoke Database Configuration Assistant (DBCA) to create a database on the 阅读全文
posted @ 2017-12-12 15:25 巴啦啦大魔王 阅读(117) 评论(0) 推荐(0)
052-113
摘要：You are working on a new Oracle Database 11g server, where only the software is installed and no database is created. You plan to create a database on 阅读全文
posted @ 2017-12-12 15:17 巴啦啦大魔王 阅读(138) 评论(0) 推荐(0)
052-112
摘要：View the Exhibit. What would happen if Oracle Home is not empty?A.The installation will not be continued until the location is empty.B.The installatio 阅读全文
posted @ 2017-12-12 15:08 巴啦啦大魔王 阅读(87) 评论(0) 推荐(0)
取出N个数中出现次数大于N/2的数字
摘要：先初始化随机输入的数字N的个数个数字，人为知道一个未知数n，其出现次数大于N/2然后用快速排序，用相差N/2-1个数之间是否相等判断哪些数是n。 阅读全文
posted @ 2017-12-12 14:20 巴啦啦大魔王 阅读(542) 评论(0) 推荐(0)
052-110
摘要：Which task would you perform before you run Oracle Universal Installer (OUI) in silent or suppressed mode for an installation? A.Run the root.sh scrip 阅读全文
posted @ 2017-12-11 17:46 巴啦啦大魔王 阅读(108) 评论(0) 推荐(0)
052-109
摘要：In a new installation of Oracle Database 11g, you perform these activities:1: Organize software and data on different subdirectories to avoid poor per 阅读全文
posted @ 2017-12-11 17:44 巴啦啦大魔王 阅读(158) 评论(0) 推荐(0)
052-108
摘要：You are installing Oracle Database 11g on your server. During the installation Oracle Universal Installer (OUI) prompts you to enter the path of the i 阅读全文
posted @ 2017-12-11 17:39 巴啦啦大魔王 阅读(99) 评论(0) 推荐(0)
052-107
摘要：Note the following points describing various utilities in Oracle Database 11g:1: It enables the transfer of data from one database to another.2: It pr 阅读全文
posted @ 2017-12-11 17:36 巴啦啦大魔王 阅读(118) 评论(0) 推荐(0)
052-106
摘要：You plan to configure the new Oracle Database 11g installation by performing these tasks:- Use Automatic Storage Management (ASM) as the storage optio 阅读全文
posted @ 2017-12-11 17:33 巴啦啦大魔王 阅读(98) 评论(0) 推荐(0)
052-105
摘要：Which statements are true regarding the creation of an incident package file by using the EMWorkbench Support? (Choose all that apply.)A.You can add S 阅读全文
posted @ 2017-12-11 17:29 巴啦啦大魔王 阅读(95) 评论(0) 推荐(0)
052-104
摘要：View the Exhibit to examine the details for an incident. Which statement is true regarding the status of the incident? Which statement is true regardi 阅读全文
posted @ 2017-12-11 17:15 巴啦啦大魔王 阅读(87) 评论(0) 推荐(0)
052-103
摘要：Which two statements are true regarding the Oracle Data Pump export and import operations?(Choose two.)A.You cannot export data from a remote database 阅读全文
posted @ 2017-12-11 17:08 巴啦啦大魔王 阅读(122) 评论(0) 推荐(0)
052-102
摘要：You want to import schema objects of the HR user using Oracle Data Pump from the development database, DEVDB, to the production database, PRODDB. A da 阅读全文
posted @ 2017-12-11 17:05 巴啦啦大魔王 阅读(244) 评论(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-100
摘要：In which situations does the Oracle Data Pump use external tables and not the direct path load while exporting a table? (Choose all that apply.)A.if a 阅读全文
posted @ 2017-12-11 14:48 巴啦啦大魔王 阅读(104) 评论(0) 推荐(0)
052-99
摘要：Which two statements are true regarding Oracle Data Pump? (Choose two.)A.EXPDP and IMPDP are the client components of Oracle Data Pump.B.DBMS_DATAPUMP 阅读全文
posted @ 2017-12-11 14:38 巴啦啦大魔王 阅读(143) 评论(0) 推荐(0)
052-98
摘要：Which two statements are true regarding the usage of the SQL*Loader utility? (Choose two.)A.You can load data into multiple tables during the same loa 阅读全文
posted @ 2017-12-11 14:30 巴啦啦大魔王 阅读(110) 评论(0) 推荐(0)
052-97
摘要：Which statement is true about loading data using the conventional path of SQL*Loader?A.Redo is not generated while performing conventional path loads. 阅读全文
posted @ 2017-12-11 14:25 巴啦啦大魔王 阅读(103) 评论(0) 推荐(0)
052-95
摘要：You have a large amount of historical data in a flat file. Some analysts in your organization need to query this data in the file. The file is too lar 阅读全文
posted @ 2017-12-11 14:14 巴啦啦大魔王 阅读(98) 评论(0) 推荐(0)
052-94
摘要：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 tab 阅读全文
posted @ 2017-12-11 14:07 巴啦啦大魔王 阅读(107) 评论(0) 推荐(0)
052-93
摘要：You are using flat files as the data source for one of your data warehousing applications. To optimize the application performance, you plan to move t 阅读全文
posted @ 2017-12-11 14:02 巴啦啦大魔王 阅读(156) 评论(0) 推荐(0)
052-92
摘要：You executed the following commands in an RMAN session for your database instance that hasfailures:RMAN> LIST FAILURE;After some time, you executed th 阅读全文
posted @ 2017-12-11 13:55 巴啦啦大魔王 阅读(192) 评论(0) 推荐(0)
052-91
摘要：View the Exhibit to examine the error that occurred during the database startup. You opened an RMAN session for the database. To repair the failure, y 阅读全文
posted @ 2017-12-11 13:49 巴啦啦大魔王 阅读(239) 评论(0) 推荐(0)
052-90
摘要：Which two activities are NOT supported by the Data Recovery Advisor (DRA)? (Choose two.)A.Recover from failures in the RAC environment.B.Diagnose and 阅读全文
posted @ 2017-12-11 13:29 巴啦啦大魔王 阅读(146) 评论(0) 推荐(0)
052-89
摘要：Which two kinds of failures make the Data Recovery Advisor (DRA) generate a manual checklist?(Choose two.)A.failure when no standby database is config 阅读全文
posted @ 2017-12-11 13:25 巴啦啦大魔王 阅读(135) 评论(0) 推荐(0)
052-88
摘要：Identify two situations in which you can use Data Recovery Advisor for recovery. (Choose two.)A.The database files are corrupted when the database is 阅读全文
posted @ 2017-12-11 13:18 巴啦啦大魔王 阅读(147) 评论(0) 推荐(0)
052-87
摘要：You are managing an Oracle Database 11g database running in ARCHIVELOG mode. The Flash Recovery Area is specified as the destination for the archived 阅读全文
posted @ 2017-12-11 13:14 巴啦啦大魔王 阅读(108) 评论(0) 推荐(0)
052-86
摘要：View the Exhibit to examine the output for the CROSSCHECK BACKUP command.Which statement is true about the output of the command? A. The backup piece 阅读全文
posted @ 2017-12-11 13:09 巴啦啦大魔王 阅读(154) 评论(0) 推荐(0)
输出0~N之间的素数
摘要：修改于上篇判断是否为素数 阅读全文
posted @ 2017-12-11 12:23 巴啦啦大魔王 阅读(531) 评论(0) 推荐(0)
判断正整数是否是素数(数据结构课后练习题2.13a)
摘要：//自己根据资料练习#include //输入一个数字判断是否为素数 #include using namespace std; bool isPrime(unsigned int N); bool type1(char N1[],int N2); unsigned int a2ul(char *s); int main(void) { char str[100],m='1'; ... 阅读全文
posted @ 2017-12-11 11:20 巴啦啦大魔王 阅读(696) 评论(0) 推荐(0)
052-85
摘要：You want to configure and schedule offline database backups to run automatically. Which tool or utility would you use to achieve this?A.the XML script 阅读全文
posted @ 2017-12-08 14:36 巴啦啦大魔王 阅读(106) 评论(0) 推荐(0)
052-84
摘要：Which two files in the database can be configured for automatic backups by using the autobackup feature in Recovery Manager (RMAN)? (Choose two.)A.dat 阅读全文
posted @ 2017-12-08 14:35 巴啦啦大魔王 阅读(168) 评论(0) 推荐(0)
052-83
摘要：You are using Enterprise Manager to schedule backups for your database. Which type of script would be generated by the backup scheduler?A.XML scriptB. 阅读全文
posted @ 2017-12-08 14:27 巴啦啦大魔王 阅读(111) 评论(0) 推荐(0)
052-81
摘要：You are managing an Oracle Database 11g database with this backup strategy:- Every Sunday night, level 0 backup is performed.- On Monday night and sub 阅读全文
posted @ 2017-12-08 14:01 巴啦啦大魔王 阅读(134) 评论(0) 推荐(0)
052-80
摘要：You perform differential incremental level 1 backups of your database on each working day and level 0 backup on Sundays, to tape.Which two statements 阅读全文
posted @ 2017-12-08 13:46 巴啦啦大魔王 阅读(107) 评论(0) 推荐(0)
052-79
摘要：You are working on a database that must be functioning 24 hours a day, 7 days a week. The database is configured in ARCHIVELOG mode.Which two options 阅读全文
posted @ 2017-12-08 13:35 巴啦啦大魔王 阅读(93) 评论(0) 推荐(0)
052-78
摘要：You are managing an Oracle Database 11g database. The database is open, and you plan to performRecovery Manager (RMAN) backups. Which three statements 阅读全文
posted @ 2017-12-08 13:31 巴啦啦大魔王 阅读(154) 评论(0) 推荐(0)
052-76
摘要：Which statement is true about a whole consistent database backup on a database running in ARCHIVELOG mode?A.The backup will consist of used data block 阅读全文
posted @ 2017-12-08 13:25 巴啦啦大魔王 阅读(113) 评论(0) 推荐(0)
052-75
摘要：Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS tablespace is lost due to a media failure. You notice 阅读全文
posted @ 2017-12-08 13:22 巴啦啦大魔王 阅读(115) 评论(0) 推荐(0)
052-74
摘要：The database is running in ARCHIVELOG mode. Examine the initialization parameters and theirvalues set to enable archiving on your database server:LOG_ 阅读全文
posted @ 2017-12-08 13:19 巴啦啦大魔王 阅读(126) 评论(0) 推荐(0)
052-73
摘要：You are managing an Oracle Database 11g database. You configured the database to run inARCHIVELOG mode. Which two statements are true in this scenario 阅读全文
posted @ 2017-12-08 13:14 巴啦啦大魔王 阅读(71) 评论(0) 推荐(0)
052-71
摘要：You configured the Flash Recovery Area for your database. The database instance has been startedin ARCHIVELOG mode and the LOG_ARCHIVE_DEST_1 paramete 阅读全文
posted @ 2017-12-08 11:37 巴啦啦大魔王 阅读(119) 评论(0) 推荐(0)
052-70
摘要：You configured the Flash Recovery Area (FRA) for your database. The database instance is running in ARCHIVELOG mode. The default location for the arch 阅读全文
posted @ 2017-12-08 11:20 巴啦啦大魔王 阅读(96) 评论(0) 推荐(0)
052-69
摘要：You are working on an instance started using the SPFILE. You want to move the Flash Recovery Area of your database to a new location. You want the Fla 阅读全文
posted @ 2017-12-08 11:16 巴啦啦大魔王 阅读(107) 评论(0) 推荐(0)
052-67
摘要：The instance abnormally terminates because of a power outage. Which statement is true about redo log files during instance recovery?A.Inactive and cur 阅读全文
posted @ 2017-12-08 10:44 巴啦啦大魔王 阅读(100) 评论(0) 推荐(0)
052-66
摘要：You notice that the performance of the database has degraded because of frequent checkpoints.Which two actions resolve the issue? (Choose two.)A.Disab 阅读全文
posted @ 2017-12-08 10:42 巴啦啦大魔王 阅读(132) 评论(0) 推荐(0)
052-65
摘要：Which two statements are true about checkpointing? (Choose two.)A. The checkpoint frequency decreases with the smaller redo log file size.B. It ensure 阅读全文
posted @ 2017-12-07 18:32 巴啦啦大魔王 阅读(122) 评论(0) 推荐(0)
052-64
摘要：Which two statements are true about setting the FAST_START_MTTR_TARGET initialization parameter to a nonzero value? (Choose two.)A.The MTTR advisor wi 阅读全文
posted @ 2017-12-07 18:14 巴啦啦大魔王 阅读(93) 评论(0) 推荐(0)
052-63
摘要：Examine the values for the following initialization parameters:FAST_START_MTTR_TARGET = 0LOG_CHECKPOINT_INTERVAL = 0Which two will be the implications 阅读全文
posted @ 2017-12-07 18:08 巴啦啦大魔王 阅读(88) 评论(0) 推荐(0)
052-62
摘要：You are in the middle of a transaction updating a very important table. The machine on which a database was running reboots because of power outage. T 阅读全文
posted @ 2017-12-07 18:04 巴啦啦大魔王 阅读(92) 评论(0) 推荐(0)
052-61
摘要：Given below is a list of scenarios:1) A user terminates his session abnormally.2) The connection between the server and the client application termina 阅读全文
posted @ 2017-12-07 17:59 巴啦啦大魔王 阅读(103) 评论(0) 推荐(0)
052-60
摘要：In which of the scenarios will the DBA perform recovery? (Choose all that apply.)A.The alert log file is corrupted.B.A tablespace is accidentally drop 阅读全文
posted @ 2017-12-07 15:30 巴啦啦大魔王 阅读(107) 评论(0) 推荐(0)
052-57
摘要：Automatic Shared Memory Management is disabled for your database instance. You realize that there are cases of SQL statements performing poorly becaus 阅读全文
posted @ 2017-12-07 15:18 巴啦啦大魔王 阅读(82) 评论(0) 推荐(0)
052-55
摘要：View the Exhibit to examine the output produced by the following query at three different times since the database instance started and has experience 阅读全文
posted @ 2017-12-07 15:04 巴啦啦大魔王 阅读(212) 评论(0) 推荐(0)
052-54
摘要：Automatic Shared Memory Management (ASMM) has been enabled for your database instance. The initialization parameters for the components that are manag 阅读全文
posted @ 2017-12-07 14:48 巴啦啦大魔王 阅读(118) 评论(0) 推荐(0)
052-51
摘要：In a system, large online transaction processing (OLTP) jobs run during the daytime that require a large database buffer cache. In the night, the syst 阅读全文
posted @ 2017-12-07 14:18 巴啦啦大魔王 阅读(182) 评论(0) 推荐(0)
052-50
摘要：Which two statements are true about alerts? (Choose two.)A.Clearing an alert sends the alert to the alert history.B.Response actions cannot be specifi 阅读全文
posted @ 2017-12-07 13:25 巴啦啦大魔王 阅读(104) 评论(0) 推荐(0)
052-49
摘要：View the Exhibit to examine the output of the DBA_OUTSTANDING_ALERTS view. After 30 minutes, you executed the following command:SQL> SELECT reason,met 阅读全文
posted @ 2017-12-07 11:35 巴啦啦大魔王 阅读(80) 评论(0) 推荐(0)
052-48
摘要：The job to gather optimizer statistics for objects runs as part of the automatic maintenance window in your database instance. At a certain point of t 阅读全文
posted @ 2017-12-07 11:26 巴啦啦大魔王 阅读(92) 评论(0) 推荐(0)
052-47
摘要：Your database instance is functional for the past one month. The Automatic Workload Repository(AWR) snapshot retention is set to 7 and the STATISTICS_ 阅读全文
posted @ 2017-12-07 11:16 巴啦啦大魔王 阅读(95) 评论(0) 推荐(0)
052-46
摘要：Which two statements are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose two.)A.The ADDM requires at least four AWR snapshots for 阅读全文
posted @ 2017-12-07 11:06 巴啦啦大魔王 阅读(96) 评论(0) 推荐(0)
052-45
摘要：Which statement is true about the Manageability Monitor (MMON) background process?A.It transfers statistics from memory to disk at regular intervals.B 阅读全文
posted @ 2017-12-07 10:58 巴啦啦大魔王 阅读(76) 评论(0) 推荐(0)
052-44
摘要：Your database is functional with a peak load for the last one hour. You want to preserve the performance statistics collected during this period to be 阅读全文
posted @ 2017-12-07 10:53 巴啦啦大魔王 阅读(91) 评论(0) 推荐(0)
052-43
摘要：In your database instance, the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the impact of this setting?A.Optimizer statistics ar 阅读全文
posted @ 2017-12-07 10:48 巴啦啦大魔王 阅读(92) 评论(0) 推荐(0)
052-42
摘要：Examine the command:SQL> DBMS_STATS.SET_TABLE_PREFS('SH', 'CUSTOMERS', 'PUBLISH', 'false');Which statement describes the effect of the above command?A 阅读全文
posted @ 2017-12-07 10:44 巴啦啦大魔王 阅读(107) 评论(0) 推荐(0)
052-41
摘要：You have recently collected statistics on certain objects of a schema in your database. But you observe suboptimal execution plans for the queries on 阅读全文
posted @ 2017-12-07 10:22 巴啦啦大魔王 阅读(94) 评论(0) 推荐(0)
证明log X < X 对于所有的X > 0成立
摘要：如果 如果X = 1 logX = 0 -> 0 < 1 命题成立 否则 logX < 0 而 X > 0 所以 命题成立 如果 1 < X < 2 logX < 1 命题成立 如果 X = 2 logX = 1 < 2 命题成立 归纳基础：1< X ≤ 2 时命题成立，由上可知。 归纳假设：假设命 阅读全文
posted @ 2017-12-06 16:42 巴啦啦大魔王 阅读(804) 评论(0) 推荐(1)
学习笔记-级数
摘要：1.无穷级数到底在研究什么？ 2.正项级数及根据定义判别正项级数是否收敛？ 3.正项级数的比较判别法 级数是指将数列 的项 ， ，…， ，…依次用加号连接起来的函数，是数项级数的简称。如： ，简写为 ， 称为级数的通项，记 称之为级数的部分和。如果当 时 ，数列Sn有极限,极限为S，则说级数收敛，并 阅读全文
posted @ 2017-12-05 16:54 巴啦啦大魔王 阅读(958) 评论(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 巴啦啦大魔王 阅读(88) 评论(0) 推荐(0)
052-38
摘要：To make audit information more productive, the DBA executes the following command before starting an audit operation:SQL> ALTER SYSTEM SET AUDIT_TRAIL 阅读全文
posted @ 2017-12-05 16:39 巴啦啦大魔王 阅读(80) 评论(0) 推荐(0)
052-37
摘要：You execute the following command to audit database activities:SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL;What is the effect of 阅读全文
posted @ 2017-12-05 16:30 巴啦啦大魔王 阅读(98) 评论(0) 推荐(0)
052-36
摘要：In your production database, data manipulation language (DML) operations are executed on the SALES table. You have noticed some dubious values in the 阅读全文
posted @ 2017-12-05 15:51 巴啦啦大魔王 阅读(104) 评论(0) 推荐(0)
052-34
摘要：A user, who is authenticated externally, logs in to a remote machine and connects to the databaseinstance. What action would you take to ensure that a 阅读全文
posted @ 2017-12-05 15:16 巴啦啦大魔王 阅读(129) 评论(0) 推荐(0)
052-33
摘要：Some non-DBA users in your database have been granted ANY TABLE system privileges and theyare able to access data dictionary base tables. You decide t 阅读全文
posted @ 2017-12-05 15:12 巴啦啦大魔王 阅读(130) 评论(0) 推荐(0)
052-32
摘要：Your database instance is running with full workload after database creation. You have decided to use a fixed-size undo tablespace. You want to use th 阅读全文
posted @ 2017-12-05 15:04 巴啦啦大魔王 阅读(103) 评论(0) 推荐(0)
052-31
摘要：Which statement is true about the UNDO_RETENTION parameter when retention guarantee is not enabled?A.It is the time period after which the undo data b 阅读全文
posted @ 2017-12-05 14:58 巴啦啦大魔王 阅读(76) 评论(0) 推荐(0)
052-30
摘要：In which situation may the UNDO_RETENTION parameter be ignored, even if it is set to a value?A. When the data file of the undo tablespace is autoexten 阅读全文
posted @ 2017-12-05 14:48 巴啦啦大魔王 阅读(106) 评论(0) 推荐(0)
052-28
摘要：View the Exhibit and examine the undo tablespace attributes. Your database instance is experiencing a large volume of transactions from non-DBA users 阅读全文
posted @ 2017-12-05 14:41 巴啦啦大魔王 阅读(79) 评论(0) 推荐(0)
052-26
摘要：Which two statements are true regarding undo tablespaces? (Choose two.)A.The database can have more than one undo tablespace.B.The UNDO_TABLESPACE par 阅读全文
posted @ 2017-12-05 14:35 巴啦啦大魔王 阅读(105) 评论(0) 推荐(0)
052-25
摘要：Which three operations require undo data? (Choose three.)A.committing a transactionB.flashing back a transaction – 回退操作C.recovering a failed transacti 阅读全文
posted @ 2017-12-05 14:32 巴啦啦大魔王 阅读(95) 评论(0) 推荐(0)
052-24
摘要：Which two statements correctly describe the relation between a data file and the logical databasestructures? (Choose two.)A.An extent cannot spread ac 阅读全文
posted @ 2017-12-05 14:28 巴啦啦大魔王 阅读(132) 评论(0) 推荐(0)
oracle 检查字符中数据类型 函数&存储过程
摘要：dump函数用来判断字符串中的字符类型是属于number或者string 存储过程 函数 阅读全文
posted @ 2017-12-04 17:19 巴啦啦大魔王 阅读(1326) 评论(0) 推荐(0)
052-22
摘要：Identify the logical structure that will never have more than one data segment created for it.A.external tableB.partitioned tableC.partitioned indexD. 阅读全文
posted @ 2017-12-01 16:44 巴啦啦大魔王 阅读(115) 评论(0) 推荐(0)
052-20
摘要：You have set Tablespace Full Metrics Threshold values for the USERS tablespace as follows:Warning (%): 90Critical (%): 95Which background process is r 阅读全文
posted @ 2017-12-01 16:06 巴啦啦大魔王 阅读(111) 评论(0) 推荐(0)
052-16&17
摘要：16.Note the following functionalities of various background processes:1: Record the checkpoint information in data file headers.--CKPT2: Perform recov 阅读全文
posted @ 2017-12-01 14:23 巴啦啦大魔王 阅读(205) 评论(0) 推荐(0)
052-15
摘要：Which two statements are true about Shared SQL Area and Private SQL Area? (Choose two.)A. Shared SQL Area will be allocated in the shared poolB. Share 阅读全文
posted @ 2017-12-01 13:31 巴啦啦大魔王 阅读(112) 评论(0) 推荐(0)
052-14
摘要：These are points that describe the contents of different memory components:1: Descriptive information or metadata about schema objects that are querie 阅读全文
posted @ 2017-12-01 13:13 巴啦啦大魔王 阅读(145) 评论(0) 推荐(0)
052-13
摘要：You have executed this command to change the size of the database buffer cache:SQL> ALTER SYSTEM SET DB_CACHE_SIZE=2516582;System altered.To verify th 阅读全文
posted @ 2017-12-01 12:07 巴啦啦大魔王 阅读(128) 评论(0) 推荐(0)
052-12
摘要：Which is the correct description of a pinned buffer in the database buffer cache?A. The buffer is currently being accessedB. The buffer is empty and h 阅读全文
posted @ 2017-12-01 11:34 巴啦啦大魔王 阅读(130) 评论(0) 推荐(0)
052-11
摘要：Identify the memory component from which memory may be allocated for:1: Session memory for the shared server2: Buffers for I/O slaves3: Oracle Databas 阅读全文
posted @ 2017-12-01 11:27 巴啦啦大魔王 阅读(129) 评论(0) 推荐(0)
052-10
摘要：Examine the following statement that is used to modify the primary key constraint on the SALES table:SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISAB 阅读全文
posted @ 2017-12-01 11:23 巴啦啦大魔王 阅读(118) 评论(0) 推荐(0)
052-9
摘要：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 followin 阅读全文
posted @ 2017-12-01 11:06 巴啦啦大魔王 阅读(114) 评论(0) 推荐(0)
052-8
摘要：Observe the information in the columns:1. The SGA2. The cursor state3. User-session data4. The stack spacea. Text and parsed forms of all SQL statemen 阅读全文
posted @ 2017-12-01 10:57 巴啦啦大魔王 阅读(180) 评论(0) 推荐(0)
052-6
摘要：Note the following points describing various utilities in Oracle Database 11g:1. It enables the transfer of data from one database to another--数据泵(ben 阅读全文
posted @ 2017-12-01 10:40 巴啦啦大魔王 阅读(163) 评论(0) 推荐(0)
052-5
摘要：The database instance is currently using SPFILE. View the Exhibit and examine the error that you received while running the DB Structure Integrity che 阅读全文
posted @ 2017-12-01 10:13 巴啦啦大魔王 阅读(135) 评论(0) 推荐(0)
052-3
摘要：While observing the index statistics, you find that an index is highly fragmented, thereby resulting in poor database performance. Which option would 阅读全文
posted @ 2017-12-01 09:55 巴啦啦大魔王 阅读(164) 评论(0) 推荐(0)