The only oracle database 12c installation and administration 1z0 062 pdf resources for you

It is more faster and easier to pass the Oracle oracle database 12c installation and administration 1z0 062 pdf exam by using Best Quality Oracle Oracle Database 12c: Installation and Administration questuins and answers. Immediate access to the Replace 1z0 062 pdf Exam and find the same core area 1z0 062 dumps questions with professionally verified answers, then PASS your exam with a high score now.


♥♥ 2021 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

Q21. You configure your database Instance to support shared server connections. 

Which two memory areas that are part of PGA are stored in SGA instead, for shared server connection? 

A. User session data 

B. Stack space 

C. Private SQL area 

D. Location of the runtime area for DML and DDL Statements 

E. Location of a part of the runtime area for SELECT statements 

Answer: A,C 

Explanation: A: PGA itself is subdivided. The UGA (User Global Area) contains session state information, including stuff like package-level variables, cursor state, etc. Note that, with shared server, the UGA is in the SGA. It has to be, because shared server means that the session state needs to be accessible to all server processes, as any one of them could be assigned a particular session. However, with dedicated server (which likely what you're using), the UGA is allocated in the PGA. 

C: The Location of a private SQL area depends on the type of connection established for a session. If a session is connected through a dedicated server, private SQL areas are located in the server process’ PGA. However, if a session is connected through a shared server, part of the private SQL area is kept in the SGA. 

Note: 

* System global area (SGA) The SGA is a group of shared memory structures, known as SGA components, that contain data and control information for one Oracle Database instance. The SGA is shared by all server and background processes. Examples of data stored in the SGA include cached data blocks and shared SQL areas. 

* Program global area (PGA) 

A PGA is a memory region that contains data and control information for a server process. It is nonshared memory created by Oracle Database when a server process is started. Access to the PGA is exclusive to the server process. There is one PGA for each server process. Background processes also allocate their own PGAs. The total memory used by all individual PGAs is known as the total instance PGA memory, and the collection of individual PGAs is referred to as the total instance PGA, or just instance PGA. You use database initialization parameters to set the size of the instance PGA, not individual PGAs. 

Reference: Oracle Database Concepts 12c 


Q22. Which Oracle Database component is audited by default if the unified Auditing option is enabled? 

A. Oracle Data Pump 

B. Oracle Recovery Manager (RMAN) 

C. Oracle Label Security 

D. Oracle Database Vault 

E. Oracle Real Application Security 

Answer:


Q23. 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: A,D 


Q24. 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:

Explanation: 

* 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. The size of the seed PDB is only about 1 gigabyte and it takes only a few seconds on a typical machine to copy it. 


Q25. Examine the query and its output: 

SQL> SELECT REASON, metric_value FROM dba_outstanding_alerts; 

REASONMETRIC_VALUE 

Tablespace [TEST] is [28 perce 28.125 nt] full 

Metrics "Current Logons Count"29 

Metrics "Database Time Spent99.0375405 waiting (%)" is at 99.03754 for event class "Application" db_recovery_file_dest_size of97 4294967296 bytes is 97.298 used and has 116228096 remaining bytes available. 

After 30 minutes, you execute the same query: 

SQL> SELECT reason, metric_value FROM dba_outstanding_alerets; 

REASONMETRIC_VALUE 

Tablespace [TEST] is [28 percs 28.125 nt] full 

What might have caused three of the alerts to disappear? 

A. The threshold alerts were cleared and transferred to d0A_alert_history. 

B. An Automatic Workload Repository (AWR) snapshot was taken before the execution of the second 

C. An Automatic Database Diagnostic Monitor (ADOM) report was generated before the execution of the second query. 

D. The database instance was restarted before the execution of the second query. 

Answer:


Q26. Identify three valid options for adding a pluggable database (PDB) to an existing multitenant container database (CDB). 

A. Use the CREATE PLUGGABLE DATABASE statement to create a PDB using the files from the SEED. 

B. Use the CREATE DATABASE . . . ENABLE PLUGGABLE DATABASE statement to provision a PDB by copying file from the SEED. 

C. Use the DBMS_PDB package to clone an existing PDB. 

D. Use the DBMS_PDB package to plug an Oracle 12c non-CDB database into an existing CDB. 

E. Use the DBMS_PDB package to plug an Oracle 11 g Release 2 (11.2.0.3.0) non-CDB database into an existing CDB. 

Answer: A,C,D 

Explanation: Use the CREATE PLUGGABLE DATABASE statement to create a pluggable database (PDB). 

This statement enables you to perform the following tasks: 

* (A) Create a PDB by using the seed as a template 

Use the create_pdb_from_seed clause to create a PDB by using the seed in the multitenant container database (CDB) as a template. The files associated with the seed are copied to a new location and the copied files are then associated with the new PDB. 

* (C) Create a PDB by cloning an existing PDB 

Use the create_pdb_clone clause to create a PDB by copying an existing PDB (the source PDB) and then plugging the copy into the CDB. The files associated with the source PDB are copied to a new location and the copied files are associated with the new PDB. This operation is called cloning a PDB. 

The source PDB can be plugged in or unplugged. If plugged in, then the source PDB can be in the same CDB or in a remote CDB. If the source PDB is in a remote CDB, then a database link is used to connect to the remote CDB and copy the files. 

* Create a PDB by plugging an unplugged PDB or a non-CDB into a CDB 

Use the create_pdb_from_xml clause to plug an unplugged PDB or a non-CDB into a CDB, using an XML metadata file. 


Q27. 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: C,D 


Q28. You upgraded your database from pre-12c to a multitenant container database (CDB) containing pluggable databases (PDBs). 

Examine the query and its output: 

Which two tasks must you perform to add users with SYSBACKUP, SYSDG, and SYSKM privilege to the password file? 

A. Assign the appropriate operating system groups to SYSBACKUP, SYSDG, SYSKM. 

B. Grant SYSBACKUP, SYSDG, and SYSKM privileges to the intended users. 

C. Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege and the FORCE argument set to No. 

D. Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege, and FORCE arguments set to Yes. 

E. Re-create the password file in the Oracle Database 12c format. 

Answer: B,D 

Explanation: 

* orapwd 

/ You can create a database password file using the password file creation utility, 

ORAPWD. 

The syntax of the ORAPWD command is as follows: 

orapwd FILE=filename [ENTRIES=numusers] [FORCE={y|n}] [ASM={y|n}] 

[DBUNIQUENAME=dbname] [FORMAT={12|legacy}] [SYSBACKUP={y|n}] [SYSDG={y|n}] 

[SYSKM={y|n}] [DELETE={y|n}] [INPUT_FILE=input-fname] 

force - whether to overwrite existing file (optional), 

* v$PWFILE_users / 12c: V$PWFILE_USERS lists all users in the password file, and indicates whether the user has been granted the SYSDBA, SYSOPER, SYSASM, SYSBACKUP, SYSDG, and SYSKM privileges. 

/ 10c: sts users who have been granted SYSDBA and SYSOPER privileges as derived from the password file. 

ColumnDatatypeDescription USERNAMEVARCHAR2(30)The name of the user that is contained in the password file SYSDBAVARCHAR2(5)If TRUE, the user can connect with SYSDBA privileges SYSOPERVARCHAR2(5)If TRUE, the user can connect with SYSOPER privileges 

Incorrect: 

not E: The format of the v$PWFILE_users file is already in 12c format. 


Q29. Which two are prerequisites for performing a flashback transaction? 

A. Flashback Database must be enabled. 

B. Undo retention guarantee for the database must be configured. 

C. EXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back transaction. 

D. Supplemental logging must be enabled. 

E. Recycle bin must be enabled for the database. 

F. Block change tracking must be enabled tor the database. 

Answer: A,C 

Reference: Oracle Database Advanced Application Developer's Guide 11g, Using Oracle Flashback Technology 


Q30. 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: B,D 

Reference: http://docs.oracle.com/cd/E11882_01/server.112/e40540/logical.htm#CNCPT250