[Feb-2022 Newly Released] 1z0-062 Exam Questions For You To Pass
Oracle 1z0-062 Exam: Basic Questions With Answers
Oracle 1z0-062 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
NEW QUESTION 46
You notice that the elapsed time for an important database scheduler Job is unacceptably long.
The job belongs to a scheduler job class and window.
Which two actions would reduce the job's elapsed time? (Choose two.)
- A. Increasing the priority of the scheduler window to which the job belongs
- B. Increasing the priority of the job class to which the job belongs
- C. Increasing the value of the JOB_QUEUE_PROCESSES parameter
- D. Increasing the resource allocation for the consumer group mapped to the scheduler job's job class within the plan mapped to the scheduler window
- E. Moving the job to an existing higher priority scheduler window with the same schedule and duration
- F. Increasing the job's relative priority within the Job class to which it belongs
Answer: D,F
Explanation:
Explanation/Reference:
Explanation:
B: Job priorities are used only to prioritize among jobs in the same class.
Note: Group jobs for prioritization
Within the same job class, you can assign priority values of 1-5 to individual jobs so that if two jobs in the class are scheduled to start at the same time, the one with the higher priority takes precedence. This ensures that you do not have a less important job preventing the timely completion of a more important one.
C: Set resource allocation for member jobs
Job classes provide the link between the Database Resource Manager and the Scheduler, because each job class can specify a resource consumer group as an attribute. Member jobs then belong to the specified consumer group and are assigned resources according to settings in the current resource plan.
NEW QUESTION 47
Examine the parameters for your database instance:
You execute the following command:
SQL> ALTER TABLESPACE undotbs1 RETENTION NOGUARANTEE;
Which statement is true in this scenario?
- A. Inactive undo data is retained for 1200 seconds even if subsequent transactions fail due to lack of space in the undo tablespace.
- B. An attempt is made to keep inactive undo for 1200 seconds but transactions may overwrite the undo before that time has elapsed.
- C. Undo data is written to flashback logs after 1200 seconds.
- D. You can perform a Flashback Database operation only within the duration of 1200 seconds.
Answer: B
NEW QUESTION 48
After implementing full Oracle Data Redaction, you change the default value for the NUMBER data type as follows:
After changing the value, you notice that FULL redaction continues to redact numeric data with zero.
What must you do to activate the new default value for numeric full redaction?
- A. Flush the shared pool.
- B. Re-enable redaction policies that use FULL data redaction.
- C. Re-connect the sessions that access objects with redaction policies defined on them.
- D. Re-create redaction policies that use FULL data redaction.
- E. Restart the database instance.
Answer: E
Explanation:
About Altering the Default Full Data Redaction Value
You can alter the default displayed values for full Data Redaction polices. By default, 0 is the redacted value when Oracle Database performs full redaction (DBMS_REDACT.FULL) on a column of the NUMBER data type. If you want to change it to another value (for example, 7), then you can run the DBMS_REDACT.UPDATE_FULL_REDACTION_VALUES procedure to modify this value. The modification applies to all of the Data Redaction policies in the current database instance. After you modify a value, you must restart the database for it to take effect.
Note:
* The DBMS_REDACT package provides an interface to Oracle Data Redaction, which enables you to mask (redact) data that is returned from queries issued by low-privileged users or an application.
* UPDATE_FULL_REDACTION_VALUES Procedure
This procedure modifies the default displayed values for a Data Redaction policy for full redaction.
* After you create the Data Redaction policy, it is automatically enabled and ready to redact data.
* Oracle Data Redaction enables you to mask (redact) data that is returned from queries issued by low- privileged users or applications. You can redact column data by using one of the following methods:
/ Full redaction.
/ Partial redaction.
/ Regular expressions.
/ Random redaction.
/ No redaction.
NEW QUESTION 49
Your database is configured in ARCHIVELOG mode, and a daily full database backup is taken by using RMAN. Control file autobackup is configured.
Loss of which three database files can lead to an incomplete recovery? (Choose three.)
- A. server parameterle (SPFILE)
- B. active online redo logle group
- C. inactive online redo log file group
- D. all the control flies
- E. a data file belonging to the default temporary tablespace
- F. a data file belonging to theSYSAUXtablespace
Answer: B,C,D
NEW QUESTION 50
You want to create a role that:
- is protected from unauthorized usage
- does not use a password embedded in the application source code or stored in a table
- is enabled for a user based on security policies defined in a PL/SQL package How would you create this role?
- A. as a secure application role
- B. with global authentication
- C. with external authentication
- D. with definer's rights
Answer: A
Explanation:
Explanation
References: https://docs.oracle.com/cd/B28359_01/network.111/b28531/authorization.htm#DBSEG97973
NEW QUESTION 51
Your database supports a Decision Support System (DSS) workload that involves the execution of complex queries. Currently, the database is running with peak workload. You want to analyze some of the most resource-intensive statements cached in the library cache.
What must you run to receive recommendations on the efficient use of indexes and materialized views to improve query performance?
- A. SQL Access Advisor
- B. Automatic Workload Repository (AWR) report
- C. Automatic Database Diagnostic Monitor (ADDM)
- D. SQL Performance Analyzer
- E. SQL Tuning Advisor
Answer: A
Explanation:
References:https://docs.oracle.com/cd/B28359_01/server.111/b28314/tdpdw_perform.htm
#TDPDW00813
NEW QUESTION 52
In your production database, data manipulation language (DML) operations are executed on the SALES table.
You have noticed some dubious values in the SALES table during the last few days. You are able to track users, actions taken, and the time of the action for this particular period but the changes in data are not tracked.
You decide to keep track of both the old data and new data in the table long with the user information.
What action would you take to achieve this task?
- A. Apply fine-grained auditing.
- B. Impose standard database auditing to audit SQL statements.
- C. Impose standard database auditing to audit object privileges.
- D. Implement value-based auditing.
Answer: D
NEW QUESTION 53
Which two statements are true about SQL *Loader Express Mode in an Oracle 12c database?
- A. You can selectively load rows into a table based on a filer.
- B. TheDEGREE_OF_PARALLELISMparameter is set toAUTO.
- C. You cannot have multiple SQL *Loader data files.
- D. If no data file is specified, it assumes the data file to be<table-name>.datin the current directory and uses it.
- E. You can have multiple bad files created when loading in parallel.
Answer: B,D
Explanation:
References:https://docs.oracle.com/database/121/SUTIL/GUID-0F35B551-861B-450D-
8 BF3-2312893A67D7.htm#SUTIL3951
NEW QUESTION 54
Which set of statements is true about data dictionary views?
1. They are stored in the SYSTEM tablespace.
2. They are based on virtual tables.
3. They are owned by the SYS user.
4. They can be queried by a normal user only if the 07_DICTIONARY_ACCESSIBILITY parameter is set to TRUE.
5. The V$FIXED_TABLE view can be queried to list the names of these views.
6. They are owned by the SYSTEM user.
- A. 1 and 3
- B. 2, 3, 4, and 5
- C. 2, 5, and 6
- D. 1, 2, and 3
Answer: A
Explanation:
Explanation
References: https://docs.oracle.com/cd/E11882_01/server.112/e40540/datadict.htm#CNCPT002
NEW QUESTION 55
Which two actions does an incremental checkpoint perform?
- A. It writes the checkpoint position to the data file headers.
- B. It signals CKPT to write the checkpoint position to the data file headers.
- C. It writes the checkpoint position to the control file.
- D. It advances the checkpoint position in the checkpoint queue.
Answer: C,D
Explanation:
References:
http://www.dba-oracle.com/t_incremental_checkpoint.htm
NEW QUESTION 56
Your database is configured in ARCHIVELOGmode, and a daily full database backup is taken by using RMAN. Control file autobackup is configured.
Loss of which three database files can lead to an incomplete recovery? (Choose three.)
- A. a data file belonging to the SYSAUXtablespace
- B. active online redo log file group
- C. inactive online redo log file group
- D. all the control flies
- E. a data file belonging to the default temporary tablespace
- F. server parameter file (SPFILE)
Answer: B,C,D
NEW QUESTION 57
Which statement is true about the Log Writer process?
- A. It writes when it receives a signal from the checkpoint process (CKPT).
- B. It writes concurrently to all members of multiplexed redo log groups.
- C. It writes when a user commits a transaction.
- D. It writes after the Database Writer process writes dirty buffers to disk.
Answer: C
Explanation:
References:
NEW QUESTION 58
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:
* 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 59
You have altered a non-unique index to be invisible to determine if queries execute within an acceptable response time without using this index.
Which two are possible if table updates are performed which affect the invisible index columns? (Choose two.)
- 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 60
The HRuser updates the salary of one of the employees in the non-partitioned EMPLOYEEStable, but does not commit the transaction.
Which two types of lock exist in this situation? (Choose two.)
- A. row level lock on the row being updated
- B. shared lock on the EMPLOYEEStable
- C. exclusive lock on the EMPLOYEES table
- D. null lock on the row being updated
- E. null lock on the EMPLOYEES table
Answer: A,B
NEW QUESTION 61
Which three statements are true about Flashback Database?
- A. Flashback Database uses a restored control file to recover a database.
- B. Flashback Database can recover a database to the state that it was in before a reset logs operation.
- C. 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.
- D. Flashback Database can recover a data file that was dropped during the span of time of the flashback.
- E. The Oracle database automatically creates, deletes, and resides flashback logs in the Fast
Recovery Area. - F. Flashback logs are written sequentially, and are archived.
Answer: A,C,E
Explanation:
* Flashback Database uses its own logging mechanism, creating flashback logs and storing them in the fast recovery area (C). You can only use Flashback Database if flashback logs are available. To take advantage of this feature, you must set up your database in advance to create flashback logs.
* To enable Flashback Database, you configure a fast recovery area and set a flashback retention target. This retention target specifies how far back you can rewind a database with Flashback Database.
From that time onwards, at regular intervals, the database copies images of each altered block in every data file into the flashback logs. These block images can later be reused to reconstruct the data file contents for any moment at which logs were captured. (F)
Incorrect: Not E: You cannot use Flashback Database alone to retrieve a dropped data file. If you flash back a database to a time when a dropped data file existed in the database, only the data file entry is added to the control file. You can only recover the dropped data file by using RMAN to fully restore and recover the data file.
Reference: Oracle Database Backup and Recovery User's Guide 12c R
NEW QUESTION 62
In your database, the RESOURCE_LIMIT parameter is set to TRUE.
You create the profile:
Which two statements are true about users and their sessions that are subject to this profile? (Choose
two.)
- A. The PASSWORD_LIFE_TIME value is ignored because of the unlimited value of
PASSWORD_REUSE_MAX. - B. These users can never reuse a password
- C. In each user session, the limit for LOGICAL_READS_PER_SESSION in the same as defined in the
DEFAULT profile. - D. The CPU_PER_CALL is ignored in the user sessions because of the unlimited value of
CPU_PER_CALL
Answer: A,C
NEW QUESTION 63
Which statement is true regarding the DEFAULT profile?
- A. It canbe dropped and recreated.
- B. A different DEFAULT profile can be created before each user in a database.
- C. it must be explicitly assigned to the user.
- D. The values assigned to the resource limits and password parameters in the default profile can be altered.
Answer: D
NEW QUESTION 64
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. Both the SGA_TARGET and MEMORY_TARGET parameters are set.
- B. The SGA_MAX_SIZE and SGA_TARGET parameter values are not equal.
- C. The STATISTICS_LEVEL parameter is set to BASIC.
- D. The PGA_AGGREGATE_TARGET parameter is set to zero.
Answer: C
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 65
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 DSS_QUERIES 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 resource management. - C. 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. - D. An attempt to start a new session by a user belonging to OTHE_GROUPS 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: B,E
NEW QUESTION 66
Which four actions are possible during an Online Data file Move operation? (Choose four.)
- 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:
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 67
......
New 2022 Realistic Free Oracle 1z0-062 Exam Dump Questions & Answer: https://pdfdumps.free4torrent.com/1z0-062-valid-dumps-torrent.html