OCP解析 - 053
文档搬运工
这个作者很懒,什么都没留下…
展开
-
052试题 10 - RMAN参数optimization / recovery Window
题目:10.Consider the following scenario for your database:-Backup optimization is enabled in RMAN. The recovery window is set to 7 days in RMAN. The mostrecent backup to disk for the TOOLS tablespac...原创 2019-08-08 09:28:51 · 216 阅读 · 0 评论 -
052试题 11 / 13 - Adaptive Thresholds
题目:11.View the Exhibit to examine the metrics with a threshold. Which statement is true regarding theNumber of Transactions (per second) metric?A. Oracle uses statistical relevance to determine w...原创 2019-08-08 09:37:19 · 252 阅读 · 0 评论 -
053试题 12 /133 /236/241 - keep option
题目:12.You performed the RMAN database backup having a backupset key number 231 with the KEEP FOREVER option.After some days, you want to change the status of the database backup and you issued the ...原创 2019-08-08 09:51:21 · 421 阅读 · 0 评论 -
052试题 14 - online patching
题目:14.Which two statements are true regarding hot patching? (Choose two.)A. It requires relinking of the Oracle binary.B. It does not require database instance shutdown.C. It can detect conflicts...原创 2019-08-08 10:15:52 · 228 阅读 · 0 评论 -
052试题 15 - Virtual Private Catalog
题目:15.You are in the process of creating a virtual private catalog in your Oracle Database 11g database. ThePROD1, PROD2, and PROD3 Oracle Database 10g databases are registered in the base recovery...原创 2019-08-08 10:32:49 · 169 阅读 · 0 评论 -
053试题 16 - TSPITR (基于时间点的表空间恢复)
题目:16.Because of a logical corruption in your production database, you wanted to perform Tablespace Pointin Time Recovery (TSPITR). But before you start the recovery, you queried theTS_PITR_OBJECT...原创 2019-08-08 10:43:44 · 189 阅读 · 0 评论 -
053试题 17 - Merging Interval Partitions
题目: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 range (inv_date) interval(numtoyminter...原创 2019-08-08 11:02:21 · 168 阅读 · 0 评论 -
053试题 - 18 DBMS_ADDM
题目:18.You create a new Automatic Database Diagnostic Monitor (ADDM) task:instance_analysis_mode_task. To view the ADDM report, you use the following command:SQL> SELECT dbms_addm.get_report('my...原创 2019-08-08 11:22:45 · 278 阅读 · 0 评论 -
053试题 19 - online redefinition
题目:19.A PL/SQL procedure queries only those columns of a redefined table that were unchanged by theonline table redefinition. What happens to the PL/SQL procedure after the online table redefinitio...原创 2019-08-08 11:31:18 · 212 阅读 · 0 评论 -
053试题 20/690 - Monitoring Oracle Database Resource Manager
题目:20.View the Exhibit and examine the resource consumption details for the current plan in use by thedatabase instance.Which two statements are true based on the output? (Choose two.)Exhibit:...原创 2019-08-08 12:27:13 · 214 阅读 · 0 评论 -
053 试题 1/ 252 / 253 - SQL PLAN Baseline
题目:1.While deploying a new application module, the software vendor ships the application software alongwith appropriate SQL plan baselines for the new SQLs being introduced. Which two statements de...原创 2019-08-07 09:42:51 · 267 阅读 · 0 评论 -
053试题 2 / 223 / 273 - Moving Window Baseline && Computing Threshold Statistics for Baselines
题目:2.You plan to have a larger moving window size for the default system-defined moving window baseline because you want to use the adaptive threshold.Which statement factors in this consideration ...原创 2019-08-07 09:53:15 · 220 阅读 · 0 评论 -
053试题 3 - Clearing a Redo Log File
题目:3.Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which containsone redo member. When you attempt to start the database, you receive the following errors:ORA-0...原创 2019-08-07 10:01:19 · 177 阅读 · 0 评论 -
053试题 5 / 140 - Database Health Monitor
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 : Data Block Integrity Check Mode :REACTIVE Status ...原创 2019-08-07 10:23:44 · 197 阅读 · 0 评论 -
052试题6 / 26 - Importing and Moving a Recovery Catalog
题目:6.You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schemaowned by the user RCO11. The INST1 database contains an Oracle Database version 10.1 catalogsch...原创 2019-08-07 10:37:41 · 230 阅读 · 0 评论 -
053试题 21 / 198 /200 / 289/355/363/650/700 - duplicate database
题目:21.You are managing an Oracle Database 11g instance. You want to create a duplicate database for testing purpose.What are the prerequisites for performing the active database duplication? (Choos...原创 2019-08-09 12:42:33 · 305 阅读 · 0 评论 -
053试题 22 - index invisible
题目:22.An index called ORD_CUSTNAME_IX has been created on the CUSTNAME column in the ORDERS table using the following command:SQL>CREATE INDEX ord_custname_ix ON orders(custname);The ORDERS tab...原创 2019-08-09 12:50:11 · 264 阅读 · 0 评论 -
053试题 23 - dbms_lob.setoptions
题目:23.Which tasks can be accomplished using the DBMS_LOB. SETOPTIONS procedure?A. only encryption and compression settings for all SecureFile LOBsB. only encryption and deduplication settings for ...原创 2019-08-09 12:58:17 · 242 阅读 · 0 评论 -
053试题 24 - Building SQL Test Cases
题目:24.Which of the following information will be gathered by the SQL Test Case Builder for the problems pertaining to SQL-related problems? (Choose all that apply.)A. ADR diagnostic filesB. all th...原创 2019-08-09 13:06:23 · 149 阅读 · 0 评论 -
053试题 25 - flashbak data archive & DDL
题目:25.You enabled Flashback Data Archive on the INVENTORY table. Which DDL operation is supported onthe table after enabling Flashback Data Archive?A. Drop the table.B. Partition the tableC. Tru...原创 2019-08-09 13:17:52 · 241 阅读 · 0 评论 -
053试题 7/483 - DBMS_NETWORK_ACL_ADMIN
题目:7.You need to configure fine-grained access control to external network resources from within yourdatabase. You create an access control list (ACL) using the DBMS_NETWORK_ACL_ADMIN package.Whic...原创 2019-08-07 11:13:30 · 361 阅读 · 0 评论 -
053试题 8 - 在线重定义 迁移basicfile 到 securefile
题目: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 can be done at the table level or partition...原创 2019-08-07 11:28:33 · 380 阅读 · 0 评论 -
053试题 9 - DBMS_SPACE.SPACE_USAGE ,securefiles
题目: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 BasicFile LOB chunks.B. It returns space usag...原创 2019-08-07 12:36:06 · 223 阅读 · 0 评论 -
053试题 105 / 203 / 256- table compression
题目:105.Which statements are true regarding table compression? (Choose all that apply.)A. It saves disk space and reduces memory usage.B. It saves disk space but has no effect on memory usage.C. I...原创 2019-08-19 09:19:58 · 178 阅读 · 0 评论 -
053试题 106 / 128 /130 /138 / 143 - flashback archive & flashback transaction& drop flashback archive
题目:106.You are working as a DBA on the decision support system. There is a business requirement to trackand store all transactions for at least three years for a few tables in the database. Automat...原创 2019-08-19 09:26:57 · 246 阅读 · 0 评论 -
053试题 107 - recovery
题目:107.Which components are needed for successful and most efficient recovery.A. The backup RB3 and the current online redo log filesB. the backup RB2 and the archived redo log files after the log...原创 2019-08-19 09:31:27 · 253 阅读 · 0 评论 -
053试题 108 - md_backup & md_restore
题目:108.You are managing an Oracle Database 11g instance with ASM storage. You lost an ASM disk groupDATA. You have RMAN backup of data as well as ASM metadata backup. You want to re-create themiss...原创 2019-08-19 09:46:03 · 241 阅读 · 0 评论 -
053试题 109 - online redefinition
题目:109.Which statement describes the effect of table redefinition on the triggers attached to the table?A. All triggers on the table are invalidated and are automatically revalidated with the next ...原创 2019-08-19 10:00:56 · 183 阅读 · 0 评论 -
053试题 110 / 276 - Repeating Baseline Template
题目:110.You plan to collect the Automatic Workload Repository (AWR) data every Monday morning for amonth. You want Oracle Database to automatically create a baseline every Monday and remove the old...原创 2019-08-19 10:19:38 · 220 阅读 · 0 评论 -
053试题 27/613/614/635/663 - RMAN & fast recovery area
题目:27.You are using the flash recovery area (fast recovery area in 11g Release 2) to store backup related files in your database.After regular monitoring of space usage in the Mash recovery area. Y...原创 2019-08-09 16:04:27 · 280 阅读 · 0 评论 -
053试题 28 - 分区表收集统计信息
题目:28.You have a range-partitioned table in your database. Each partition in the table contains the sales data for a quarter.The partition related to the current quarter is modified frequently and ...原创 2019-08-09 16:17:35 · 250 阅读 · 0 评论 -
053试题 29/393/397/499/619/665/681 - ADR
题目:29.Which two statements are true regarding the Automatic Diagnostic Repository (ADR) in Oracle Database 11g? (Choose two.)A. A single ADR can support multiple ADR homes for different database in...原创 2019-08-09 16:27:48 · 256 阅读 · 0 评论 -
053试题 30 - Maintenance Window
题目:30.Which two statements are true with respect to the maintenance window? (Choose two.)A. A DBA can enable or disable an individual task in all maintenance windows.B. A DBA cannot change the dur...原创 2019-08-09 16:36:16 · 281 阅读 · 0 评论 -
053试题 31 - Transportation tablespace
题目:31.Which two statements are correct about database transportation? (Choose two.)A. The source and target platforms must be the sameB. Redo logs, control files and temp files are also transporte...原创 2019-08-09 16:50:48 · 229 阅读 · 0 评论 -
053试题 65 - Managing tablespace alerts
题目:65.An online tablespace, TEST_TBS, is full and you realize that no server-managed tablespace thresholdalerts were generated for the TEST_TBS tablespace. What could be the reason, if the TEST_TBS...原创 2019-08-14 09:31:19 · 224 阅读 · 0 评论 -
053试题 66/414/419/674/702 - ASSM内存管理
题目:66.Which two initialization parameters would you set to enable Automatic Shared Memory Management? (Choose two.)A. set SHARED_POOL_SIZE to zeroB. set STATISTICS_LEVEL to BASICC. set SGA_TARGET...原创 2019-08-14 09:38:56 · 251 阅读 · 0 评论 -
053试题 67/380/381/382/384/489/609/648/704 - flashback version query
题目:67.On which two database objects can the VERSIONS clause of the Flashback Versions Query be used? (Choose two.)A. fixed tablesB. heap tablesC. external tablesD. temporary tablesE. Index-Orga...原创 2019-08-14 10:14:46 · 321 阅读 · 0 评论 -
053试题68 / 278/572/699 - 临时表空间组 && 临时表空间
题目:68.You have three temporary tablespace groups named G1, G2, and G3 in your database. You arecreating a new temporary tablespace as follows:CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE '/u1/data/t...原创 2019-08-14 10:22:46 · 340 阅读 · 0 评论 -
053试题 111 / 167/450/451/638/653 - Lightweight Jobs
题目:111.Which three statements are true regarding persistent lightweight jobs? (Choose three.)A. Persistent lightweight jobs modify several tables in the data dictionary to generate a lot of redo.B...原创 2019-08-19 10:34:20 · 222 阅读 · 0 评论 -
053试题 112 - SEC_MAX_FAILED_LOGIN_ATTEMPTS
题目:112.Your database initialization parameter file has the following entry:SEC_MAX_FAILED_LOGIN_ATTEMPTS=3Which statement is true regarding this setting?A. It drops the connection after the speci...原创 2019-08-19 10:40:20 · 363 阅读 · 0 评论