Master the 1z0-060 Upgrade to Oracle Database 12c content and be ready for exam day success quickly with this Exambible 1z0-060 free practice questions. We guarantee it!We make it a reality and give you real 1z0-060 questions in our Oracle 1z0-060 braindumps.Latest 100% VALID Oracle 1z0-060 Exam Questions Dumps at below page. You can use our Oracle 1z0-060 braindumps and pass your exam.
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for Oracle 1z0-060 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Free Instant Download NEW 1z0-060 Exam Dumps (PDF & VCE):
Available on:
http://www.surepassexam.com/1z0-060-exam-dumps.html
Q1. The tnsnames.ora file has an entry for the service alias ORCL as follows:
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
Q2. Which two statements are true about the use of the procedures listed in the v$sysaux_occupants.move_procedure column?
A. The procedure may be used for some components to relocate component data to the SYSAUX tablespace from its current tablespace.
B. The procedure may be used for some components to relocate component data from the SYSAUX tablespace to another tablespace.
C. All the components may be moved into SYSAUX tablespace.
D. All the components may be moved from the SYSAUX tablespace.
Answer: AB
Q3. 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/prod/myfile.dbf’
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 and a synonym '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
Q4. In your multitenant container database (CDB) containing pluggable database (PDBs), the HR user executes the following commands to create and grant privileges on a procedure:
CREATE OR REPLACE PROCEDURE create_test_v (v_emp_id NUMBER, v_ename
VARCHAR2, v_SALARY NUMBER, v_dept_id NUMBER)
BEGIN
INSERT INTO hr.test VALUES (V_emp_id, V_ename, V_salary, V_dept_id);
END;
/
GRANT EXECUTE ON CREATE_TEST TO john, jim, smith, king;
How can you prevent users having the EXECUTE privilege on the CREATE_TEST procedure from inserting values into tables on which they do not have any privileges?
A. Create the CREATE_TEST procedure with definer’s rights.
B. Grant the EXECUTE privilege to users with GRANT OPTION on the CREATE_TEST procedure.
C. Create the CREATE_TEST procedure with invoker’s rights.
D. Create the CREATE_TEST procedure as part of a package and grant users the EXECUTE privilege the package.
Answer: C
Q5. Identify three benefits of Unified Auditing.
A. Decreased use of storage to store audit trail rows in the database.
B. It improves overall auditing performance.
C. It guarantees zero-loss auditing.
D. The audit trail cannot be easily modified because it is read-only.
E. It automatically audits Recovery Manager (RMAN) events.
Answer: BDE
Q6. In your multitenant container database (CDB) with two pluggable database (PDBs). You want to create a new PDB by using SQL Developer.
Which statement is true?
A. The CDB must be open.
B. The CDB must be in the mount stage.
C. The CDB must be in the nomount stage.
D. Alt existing PDBs must be closeD.
Answer: A
Q7. Which three are true about the large pool for an Oracle database instance that supports
shared server connections?
A. Allocates memory for RMAN backup and restore operations
B. Allocates memory for shared and private SQL areas
C. Contains a cursor area for storing runtime information about cursors
D. Contains stack space
E. Contains a hash area performing hash joins of tables
Answer: ABC
Q8. Identify three valid methods of opening, pluggable databases (PDBs).
A. ALTER PLUGGABLE DATABASE OPEN ALL ISSUED from the root
B. ALTER PLUGGABLE DATABASE OPEN ALL ISSUED from a PDB
C. ALTER PLUGGABLE DATABASE PDB OPEN issued from the seed
D. ALTER DATABASE PDB OPEN issued from the root
E. ALTER DATABASE OPEN issued from that PDB
F. ALTER PLUGGABLE DATABASE PDB OPEN issued from another PDB
G. ALTER PLUGGABLE DATABASE OPEN issued from that PDB
Answer: AEG
Q9. Which three statements are true about Flashback Database?
A. Flashback logs are written sequentially, and are archived.
B. Flashback Database uses a restored control file to recover a database.
C. The Oracle database automatically creates, deletes, and resides flashback logs in the Fast Recovery Area.
D. Flashback Database can recover a database to the state that it was in before a reset logs operation.
E. Flashback Database can recover a data file that was dropped during the span of time of the flashback.
F. Flashback logs are used to restore to the blocks' before images, and then the redo data may be used to roll forward to the desired flashback time.
Answer: CDF
Q10. Examine the contents of SQL loader control file:
Which three statements are true regarding the SQL* Loader operation performed using the control file?
A. An EMP table is created if a table does not exist. Otherwise, if the EMP table is appended with the loaded data.
B. The SQL* Loader data file myfile1.dat has the column names for the EMP table.
C. The SQL* Loader operation fails because no record terminators are specified.
D. Field names should be the first line in the both the SQL* Loader data files.
E. The SQL* Loader operation assumes that the file must be a stream record format file with the normal carriage return string as the record terminator.
Answer: ABE
