2014 Latest Oracle 1Z0-147 Exam Demo Free Download!

QUESTION 1
What can you do with the DBMS_LOB package?

A.    Use the DBMS_LOB.WRITE procedure to write data to a BFILE.
B.    Use the DBMS_LOB.BFILENAME function to locate an external BFILE.
C.    Use the DBMS_LOB.FILEEXISTS function to find the location of a BFILE.
D.    Use the DBMS_LOB.FILECLOSE procedure to close the file being accessed.

Answer: D

QUESTION 2
Examine this procedure:
CREATE OR REPLACE PROCEDURE ADD_PLAYER (V_ID IN NUMBER, V_LAST_NAME VARCHAR2) IS BEGIN INSERT INTO PLAYER (ID,LAST_NAME) VALUES (V_ID, V_LAST_NAME);
COMMIT;
END;
This procedure must invoke the UPD_BAT_STAT procedure and pass a parameter. Which statement, when added to the above procedure, will successfully invoke the UPD_BAT_STAT procedure?

A.    EXECUTE UPD_BAT_STAT(V_ID);
B.    UPD_BAT_STAT(V_ID);
C.    RUN UPD_BAT_STAT(V_ID);
D.    START UPD_BAT_STAT(V_ID);

Answer: B

QUESTION 3
Which three describe a stored procedure? (Choose three.)

A.    A stored procedure is typically written in SQL.
B.    By default, a stored procedure executes with the privileges of its owner.
C.    A stored procedure has three parts: the specification, the body, and the exception handler part .
D.    A stored procedure is stored in the database and can be shared by a number of programs.
E.    A stored procedure offers some advantages over a standalone SQL statement, such as programmable functionality and compiled code.

Answer: BDE

QUESTION 4
Examine this procedure:
CREATE OR REPLACE PROCEDURE INSERT_TEAM (V_ID in NUMBER, V_CITY in VARCHAR2 DEFAULT ‘AUSTIN’, V_NAME in VARCHAR2) IS BEGIN INSERT INTO TEAM (id, city, name) VALUES (v_id, v_city, v_name);
COMMIT;
END;
Which two statements will successfully invoke this procedure in SQL*Plus? (Choose two.)

A.    EXECUTE INSERT_TEAM;
B.    EXECUTE INSERT_TEAM(3, V_NAME=>’LONGHORNS’, V_CITY=>’AUSTIN’);
C.    EXECUTE INSERT_TEAM(3,’AUSTIN’,’LONGHORNS’);
D.    EXECUTE INSERT_TEAM (V_ID := 3, V_NAME := ‘LONGHORNS’, V_CITY := ‘AUSTIN’);
E.    EXECUTE INSERT_TEAM (3,’LONGHORNS’);

Answer: BC

QUESTION 5
You need to create a DML trigger. Which five pieces need to be identified? (Choose five.)

A.    table
B.    DML event
C.    trigger body
D.    package body
E.    package name
F.    trigger name
G.    system event
H.    trigger timing

Answer: ABCFH

QUESTION 6
This statement fails when executed: CREATE OR REPLACE TRIGGER CALC_TEAM_AVG AFTER INSERT ON PLAYER BEGIN INSERT INTO PLAYER_BAT_STAT (PLAYER_ID, SEASON_YEAR,AT_BATS,HITS) VALUES (:NEW.ID, 1997, 0,0); END; To which type must you convert the trigger to correct the error?

A.    row
B.    statement
C.    ORACLE FORM trigger
D.    before

Answer: A

QUESTION 7
The add_player , upd_player_stat , and upd_pitcher_stat procedures are grouped together in a package. A variable must be shared among only these procedures. Where should you declare this variable?

A.    in the package body
B.    in a database trigger
C.    in the package specification
D.    in each procedure’s DECLARE section, using the exact same name in each

Answer: A

QUESTION 8
Examine this package:
  clip_image001[12]
Which statement is true?

A.    The value of DISCOUNT_RATE always remains 0.00 in a session.
B.    The value of DISCOUNT_RATE is set to 0.10 each time the package is invoked in a session.
C.    The value of DISCOUNT_RATE is set to 1.00 each time the procedure DISPLAY_PRICE is invoked.
D.    The value of DISCOUNT_RATE is set to 0.10 when the package is invoked for the first time in a session.

Answer: D

QUESTION 9
Examine this code:
 clip_image001[14]
Which statement is true?

A.    g_comm has a value of 15 at 9:06am for Smith.
B.    g_comm has a value of 15 at 9:06am for Jones.
C.    g_comm has a value of 20 at 9:06am for both Jones and Smith.
D.    g_comm has a value of 15 at 9:03am for both Jones and Smith.
E.    g_comm has a value of 10 at 9:06am for both Jones and Smith.
F.    g_comm has a value of 10 at 9:03 for both Jones and Smith.

Answer: B

QUESTION 10
Examine this code:
 clip_image001[16]
Which statement removes the function?

A.    DROP gen_email_name;
B.    REMOVE gen_email_name;
C.    DELETE gen_email_name;
D.    TRUNCATE gen_email_name;
E.    DROP FUNCTION gen_email_name;
F.    ALTER FUNCTION gen_email_name REMOVE;

Answer: E
Passing your Oracle 1Z0-147 Exam by using the latest Oracle 1Z0-147 Exam Demo Full Version: http://www.braindump2go.com/1z0-147.html

2014 Latest Oracle 1Z0-062 Exam Demo Free Download!

QUESTION 1
Examine the parameters for your database instance:
NAMETYPE VALUE
————————– ——————————- —————————
undo_management string AUTO
undo_retentioninteger 12 00
undo_tablespace string UNDOTBS1
You execute the following command:
SQL> ALTER TABLESPACE undotbs1 RETENTION NOGUARANTEE;
Which statement is true in this scenario?

A.    Undo data is written to flashback logs after 1200 seconds.
B.    Inactive undo data is retained for 1200 seconds even if subsequent transactions fail due to lack of space in the undo tablespace.
C.    You can perform a Flashback Database operation only within the duration of 1200 seconds.
D.    An attempt is made to keep inactive undo for 1200 seconds but transactions may overwrite the undo before that time has elapsed.

Answer: A

QUESTION 2
A user establishes a connection to a database instance by using an Oracle Net connection. You want to ensure the following:
1. The user account must be locked after five unsuccessful login attempts.
2. Data read per session must be limited for the user.
3. The user cannot have more than three simultaneous sessions.
4. The user must have a maximum of 10 minutes session idle time before being logged off automatically.
How would you accomplish this?

A.    by granting a secure application role to the user
B.    by implementing Database Resource Manager
C.    by using Oracle Label Security options
D.    by assigning a profile to the user

Answer: D

QUESTION 3
As a user of the ORCL database, you establish a database link to the remote HQ database such that all users in the ORCL database may access tables only from the SCOTT schema in the HQ database. SCOTT’s password is TIGER. The service mane “HQ” is used to connect to the remote HQ database. Which command would you execute to create the database link?

A.    CREATE DATABASE LINK HQ USING ‘HQ’;
B.    CREATE DATABASE LINK HQ CONNECT TO CXJRRENT_USER USING HQ’ S
C.    CREATE PUBLIC DATABASE LINK HQ CONNECT TO scott IDENTIFIED BY tiger USING ‘HQ’;
D.    CREATE DATABASE LINK HQ CONNECT TO scott IDENTIFIED BY tiger USING ‘HQ’;

Answer: B

QUESTION 4
What happens if a maintenance window closes before a job that collects optimizer statistics completes?

A.    The job is terminated and the gathered statistics are not saved.
B.    The job is terminated but the gathered statistics are not published.
C.    The job continues to run until all statistics are gathered.
D.    The job is terminated and statistics for the remaining objects are collected the next time the maintenance window opens.

Answer: D

QUESTION 5
You plan to create a database by using the Database Configuration Assistant (DBCA), with the following specifications:
– Applications will connect to the database via a middle tier.
– The number of concurrent user connections will be high.
– The database will have mixed workload, with the execution of complex BI queries scheduled at night.
Which DBCA option must you choose to create the database?

A.    a General Purpose database template with default memory allocation
B.    a Data Warehouse database template, with the dedicated server mode option and AMM enabled
C.    a General Purpose database template, with the shared server mode option and Automatic Memory Management (AMM) enabled
D.    a default database configuration

Answer: C

QUESTION 6
Which two statements are true about the logical storage structure of an Oracle database?

A.    An extent contains data blocks that are always physically contiguous on disk.
B.    An extent can span multiple segments,
C.    Each data block always corresponds to one operating system block.
D.    It is possible to have tablespaces of different block sizes.
E.    A data block is the smallest unit of I/O in data files.

Answer: BD

QUESTION 7
Which two statements correctly describe the relationship between data files and logical database structures?

A.    A segment cannot span data files.
B.    A data file can belong to only one tablespace.
C.    An extent cannot span data files.
D.    The size of an Oracle data block in a data file should be the same as the size of an OS block.

Answer: BC

QUESTION 8
Which statement is true about the Log Writer process?

A.    It writes when it receives a signal from the checkpoint process (CKPT).
B.    It writes concurrently to all members of multiplexed redo log groups.
C.    It writes after the Database Writer process writes dirty buffers to disk.
D.    It writes when a user commits a transaction.

Answer: D

QUESTION 9
The ORCL database is configured to support shared server mode. You want to ensure that a user connecting remotely to the database instance has a one-to-one ratio between client and server processes. Which connection method guarantees that this requirement is met?

A.    connecting by using an external naming method
B.    connecting by using the easy connect method
C.    creating a service in the database by using the dbms_service.create_service procedure and using this service for creating a local naming service”
D.    connecting by using the local naming method with the server = dedicated parameter set in the tnsnames.ora file for the net service
E.    connecting by using a directory naming method

Answer: CE

QUESTION 10
Which two tasks can be performed on an external table?

A.    partitioning the table
B.    creating an invisible index
C.    updating the table by using an update statement
D.    creating a public synonym
E.    creating a view

Answer: CD

QUESTION 11
Which three statements are true about a job chain?

A.    It can contain a nested chain of jobs.
B.    It can be used to implement dependency-based scheduling.
C.    It cannot invoke the same program or nested chain in multiple steps in the chain.
D.    It cannot have more than one dependency.
E.    It can be executed using event-based or time-based schedules.

Answer: ABE

QUESTION 12
The hr user receiver, the following error while inserting data into the sales table:
ERROR at line 1:
ORA-01653; unable to extend table HR.SALES by 128 in tablespace USERS
On investigation, you find that the users tablespace uses Automnrif Segment Space Management (ASSM). It is the default tablespace for the HR user with an unlimited quota on it. Which two methods would you use to resolve this error?

A.    Altering the data life associated with the USERS tablespace to ex automatically
B.    Adding a data life to the USERS tablespace
C.    Changing segment space management for the USERS tablespace to manual
D.    Creating a new tablespace with autoextend enabled and changing the default tablespace of the HR user to the new tablespace
E.    Enabling resumable space allocation by setting the RESUMABLE_TIMEOUT parameter to a nonzero value

Answer: AD

QUESTION 13
Which three factors influence the optimizer’s choice of an execution plan?

A.    the optimizer_mode initialization parameter
B.    operating system (OS) statistics
C.    cardinality estimates
D.    object statistics in the data dictionary
E.    fixed baselines

Answer: AB

QUESTION 14
Examine the resources consumed by a database instance whose current Resource Manager plan is displayed.
SQL> SELECT name, active_sessions, queue_length,
Consumed_cpu_time, cpu_waits, cpu_wait_time
FROM v$rsrc_consumer_group;
NAMEACTIVE_SESSIONS QUEUE_LENGTH CONSUMED_CPU_WAITS
CPU_WAIT_TIME
———————————– ——————– ——————– ——————— —————-
OLTP__ORDER__ENTRY1029690 467
OTHES__GROUPS 0 059823664089
60425
SYS_GROUP 1 02420704 914
19540
DS.S_QUERIES4245946603004
55700
Which two statements are true?

A.    An attempt to start a new session by a user belonging to DSS_QUERIES fails with an error.
B.    An attempt to start a new session by a user belonging to OTHE_GROUPS fails with an error.
C.    The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to resource management.
D.    The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to I/O waits and latch or enqueue contention.
E.    A user belonging to the DSS__QUERIES resource consumer group can create a new session but the session will be queued.

Answer: CE

QUESTION 15
Which action takes place when a file checkpoint occurs?

A.    The checkpoint position is advanced in the checkpoint queue.
B.    All buffers for a checkpointed file that were modified before a specific SCN are written to disk by DBWn and the SCN is stored in the control file.
C.    The Database Writer process (DBWn) writes all dirty buffers in the buffer cache to data files.
D.    The Log Writer process (LGWR) writes all redo entries in the log buffer to online redo log files.

Answer: C
Passing your Oracle 1Z0-062 Exam by using the latest Oracle 1Z0-062 Exam Demo Full Version: http://www.braindump2go.com/1z0-062.html

2014 Latest Oracle 1Z0-061 Exam Demo Free Download!

QUESTION 1
You need to create a table for a banking application. One of the columns in the table has the following requirements:
1) You want a column in the table to store the duration of the credit period.
2) The data in the column should be stored in a format such that it can be easily added and subtracted with date data type without using conversion functions.
3) The maximum period of the credit provision in the application is 30 days.
4) The interest has to be calculated for the number of days an individual has taken a credit for.
Which data type would you use for such a column in the table?

A.    DATE
B.    NUMBER
C.    TIMESTAMP
D.    INTERVAL DAY TO SECOND
E.    INTERVAL YEAR TO MONTH

Answer: D

QUESTION 2
Which three tasks can be performed using SQL functions built into Oracle Database?

A.    Displaying a date in a nondefault format
B.    Finding the number of characters in an expression
C.    Substituting a character string in a text expression with a specified string
D.    Combining more than two columns or expressions into a single column in the output

Answer: ABC

QUESTION 3
View the Exhibit and examine the data in the employees table:
 clip_image002[8]
You want to display all the employee names and their corresponding manager names.
Evaluate the following query:
 
Which join option can be used in the blank in the above query to get the required output?

A.    INNER JOIN
B.    FULL OUTER JOIN
C.    LEFT OUTER JOIN
D.    RIGHT OUTER JOIN

Answer: C

QUESTION 4
YOU need to display the date ll-oct-2007 in words as `Eleventh of October, Two Thousand Seven’.
Which SQL statement would give the required result?
 clip_image002[10]

A.    Option A
B.    Option B
C.    Option C
D.    Option D

Answer: A

QUESTION 5
Examine the data in the ORD_ITEMS table:
 clip_image001[6]
Evaluate the following query:
 clip_image001[8]
Which statement is true regarding the outcome of the above query?

A.    It gives an error because the having clause should be specified after the group by clause.
B.    It gives an error because all the aggregate functions used in the having clause must be specified
in the select list.
C.    It displays the item nos with their average quantity where the average quantity is more than double
the minimum quantity of that item in the table.
D.    It displays the item nos with their average quantity where the average quantity is more than double
the overall minimum quantity of all the items in the table.

Answer: C

QUESTION 6
Which two statements are true regarding subqueries?

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
Explanation:
Using a Subquery to Solve a Problem
Suppose you want to write a query to find out who earns a salary greater than Abel’s salary.
To solve this problem, you need two queries: one to find how much Abel earns, and a second query to find who earns more than that amount. You can solve this problem by combining the two queries, placing one query inside the other query. The inner query (or subquery) returns a value that is used by the outer query (or main query).
Using a subquery is equivalent to performing two sequential queries and using the result of the first query as the search value in the second query.
Subquery Syntax
A subquery is a SELECT statement that is embedded in the clause of another SELECT statement. You can build powerful statements out of simple ones by using subqueries. They can be very useful when you need to select rows from a table with a condition that depends on the data in the table itself.
You can place the subquery in a number of SQL clauses, including the following:
WHERE clause
HAVING clause
FROM clause
In the syntax:
operator includes a comparison condition such as >, =, or IN Note: Comparison conditions fall into two classes: single-row operators (>, =, >=, <, <>, <=) and multiple-row operators (IN, ANY, ALL, EXISTS). The subquery is often referred to as a nested SELECT, sub-SELECT, or inner SELECT statement. The subquery generally executes first, and its output is used to complete the query condition for the main (or outer) query.
Guidelines for Using Subqueries
Enclose subqueries in parentheses. Place subqueries on the right side of the comparison condition for readability. (However, the subquery can appear on either side of the comparison operator.) Use single-row operators with single-row subqueries and multiple- row operators with multiple-row subqueries.
Subqueries can be nested to an unlimited depth in a FROM clause but to “only” 255 levels in a WHERE clause. They can be used in the SELECT list and in the FROM, WHERE, and HAVING clauses of a query.

QUESTION 7
Examine the structure of the products table:
 clip_image001[10]
You want to display the names of the products that have the highest total value for UNIT_PRICE * QTY_IN_HAND.
Which SQL statement gives the required output?
 clip_image002[12]

A.    Option A
B.    Option B
C.    Option C
D.    Option D

Answer: A

Passing your Oracle 1Z0-061 Exam by using the latest Oracle 1Z0-061 Exam Demo Full Version: http://www.braindump2go.com/1z0-061.html

2014 Latest Oracle 1Z0-060 Exam Demo Free Download!

QUESTION 1
You notice that the performance of your production 24/7 Oracle database significantly degraded. Sometimes you are not able to connect to the instance because it hangs. You do not want to restart the database instance.
How can you detect the cause of the degraded performance?

A.    Enable Memory Access Mode, which reads performance data from SGA.
B.    Use emergency monitoring to fetch data directly from SGA analysis.
C.    Run Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest Automatic
Workload Repository (AWR) snapshots.
D.    Use Active Session History (ASH) data and hang analysis in regular performance monitoring.
E.    Run ADDM in diagnostic mode.

Answer: C
Explanation:
*In most cases, ADDM output should be the first place that a DBA looks when notified of a performance problem.
*Performance degradation of the database occurs when your database was performing optimally in the past, such as 6 months ago, but has gradually degraded to a point where it becomes noticeable to the users. The Automatic Workload Repository (AWR) Compare Periods report enables you to compare database performance between two periods of time.
While an AWR report shows AWR data between two snapshots (or two points in time), the AWR Compare Periods report shows the difference between two periods (or two AWR reports with a total of four snapshots). Using the AWR Compare Periods report helps you to identify detailed performance attributes and configuration settings that differ between two time periods.
Reference:Resolving Performance Degradation Over Time

QUESTION 2
You plan to use the In Database Archiving feature of Oracle Database 12c, and store rows that are inactive for over three months, in Hybrid Columnar Compressed (HCC) format.
Which three storage options support the use of HCC?

A.    ASM disk groups with ASM disks consisting of Exadata Grid Disks.
B.    ASM disk groups with ASM disks consisting of LUNS on any Storage Area Network array
C.    ASM disk groups with ASM disks consisting of any zero padded NFS-mounted files
D.    Database files stored in ZFS and accessed using conventional NFS mounts.
E.    Database files stored in ZFS and accessed using the Oracle Direct NFS feature
F.    Database files stored in any file system and accessed using the Oracle Direct NFS feature
G.    ASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays

Answer: AEG
Explanation:
HCC requires the use of Oracle Storage ?Exadata(A), Pillar Axiom(G)or Sun ZFS Storage Appliance (ZFSSA).
Note:
*Hybrid Columnar Compression, initially only available on Exadata, has been extended to supportPillar Axiom and Sun ZFS Storage Appliance (ZFSSA) storage when used with Oracle Database Enterprise Edition 11.2.0.3 and above
*Oracle offers the ability to manage NFS using a feature called Oracle Direct NFS (dNFS). Oracle Direct NFS implements NFS V3 protocol within the Oracle database kernel itself. Oracle Direct NFS client overcomes many of the challenges associated with using NFS with the Oracle Database with simple configuration, betterperformance than traditional NFS clients, and offers consistent configuration across platforms.
QUESTION 3
In your multitenant container database (CDB) containing pluggable databases (PDB), users complain about performance degradation.
How does real-time Automatic database Diagnostic Monitor (ADDM) check performance degradation and provide solutions?

A.    It collects data from SGA and compares it with a preserved snapshot.
B.    It collects data from SGA, analyzes it, and provides a report.
C.    It collects data from SGA and compares it with the latest snapshot.
D.    It collects data from both SGA and PGA, analyzes it, and provides a report.

Answer: B
Explanation:
Note:
*The multitenant architecture enables an Oracle database to function as a multitenant container database (CDB) that includes zero, one, or many customer-created pluggable databases (PDBs). A PDB is a portable collection of schemas, schema objects, and nonschema objects that appears to an Oracle Net client as a non-CDB. All Oracle databases before Oracle Database 12c were non-CDBs.
*The System Global Area (SGA) is a group of shared memory areas that are dedicated to an Oracle “instance” (an instance is your database programs and RAM). *The PGA (Program or Process Global Area) is a memory area (RAM) that stores data and control information for a single process.

QUESTION 4
The tnsnames.ora file has an entry for the service alias ORCL as follows:
  clip_image002[4]
The TNS ping command executes successfully when tested with ORCL; however, from the same OS user session, you are not able to connect to the database instance with the following command:
SQL > CONNECT scott/tiger@orcl
What could be the reason for this?

A.    The listener is not running on the database node.
B.    The TNS_ADMIN environment variable is set to the wrong value.
C.    The orcl.oracle.com database service is not registered with the listener.
D.    The DEFAULT_DOMAIN parameter is set to the wrong value in the sqlnet.ora file.
E.    The listener is running on a different port.

Answer: C
Explanation:
Service registration enables the listener to determine whether a database service and its service handlers are available. A service handler is a dedicated server process or dispatcher that acts as a connection point to a database. During registration, the LREG process provides the listener with the instance name, database service names, and the type and addresses of service handlers. This information enables the listener to start a service handler when a client request arrives.

QUESTION 5
Examine the following steps of privilege analysis for checking and revoking excessive, unused privileges granted to users:
1. Create a policy to capture the privilege used by a user for privilege analysis.
2. Generate a report with the data captured for a specified privilege capture.
3. Start analyzing the data captured by the policy.
4. Revoke the unused privileges.
5. Compare the used and unused privileges’ lists.
6. Stop analyzing the data.
Identify the correct sequence of steps.

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

Answer: B
Explanation:
1.Create a policy to capture the privilege used by a user for privilege analysis.
3.Start analyzing the data captured by the policy.
6.Stop analyzing the data.
2.Generate a report with the data captured for a specified privilege capture.
5.Compare the used and unused privileges’ lists.
4.Revoke the unused privileges.

QUESTION 6
You database is running an ARCHIVELOG mode.
The following parameter are set in your database instance:
LOG_ARCHIVE_FORMAT = arch+%t_%r.arc
LOG_ARCHIVE_DEST_1 = `LOCATION = /disk1/archive’
DB_RECOVERY_FILE_DEST_SIZE = 50G
DB_RECOVERY_FILE = `/u01/oradata’
Which statement is true about the archived redo log files?

A.    They are created only in the location specified by the LOG_ARCHIVE_DEST_1 parameter.
B.    They are created only in the Fast Recovery Area.
C.    They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and in the
default location $ORACLE_HOME/dbs/arch.
D.    They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the location
specified by the DB_RECOVERY_FILE_DEST parameter.

Answer: A
Explanation:
You can choose to archive redo logs to a single destination or to multiple destinations.
Destinations can be local–within the local file system or an Oracle Automatic Storage Management (Oracle ASM) disk group–or remote (on a standby database). When you archive to multiple destinations, a copy of each filled redo log file is written to each destination. These redundant copies help ensure that archived logs are always available in the event of a failure at one of the destinations. To archive to only a single destination, specify that destination using the LOG_ARCHIVE_DESTandLOG_ARCHIVE_DUPLEX_DESTinitialization parameters. ARCHIVE_DEST initialization parameter. To archive to multiple destinations, you can choose to archive to two or more locations using the LOG_ARCHIVE_DEST_n initialization parameters, or to archive only to a primary and secondary destination using the LOG_ ARCHIVE_DEST and LOG_ARCHIVE_DUPLEX_DEST initialization parameters.

QUESTION 7
Your multitenant container database (CDB) is running in ARCHIVELOG mode. You connect to the CDB RMAN. Examine the following command and its output:
 clip_image002[6]
You execute the following command:
RMAN > BACKUP DATABASE PLUS ARCHIVELOG;
Which data files will be backed up?

A.    Data files that belong to only the root container
B.    Data files that belong to the root container and all the pluggable databases (PDBs)
C.    Data files that belong to only the root container and PDB$SEED
D.    Data files that belong to the root container and all the PDBs excluding PDB$SEED

Answer: B
Explanation:
Backing Up a Whole CDB
Backing up a whole CDB is similar to backing up a non-CDB. When you back up a whole CDB, RMAN backs up the root, all the PDBs, and the archived redo logs. You can then recover either the whole CDB, the root only, or one or more PDBs from the CDB backup.
Note:
*You can back up and recover a whole CDB, the root only, or one or more PDBs.
*Backing Up Archived Redo Logs with RMAN
Archived redo logs are the key to successful media recovery. Back them up regularly. You can back up logs with BACKUP ARCHIVELOG, or back up logs while backing up datafiles and control files by specifying BACKUP … PLUS ARCHIVELOG.

QUESTION 8
You are administering a database stored in Automatic Storage management (ASM). The files are stored in the DATA disk group. You execute the following command:
SQL > ALTER DISKGROUP data ADD ALIAS `+data/prod/myfile.dbf’ FOR `+data.231.45678′;
What is the result?
A.    The file `+data.231.54769′ is physically relocated to `+data/prod’ and renamed as `myfile.dbf’.
B.    The file `+data.231.54769′ is renamed as `myfile.dbf’, and copied to `+data/prod’.
C.    The file `+data.231.54769′ remains in the same location andasynonym’myfile.dbf’ is created.
D.    The file `myfile.dbf’ is created in `+data/prod’ and the reference to `+data.231.54769′ in the data
dictionary removed.

Answer: C
Explanation:
ADD ALIAS
Use this clause to create an alias name for an Oracle ASM filename. The alias_name consists of the full directory path and the alias itself.

QUESTION 9
Which three functions are performed by the SQL Tuning Advisor?

A.    Building and implementing SQL profiles
B.    Recommending the optimization of materialized views
C.    Checking query objects for missing and stale statistics
D.    Recommending bitmap, function-based, and B-tree indexes
E.    Recommending the restructuring of SQL queries that are using bad plans

Answer: ACE
Explanation:
The SQL Tuning Advisor takes one or more SQL statements as an input and invokes the Automatic Tuning Optimizer to perform SQL tuning on the statements. The output of the SQL Tuning Advisor is in the form of an advice or recommendations, along with a rationale for eachrecommendation and its expected benefit. The recommendation relates to collection of statistics on objects(C), creation of new indexes, restructuring of the SQL statement(E), or creation of a SQL profile(A). You can choose to accept the recommendation to complete the tuning of the SQL statements.

QUESTION 10
Examine the following command:
ALTER SYSTEM SET enable_ddl_logging=FALSE;
Which statement is true?

A.    None of the data definition language (DDL) statements are logged in the trace file.
B.    Only DDL commands that resulted in errors are logged in the alert log file.
C.    A new log.xml file that contains the DDL statements is created, and the DDL command details are
removed from the alert log file.
D.    Only DDL commands that resulted in the creation of new database files are logged.

Answer: A
Explanation:
ENABLE_DDL_LOGGING enables or disables the writing of a subset of data definition language (DDL) statements to a DDL alert log.
The DDL log is a file that has the same format and basic behavior as the alert log, but it only contains the DDL statements issued by the database. The DDL log is created only for the RDBMS component and only if the ENABLE_DDL_LOGGING initialization parameter is set to true. When this parameter is set to false, DDL statements are not included in any log.

QUESTION 11
Your multitenant container database (CDB) contains three pluggable database (PDBs). You find that the control file is damaged. You plan to use RMAN to recover the control file. There are no startup triggers associated with the PDBs.
Which three steps should you perform to recover the control file and make the database fully operational?

A.    Mount the container database (CDB) and restore the control file from the control file auto backup.
B.    Recover and open the CDB in NORMAL mode.
C.    Mount the CDB and then recover and open the database, with the RESETLOGS option.
D.    Open all the pluggable databases.
E.    Recover each pluggable database.
F.    Start the database instance in the nomount stage and restore the control file from control file auto backup.

Answer: CDF
Explanation:
Step 1: F
Step 2: D
Step 3: C: If all copies of the current control file are lost or damaged, then you must restore and mount a backup control file. You must then run the RECOVERcommand, even if no data files have been restored, and open the database with the RESETLOGS option.
Note:
*RMAN and Oracle Enterprise Manager Cloud Control (Cloud Control) provide full support for backup and recovery in a multitenant environment. You can back up and recover a whole multitenant container database (CDB), root only, or one or more pluggable databases (PDBs).

Passing your Oracle 1Z0-060 Exam by using the latest Oracle 1Z0-060 Exam Demo Full Version: http://www.braindump2go.com/1z0-060.html

Official 2014 Latest Oracle 1Z0-482 Demo Free Download!

QUESTION 1
You want to add a new CDC subscriber in ODI after you have started the Journal process, what steps do you need to go through in order to use this new subscriber?

A.    Drop Journal, remove existing subscribers, add a new subscriber, start Journal, and edit the default Journalizing filter in your Interfaces
B.    Drop Journal,add anew subscriber, start Journal, and remove the default Journalizing filter in your Interfaces
C.    Drop Journal, add a new subscriber, start Journal, and edit the default Journalizing filter in your Interfaces
D.    Add anew subscriber and edit the default Journalizing filter in your Interfaces

Answer: C

QUESTION 2
You are loading a file into a database but the file name is unknown at design time and will have to be passed dynamically to a Package at run time; how do you achieve this?

A.    Create a variable, use it in Topology at the File dataserver-level, and add it to a package as a Declare Variable step
B.    Create a variable, use it in Topology at the File dataserver-level, and add it to a package as a Set Variable step
C.    Create a variable, use it as the Resource Name of the File datastore, and add it to a package as a Declare Variable step
D.    Create a variable, use it as the Resource Name of the File datastore, and add it to a package as a Set Variable step

Answer: D

QUESTION 3
Select the two correct statements about the Date Profiler.

A.    It can profile string dates written in a variety of formats, such as DD/MM/YYYY or MM/DD/YYYY.
B.    It provides a distribution for the day in the year, such as February 21, regardless of the year.
C.    It allows the EDQ user to define a valid range of dates.
D.    By clicking a date in blue, the user can drill down to the records that carried that value.
E.    It rejects February 29 as an invalid date.

Answer: AD

QUESTION 4
Which two ODI knowledge modules are included in the Application Adapter for Hadoop?

A.    IKM Oracle Incremental Update
B.    IKM Hive Transform
C.    IKM SQL to File Append
D.    IKM FiletoHive

Answer: BD
Explanation:
http://docs.oracle.com/cd/E27101_01/doc.10/e27365/odi.htm

QUESTION 5
When working with delimited flat files, is it possible to enforce primary key on a flat file using a CKM?

A.    No, it is not possible to enforce constraints on some technologies such as flat files and JMS queues.
B.    No, it is not possible to enforce constraints on any technology.
C.    Yes, it is possible also to forward-engineer it to the flat file definition.
D.    Yes, but you have to save it as a fixed file.

Answer: A

If you want to pass the Oracle 1Z0-482 Exam sucessfully, recommend to read latest Oracle 1Z0-482 Demo full version.

1 8 9 10