1Z1-050 무료 덤프문제 온라인 액세스

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 create the same directory structure for duplicate database files as of the target database.
You executed the following RMAN commands:
RMAN> CONNECT TARGET sys/sys@APPPROD
RMAN> CONNECT AUXILIARY sys/sys@DUPDB
RMAN> DUPLICATE TARGET DATABASE TO
dupdb
FROM ACTIVE DATABASE
PASSWORD FILE
SPILE
NOFILENAMECHECK;
What are the implications of this command?

• A.It creates database files for the duplicate database under the same Oracle home as that of the target but with a different directory for the duplicate database.
• B.It creates database files for the duplicate database under the same Oracle home as that of the target database with the same directory structure.
• C.It overwrites data files of the target database because a different location for data files is not mentioned for the duplicate database.
• D.It creates database files for the duplicate database under the Oracle base with a different directory for the duplicate database.

Examine the following PL/SQL block:
SET SERVEROUTPUT ON
SET LONG 10000
ECLARE report clob;
BEGIN
report := DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE();
DBMS_OUTPUT .PUT_LINE(report);
END;
Which statement describes the effect of the execution of the above PL/SQL block?

• A.All the nonaccepted SQL profiles are accepted into the plan baseline.
• B.The plan baselines are verified with the SQL profiles.
• C.The nonaccepted plans in the SQL Management Base are verified with the existing plan baselines.
• D.All fixed plan baselines are converted into nonfixed plan baselines.

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(SAU\RY)INTO avgsal
FROM EMPLOYEES
WHERE DEPARTMENTJD = dept_id;
RETURN avgsal;
END get_dept_avg;
Which statement is true regarding the above function?

• A.If the function is invoked with a different parameter value, the existing result in the result cache gets overwritten by the latest value.
• B.Each time the function is invoked in a different session, the current result in the result cache gets overwritten.
• C.If the function execution results in an unhandled exception, the exception result is also stored in the cache.
• D.The cached result becomes invalid when any structural change is done to the EMPLOYEES table.

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 role in Oracle Internet Directory (OID). SSL and the password file have been configured. A user SCOTT with the SYSDBA privilege tries to connect to the database instance from a remote machine using the command:
$ SQLPLUS scott/tiger@DB01 AS SYSDBA where DB01 is the net service name. Which authentication method would be used first?

• A.authentication by using the Oracle Internet Directory
• B.authentication by password file
• C.authentication by using the local OS of the database server
• D.authentication by using certificates over SSL

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 NUMBER(10,2),
total_value AS ( qty * rate))
PARTITION BY RANGE (total_value)
(PARTITION p1 VALUES LESS THAN (100000),
PARTITION p2 VALUES LESS THAN (150000),
PARTITION p3 VALUES LESS THAN (MAXVALUE))
COMPRESS FOR ALL OPERATIONS;
Which statement is true regarding this command?

• A.It produces an error because compression cannot be used for the TOTAL_VALUE partition key.
• B.It executes successfully but the values in the TOTAL_VALUE column would not be physically stored in the partitions.
• C.It produces an error because the TOTAL_VALUE column cannot be used as a partition key.
• D.It executes successfully but partition pruning cannot happen for this partition key.