Pass Oracle Oracle Database 12c: Installation and Administration Exam in First Attempt Guaranteed Updated Dump from PrepAwayETE!
Pass 1z0-062 Exam with 380 Questions - Verified By PrepAwayETE
NEW QUESTION 28
Which three statements are true about space usage alerts? (Choose three.)
- A. Alerts are issued only when the critical threshold for space available in a tablespace is breached.
- B. Database alerts can provide warnings about low space availability at both tablespace and segment levels.
- C. A newly created locally managed tablespace is automatically assigned the default threshold values defined for a database.
- D. The sum of active extents and allocated user quotas is considered to compute space usage for an undo tablespace.
- E. Alerts are not issued for locally managed tablespaces that are offline or in read-only mode.
Answer: A,C,E
Explanation:
References: https://docs.oracle.com/cd/B28359_01/server.111/b28310/schema001.htm#ADMIN10120
NEW QUESTION 29
You use a recovery catalog for maintaining your database backups.
You execute the following command:
$rman TARGET / CATALOG rman / cat@catdb
RMAN > BACKUP VALIDATE DATABASE ARCHIVELOG ALL;
Which two statements are true? (Choose two.)
- A. Checks are performed to confirm whether all database files exist in correct locations
- B. Checks are performed for physical corruptions.
- C. Corrupted blocks, if any, are repaired.
- D. Backup sets containing both data files and archive logs are created.
- E. Checks are performed for logical corruptions.
Answer: A,B
Explanation:
Explanation
B (not C): You can validate that all database files and archived redo logs can be backed up by running a command as follows:
RMAN> BACKUP VALIDATE DATABASE ARCHIVELOG ALL;
This form of the command would check for physical corruption. To check for logical corruption, RMAN> BACKUP VALIDATE CHECK LOGICAL DATABASE ARCHIVELOG ALL; D: You can use the VALIDATE keyword of the BACKUP command to do the following:
Check datafiles for physical and logical corruption
Confirm that all database files exist and are in the correct locations.
Note:
You can use the VALIDATE option of the BACKUP command to verify that database files exist and are in the correct locations (D), and have no physical or logical corruptions that would prevent RMAN from creating backups of them. When performing a BACKUP...VALIDATE, RMAN reads the files to be backed up in their entirety, as it would during a real backup. It does not, however, actually produce any backup sets or image copies (Not A, not E).
NEW QUESTION 30
Your database supports an online transaction processing (OLTP) workload in which one of the applications creates a temporary table for a session and performs transactions on it.
This consumes a lot of undo tablespace and generates lots of redo.
Which two actions would you take to solve this problem? (Choose two.)
- A. Enable undo retention guarantee.
- B. Increase the size of the redo log buffer.
- C. Increase the size of the temporary tablespace.
- D. Enable temporary undo for the database.
- E. Enable Automatic Memory Management (AMM).
Answer: C,D
NEW QUESTION 31
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. A dropped PDB can never be plugged back into a multitenant container database (CDB).
- D. The PDB must be unplugged.
- E. The PDB data files are always removed from disk.
Answer: B,D
Explanation:
References:
http://docs.oracle.com/database/121/ADMIN/cdb_plug.htm#ADMIN13658
NEW QUESTION 32
You have successfully taken a database backup by using the command:
RMAN> BACKUP AS BACKUPSET DATABASE;
Now you execute this command:
RMAN> BACKUP INCREMENTAL LEVEL 1 DATABASE;
What is the outcome?
- A. It first takes an incremental level 0 backup and then an incremental level 1 backup.
- B. It fails because an incremental level 0 backup does not exist.
- C. It takes a backup of blocks that have been formatted since the last full database backup.
- D. It fails because an incremental level 1 backup always searches for an image copy as level 0 backup.
- E. It takes an incremental level 0 backup of the database.
Answer: A
Explanation:
Explanation/Reference:
References: https://docs.oracle.com/cd/B19306_01/backup.102/b14192/bkup004.htm (4.4.1.2)
NEW QUESTION 33
You find this query being used in your Oracle 12c database:
Which method a used by the optimizer to limit the rows being returned?
- A. A TOP-N query is created to limit the rows to 20 percent of the total rows
- B. A filter is added to the table query dynamically using ROWNUM to limit the rows to 20 percent of the total rows
- C. All the rows are returned to the client or middle tier but only the first 20 percent are returned to the screen or the application.
- D. A view is created during execution and a filter on the view limits the rows to 20 percent of the total rows.
Answer: D
NEW QUESTION 34
Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information lifecycle Management (ILM)? (Choose three.)
- A. Tracking the most recent write time for a table segment in the SYSAUX tablespace
- B. Tracking the most recent write time for a table block
- C. Tracking insert time by row for table rows
- D. Tracking the most recent read time for a table segment in a user tablespace
- E. Tracking the most recent read time for a table segment in the SYSAUX tablespace
- F. Tracking the most recent write time for a table segment in a user tablespace
Answer: B,D,F
Explanation:
Explanation/Reference:
Explanation:
Incorrect:
Not E, Not F When Heat Map is enabled, all accesses are tracked by the in-memory activity tracking module. Objects in the SYSTEM and SYSAUX tablespaces are not tracked.
* To implement your ILM strategy, you can use Heat Map in Oracle Database to track data access and modification.
Heat Map provides data access tracking at the segment-level and data modification tracking at the segment and row level.
* To implement your ILM strategy, you can use Heat Map in Oracle Database to track data access and modification. You can also use Automatic Data Optimization (ADO) to automate the compression and movement of data between different tiers of storage within the database.
References:
NEW QUESTION 35
Which two statements are true about SQL *Loader Express Mode in an Oracle 12c database?
- A. The DEGREE_OF_PARALLELISM parameter is set to AUTO.
- B. You can selectively load rows into a table based on a filer.
- C. You can have multiple bad files created when loading in parallel.
- D. You cannot have multiple SQL *Loader data files.
- E. If no data file is specified, it assumes the data file to be <table-name>.dat in the current directory and uses it.
Answer: A,C
NEW QUESTION 36
Which two are prerequisites for performing a flashback transaction? (Choose two.)
- A. Flashback Database must be enabled.
- B. EXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back
transaction. - C. Recycle bin must be enabled for the database.
- D. Undo retention guarantee for the database must be configured.
- E. Block change tracking must be enabled tor the database.
- F. Supplemental logging must be enabled.
Answer: D,F
Explanation:
Explanation/Reference:
Explanation:
References: http://searchoracle.techtarget.com/tip/How-to-perform-Oracle-Flashback-Transaction-Queries
https://docs.oracle.com/cd/E11882_01/appdev.112/e41502/adfns_flashback.htm#ADFNS610
NEW QUESTION 37
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. There are frequent logons and logoffs.
- B. A large number COMMITS are being performed.
- C. The size of the shared pool is too small.
- D. The buffers are being read into the buffer cache, but some other session is changing the buffers.
- E. Cursors are not being shared.
Answer: A,C,E
NEW QUESTION 38
You are required to migrate your 11.2.0.3 database as a pluggable database (PDB) to a multitenant container database (CDB).
The following are the possible steps to accomplish this task:
1. Place all the user-defined tablespace in read-only mode on the source database.
2. Upgrade the source database to a 12c version.
3. Create a new PDB in the target container database.
4. Perform a full transportable export on the source database with the VERSION parameter set to 12 using the expdp utility.
5. Copy the associated data files and export the dump file to the desired location in the target database.
6. Invoke the Data Pump import utility on the new PDB database as a user with the DATAPUMP_IMP_FULL_DATABASE role and specify the full transportable import options.
7. Synchronize the PDB on the target container database by using the DBMS_PDS.SYNC_ODB function.
Identify the correct order of the required steps.
- A. 1, 5, 6, 4, 3, 2
- B. 2, 1, 3, 4, 5, 6
- C. 2, 1, 3, 4, 5, 6, 7
- D. 1, 3, 4, 5, 6, 7
- E. 1, 4, 3, 5, 6, 7
Answer: E
Explanation:
1. Set user tablespaces in the source database to READ ONLY.
2. From the Oracle Database 11g Release 2 {11.2.0.3) environment, export the metadata and any data residing in administrative tablespaces from the source database using the FULL=Y and TRANSPORTABLE=ALWAYS parameters. Note that the VER$ION=12 parameter is required only when exporting from an Oracle Database llg Release 2 database:
3. Copy the tablespace data files from the source system to the destination system. Note that the log file from the export operation will list the data files required to be moved.
4. Create a COB on the destination system, including a PDB into which you will import the source database.
5. In the Oracle Database 12c environment, connect to the pre-created PDB and import the dump file. The act of importing the dump file will plug the tablespace data files into the destination PDB
Oracle White Paper - Upgrading to Oracle Database 12c -August 2013
NEW QUESTION 39
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 plug an Oracle 12c non-CDB database into an existing CDB.
- D. 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.
- E. Use the DBMS_PDB package to clone an existing PDB.
Answer: A,C,E
Explanation:
Explanation/Reference:
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.
NEW QUESTION 40
Your multitenant container database (CDB) contains some pluggable databases (PDBs), you execute the following
command in the root container:
Which two statements are true?
- A. The command will create a user in the root container only because the container clause is not used.
- B. The command will, create a common user whose description is contained in the root and each PDB.
- C. The schema for the common user C # # A_ADMIN can be different in each container.
- D. The C # # A_ADMIN user will be able to use the TEMP_TS temporary tablespace only in root.
- E. Schema objects owned by the C# # A_ADMIN common user can be shared across all PDBs.
Answer: B,C
NEW QUESTION 41
Which two statements are true about a server parameter file (SPFILE)? (Choose two.)
- A. An SPFILE contains only those dynamic parameters that can be changed without having to restart the
database instance. - B. An SPFILE can be created only before a database instance is started.
- C. An SPFILE must reside in the ORACLE_HOME/dbsdirectory.
- D. A PFILE can be used to start up a database instance even if an SPFILE exists.
- E. An SPFILE can be created from a PFILE or from memory.
Answer: D,E
NEW QUESTION 42
Identify three scenarios in which you would recommend the use of SQL Performance Analyzer to analyze impact on the performance of SQL statements.
- A. Change in the Oracle Database version
- B. Migration of database storage from non-ASM to ASM storage
- C. Change in your network infrastructure
- D. Database and operating system upgrade
- E. Change in the hardware configuration of the database server
Answer: A,D,E
Explanation:
Explanation/Reference:
Explanation:
Oracle 11g/12c makes further use of SQL tuning sets with the SQL Performance Analyzer, which compares the performance of the statements in a tuning set before and after a database change. The database change can be as major or minor as you like, such as:
* (E) Database, operating system, or hardware upgrades.
* (A,C) Database, operating system, or hardware configuration changes.
* Database initialization parameter changes.
* Schema changes, such as adding indexes or materialized views.
* Refreshing optimizer statistics.
* Creating or changing SQL profiles.
NEW QUESTION 43
Your multitenant container database, CDB1, is running in ARCHIVELOG mode and has two pluggable databases, HR_PDB and ACCOUNTS_PDB. An RMAN backup exists for the database.
You issue the command to open ACCOUNTS_PDB and find that the USERDATA.DBF data file for the default permanent tablespace USERDATA belonging to ACCOUNTS_PDB is corrupted.
What should you do before executing the commands to restore and recover the data file in ACCOUNTS_PDB?
- A. Take the USERDATA tablespace offline in ACCOUNTS_PDB.
- B. Place CDB1 in the mount stage and then the USERDATA tablespace offline in ACCOUNTS_PDB.
- C. Place CDB1 in the mount stage and issue the ALTER PLUGGABLE DATABASE accounts_pdb CLOSE IMMEDIATE command.
- D. Issue the ALTER PLUGGABLE DATABASE accounts_pdb RESTRICTED command.
Answer: A
Explanation:
* You can take an online tablespace offline so that it is temporarily unavailable for general use. The rest of the database remains open and available for users to access data. Conversely, you can bring an offline tablespace online to make the schema objects within the tablespace available to database users. The database must be open to alter the availability of a tablespace.
NEW QUESTION 44
Which three statements are true about Automatic Workload Repository (AWR)?
- A. The snapshots collected by AWR are used by the self-tuning components in the database
- B. The AWR data is stored in memory and in the database.
- C. All AWR tables belong to the SYSTEM schema.
- D. AWR computes time model statistics based on time usage for activities, which are displayed in the v$SYS time model and V$SESS_TIME_MODEL views.
- E. AWR contains system wide tracing and logging information.
Answer: A,B,E
Explanation:
Explanation/Reference:
Explanation:
* A fundamental aspect of the workload repository is that it collects and persists database performance data in a manner that enables historical performance analysis.
The mechanism for this is the AWR snapshot. On a periodic basis, AWR takes a "snapshot" of the current statistic values stored in the database instance's memory and persists them to its tables residing in the SYSAUX tablespace.
* AWR is primarily designed to provide input to higherlevel components such as automatic tuning algorithms and advisors, but can also provide a wealth of information for the manual tuning process.
NEW QUESTION 45
Your production database uses file system storage. You want to move storage to Oracle Automatic Storage
Management (ASM).
How would you achieve this?
- A. by using RMAN
- B. by using the Database Upgrade Assistant (DBUA)
- C. by using a transportable database
- D. by using Data Pump
Answer: A
Explanation:
References:
http://docs.oracle.com/cd/E11882_01/server.112/e18951.pdf (p.184)
NEW QUESTION 46
Examine these two statements:
Which three are true about the MRKT tablespace?
- A. The MRKT tablespace may be dropped if it has no contents.
- B. Users who were using the old default tablespace will have their default tablespaces changed to the MRKT tablespace.
- C. The relative file number of the tablespace is not stored in rowids for the table rows that are stored in the MRKT tablespace.
- D. The MRKT tablespace is created as a small file tablespace, because the file size is less than the minimum required for big file files.
- E. No more data files can be added to the tablespace.
Answer: A,B,E
Explanation:
Explanation/Reference:
Explanation:
NEW QUESTION 47
Which two statements are true about Oracle Managed Files (OMF)?
- A. OMF may affect the location of the redo log files and archived log files.
- B. The file system directions that are specified by OMF parameters are created automatically.
- C. OMF automatically creates unique file names for table spaces and control files.
- D. OMF cannot be used in a database that already has data files created with user-specified directions.
- E. OMF can be used with ASM disk groups, as well as with raw devices, for better file management.
Answer: A,C
Explanation:
Explanation/Reference:
Explanation:
D: The database internally uses standard file system interfaces to create and delete files as needed for the following database structures:
Tablespaces
Redo log files
Control files
Archived logs
Block change tracking files
Flashback logs
RMAN backups
Note:
* Using Oracle-managed files simplifies the administration of an Oracle Database. Oracle-managed files eliminate the need for you, the DBA, to directly manage the operating system files that make up an Oracle Database. With Oracle-managed files, you specify file system directories in which the database automatically creates, names, and manages files at the database object level. For example, you need only specify that you want to create a tablespace; you do not need to specify the name and path of the tablespace's datafile with the DATAFILE clause.
http://www.oracle-base.com/articles/9i/oracle-managed-files.php
http://docs.oracle.com/cd/B10500_01/server.920/a96521/omf.htm
References:
NEW QUESTION 48
You notice a high number of waits for the db file scattered read and db file sequential read events in the recent Automatic Database Diagnostic Monitor (ADDM) report. After further investigation, you find that queries are performing too many full table scans and indexes are not being used even though the filter columns are indexed.
Identify three possible reasons for this.
- A. Oversized buffer cache
- B. Undersized shared pool
- C. High clustering factor for the indexes
- D. High value for the DB_FILE_MULTIBLOCK_READ_COUNT parameter
- E. Missing or stale histogram statistics
Answer: C,D,E
Explanation:
D: DB_FILE_MULTIBLOCK_READ_COUNT is one of the parameters you can use to minimize I/O during table scans. It specifies the maximum number of blocks read in one I/O operation during a sequential scan. The total number of I/Os needed to perform a full table scan depends on such factors as the size of the table, the multiblock read count, and whether parallel execution is being utilized for the operation.
NEW QUESTION 49
Which three statements are true about windows? (Choose three.)
- A. Windows work with job classes to control resource allocation
- B. Windows can automatically start job or change resource allocation among jobs for various time periods
- C. Only one window can be open at any given time
- D. Consumer groups are associated with windows
- E. The database service name must be provided during windows creation
Answer: A,B,C
NEW QUESTION 50
To implement Automatic Management (AMM), you set the following parameters:
When you try to start the database instance with these parameter settings, you receive the following error message:
SQL > startup
ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information.
Identify the reason the instance failed to start.
- A. The STATISTICS_LEVEL parameter is set to BASIC.
- B. The PGA_AGGREGATE_TARGET parameter is set to zero.
- C. The SGA_MAX_SIZE and SGA_TARGET parameter values are not equal.
- D. Both the SGA_TARGET and MEMORY_TARGET parameters are set.
Answer: A
Explanation:
Example:
SQL> startup force
ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings ORA-00848: STATISTICS_LEVEL cannot be set to BASIC with SGA_TARGET or
MEMORY_TARGET
NEW QUESTION 51
......
Penetration testers simulate 1z0-062 exam: https://www.prepawayete.com/Oracle/1z0-062-practice-exam-dumps.html
Free Test Engine For Oracle Database 12c: Installation and Administration Certification Exams: https://drive.google.com/open?id=1kwyDw8kGZ7XRZRHvG8RrlOAsV_5V9XZt