OCSecA 1Z0-053 Oracle

www.it-pruefungen.ch hilft Ihnen mit hochwertigenUnterlagen und Software, die Fragen und Antworten Zertifizierungsprüfung zu bestehen. Mit Hilfe der www.it-pruefungen.ch sind Sie sicher, die Zertifizierung mit einem hohen Punkt zu bestehen und den Erfolg im IT-Bereich erobern.

1Z0-053 Oracle Database 11g: Administration II Vorbereitung für IT-Prüfung hat eine Reihe von spezialisierten Zertifizierungsprüfung im Zusammenhang mit einem bestimmten Gebiet, und so ist die Wahl der richtigen Training Produkt ist sehr wichtig.

OCSecA 1Z0-053 Oracle

QUESTION 1
Examine the following command used to perform incremental level 0 backup:

RMAN> BACKUP INCREMENTAL LEVEL 0 DATABASE;

To enable the block change tracking, after the incremental level 0 backup you issued the following command:

SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE ‘/mydir/
rman_change_track.f’;

To perform incremental level 1 cumulative backup, you issued the following command:

RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;

Which two statements are true in the above situation? (Choose two.)

A. The block change tracking data will be used only from the next incremental 0 backup.
B. The incremental backup will use change tracking data for accomplishing the backup.
C. The incremental backup will not use change tracking data for accomplishing the backup.
D. The block track file will scan all the blocks and create bitmap for all the blocks backed up in the level 0
backup.

Answer: AC
Section: Backup, Recovery & Recovery Manager (RMAN)

Explanation/Reference:
Section: Backup, Recovery & Recovery Manager (RMAN)

http://www.pythian.com/documents/Pythian-oracle-block-change.pdf After enabling change tracking, the first level 0 incremental backup still has to scan the entire datafile, as the change tracking file does not yet reflect the status of the blocks. Subsequent incremental backup that use this level 0 as parent will take advantage of the change tracking file. When some a chunk needs to be marked dirty for the first time after incremental backup, version information in bitmap extent headers (X$KRCFBH) is initialized – XFLAGS is set to 2, CURR_VERCNT and CURR_VERTIME
filled from datafile descriptor. If file had no changes since last incremental backup – nothing is written to the bitmap. There is no difference in handling different backup levels. Version is created in the same way whether its level 0, level 1 or level 4 backup. By the way, it seems that Oracle 10g documentation officially mentions only support for levels 0 and 1. However, I checked incremental backup levels up to 4 and they do work (10.2.0.2). Oracle Press 1Z1-053 Exam Guide, Chapter 4: Creating RMAN Backups The first incremental level 0 backup reads every block in the datafile, and subsequent incremental level 1 backups use the block change tracking file. No reference to create bitmap found. http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192/bkup004.htm#i1032148

RMAN’s change tracking feature for incremental backups improves incremental backup performance by recording changed blocks in each datafile in a change tracking file. If change tracking is enabled, RMAN uses the change tracking file to identify changed blocks for incremental backup, thus avoiding the need to scan every block in the datafile. Using change tracking in no way changes the commands used to pe form incremental backups, and the change tracking files themselves generally require little maintenance after initial configuration.

QUESTION 2
You want to use the automatic management of backup and recovery operations features for your database.

Which configuration must you set?

A. Enable the flash recovery area and specify it as the archived redo log destination.
B. Disable the flash recovery area and start the database instance in ARCHIVELOG mode.
C. Enable the flash recovery area but do not specify it as the archived redo log destination.
D. Disable the flash recovery area and start the database instance in NOARCHIVELOG mode.

Answer: A

QUESTION 3
Which three types of files can be automatically placed in the flash recovery area (fast recovery area in 11g Release 2)? (Choose three.)

A. Alert log file
B. Archived redo log files
C. Control file autobackups
D. Server Parameter file (SPFILE)
E. Recovery Manager (RMAN) backup piece

Answer: BCE

OCSecA 1Z0-053 Oracle

OCSecA 1Z0-052 Oracle

www.it-pruefungen.ch hilft Ihnen mit hochwertigenUnterlagen und Software, die Fragen und Antworten Zertifizierungsprüfung zu bestehen. Mit Hilfe der www.it-pruefungen.ch sind Sie sicher, die Zertifizierung mit einem hohen Punkt zu bestehen und den Erfolg im IT-Bereich erobern.

1Z0-052 Oracle Database 11g: Administrator I Vorbereitung für IT-Prüfung hat eine Reihe von spezialisierten Zertifizierungsprüfung im Zusammenhang mit einem bestimmten Gebiet, und so ist die Wahl der richtigen Training Produkt ist sehr wichtig.

OCSecA 1Z0-052 Oracle

QUESTION NO: 1
Your database instance is currently configured to support 1,500 connections. The Web application that uses the database allows a large number of users to work with the database simultaneously.
Some users of the Web application do not interact with the server all the time. You want to
increase the scalability by configuring the database instance to handle more connections. As a DBA, which configuration would you set to support more than 1,500 connections at a time?

A. You would configure more listeners for the database.
B. You would configure the database in shared server mode to use the connection pooling feature.
C. You would increase the value of the PGA_AGGREGATE_TARGET initialization parameter that assigns more session memory to users.
D. You would decrease the value of the PRIVATE_SGA resource limit in the profiles used by the users to accommodate more session information.

Answer: B

QUESTION NO: 2
Which two statements describe good practices for an application developer to reduce locking conflicts in Oracle database? (Choose two.)

A. Avoid coding unnecessary longrunning transactions.
B. Allow the database to handle locks in default locking mode.
C. Always explicitly code the locks as per the requirement of the application.
D. Allow escalation of row locks to block locks if too many row locks cause problem.

Answer: A,B

QUESTION NO: 3
These are points that describe the contents of different memory components:
1: Descriptive information or metadata about schema objects that are queried by using SQL statements
2: The runtime area for data manipulation language (DML) or data definition language (DDL) statements
3: Results of SQL queries and PL/SQL functions
4: Executable forms of SQL cursors, PL/SQL programs, and Java classes
5: The information necessary to reconstruct changes made to the database by a transaction
Which of these will be stored in the Shared Pool if the necessary configurations are done?

A. 1 and 2
B. 2 and 5
C. 1,3, and 4
D. 3,4 and 5
E. 1,2,3 and 4

Answer: C

OCSecA 1Z0-052 Oracle

OCSecA 1Z0-051 Oracle

www.it-pruefungen.ch hilft Ihnen mit hochwertigenUnterlagen und Software, die Fragen und Antworten Zertifizierungsprüfung zu bestehen. Mit Hilfe der www.it-pruefungen.ch sind Sie sicher, die Zertifizierung mit einem hohen Punkt zu bestehen und den Erfolg im IT-Bereich erobern.

1Z0-051 Oracle Database: SQL Fundamentals I Vorbereitung für IT-Prüfung hat eine Reihe von spezialisierten Zertifizierungsprüfung im Zusammenhang mit einem bestimmten Gebiet, und so ist die Wahl der richtigen Training Produkt ist sehr wichtig.

OCSecA 1Z0-051 Oracle

QUESTION 1
View the Exhibit and examine the data in the

The PROJ_TASK_DETAILS table stores information about tasks involved in a project and the relation between them.
The BASED_ON column indicates dependencies between tasks. Some tasks do not depend on the completion of any other tasks.

You need to generate a report showing all task IDs, the corresponding task ID they are dependent on, and the name of the employee in charge of the task it depends on.

Which query would give the required result?

A. SELECT p.task_id, p.based_on, d.task_in_charge
FROM proj_task_details p JOIN proj_task_details d
ON (p.based_on = d.task_id);
B. SELECT p.task_id, p.based_on, d.task_in_charge
FROM proj_task_details p LEFT OUTER JOIN proj_task_details d ON (p.based_on = d.task_id);
C. SELECT p.task_id, p.based_on, d.task_in_charge
FROM proj_task_details p FULL OUTER JOIN proj_task_details d ON (p.based_on = d.task_id);
D. SELECT p.task_id, p.based_on, d.task_in_charge
FROM proj_task_details p JOIN proj_task_details d
ON (p.task_id = d.task_id);

Answer: B

QUESTION 2
Which two statements are true regarding subqueries? (Choose two.)

A. A subquery can retrieve zero or more rows.
B. Only two subqueries can be placed at one level.
C. A subquery can be used only in SQL query statements.
D. A subquery can appear on either side of a comparison operator.
E. There is no limit on the number of subquery levels in the WHERE clause of a SELECT statement.

Answer: AD

OCSecA 1Z0-051 Oracle

OCSecA 1Z0-047 Oracle

www.it-pruefungen.ch hilft Ihnen mit hochwertigenUnterlagen und Software, die Fragen und Antworten Zertifizierungsprüfung zu bestehen. Mit Hilfe der www.it-pruefungen.ch sind Sie sicher, die Zertifizierung mit einem hohen Punkt zu bestehen und den Erfolg im IT-Bereich erobern.

1Z0-047 Oracle Database SQL Expert Vorbereitung für IT-Prüfung hat eine Reihe von spezialisierten Zertifizierungsprüfung im Zusammenhang mit einem bestimmten Gebiet, und so ist die Wahl der richtigen Training Produkt ist sehr wichtig.

OCSecA 1Z0-047 Oracle

1.Which two statements are true regarding the types of table joins available in Oracle Database
10g? (Choose two.)
A.You can use the JOIN clause to join only two tables.
B.You can explicitly provide the join condition with a NATURAL JOIN.
C.You can use the USING clause to join tables on more than one column.
D.You can use the ON clause to specify multiple conditions while joining tables.
Correct:C D

2.Which two statements are true regarding subqueries? (Choose two.)
A.The ORDER BY clause can be used in the subquery.
B.A subquery can be used in the FROM clause of a SELECT statement.
C.If the subquery returns NULL, the main query may still return result rows.
D.A subquery can be placed in a WHERE clause, GROUP BY clause, or a HAVING clause.
E.Logical operators, such as AND, OR and NOT, cannot be used in the WHERE clause of a subquery.
Correct:A B

3.Evaluate the following SQL statements in the given order: DROP TABLE dept; CREATE TABLE dept (deptno NUMBER(3) PRIMARY KEY, deptname VARCHAR2(10)); DROP TABLE dept; FLASHBACK TABLE dept TO BEFORE DROP; Which statement is true regarding the above FLASHBACK operation?
A.It recovers only the first DEPT table.
B.It recovers only the second DEPT table.
C.It does not recover any of the tables because FLASHBACK is not possible in this case.
D.It recovers both the tables but the names would be changed to the ones assigned in the RECYCLEBIN.
Correct:B

4.Given below is a list of functions and their purpose in random order. Function Purpose 1)NVL
a) Used for evaluating NOT NULL and NULL values 2)NULLIF b) Used to return the first non- null values in a list of expressions 3)COALESCE c) Used to compare two expressions. If both are same,
it returns NULL; otherwise, it returns only the first expression. 4)NVL2 d) Used to convert NULL
values to actual values Identify the correct combination of functions and their usage.
A.1-a, 2-c, 3-b, 4-d B.1-d, 2-c, 3-b, 4-a C.1-b, 2-c, 3-d, 4-a D.1-d, 2-b, 3-c, 4-a Correct:B

OCSecA 1Z0-047 Oracle