as2

QUESTION 551
To control the execution of a server process when it is receiving bad packets from a potentially malicious client, you set the SEC_PROTOCOL_ERROR_FURTHER_ACTION initialization parameter as follows:
SQL> ALTER SYSTEM SET SEC_PROTOCOL_ERROR_FURTHER_ACTION = Drop,10;
What is the significance of this setting?

QUESTION 527
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. You realize that the flash recovery area is (jetting filled up very fast and it is running out of space. Your database flash recovery area is low on specie
and you have no more room on disk.
Proactively, which two options could you use to make more space available in the flash recovery [Choose two]

QUESTION 549
Which statement about recovering from the loss of a redo log group is true?

QUESTION 573
You are using Recovery Manager (RMAN) to perform backups. In which three situations would you perform a compressed backup? (Choose three.)

QUESTION 559
You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature. Which statement should you use to enable the block change tracking feature?

QUESTION 543
View the following SQL statements:

Transaction T1 INSERT INTO hr.regions VALUES (5,'Pole');

COMMIT;

Transaction T2 UPDATE hr.regions SET region_name='Poles' WHERE region_id = 5; COMMIT;

Transaction T3 UPDATE hr.regions SET region_name='North and South Poles' WHERE region_id = 5;

You want to back out transaction T2. Which option would you use?

QUESTION 544
You have a very large table that your users access frequently. Which of the following advisors will recommend any indexes to improve the performance of queries against this table?

QUESTION 550
Examine the following command:
ALTER DISKGROUP data MOUNT FORCE;
In which scenario can you use the above command to mount the disk group?

QUESTION 556
You discover that your Recycle Bin contains two tables with the same name, MY_TABLE. You also have a table named MY_TABLE in your schema. You execute the following statement:
FLASHBACK TABLE my_table TO BEFORE DROP RENAME TO my_table2;
What will be the result of executing this statement?

QUESTION 545
What is the advantage of setting the ASM-preferred mirror read for the Stretch cluster configuration?

QUESTION 553
You want to use RMAN to create compressed backups.
Which statement is true about the compression algorithms that RMAN can use?

QUESTION 538
The SQL Tuning Advisor configuration has default settings in your database instance. Which recommendation is automatically implemented after the SQL Tuning Advisor is run as part of the automatic maintenance task?

QUESTION 562
You want to convert your existing non-ASM files to ASM files for the database PROD. Which method or command would you use to accomplish this task?

QUESTION 531
Which two statements are correct about database transportation? (Choose two.)

QUESTION 567
On which two database objects can the VERSIONS clause of the Flashback Versions Query be used? (Choose two.)

QUESTION 557
Which background process of a database instance, using Automatic Storage Management (ASM), connects as a foreground process into the ASM instance?

QUESTION 540
Evaluate the following code:
SQL>VARIABLE task_name VARCHAR2(255); SQL>VARIABLE sql_stmt VARCHAR2(4000); SQL>BEGIN :
sql_stmt := 'SELECT COUNT(*) FROM customers
WHERE cust_state_province =''CA''';
:task_name := 'MY_QUICKTUNE_TASK';
DBMS_ADVISOR.QUICK_TUNE(DBMS_ADVISOR.SQLACCESS_ADVISOR,
:task_name, :sql_stmt);
END;
What is the outcome of this block of code?

QUESTION 569
The EMP table exists in your schema. You want to execute the following query:
SELECT ename, sal FROM emp AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '6' MINUTE) WHERE
ename = 'ALLEN';
What are the minimum requirements for the statement to execute successfully? (Choose all that apply)

QUESTION 530
Which two statements are true with respect to the maintenance window? (Choose two.)

QUESTION 546
What happens when you run the SQL Tuning Advisor with limited scope?

QUESTION 558
Which statement is true when Automatic Workload Repository (AWR) baselines are created using baseline templates?

QUESTION 536
Which two statements are true regarding the functionality of the remap command in ASMCMD?
(Choose two.)

QUESTION 533
You want to perform the following operations for the DATA ASM disk group:
-Verify the consistency of the disk. -Cross-check all the file extent maps and allocation tables for consistency. -
Check whether the alias metadata directory and file directory are linked correctly. -Check that ASM metadata directories do not have unreachable allocated blocks.
Which command accomplishes these tasks?

QUESTION 534
Examine the following RMAN command:
BACKUP DATABASE
TAG TESTDB
KEEP UNTIL 'SYSDATE+1'
RESTORE POINT TESTDB06;Which two statements are true regarding the backup taken by using the above RMAN command? (Choose two.)

QUESTION 571
The Automatic Database Diagnostic Monitor (ADDM) analysis runs every 60 minutes on your database. Your database is facing a series of interrelated problems over a period of two hours. You need to ensure that the ADDM analysis is run over a time span of two hours in future. What would you do?

QUESTION 566
Which two initialization parameters would you set to enable Automatic Shared Memory Management? (Choose two.)

QUESTION 572
You have 100 segments in the USERS tablespace. You realize that the USERS tablespace is running low on space.
You can use Segment Advisor to _____.

QUESTION 529
Which two statements are true regarding the Automatic Diagnostic Repository (ADR) in Oracle Database 11g?
(Choose two.)

QUESTION 554
Evaluate the following function code:
CREATE FUNCTION get_dept_avg(dept_id NUMBER) RETURN NUMBER RESULT_CACHE RELIES_ON
(EMPLOYEES) IS avgsal NUMBER(6);
BEGIN
SELECT AVG(SALARY)INTO avgsal
FROM EMPLOYEES
WHERE DEPARTMENT_ID = dept_id;
RETURN avgsal;
END get_dept_avg;
Which statement is true regarding the above function?

QUESTION 565
An online tablespace, TEST_TBS, is full and you realize that no server-managed tablespace threshold alerts were generated for the TEST_TBS tablespace. What could be the reason, if the TEST_TBS tablespace does not include autoextensible data files?

QUESTION 560
For which two situations would you use functionality provided by the Resource Manager? (Choose two.)

QUESTION 535
You want the Automatic SQL Tuning process to stop accepting and implementing the recommended SQL profiles automatically. Which action would you perform to achieve this?

QUESTION 552
You have the following requirements in relation to the detection of block corruption for your database instance:
Check for logical self-consistency of data blocks when modified in memory.
Checksums are calculated before and after the block change.
Checks are performed for the lost writes to the physical standby database.
Which method would help you perform the above checks automatically?

QUESTION 564
You performed an incomplete recovery and opened the database with the RESETLOGS option. The LOG_ARCHIVE_FORMAT parameter is set to 'ora_%t_%s_%r.log'. Which statement regarding the archived redo log files, created in an earlier incarnation of the database, is true?

QUESTION 537
During the installation of Oracle Database 11g, you do not set ORACLE_BASE explicitly. You selected theoption to create a database as part of the installation. How would this environment variable setting affect the installation?

QUESTION 570
You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace:
ALTER TABLE employees SHRINK SPACE CASCADE;
Which statement is correct in this scenario?

QUESTION 526
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 catalog schema owned by the user RCAT10.
You want the RMAN to import metadata for database IDs 1423241 and 1423242, registered in RCAT10, into the recovery catalog owned by RCO11. You executed the following commands:
RMAN> CONNECT CATALOG rco11/password@catdb
RMAN> IMPORT CATALOG rcat10/oracle@inst1 NO UNREGISTER;
Which two statements are true regarding the tasks accomplished with these commands? (Choose two.)

QUESTION 555
Following is the list of locations in random order where oranfstab can be placed.
1./etc/mtab
2.$ORACLE_HOME/dbs/oranfstab
3./etc/oranfstab
What is the sequence in which Direct NFS will search the locations?

QUESTION 541
You have applications that have frequently executed queries, and produce small and static result sets.
You configure the sqlnet.ora file in the client machine to set a nonzero value for the
OCI_RESULT_CACHE_MAX_SIZE parameter.
What is the purpose of this configuration?

QUESTION 542
You plan to use SQL Performance Analyzer to analyze the SQL workload. You created a SQL Tuning Set as a part of the workload capturing. What information is captured as part of this process? (Choose all that apply.)

QUESTION 568
You have three temporary tablespace groups named G1, G2, and G3 in your database. You are creating a new temporary tablespace as follows:
CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE '/u1/data/temp1.dbf' SIZE 10M TABLESPACE GROUP '';
Which statement regarding the above command is correct?

QUESTION 528
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 other partitions undergo fewer data manipulations. The preferences for the table are set to their default values. You collect statistics for the table using the following command in regular intervals:
SQL> EXECUTE DBMS_STATS.GATHER_TABLE_STATS('SH','SALES',GRANULARITY=>'GLOBAL');
You need statistics to be collected more quickly. What can you do to achieve this?

QUESTION 548
View the Exhibit to examine the error obtained during the I/O calibration process.
There are no data files on raw devices. What is the reason for this error?
View exhibit

QUESTION 575
View the Exhibit.
As shown in the diagram, in-memory statistics are transferred to the disk at regular intervals. Which background process performs this activity?
View exhibit

QUESTION 563
Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions?

QUESTION 539
View the Exhibit to examine the Automatic SQL Tuning result details. Which action would you suggest for the selected SQL statement in the Exhibit?
View exhibit

QUESTION 561
Which of the following advisors within the Oracle advisory framework will analyze a single SQL statement and make recommendations for performance improvement?

QUESTION 547
You issue the following command on the RMAN prompt.
REPORT NEED BACKUP DAYS 5;
Which statement is true about executing this command?

QUESTION 574
Immediately after adding a new disk to or removing an existing disk from an ASM instance, you find that the performance of the database goes down initially until the time the addition or removal process is completed, and then gradually becomes normal.
Which two activities would you perform to maintain a consistent performance of the database while adding or removing disks? (Choose two.)

QUESTION 532
In your production database, you:
-Are using Recovery Manager (RMAN) with a recovery catalog to perform the backup operation at regularintervals Set the control file autobackup to "on"
-Are maintaining image copies of the database files
You have lost the server parameter tile (SPFILE) and the control file. Which option must you consider before
restoring the SPFILI: and the control file by using the control file autobackup?