[Nov 11, 2021] 1z0-062 Exam Dumps - Oracle Practice Test Questions
New Real 1z0-062 Exam Dumps Questions
Conclusion
In summary, it should be recalled that Oracle Database 12c designations accentuate the full set of skills required to work with the DBMS for daily operational management and maintenance. Currently, in the competitive market, it is common practice to validate your skills and experience through certification by nailing the corresponding exam. So, successfully passing the Oracle Database 12c Administration 1Z0-062 test will not only be a shining point on your CV but will also open new doors for you on your path to mastering the Oracle Database environment. All you have to do is make a firm decision, register for the actual exam, and start preparing. You have all the power here!
NEW QUESTION 41
Which three statements are true concerning the multitenant architecture? (Choose three.)
- A. Different PDBs can have different default block sizes.
- B. PDBs share a common system tablespace.
- C. Instance recovery is always performed at the CDB level.
- D. A PDB can have a private temp tablespace.
- E. Each pluggable database (PDB) has its own set of background processes.
- F. PDBs can share the sysaux tablespace.
- G. Log switches occur only at the multitenant container database (CDB) level.
Answer: C,D,G
Explanation:
Explanation
B:
* A PDB would have its SYSTEM, SYSAUX, TEMP tablespaces. It can also contains other user created tablespaces in it.
* There is one default temporary tablespace for the entire CDB. However, you can create additional temporary tablespaces in individual PDBs.
D:
* There is a single redo log and a single control file for an entire CDB
* A log switch is the point at which the database stops writing to one redo log file and begins writing to another. Normally, a log switch occurs when the current redo log file is completely filled and writing must continue to the next redo log file.
G: instance recovery
The automatic application of redo log records to uncommitted data blocks when an database instance is restarted after a failure.
Incorrect:
Not A:
* There is one set of background processes shared by the root and all PDBs.
* High consolidation density. The many pluggable databases in a single container database share its memory and background processes, letting you operate many more pluggable databases on a particular platform than you can single databases that use the old architecture.
Not C: There is a separate SYSAUX tablespace for the root and for each PDB.
Not F: There is a separate SYSTEM tablespace for the root and for each PDB.
NEW QUESTION 42
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. Stack space
- B. Location of a part of the runtime area for SELECT statements
- C. Location of the runtime area for DML and DDL Statements
- D. User session data
- E. Private SQL area
Answer: D,E
Explanation:
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 43
Unified auditing is enabled in your database. The HR_ADMINand OE_ADMINroles exist and are granted
system privileges.
You execute the command:
SQL>CREATE AUDIT POLICY tab1e_aud PRIVILEGES CREATE ANY TABLE, DROP ANY TABLE
ROLES
hr_admin, oe_admin;
Which statement is true?
- A. It succeeds and starts capturing only successful SQL statements for all users who have either the
specified privileges or roles granted to them. - B. It succeeds and needs to be enabled to capture all SQL statements that require either the specified
privileges or any privilege granted to the HR_ADMINand OE_ADMINrole. - C. It fails because the command does not specify when the unified audit policy should be enforced.
- D. It fails because system privileges cannot be granted with roles in the same audit policy.
Answer: A
NEW QUESTION 44
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?
- A. The partitions can be compressed in the same tablespaces.
- B. Global indexes must be rebuilt manually after moving the partitions.
- C. The partitions can be moved online to new tablespaces.
- D. Local indexes must be rebuilt manually after moving the partitions.
- E. The partitions can be compressed in the new tablespaces.
Answer: A,C,E
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 45
A warehouse fact table in your Oracle 12c Database is range-partitioned by month and accessed frequently with queries that span multiple partitions
The table has a local prefixed, range partitioned index.
Some of these queries access very few rows in some partitions and all the rows in other partitions, but these queries still perform a full scan for all accessed partitions.
This commonly occurs when the range of dates begins at the end of a month or ends close to the start of a month.
You want an execution plan to be generated that uses indexed access when only a few rows are accessed from a segment, while still allowing full scans for segments where many rows are returned.
Which three methods could transparently help to achieve this result?
- A. Using a partial local Index on the warehouse fact table month column with indexing disabled for the table partitions that return a few rows to the queries.
- B. Using a partial global index on the warehouse fact table month column with indexing disabling for the table partitions that return most of their rows to the queries.
- C. Using a partial global index on the warehouse fact table month column with indexing disabled for the table partitions that return a few rows to the queries.
- D. Using a partial local Index on the warehouse fact table month column with indexing disabled to the table partitions that return most of their rows to the queries.
- E. Converting the partitioned table to a partitioned view that does a UNION ALL query on the monthly tables, which retains the existing local partitioned column.
- F. Using a partitioned view that does a UNION ALL query on the partitions of the warehouse fact table, which retains the existing local partitioned column.
Answer: A,B,F
Explanation:
Note:
* Oracle 12c now provides the ability to index a subset of partitions and to exclude the others.
Local and global indexes can now be created on a subset of the partitions of a table. Partial Global indexes provide more flexibility in index creation for partitioned tables. For example, index segments can be omitted for the most recent partitions to ensure maximum data ingest rates without impacting the overall data model and access for the partitioned object.
Partial Global Indexes save space and improve performance during loads and queries. This feature supports global indexes that include or index a certain subset of table partitions or subpartitions, and exclude the others. This operation is supported using a default table indexing property. When a table is created or altered, a default indexing property can be specified for the table or its partitions.
NEW QUESTION 46
On your Oracle 12c database, you Issue the following commands to create indexes SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customers_id, sales_rep_id) INVISIBLE; SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customers_id, sales_rep_id); Which two statements are correct? (Choose two.)
- A. Only the ORD_CUSTOMER_IX2 index is created.
- B. Only the ORD_CUSTOMER_IX1 index is created.
- C. The optimizer evaluates index access from both the Indexes before deciding on which index to use for query execution plan.
- D. Both the indexes are updated when a new row is inserted, updated, or deleted In the orders table.
- E. Both the indexes are created; however, only the ORD_COSTOMER index is visible.
Answer: D,E
Explanation:
Explanation/Reference:
Explanation:
11G has a new feature called Invisible Indexes. An invisible index is invisible to the optimizer as default.
Using this feature we can test a new index without effecting the execution plans of the existing sql statements or we can test the effect of dropping an index without dropping it.
NEW QUESTION 47
A database is open READ WRITE and the instance has multiple sessions some of which have active
transactions.
You execute this command:
SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;
Which three are true about the active transactions? (Choose three.)
- A. They may issue COMMIT OR ROLLBACK statements
- B. They may continue to issue DML statements
- C. They are terminated immediately
- D. They may continue to issue queries
- E. They are rolled back automatically
- F. They are suspended and unable to issue any statements
Answer: C,E,F
NEW QUESTION 48
Your database is in ARCHIVELOG mode.
You want to disable archiving for the database.
Examine these steps:
1. Execute the ALTER DATABASE NOARCHIVELOGcommand
2. Execute SHUTDOWN IMMEDIATE
3. Execute STARTUP MOUNT
4. Set the DB_RECOVERY_FILE_DESTparameter to $ORACLE_HOME/dbs/
5. Execute STARTUP NOMOUNT
6. Open the database
7. Execute SHUTDOWN TRANSACTIONAL
Identify the required steps in the correct sequence.
- A. 4, 2, 5, 1, 6
- B. 2, 3, 1, 6
- C. 1, 2, 3, 4, 6
- D. 2, 5, 1, 6
Answer: D
Explanation:
Explanation/Reference: http://dba-oracle.com/bk_disable_archive_log_mode.htm
NEW QUESTION 49
Identify the persistent configuration setting for the target database that can be set for the backup by using RMAN. (Choose all that apply.)
- A. Default destinations for backups
- B. Multiple backup device types for single backup
- C. Default backup device type
- D. Default section size for backups
- E. Backup retention policy
Answer: A,C,E
Explanation:
Explanation
http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmconfb.htm#BRADV89399
NEW QUESTION 50
What are two benefits of installing Grid Infrastructure software for a stand-alone server before installing and creating an Oracle database?
- A. Enables the Installation of Grid Infrastructure files on block or raw devices.
- B. Effectively implements role separation
- C. Enables you to take advantage of Oracle Managed Files.
- D. Helps you to easily upgrade the database from a prior release.
- E. Automaticallyregisters the database with Oracle Restart.
Answer: B,E
Explanation:
C: To use Oracle ASM or Oracle Restart, you must first install Oracle Grid Infrastructure for a standalone server before you install and create the database. Otherwise, you must manually register the database with Oracle Restart.
Desupport of Block and Raw Devices
With the release of Oracle Database 11g release 2 (11.2) and Oracle RAC 11g release 2
(11.2), using Database Configuration Assistant or the installer to store Oracle Clusterware or Oracle Database files directly on block or raw devices is not supported.
If you intend to upgrade an existing Oracle RAC database, or an Oracle RAC database with Oracle ASM instances, then you can use an existing raw or block device partition, and perform a rolling upgrade of your existing installation. Performing a new installation using block or raw devices is not allowed.
References:
NEW QUESTION 51
Your database is running in NOARCHIVLOG mode.
Examine the following parameters:
You execute the following command after performing a STARTUP MOUNT:
SQL> ALTER DATABASE ARCHIVELOG;
Which statement is true about the execution of the command?
- A. It executes successfully and issues a warning to set LOG_ARCHIVE_DEST while opening the database.
- B. It executes successfully and sets the Fast Recovery Area as the local archive destination.
- C. It executes successfully and sets $ORACLE_HOME/dbs as the default archive destination.
- D. It fails and returns an error about LOG_ARCHIVE_DEST not being set.
Answer: B
NEW QUESTION 52
Which three operations can be performed as multipartition operations in Oracle?
- A. Move partitions of a range-partitioned table
- B. Drop partitions of a list partitioned table
- C. Merge partitions of a list partitioned table
- D. Merge partitions of a reference partitioned index
- E. Coalesce partitions of a hash-partitioned global index.
- F. Rename partitions of a range partitioned table
Answer: B,C,D
Explanation:
Multipartition maintenance enables adding, dropping, truncate, merge, split operations on multiple partitions.
A: Merge Multiple Partitions:
The new "ALTER TABLE ... MERGE PARTITIONS " help merge multiple partitions or subpartitions with a single statement. When merging multiple partitions, local and global index operations and semantics for inheritance of unspecified physical attributes are the same for merging two partitions.
B: Drop Multiple Partitions:
The new "ALTER TABLE ... DROP PARTITIONS " help drop multiple partitions or subpartitions
with a single statement.
Example:
view plaincopy to clipboardprint?
SQL> ALTER TABLE Tab_tst1 DROP PARTITIONS
Tab_tst1_PART5, Tab_tst1_PART6, Tab_tst1_PART7;
Table altered
SQL>
Restrictions :
-You can't drop all partitions of the table.
-If the table has a single partition, you will get the error: ORA-14083: cannot drop the only partition of a partitioned.
NEW QUESTION 53
Your database instance has the following parameter setting:
OS_AUTHENT_PREFIX = OPS$
You execute the following command:
And then grant OPS$GUEST_USER the CREATE SESSION privilege.
Which two statements are true? (Choose two.)
- A. GUEST_USER can log on to the database without specifying a username and password.
- B. GUEST_USER is forced to change the password at the first login.
- C. The authentication details for GUEST_USER are stored in the database password file.
- D. A local GUEST_USER OS account should exist before GUEST_USER can log on to the database.
- E. GUEST_USER can query the tables created in the USERS tablespace by default.
Answer: A,D
NEW QUESTION 54
The schema SALES exists in two databases, ORCL1 and ORCL2, and has the same password, SALES123.
User SALES has CREATE DATABASE LINK and CREATE SESSION privileges on both databases.
Examine these commands:
Conn SALES/SALES123
CREATE DATABASE LINK orcl2 USING 'orcl2';
What is the outcome of executing these commands in the ORCL1 database?
- A. ORCL2 database link creation fails.
- B. ORCL2 is created as a private database link to connect to only the SALES schema in the ORCL2 database.
- C. ORCL2 is created as a shared database link to connect multiple sessions to the SALES schema in the ORCL2 database.
- D. ORCL2 is created as a public database link to connect a single session to the SALES schema in the ORCL2 database.
Answer: B
NEW QUESTION 55
Which two statements are true about the (PMON) background process in Oracle Database 12c?
- A. It frees resources held by abnormally terminated processes.
- B. It kills sessions that exceed idle time.
- C. It frees unused temporary segments.
- D. It registers database services with all local and remote listeners known to the database instance.
- E. It records checkpoint information in the control file.
Answer: A,D
Explanation:
References:
https://docs.oracle.com/database/122/CNCPT/process-architecture.htm#CNCPT9840
NEW QUESTION 56
Your database is configured in ARCHIVELOG mode.
Examine the RMAN configuration parameters:
Examine the command:
RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;
Which two are true? (Choose two.)
- A. It creates image copies of the database files
- B. It creates a backupset of archive log files
- C. It fails because the DELETE INPUT option can be used only with the BACKUP AS COPY command
- D. It fails because the DELETE INPUT option can be used only with the BACKUP AS BACKUPSET command
- E. It creates image copies of the archivelogs
Answer: D,E
NEW QUESTION 57
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 Data Pump
- B. by using the Database Upgrade Assistant (DBUA)
- C. by using a transportable database
- D. by using RMAN
Answer: D
Explanation:
References: http://docs.oracle.com/cd/E11882_01/server.112/e18951.pdf (p.184)
NEW QUESTION 58
You are connected using SQL* Plus to a multitenant container database (CDB) with SYSDBA privileges and execute the
following sequence statements:
What is the result of the last SET CONTAINER statement and why is it so?
- A. It succeeds because the PDB_ADMIN user has the required privileges.
- B. It fails because local users are unable to use the SET CONTAINER statement.
- C. It fails because common users are unable to use the SET CONTAINER statement.
- D. If fails because the SET CONTAINER statement cannot be used with PDB$SEED as the target pluggable database
(PDB).
Answer: B
NEW QUESTION 59
Which statement is true about redo log files during instance recovery?
- A. All redo log entries in the current and active logs are applied to data files to reconstruct changes made after the
most recent checkpoint. - B. All current, online, and archived redo logs are required to complete instance recovery.
- 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
NEW QUESTION 60
You are using RMAN to back up your database. All the data files are in read/write mode.
Examine the RMAN configuration parameters:
Which two statements are true about a whole consistent backup of a database running in ARCHIVELOG
mode? (Choose two.)
- A. The database instance must be shut down to take the backup.
- B. The database must be in MOUNT state to take the backup.
- C. The system Change Number (SCN) is the same for all the data files in the backup.
- D. The backup can be used as an incremental level 0 backup.
- E. The backup consists of blocks that have been formatted.
Answer: A,C
NEW QUESTION 61
Examine the resources consumed by a database instance whose current Resource Manager plan is displayed.
SQL> SELECT name, active_sessions, queue_length,
Consumed_cpu_time, cpu_waits, cpu_wait_time
FROM v$rsrc_consumer_group;
NAMEACTIVE_SESSIONS QUEUE_LENGTH CONSUMED_CPU_WAITS
CPU_WAIT_TIME
----------------------------------- -------------------- -------------------- --------------------- ----------------
OLTP__ORDER__ENTRY1029690 467
6709
OTHES__GROUPS 0 059823664089
60425
SYS_GROUP 1 02420704 914
19540
DS.S_QUERIES4245946603004
55700
Which two statements are true?
- A. An attempt to start a new session by a user belonging to OTHE_GROUPS fails with an error.
- B. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due
to I/O waits and latch or enqueue contention. - C. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due
to resource management. - D. An attempt to start a new session by a user belonging to DSS_QUERIES fails with an error.
- E. A user belonging to the DSS__QUERIES resource consumer group can create a new session but the session will be
queued.
Answer: C,E
NEW QUESTION 62
The user SCOTT owns the CUST table that is placed in the SALES tablespace. The user SCOTT opens a session and executes commands as follows:
SQL> INSERT INTO cust VALUES(101, 'JACK');
1 row created.
SQL> INSERT INTO cust VALUES(102, 'SMITH');
1 row created.
As a DBA, you execute the following command from another session:
ALTER TABLESPACE sales READ ONLY;
Which statement is true regarding the effect of this command on the transaction in Scott's session?
- A. The command fails as a transaction is still pending.
- B. The command waits and the user SCOTT can execute data manipulation language (DML) statements only as part of the current transaction.
- C. The command hangs until all transactions on the objects in the tablespace commit or rollback, and then the tablespace is placed in readonly mode.
- D. The transaction in Scott's session is rolled back and the tablespace becomes readonly.
Answer: C
NEW QUESTION 63
What happens if a maintenance window closes before a job that collects optimizer statistics completes?
- A. The job continues to run until all statistics are gathered.
- B. The job is terminated and statistics for the remaining objects are collected the next time the maintenance window opens.
- C. The job is terminated but the gathered statistics are not published.
- D. The job is terminated and the gathered statistics are not saved.
Answer: B
Explanation:
Explanation
The stop_on_window_close attribute controls whether the GATHER_STATS_JOB continues when the maintenance window closes. The default setting for the stop_on_window_close attribute is TRUE, causing Scheduler to terminate GATHER_STATS_JOB when the maintenance window closes. The remaining objects are then processed in the next maintenance window.
References: https://docs.oracle.com/cd/B19306_01/server.102/b14211/stats.htm#g49431
NEW QUESTION 64
Which four actions are possible during an Online Data file Move operation? (Choose four.)
- A. Flashing back the database
- B. Creating and dropping tables in the data file being moved
- C. Performing Block Media Recovery for a data block in the data file being moved
- D. Executing DML statements on objects stored in the data file being moved
- E. Querying tables in the data file being moved
- F. Performing file shrink of the data file being moved
Answer: A,B,D,E
Explanation:
Explanation/Reference:
Explanation:
- You can now move On line Datafile without hove to stop Monoged Recovery and manually copy and
rename Files. This can even be used to move Datafiles from or to ASM.
- New in Oracle Database 12c: FROM METAUNK. Physical Standby Database is in Active Data Guard
Mode (opened READ ONLY and Managed Recovery is running):
It is now possible to online move a Datafile while Managed Recovery is running, ie. the Physical Standby
Database is in Active Data Guard Mode. You can use this Command to move the Datafile
- A flashback operation does not relocate a moved data file to its previous location. If you move a data file
online from one location to another and later flash back the database to a point in time before the move,
then the Data file remains in the new location, but the contents of the Data file ore changed to the contents
at the time specified in the flashback. Oracle0 Database Administrator's Guide 12c Release 1 (12.1)
NEW QUESTION 65
Which activity is audited by default and recorded in the operating system audit trail irrespective of whether or not database auditing is enabled?
- A. creation of a fine-grained audit policy
- B. execution of SQL statements by users connected with theSYSDBAprivilege
- C. configuration of unified auditing mode
- D. usage of theAUDITstatement
Answer: B
Explanation:
Referenceshttps://docs.oracle.com/cd/B28359_01/network.111/b28531/auditing.htm#DBS
EG0622
NEW QUESTION 66
......
Pass Your 1z0-062 Exam Easily with Accurate PDF Questions: https://www.examcollectionpass.com/Oracle/1z0-062-practice-exam-dumps.html