Ucertify offers free demo for oracle database 12c installation and administration 1z0 062 pdf exam. "Oracle Database 12c: Installation and Administration", also known as oracle database 12c installation and administration 1z0 062 pdf exam, is a Oracle Certification. This set of posts, Passing the Oracle oracle database 12c installation and administration 1z0 062 pdf exam, will help you answer those questions. The oracle database 12c installation and administration 1z0 062 pdf Questions & Answers covers all the knowledge points of the real exam. 100% real Oracle 1z0 062 dumps exams and revised by experts!


♥♥ 2017 NEW RECOMMEND ♥♥

Free VCE & PDF File for Oracle 1Z0-062 Real Exam (Full Version!)

★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions

Free Instant Download NEW 1Z0-062 Exam Dumps (PDF & VCE):
Available on: http://www.surepassexam.com/1Z0-062-exam-dumps.html

Q91. You wish to enable an audit policy for all database users, except SYS, SYSTEM, and SCOTT. 

You issue the following statements: 

SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYS; 

SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYSTEM; 

SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SCOTT; 

For which database users is the audit policy now active? 

A. All users except SYS 

B. All users except SCOTT 

C. All users except sys and SCOTT 

D. All users except sys, system, and SCOTT 

Answer:

Explanation: If you run multiple AUDIT statements on the same unified audit policy but specify different EXCEPT users, then Oracle Database uses the last exception user list, not any of the users from the preceding lists. This means the effect of the earlier AUDIT POLICY ... EXCEPT statements are overridden by the latest AUDIT POLICY ... EXCEPT statement. 

Note: 

* The ORA_DATABASE_PARAMETER policy audits commonly used Oracle Database parameter settings. By default, this policy is not enabled. 

* You can use the keyword ALL to audit all actions. The following example shows how to audit all actions on the HR.EMPLOYEES table, except actions by user pmulligan. 

Example Auditing All Actions on a Table 

CREATE AUDIT POLICY all_actions_on_hr_emp_pol ACTIONS ALL ON HR.EMPLOYEES; 

AUDIT POLICY all_actions_on_hr_emp_pol EXCEPT pmulligan; 

Reference: Oracle Database Security Guide 12c, About Enabling Unified Audit Policies 


Q92. Examine the details of the Top 5 Timed Events in the following Automatic Workloads Repository (AWR) report: 

What are three possible causes for the latch-related wait events? 

A. The size of the shared pool is too small. 

B. Cursors are not being shared. 

C. A large number COMMITS are being performed. 

D. There are frequent logons and logoffs. 

E. The buffers are being read into the buffer cache, but some other session is changing the buffers. 

Answer: A,B,E 


Q93. Which two statements are true about the RMAN validate database command? 

A. It checks the database for intrablock corruptions. 

B. It can detect corrupt pfiles. 

C. It can detect corrupt spfiles. 

D. It checks the database for interblock corruptions. 

E. It can detect corrupt block change tracking files. 

Answer: A,C 

Explanation: 

Block corruptions can be divided Into Interblock corruption and intrablock corruption. In intrablock corruption. th. corruption occurs within the block itself and can be either physical or logical corruption. In interblock corruption, the corruption occurs between blocks and can only be logical corruption. (key word) * The VALIDATE command checks for intrablock corruptions only. Only DBVERIFY and the ANALYZE statement detect Interblock corruption. VALIDATE Command Output ..> List of Control File and SPFILE. 

File TYPE >.. SPFILE or Control File. 

Status >.. OK if no corruption, or FAILED If block corruption is found. 

Blocks Failing ... The number of blocks that fail the corruption check. These 

blocks are newly corrupt. 

Blocks Examined ... Total number of blocks in the file. 

Oracle' Database Backup and Recovery User's Guide 

12c Release 1 (12.1) - 16 Validating Database Files and Backups 


Q94. To enable the Database Smart Flash Cache, you configure the following parameters: 

DB_FLASH_CACHE_FILE = ‘/dev/flash_device_1’ , ‘/dev/flash_device_2’ 

DB_FLASH_CACHE_SIZE=64G 

What is the result when you start up the database instance? 

A. It results in an error because these parameter settings are invalid. 

B. One 64G flash cache file will be used. 

C. Two 64G flash cache files will be used. 

D. Two 32G flash cache files will be used. 

Answer:


Q95. Which three activities are supported by the Data Recovery Advisor? 

A. Advising on block checksum failures 

B. Advising on inaccessible control files 

C. Advising on inaccessible block change tracking files 

D. Advising on empty password files 

E. Advising on invalid block header field values 

Answer: A,B,E 

Explanation: * Data Recovery Advisor can diagnose failures such as the following: 

/ (B) Components such as datafiles and control files that are not accessible because they do not exist, do not have the correct access permissions, have been taken offline, and so on 

/ (A, E) Physical corruptions such as block checksum failures and invalid block header field values 

/ Inconsistencies such as a datafile that is older than other database files / I/O failures such as hardware errors, operating system driver failures, and exceeding operating system resource limits (for example, the number of open files) 

* The Data Recovery Advisor automatically diagnoses corruption or loss of persistent data on disk, determines the appropriate repair options, and executes repairs at the user's request. This reduces the complexity of recovery process, thereby reducing the Mean Time To Recover (MTTR). 


Q96. You executed this command to create a password file: 

$ orapwd file = orapworcl entries = 10 ignorecase = N 

Which two statements are true about the password file? 

A. It will permit the use of uppercase passwords for database users who have been granted the SYSOPER role. 

B. It contains username and passwords of database users who are members of the OSOPER operating system group. 

C. It contains usernames and passwords of database users who are members of the OSDBA operating system group. 

D. It will permit the use of lowercase passwords for database users who have granted the SYSDBA role. 

E. It will not permit the use of mixed case passwords for the database users who have been granted the SYSDBA role. 

Answer: A,D 

Explanation: * You can create a password file using the password file creation utility, ORAPWD. 

* Adding Users to a Password File 

When you grant SYSDBA or SYSOPER privileges to a user, that user's name and privilege information are added to the password file. If the server does not have an EXCLUSIVE 

password file (that is, if the initialization parameter REMOTE_LOGIN_PASSWORDFILE is NONE or SHARED, or the password file is missing), Oracle Database issues an error if you attempt to grant these privileges. 

A user's name remains in the password file only as long as that user has at least one of these two privileges. If you revoke both of these privileges, Oracle Database removes the user from the password file. 

* The syntax of the ORAPWD command is as follows: 

ORAPWD FILE=filename [ENTRIES=numusers] [FORCE={Y|N}] [IGNORECASE={Y|N}] [NOSYSDBA={Y|N}] 

* IGNORECASE If this argument is set to y, passwords are case-insensitive. That is, case is ignored when comparing the password that the user supplies during login with the password in the password file. 


Q97. What is the effect of specifying the "ENABLE PLUGGABLE DATABASE" clause in a "CREATE DATABASE” statement? 

A. It will create a multitenant container database (CDB) with only the root opened. 

B. It will create a CDB with root opened and seed read only. 

C. It will create a CDB with root and seed opened and one PDB mounted. 

D. It will create a CDB that must be plugged into an existing CDB. 

E. It will create a CDB with root opened and seed mounted. 

Answer:

Explanation: * The CREATE DATABASE ... ENABLE PLUGGABLE DATABASE SQL statement creates a new CDB. If you do not specify the ENABLE PLUGGABLE DATABASE clause, then the newly created database is a non-CDB and can never contain PDBs. 

Along with the root (CDB$ROOT), Oracle Database automatically creates a seed PDB (PDB$SEED). The following graphic shows a newly created CDB: 

Description of admin095.png follows 

* Creating a PDB Rather than constructing the data dictionary tables that define an empty PDB from scratch, and then populating its Obj$ and Dependency$ tables, the empty PDB is created when the CDB is created. (Here, we use empty to mean containing no customer-created artifacts.) It is referred to as the seed PDB and has the name PDB$Seed. Every CDB non-negotiably contains a seed PDB; it is non-negotiably always open in read-only mode. This has no conceptual significance; rather, it is just an optimization device. The create PDB operation is implemented as a special case of the clone PDB operation. 


Q98. Which three are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when it is enabled? 

A. Reduced logical I/O 

B. Reduced virtual memory utilization 

C. Improved parallel Execution performance 

D. Improved Serial Execution performance 

E. Reduced physical I/O 

F. Reduced CPU utilization 

Answer: B,C,F 

Explanation: * Multiprocess and Multithreaded Oracle Database Systems 

Multiprocess Oracle Database (also called multiuser Oracle Database) uses several processes to run different parts of the Oracle Database code and additional Oracle processes for the users—either one process for each connected user or one or more processes shared by multiple users. Most databases are multiuser because a primary advantage of a database is managing data needed by multiple users simultaneously. 

Each process in a database instance performs a specific job. By dividing the work of the database and applications into several processes, multiple users and applications can connect to an instance simultaneously while the system gives good performance. 

* In previous releases, Oracle processes did not run as threads on UNIX and Linux systems. Starting in Oracle Database 12c, the multithreaded Oracle Database model enables Oracle processes to execute as operating system threads in separate address spaces. 


Q99. What is the result of executing a TRUNCATE TABLE command on a table that has Flashback Archiving enabled? 

A. It fails with the ORA-665610 Invalid DDL statement on history-tracked message 

B. The rows in the table are truncated without being archived. 

C. The rows in the table are archived, and then truncated. 

D. The rows in both the table and the archive are truncated. 

Answer:

Explanation: You cannot roll back a TRUNCATE TABLE statement, nor can you use a FLASHBACK TABLE statement to retrieve the contents of a table that has been truncated.