- 博客(974)
- 资源 (40)
- 收藏
- 关注
翻译 ocp-508
QUESTION NO: 508 You need to configure fine-grained access control to external network resources from within your database. You create an access control list (ACL) using the DBMS_NETWORK_ACL_ADMIN p
2015-10-19 08:38:13 1009
翻译 ocp-507
QUESTION NO: 507 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 an Oracle Database version 10.1
2015-10-19 08:38:01 841
翻译 ocp-506
QUESTION NO: 506 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 : R
2015-10-19 08:37:47 761
翻译 ocp-505
QUESTION NO: 505 Which three components does the Scheduler use for managing tasks within the Oracle environment? (Choose three.) A. a job B. a program C. a schedule D. a PL/SQL procedure Answer:
2015-10-19 08:37:33 750
翻译 ocp-504
QUESTION NO: 504Your 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 database, you receive the following erro
2015-10-19 08:37:19 715
翻译 ocp-503
QUESTION NO: 503 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 con
2015-10-19 08:37:06 787
翻译 ocp-502
QUESTION NO: 502 While deploying a new application module, the software vendor ships the application software along with appropriate SQL plan baselines for the new SQLs being introduced. Which two st
2015-10-19 08:36:53 1029
翻译 ocp-501
QUESTION NO: 501 The following databases are registered in the base recovery catalog: PROD1, PROD2, and PROD3. The database user CATOWNER owns the base recovery catalog. You want a new user VPC1 to h
2015-10-19 08:36:38 960
翻译 ocp-500
QUESTION NO: 500 In your database, the LDAP_DIRECTORY_SYSAUTH initialization parameter has been set to YES and the users who need to access the database as DBAs have been granted SYSDBA enterprise ro
2015-10-19 08:35:33 1089
翻译 ocp-499
QUESTION NO: 499 While tuning a SQL statement, the SQL Tuning Advisor finds an existing SQL profile for the statement that has stale statistics available. What would the optimizer do in this situatio
2015-10-18 16:06:44 1219
翻译 ocp-498
QUESTION NO: 498? View the Exhibit for some of the parameter settings. You start a session and issue the following command: SQL>CREATE INDEX emp_ename ON emp(ename) TABLESPACE users INVISIBLE; Wha
2015-10-18 16:06:32 1102
翻译 ocp-497
QUESTION NO: 497 You perform the following activities during the database upgrade from Oracle Database 10g to Oracle Database 11g: 1. Capture plans for a SQL workload into a SQL Tuning Set (STS) be
2015-10-18 16:05:53 1606
翻译 ocp-496
QUESTION NO: 496 Which statement about using RMAN stored scripts is true? A. To create and execute an RMAN stored script, you must use a recovery catalog. B. When executing a stored script and a c
2015-10-18 16:05:38 1078
翻译 ocp-495
QUESTION NO: 495Which tuning tool recommends how to optimize materialized views so that these views can take advantage of the general query rewrite feature? A. Segment Advisor B. SQL Access Advisor
2015-10-18 16:05:27 1031
翻译 ocp-494
QUESTION NO: 494 Observe the following warning in an RMAN session of your database instance: WARNING: new failures were found since last LIST FAILURE command Which statement describes the scenario t
2015-10-18 16:05:13 1110
翻译 ocp-493
QUESTION NO: 493 You decided to use Direct NFS configuration in a non-RAC Oracle installation and created the oranfstab file in /etc. Which two statements are true regarding this oranfstab file? (Cho
2015-10-18 16:04:59 1837
翻译 ocp-492
QUESTION NO: 492 ENCRYPT_TS is an encrypted tablespace that contains tables with data. Which statement is true regarding the effect of queries and data manipulation language (DML) statements on the e
2015-10-18 16:04:46 1133
翻译 ocp-491
QUESTION NO: 491What are the recommendations for Oracle Database 11g installation to make it Optimal Flexible Architecture (OFA)-compliant? (Choose all that apply.) A. ORACLE_BASE should be set expl
2015-10-18 16:04:22 1798
翻译 ocp-490
QUESTION NO: 490 You are managing the APPPROD database as a DBA which is not using the Oracle-managed files. You plan to duplicate this database in the same system with the name DUPDB.You want to cre
2015-10-18 16:00:33 1392
翻译 ocp-489
QUESTION NO: 489 You are maintaining the SALES database. You have added a new disk to a disk group. Automatic Storage Management performs the rebalancing activity. You want to speed up the rebalancin
2015-10-18 16:00:17 1129
翻译 ocp-488
QUESTION NO: 488 Evaluate the following command: SQL> CREATE TABLE design_data (id NUMBER,doc CLOB) LOB(doc) STORE AS SECUREFILE(DEDUPLICATE) ; Which statement is true regarding the above command?
2015-10-18 15:59:54 1866
翻译 ocp-487
QUESTION NO: 487 The Oracle Database 11g database is running in the ARCHIVELOG mode. The archived redo log files are stored on three locations. The Flash Recovery Area is one of the locations. The de
2015-10-18 15:59:41 842
翻译 ocp-486
QUESTION NO: 486 View the Exhibit to examine the error while executing the REPAIR FAILURE command in an RMAN session. What is the reason for this error?A. Another repair session is running concurre
2015-10-18 15:59:27 1334
翻译 ocp-485
QUESTION NO: 485 Evaluate the following SQL statement used to create the PRODUCTS table:CREATE TABLE products (product_id NUMBER(3) PRIMARY KEY, product_desc VARCHAR2(25), qty NUMBER(8,2), rate NUM
2015-10-18 15:59:12 1588 1
翻译 ocp-484
QUESTION NO: 484 You set the following parameters in the parameter file and restarted the database: MEMORY_MAX_TARGET=0 MEMORY_TARGET=500M PGA_AGGREGATE_TARGET=90M SGA_TARGET=270M Which two stateme
2015-10-18 15:58:57 961
翻译 ocp-483
QUESTION NO: 483 You are managing an Oracle 11g database with ASM storage, for which the COMPATIBLE initialization parameter is set to 11.1.0. In the ASM instance, the COMPATIBLE.RDBMS attribute for
2015-10-18 15:58:41 1405
翻译 ocp-482
QUESTION NO: 482 You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the databa
2015-10-18 15:58:06 692
翻译 ocp-481
QUESTION NO: 481 View the Exhibit to examine the replay settings for replay parameters. What is the implication for setting the values for replay parameters? (Choose all that apply.) A. The COMMIT
2015-10-18 15:57:31 916
翻译 ocp-480
QUESTION NO: 480 Identify the activities performed as part of the Automatic SQL Tuning process in the maintenance window? (Choose all that apply.) A. generating the SQL profile B. testing and acce
2015-10-18 09:43:29 1387
翻译 ocp-479
QUESTION NO: 479 You issued the following command: CREATE GLOBAL TEMPORARY TABLE admin_work_area (startdate DATE, enddate DATE, class CHAR(20)) ON COMMIT DELETE ROWS TABLESPACE tbs_t1; An index
2015-10-18 09:43:11 882
翻译 ocp-478
QUESTION NO: 478 The BOOKINGS table contains online booking information. When a booking is confirmed, the details are transferred to an archival table BOOKINGS_HIST and deleted from the BOOKINGS tabl
2015-10-18 09:42:54 801
翻译 ocp-477
QUESTION NO: 477 The following command is executed to create the baseline template: SQL> EXECUTE DBMS_WORKLOAD_REPOSITORY.CREATE_BASELINE_TEMPLATE(START_TIME=> TO_TIMESTAMP(SYSDATE+2),END_TIME=>T
2015-10-18 09:42:40 899
翻译 ocp-476
QUESTION NO: 476 You have enabled resumable space allocation in your database by setting the RESUMABLE_TIMEOUT parameter set to a nonzero value. Which three statements about resumable space allocat
2015-10-18 09:42:25 1535
翻译 ocp-475
QUESTION NO: 475 The SQL Tuning Advisor has been configured with default configurations in your database instance. Which recommendation is automatically implemented without the DBA’s intervention aft
2015-10-18 09:42:08 1111
翻译 ocp-474
QUESTION NO: 474 Which statements are true regarding the system-defined moving window baseline in Oracle Database 11g? (Choose all that apply.) A. It does not allow you to change the moving window
2015-10-18 09:41:49 830
翻译 ocp-473
QUESTION NO: 473 You issue the following RMAN command to set a retention policy on a database: RMAN>CONFIGURE RETENTION POLICY TO REDUNDANCY 2; What will be the outcome of issuing this command? A. A
2015-10-18 09:41:35 692
翻译 ocp-472
QUESTION NO: 472 Examine the output of the query that you executed to list the objects in the recycle bin: You verified that no table named SALES_TAB exists in the schema. Then you executed the foll
2015-10-18 09:41:21 799
翻译 ocp-471
QUESTION NO: 471? Which tasks are run automatically as part of the Automated Maintenance Task by default? (Choose all that apply.) A. Segment Advisor B. SQL Access Advisor C. Optimizer statistics
2015-10-18 09:40:59 705
翻译 ocp-470
QUESTION NO: 470 Examine the following set of RMAN commands: RMAN> CONFIGURE CHANNEL dc1 DEVICE TYPE DISK FORMAT . /u02 /backup/ %U’ ,” RMAN> RUN ( ALLOCATE CHANNEL Chi DEVICE TYPE DISK; EXECUTE S
2015-10-18 09:40:20 788
翻译 ocp-469
QUESTION NO: 469 You are using Recovery Manager (RMAN) for backup and recovery operations with a recovery catalog. You have been taken database backups every evening. On November 15, 2007, at 11:30 A
2015-10-18 09:40:03 722
华为云架构师H13_821考试资料独一份带备注的
2020-11-03
oa-ecology帮助文件
2013-05-04
网页特效代码集锦很多很炫效果
2010-07-23
.NET数据库通用接口SQLSERVER和ORACLE
2009-12-19
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人