Certshared now are offering 100% pass ensure 1Z0-062 dumps!
https://www.certshared.com/exam/1Z0-062/ (379 Q&As)
Oracle
Exam Questions 1Z0-062
Oracle Database 12c: Installation and Administration
Guaranteed success with Our exam guides visit - https://www.certshared.com
Certshared now are offering 100% pass ensure 1Z0-062 dumps!
https://www.certshared.com/exam/1Z0-062/ (379 Q&As)
NEW QUESTION 1
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? (Choose two.)
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: AC
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.
References:
NEW QUESTION 2
Which two statements are true concerning dropping a pluggable database (PDB)? (Choose two.)
A. The PDB must be open in read-only mode.
B. The PDB must be in mount state.
C. The PDB must be unplugged.
D. The PDB data files are always removed from disk.
E. A dropped PDB can never be plugged back into a multitenant container database (CDB).
Answer: BC
Explanation:
References: http://docs.oracle.com/database/121/ADMIN/cdb_plug.htm#ADMIN13658
NEW QUESTION 3
You run a script that completes successfully using SQL*Plus that performs these actions:
1. Creates a multitenant container database (CDB)
2. Plugs in three pluggable databases (PDBs)
3. Shuts down the CDB instance
4. Starts up the CDB instance using STARTUP OPEN READ WRITE
Which two statements are true about the outcome after running the script? (Choose two.)
A. The seed will be in mount state.
B. The seed will be opened read-only.
C. The seed will be opened read/write.
D. The other PDBs will be in mount state.
E. The other PDBs will be opened read-only.
F. The PDBs will be opened read/write.
Answer: BD
Explanation:
B: The seed is always read-only.
D: Pluggable databases can be started and stopped using SQL*Plus commands or the ALTER PLUGGABLE DATABASE command.
NEW QUESTION 4
Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?
A. By default, EM express is available for a database after database creation.
B. You can use EM express to manage multiple databases running on the same server.
C. You can perform basic administrative tasks for pluggable databases by using the EM express interface.
D. You cannot start up or shut down a database Instance by using EM express.
E. You can create and configure pluggable databases by using EM express.
Answer: D
Explanation:
References: http://www.oracle.com/technetwork/database/manageability/emx-intro-1965965.html
Guaranteed success with Our exam guides visit - https://www.certshared.com
Certshared now are offering 100% pass ensure 1Z0-062 dumps!
https://www.certshared.com/exam/1Z0-062/ (379 Q&As)
NEW QUESTION 5
You created an encrypted tablespace:
You then closed the encryption wallet because you were advised that this is secure.
Later in the day, you attempt to create the EMPLOYEES table in the SECURESPACE tablespace with the SALT option on the EMPLOYEE column.
Which is true about the result?
A. It creates the table successfully but does not encrypt any inserted data in the EMPNAME column because the wallet must be opened to encrypt columns with
SALT.
B. It generates an error when creating the table because the wallet is closed.
C. It creates the table successfully, and encrypts any inserted data in the EMPNAME column because the wallet needs to be open only for tablespace creation.
D. It generates error when creating the table, because the salt option cannot be used with encrypted tablespaces.
Answer: B
NEW QUESTION 6
You want to prevent a group of users in your database from performing long-running transactions that consume huge amounts of space in the undo tablespace. If
the quota for these users is exceeded during execution of a data manipulation language (DML) statement, the operation should abort and return an error.
However, queries should still be allowed, even if users have exceeded the undo space limitation.
How would you achieve this?
A. Specify the maximum amount of quota a user can be allocated in the undo tablespace.
B. Decrease the number of Interested Transaction List (ITL) slots for the segments on which these users perform transactions.
C. Implement a profile for these users.
D. Implement a Database Resource Manager pla
Answer: D
NEW QUESTION 7
Your database is configured in ARCHIVELOG mode. Examine the RMAN configuration parameters:
Examine the command:
RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;
What is the outcome?
A. It fails because the DELETE INPUT option can be used only with the BACKUP AS BACKUPSET command.
B. It executes successfully and creates a backup set of the database along with archived log files and then deletes the original archived log files.
C. It executes successfully and creates an image copy of the database along with archive log files and then deletes the original archived log files.
D. It fails because the DELETE INPUT option can be used only with the BACKUP AS COPY command.
Answer: B
Explanation:
References: https://docs.oracle.com/cd/B13789_01/server.101/b10734/rcmbackp.htm
NEW QUESTION 8
You have just completed a manual upgrade of an Oracle 11g Database to Oracle Database 12c.
The Post-Upgrade Status Tool reports an INVALID status for some of the components after the upgrade. What must you do first in this situation to attempt to fix
this problem?
A. Run catuppst.sql to perform revalidation actions
B. Run utluiobj.sql to filter out objects that were invalidated by the upgrade process.
C. Run preupgrd.sql and then execute the generated “fix-up” scripts to resolve status issues.
D. Run utlrp.sql to recompile stored PL/SQL and Java code and check the DBA_REGISTRY vie
Answer: D
NEW QUESTION 9
You enabled an audit policy by issuing the following statements:
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SCOTT;
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SYS, SYSTEM;
For which database users and for which executions is the audit policy now active? Select two.
A. SYS, SYSTEM
B. SCOTT
C. Only for successful executions
Guaranteed success with Our exam guides visit - https://www.certshared.com
Certshared now are offering 100% pass ensure 1Z0-062 dumps!
https://www.certshared.com/exam/1Z0-062/ (379 Q&As)
D. Only for failed executions
E. Both successful and failed executions
Answer: AE
Explanation:
* The ORA_DATABASE_PARAMETER policy audits commonly used Oracle Database parameter settings. By default, this policy is not enabled.
NEW QUESTION 10
In order to exploit some new storage tiers that have been provisioned by a storage administrator, the partitions of a large heap table must be moved to other
tablespaces in your Oracle 12c database?
Both local and global partitioned B-tree Indexes are defined on the table.
A high volume of transactions access the table during the day and a medium volume of transactions access it at night and during weekends.
Minimal disrupt ion to availability is required.
Which three statements are true about this requirement? (Choose three.)
A. The partitions can be moved online to new tablespaces.
B. Global indexes must be rebuilt manually after moving the partitions.
C. The partitions can be compressed in the same tablespaces.
D. The partitions can be compressed in the new tablespaces.
E. Local indexes must be rebuilt manually after moving the partitions.
Answer: ACD
Explanation:
A: You can create and rebuild indexes online. Therefore, you can update base tables at the same time you are building or rebuilding indexes on that table. You can
perform DML operations while the index build is taking place, but DDL operations are not allowed. Parallel execution is not supported when creating or rebuilding
an index online.
D: Moving (Rebuilding) Index-Organized Tables
Because index-organized tables are primarily stored in a B-tree index, you can encounter fragmentation as a consequence of incremental updates. However, you
can use the ALTER TABLE...MOVE statement to rebuild the index and reduce this fragmentation.
C: If a table can be compressed in the new tablespace, also it can be compressed in the same tablespace. Incorrect:
Not B, not E: Local and Global indexes can be automatically rebuild with UPDATE INDEXES when you move the table.
NEW QUESTION 11
You Execute the Following command to create a password file in the database server: $ orapwd file = ‘+DATA/PROD/orapwprod entries = 5 ignorecase = N
format = 12’ Which two statements are true about the password file? (Choose two.)
A. It records the usernames and passwords of users when granted the DBA role.
B. It contains the usernames and passwords of users for whom auditing is enabled.
C. Is used by Oracle to authenticate users for remote database administration.
D. It records the usernames and passwords of all users when they are added to the OSDBA or OSOPER operating system groups.
E. It supports the SYSBACKUP, SYSDG, and SYSKM system privilege
Answer: CE
NEW QUESTION 12
Which three functions can be performed by the SQL Tuning Advisor? (Choose three.)
A. recommending creation of indexes based on SQL workload
B. recommending restructuring of SQL statements that have suboptimal plans
C. checking schema objects for missing and state statistics
D. recommending optimization of materialized views
E. generating SQL profiles
Answer: BCE
NEW QUESTION 13
The performance of your database degrades between 11:00 AM and 3:00 PM. Automatic Workload Repository (AWR) snapshots are collected on an hourly basis.
What is the most efficient way of diagnosing this problem?
A. Create a custom ADDM task for the period defined by the snapshots taken between 11:00 AM and 3:00 PM.
B. Analyze the latest Automatic Database Diagnostic Monitor (ADDM) report.
C. Analyze the hourly ADDM reports generated between 11:00 AM and 3:00 PM.
D. Create a SQL Tuning Set (STS) for the currently cached SQL statements in the shared pool and run SQL Performance Analyzer (SPA) to generate
recommendations.
Answer: A
NEW QUESTION 14
Which three file types are stored in the Fast Recovery Area by default in a traditional nonOMF file system? (Choose three.)
A. online redo log files
B. parameter file
C. multiplexed copies of the current control file
D. archived log files
E. Flashback Data Archive files
F. Flashback logs
Guaranteed success with Our exam guides visit - https://www.certshared.com
Certshared now are offering 100% pass ensure 1Z0-062 dumps!
https://www.certshared.com/exam/1Z0-062/ (379 Q&As)
Answer: ADF
NEW QUESTION 15
Which task is performed by a background process in a database instance?
A. Connecting between a client process and a dispatcher
B. Executing PL/SQL code
C. Creating dedicated server connections
D. Copying online redo log files to offline storage
Answer: D
NEW QUESTION 16
Your database is configured for ARCHIVELOG mode, and a daily full database backup is taken. RMAN is configured to perform control file autobackup.
In which three scenarios do you need media recovery? (Choose three.)
A. loss of all the copies of the control file
B. loss of all the inactive online redo log group members
C. loss of a data file that belongs to the active undo tablespace
D. loss of data files that belong to the SYSTEM tablespace
E. logical corruption of data that is caused by a wrong transaction
F. abnormal termination of the database instance
Answer: ACD
NEW QUESTION 17
You want to upgrade an Oracle Database running Oracle Database 11g to Oracle Database 12c. Which three tasks should be performed before a manual
upgrade? (Choose three.)
A. running preupgrad.sql in Oracle Database 11g to generate fix-up scripts and a log file
B. running utlu121s.sql from the new Oracle home to display information about the required initialization parameters
C. copying the initialization parameter file to the new Oracle home
D. copying the password file to the new Oracle home
E. copying net configuration files to the new Oracle home
Answer: ACE
NEW QUESTION 18
The HR user updates the salary of one of the employees in the non-partitioned EMPLOYEES table, but does not commit the transaction.
Which two types of lock exist in this situation? (Choose two.)
A. exclusive lock on the EMPLOYEES table
B. null lock on the row being updated
C. null lock on the EMPLOYEES table
D. row level lock on the row being updated
E. shared lock on the EMPLOYEES table
Answer: DE
NEW QUESTION 19
Which two statements are true about resumable space allocation? (Choose two.)
A. A database-level LOGON trigger can be used to automatically configure resumable statement settings for individual sessions.
B. SELECT statements that run out of temporary space for sort areas are candidates for resumable execution.
C. A resumable statement can be suspended and resumed only once during a session.
D. Resumable space allocation does not apply when a database instance uses asynchronous commit.
E. Resumable space allocation does not apply when users exceed their assigned space quota in a tablespace.
F. Free space in a segment is automatically reclaimed when a resumable statement is suspended because of an out-of- space condition.
Answer: AB
NEW QUESTION 20
Which statement is true about redo log files during instance recovery?
A. All current, online, and archived redo logs are required to complete instance recovery.
B. All redo log entries in the current and active logs are applied to data files to reconstruct changes made after the most recent checkpoint.
C. All redo log entries in the current log are applied to data files until the checkpoint position is reached.
D. All current, active, and inactive redo logs are required to complete instance recovery.
Answer: C
Explanation:
References https://docs.oracle.com/cd/A58617_01/server.804/a58396/ch2.htm
NEW QUESTION 21
Guaranteed success with Our exam guides visit - https://www.certshared.com
Certshared now are offering 100% pass ensure 1Z0-062 dumps!
https://www.certshared.com/exam/1Z0-062/ (379 Q&As)
......
Guaranteed success with Our exam guides visit - https://www.certshared.com
Certshared now are offering 100% pass ensure 1Z0-062 dumps!
https://www.certshared.com/exam/1Z0-062/ (379 Q&As)
Thank You for Trying Our Product
We offer two products:
1st - We have Practice Tests Software with Actual Exam Questions
2nd - Questons and Answers in PDF Format
1Z0-062 Practice Exam Features:
* 1Z0-062 Questions and Answers Updated Frequently
* 1Z0-062 Practice Questions Verified by Expert Senior Certified Staff
* 1Z0-062 Most Realistic Questions that Guarantee you a Pass on Your FirstTry
* 1Z0-062 Practice Test Questions in Multiple Choice Formats and Updatesfor 1 Year
100% Actual & Verified — Instant Download, Please Click
Order The 1Z0-062 Practice Test Here
Guaranteed success with Our exam guides visit - https://www.certshared.com
Powered by TCPDF (www.tcpdf.org)
