1z0-062 Braindumps PDF, Oracle 1z0-062 Exam Cram
New 2021 1z0-062 Sample Questions Reliable 1z0-062 Test Engine
NEW QUESTION 187
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 to the table partitions
that return most of their rows to the queries. - B. 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. - C. 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. - D. 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. - E. 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. - 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: C,D,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 188
Examine the structure of the SALES table, which is stored in a locally managed tablespace with Automatic Segment Space Management (ASSM) enabled.
You want to perform online segment shrink to reclaim fragmented free space below the high water mark.
What should you ensure before the start of the operation?
- A. Row movement is enabled.
- B. No pending transaction exists on the table.
- C. Extra disk space equivalent to the size of the segment is available in the tablespace.
- D. No queries are running on this table.
- E. Referential integrity constraints for the table are disabled.
Answer: A
NEW QUESTION 189
Examine the current value for the following parameters in your database instance:
SGA_MAX_SIZE = 1024M
SGA_TARGET = 700M
DB_8K_CACHE_SIZE = 124M
LOG_BUFFER = 200M
You issue the following command to increase the value of DB_8K_CACHE_SIZE:
SQL> ALTER SYSTEM SET DB_8K_CACHE_SIZE=140M;
Which statement is true?
- A. It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGET.
- B. It fails because the DB_8K_CACHE_SIZE parameter cannot be changed dynamically.
- C. It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE.
- D. It succeeds only if memory is available from the autotuned components if SGA.
Answer: C
Explanation:
Explanation
* The SGA_TARGET parameter can be dynamically increased up to the value specified for the SGA_MAX_SIZE parameter, and it can also be reduced.
* Example:
For example, suppose you have an environment with the following configuration:
SGA_MAX_SIZE = 1024M
SGA_TARGET = 512M
DB_8K_CACHE_SIZE = 128M
In this example, the value of SGA_TARGET can be resized up to 1024M and can also be reduced until one or more of the automatically sized components reaches its minimum size. The exact value depends on environmental factors such as the number of CPUs on the system. However, the value of DB_8K_CACHE_SIZE remains fixed at all times at 128M
* DB_8K_CACHE_SIZE
Size of cache for 8K buffers
* For example, consider this configuration:
SGA_TARGET = 512M
DB_8K_CACHE_SIZE = 128M
In this example, increasing DB_8K_CACHE_SIZE by 16 M to 144M means that the 16M is taken away from the automatically sized components. Likewise, reducing DB_8K_CACHE_SIZE by 16M to 112M means that the 16M is given to the automatically sized components.
NEW QUESTION 190
You are administering a database stored in Automatic Storage Management (ASM). You use RMAN to back up the database and the MD_BACKUP command to back up the ASM metadata regularly. You lost an ASM disk group DG1 due to hardware failure.
In which three ways can you re-create the lost disk group and restore the data? (Choose three.)
- A. Use the MD_RESTORE command to restore metadata for an existing disk group by passing the existing disk group name as an input parameter and use RMAN to restore the data.
- B. Use the MD_RESTORE command to restore both the metadata and data for the failed disk group.
- C. Use the MD_RESTORE command to restore the disk group with the changed disk group specification, failure group specification, name, and other attributes and use RMAN to restore the data.
- D. Use the MKDG command to add a new disk group DG1 with the same or different specifications for failure group and other attributes and use RMAN to restore the data.
- E. Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group name and same set of disks and failure group configuration, and use RMAN to restore the data.
- F. Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group and data on the disk group.
Answer: A,C,D
Explanation:
Explanation/Reference:
Explanation:
AC (not E):
The md_restore command allows you to restore a disk group from the metadata created by the md_backup command.
md_restore can’t restore data, only metadata.
NEW QUESTION 191
As part of a manual upgrade of your database to Oracle Database 12c, you plan to issue the command:
SQL> STARTUP UPGRADE
Which three statements are true about the upgrade process? (Choose three.)
- A. TheCOMPATIBLEparameter must be set to at least 12.1.0 before issuing the command.
- B. Only connectionsAS SYSDBAare allowed during the upgrade process.
- C. All job queues remain active duringthe upgrade process.
- D. Only queries on fixed views execute without errors until you run thecatctl.plscript.
- E. All system triggersare disabled during the upgrade process.
Answer: A,D,E
NEW QUESTION 192
In your database, the STATISTICS_LEVELparameter is set to TYPICALand an Automatic
Workload Repository (AWR) snapshot is taken every 30 minutes.
Which two statements are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose two.)
- A. It calls other advisors if required, but does not provide recommendations about the advisors to be used.
- B. It requires at least four AWR snapshots for analysis.
- C. It runs after each AWR snapshot is created and it requires at least two snapshots for analysis.
- D. It measures database performance by analyzing the wait time and CPU time of all non-idle user
sessions. - E. It always compares the latest snapshot with the baseline snapshot for analysis.
Answer: C,D
NEW QUESTION 193
Which four actions are possible during an Online Data file Move operation?
- A. Querying tables in the data file being moved
- B. Performing Block Media Recovery for a data block in the data file being moved
- C. Performing file shrink of the data file being moved
- D. Executing DML statements on objects stored in the data file being moved
- E. Flashing back the database
- F. Creating and dropping tables in the data file being moved
Answer: A,D,E,F
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 con 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 194
Identify three scenarios in which you would recommend the use of SQL Performance
Analyzer to analyze impact on the performance of SQL statements.
- A. Migration of database storage from non-ASM to ASM storage
- B. Change in your network infrastructure
- C. Change in the Oracle Database version
- D. Database and operating system upgrade
- E. Change in the hardware configuration of the database server
Answer: C,D,E
Explanation:
Oracle 11g/12c makes further use of SQLtuning 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 195
Which two are prerequisites for performing a flashback transaction?
- A. EXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back transaction.
- B. Block change tracking must be enabled tor the database.
- C. Flashback Database must be enabled.
- D. Undo retention guarantee for the database must be configured.
- E. Supplemental logging must be enabled.
- F. Recycle bin must be enabled for the database.
Answer: D,E
Explanation:
References:http://searchoracle.techtarget.com/tip/How-to-perform-Oracle-Flashback-
Transaction-Queries
NEW QUESTION 196
Which three statements are true about Flashback Database? (Choose three.)
- A. Flashback logs are used to restore to the blocks before images, and then the redo data may be used to
roll forward to the desired flashback time. - B. Flashback Database can recover a database to the state that it was in before a reset logs operation.
- C. Flashback Database can recover a data file that was dropped during the span of time of the flashback.
- D. Flashback logs are written sequentially, and are archived.
- E. Flashback Database uses a restored control file to recover a database.
- F. The Oracle database automatically creates, deletes, and resides flashback logs in the Fast Recovery
Area.
Answer: A,B,F
NEW QUESTION 197
You are managing an Oracle Database 12c database. The database is open, and you plan to perform Recovery Manager (RMAN) backups.
Which three statements are true about these backups? (Choose three.)
- A. The backups would be possible only if the database is running inARCHIVELOGmode.
- B. The backups would be inconsistent.
- C. The backups need to be restoredand the database has to be recovered in case of a media failure.
- D. The backups would be consistent.
- E. The backups by default consist of all the data blocks within the chosen files or the full database.
Answer: A,B,E
Explanation:
References:https://docs.oracle.com/cd/E18283_01/server.112/e10897/backrest.htm#insert edID4
NEW QUESTION 198
You are planning the creation of a new multitenant container database (CDB) and want to store the ROOT and SEED container data files in separate directories.
You plan to create the database using SQL statements.
Which three techniques can you use to achieve this?
- A. Use Oracle Managed Files (OMF).
- B. Specify the DB_FILE_NAMECONVERT initialization parameter.
- C. Specify the SEED FILE_NAME_CONVERT clause.
- D. Specify all files in the CREATE DATABASE statement without using Oracle managed Files (OMF).
- E. Specify the PDB_FILE_NAME_CONVERT initialization parameter.
Answer: A,C,E
Explanation:
You must specify the names and locations of the seed's files in one of the following ways:
*(A) Oracle Managed Files
*(B) The SEED FILE_NAME_CONVERT Clause
*(C) The PDB_FILE_NAME_CONVERT Initialization Parameter
NEW QUESTION 199
Which three statements are true about naming methods? (Choose three.)
- A. The directory naming method supports connect-time failover and load-balancing options.
- B. In the Easy Connect method, clients can connect to a database server by using the host name of the
database with an optional port and service name. - C. The local naming method does not support connect-time failover and load-balancing options.
- D. In the Easy Connect method, the listener port and IP address must be provided for the connection to be
successful. - E. Local naming supports multiple protocols, but for any one connection, the client and server must use
the same protocol.
Answer: A,B,E
NEW QUESTION 200
Your database is open and the listener LISTENER is up. You issue the command:
LSNRCTL> RELOAD
What is the effect of reload on sessions that were originally established by listener?
- A. Existing connections are not disconnected; however, they cannot perform any operations until the listener completes the re-registration of the database instance and service handlers.
- B. All the sessions are terminated and active transactions are rolled back.
- C. The sessions are not affected and continue to function normally.
- D. Only sessions based on static listener registrations are disconnected.
Answer: C
Explanation:
Explanation/Reference:
NEW QUESTION 201
Examine the following query output:
You issue the following command to import tables into the hr schema:
$ > impdp hr/hr directory = dumpdir dumpfile = hr_new.dmp schemas=hr TRANSFORM=DISABLE_ARCHIVE_LOGGING: Y
Which statement is true?
- A. None of the operations against the master table used by Oracle Data Pump to coordinate its activities are logged.
- B. Only CREATE INDEX and CREATE TABLE statements generated by the import are logged.
- C. All database operations performed by the impdp command are logged.
- D. Only CREATE TABLE and ALTER TABLE statements generated by the import are logged.
Answer: D
Explanation:
Oracle Data Pump disable redo logging when loading data into tables and when creating indexes.
The new TRANSFORM option introduced in data pumps import provides the flexibility to turn off the redo generation for the objects during the course of import. The Master Table is used to track the detailed progress information of a Data Pump job.
The Master Table is created in the schema of the current user running the Pump Dump export or import, and it keeps tracks of lots of detailed information.
NEW QUESTION 202
In your multitenant container database (CDB) containing same pluggable databases (PDBs), you execute the following commands in the root container:
Which two statements are true?
- A. The C # # ROLE1 role is created only in the root database because the container clause is not used.
- B. Privileges are granted to the C##A_ADMIN user in the root database and all PDBs.
- C. The C # # ROLE1 role is created in the root database and all the PDBs.
- D. Privileges are granted to the C##A_ADMIN user only in the root database.
- E. The statement for granting a role to a user fails because the CONTAINER clause is not used.
Answer: C,D
Explanation:
* You can include the CONTAINER clause in several SQL statements, such as the CREATE USER, ALTER USER, CREATE ROLE, GRANT, REVOKE, and ALTER SYSTEM statements. * * CREATE ROLE with CONTAINER (optional) clause / CONTAINER = ALL Creates a common role. / CONTAINER = CURRENT Creates a local role in the current PDB.
NEW QUESTION 203
You created a new database using the "create database" statement without specifying the "ENABLE PLUGGABLE" clause.
What are two effects of not using the "ENABLE PLUGGABLE database" clause?
- A. The database is created as a non-CDB but will become a CDB whenever the first PDB is plugged in.
- B. The database is treated as a PDB and must be plugged into an existing multitenant container database (CDB).
- C. The database is created as a non-CDB but can be plugged into an existing CDB.
- D. The database is created as a non-CDB and can never contain a PDB.
- E. The database is created as a non-CDB and can never be plugged into a CDB.
Answer: C,D
Explanation:
Explanation/Reference:
Explanation:
A (not B,not E): 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.
D: You can create a PDB by plugging in a Non-CDB as a PDB.
The following graphic depicts the options for creating a PDB:
Incorrect:
Not E: For the duration of its existence, a database is either a CDB or a non-CDB. You cannot transform a non-CDB into a CDB or vice versa. You must define a database as a CDB at creation, and then create PDBs within this CDB.
NEW QUESTION 204
Which statement is true about using the Database Upgrade Assistant (DBUA) to upgrade your database from Oracle Database 11g to Oracle Database 12c?
- A. It automatically makes necessary changes to Oracle environment variables.
- B. It automatically enables unified auditing in the upgraded database.
- C. It terminates if the SYSTEM tablespace in the source database is not autoextensible.
- D. It automatically adds new data files if there is not enough disk space to grow.
Answer: D
Explanation:
Explanation
Explanation/Reference:
References: https://docs.oracle.com/cd/E18283_01/server.112/e17222/upgrade.htm#insertedID5
NEW QUESTION 205
You have altered a non-unique index to be invisible to determine if queries execute within an acceptable response
ti me without using this index.
Which two are possible if table updates are performed which affect the invisible index columns?
- A. The index automatically becomes visible in order to have it updated by DML on the table.
- B. The index remains invisible.
- C. The index is updated by the DML on the table.
- D. The index becomes unusable but the table is updated by the DML.
- E. The index is not updated by the DML statements on the indexed table.
Answer: B,C
Explanation:
Unlike unusable indexes, an invisible index is maintained during DML statements.
Note:
* Oracle 11g allows indexes to be marked as invisible. Invisible indexes are maintained like any other index, but they
are ignored by the optimizer unless the OPTIMIZER_USE_INVISIBLE_INDEXES parameter is set to TRUE at the instance
or session level. Indexes can be created as invisible by using the INVISIBLE keyword, and their visibility can be toggled
using the ALTER INDEX command.
NEW QUESTION 206
You must track all transactions that modify certain tables in the sales schema for at least three years.
Automatic undo management is enabled for the database with a retention of one day.
Which two must you do to track the transactions?
- A. Create a Flashback Data Archive in any suitable tablespace.
- B. Specify undo retention guarantee for the database.
- C. Create a Flashback Data Archive in the tablespace where the tables are stored.
- D. Enable supplemental logging for the database.
- E. Enable Flashback Data Archiving for the tables that require tracking.
Answer: A,E
Explanation:
Explanation/Reference:
Explanation:
E: By default, flashback archiving is disabled for any table. You can enable flashback archiving for a table if you have the FLASHBACK ARCHIVE object privilege on the Flashback Data Archive that you want to use for that table.
D: Creating a Flashback Data Archive
/Create a Flashback Data Archive with the CREATE FLASHBACK ARCHIVE statement, specifying the following:
Name of the Flashback Data Archive
Name of the first tablespace of the Flashback Data Archive
(Optional) Maximum amount of space that the Flashback Data Archive can use in the first tablespace
/Create a Flashback Data Archive named fla2 that uses tablespace tbs2, whose data will be retained for two years:
CREATE FLASHBACK ARCHIVE fla2 TABLESPACE tbs2 RETENTION 2 YEAR;
NEW QUESTION 207
......
Feel Oracle 1z0-062 Dumps PDF Will likely be The best Option: https://selftestengine.testkingit.com/Oracle/latest-1z0-062-exam-dumps.html