100% Pass Top-selling 1z0-062 Exams - New 2021 Oracle Pratice Exam
Oracle Database Dumps 1z0-062 Exam for Full Questions - Exam Study Guide
NEW QUESTION 20
Your database is open and the listener LISTNENER is up. You issue the command:
LSNRCTL> RELOAD
What is the effect of reload on sessions that were originally established by listener?
- A. The sessions are not affected and continue to function normally.
- B. Only sessions based on static listener registrations are disconnected.
- C. All the sessions are terminated and active transactions are rolled back.
- D. 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.
Answer: D
NEW QUESTION 21
Which action takes place when a file checkpoint occurs?
- A. The Log Writer process (LGWR) writes all redo entries in the log buffer to online redo log files.
- B. The Database Writer process (DBWn) writes all dirty buffers in the buffer cache to data files.
- C. All buffers for a checkpointed file that were modified before a specific SCN are written to disk by DBWn and the SCN is stored in the control file.
- D. The checkpoint position is advanced in the checkpoint queue.
Answer: C
Explanation:
Explanation/Reference:
NEW QUESTION 22
Which statement is true about using the Export/Import method for migrating data when upgrading to Oracle Database 12c?
- A. It can be used to migrate a database only if the source database does not have any tablespace in read-only mode.
- B. It can be used to migrate a database only if the source and target databases are hosted on the same endian format.
- C. Itautomatically restarts a Data Pump Export or Import job after a failure is connected and the job continues from the point of failure.
- D. It allows migration of a database directly over network links.
Answer: C
NEW QUESTION 23
You notice a performance change in your production Oracle 12c database. You want to know which change caused this
performance difference.
Which method or feature should you use?
- A. AWR Compare Period report
- B. Taking a new snapshot and comparing it with a preserved snapshot
- C. Compare Period ADDM report
- D. Active Session History (ASH) report
Answer: A
Explanation:
The awrddrpt.sql report is the Automated Workload Repository Compare Period Report. The awrddrpt.sql script is
located in the $ORACLE_HOME/rdbms/admin directory.
Incorrect:
Not A: Compare Period ADDM
Use this report to perform a high-level comparison of one workload replay to its capture or to another replay of the
same capture. Only workload replays that contain at least 5 minutes of database time can be compared using this
report.
NEW QUESTION 24
Which statement is true about Oracle Net Listener?
- A. The listener.ora configuration file must be located in the ORACLE_HOME/network/admin directly.
- B. It acts as the listening endpoint for the Oracle database instance for all local and non-local user connections.
- C. Service registration with the listener is performed by the process monitor (PMON) process of each database instance.
- D. The listener.ora configuration file must be configured with one or more listening protocol addresses to allow remote users to connect to a database instance.
- E. A single listener can service only one database instance and multiple remote client connections.
Answer: C
Explanation:
Explanation
https://docs.oracle.com/database/121/CNCPT/process.htm
NEW QUESTION 25
You performed an incremental level 0 backup of a database:
RMAN > BACKUP INCREMENTAL LEVEL 0 DATABASE;
To enable block change tracking after the incremental level 0 backup, you issued this command:
SQL > ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE
' /mydir/rman_change_track.f';
To perform an incremental level 1 cumulative backup, you issued this command:
RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;
Which three statements are true? (Choose three.)
- A. The incremental level 1 backup that immediately follows the enabling of block change tracking will not read the change tracking file to discover changed blocks.
- B. Block change tracking will always reduce I/O performed during cumulative incremental backups.
- C. More than one database block may be read by an incremental backup for a change made to a single block.
- D. Backup change tracking will sometimes reduce I/O performed during cumulative incremental backups.
- E. The change tracking file must always be backed up when you perform a full database backup.
Answer: A,C,D
NEW QUESTION 26
Identify two prerequisites for configuring Enterprise Manager Database Express (EM Express). (Choose two.)
- A. Use the DBMS_XDB_CONFIG.SETHTTPPORT procedure to configure a port number for Oracle HTTP Server.
- B. Create a SYSMANuser with the SYSDBAprivilege as an administrator for EM Express.
- C. Install Oracle HTTP Server.
- D. Grant the APEX_PUBLIC_USER role to the SYSMANuser.
- E. Configure at least one dispatcher for the TCP/IP protocol.
Answer: B,E
NEW QUESTION 27
You plan to migrate your database from a File system to Automata Storage Management (ASM) on same platform.
Which two methods or commands would you use to accomplish this task?
- A. Data Pump Export and import
- B. The BACKUP AS COPY DATABASE . . . command of RMAN
- C. RMAN CONVERT command
- D. Conventional Export and Import
- E. DBMS_FILE_TRANSFER with transportable tablespace
Answer: B,C
Explanation:
A:
1. Get the list of all datafiles.
Note: RMAN Backup of ASM Storage
There is often a need to move the files from the file system to the ASM storage and vice versa. This may come in
handy when one of the file systems is corrupted by some means and then the file may need to be moved to the other
file system.
D: Migrating a Database into ASM
* To take advantage of Automatic Storage Management with an existing database you must migrate that database
into ASM. This migration is performed using Recovery Manager (RMAN) even if you are not using RMAN for your
primary backup and recovery strategy.
* Example:
Back up your database files as copies to the ASM disk group.
BACKUP AS COPY INCREMENTAL LEVEL 0 DATABASE
FORMAT '+DISK' TAG 'ORA_ASM_MIGRATION';
References:
NEW QUESTION 28
You create a new pluggable database, HR_PDB, from the seed database. Which three tablespaces are created by default in HR_PDB?
- A. SYSAUX
- B. SYSTEM
- C. EXAMPLE
- D. TEMP
- E. UNDO
- F. USERS
Answer: A,B,D
Explanation:
Explanation/Reference:
Explanation:
* A PDB would have its SYSTEM, SYSAUX, TEMP tablespaces.It can also contains other user created tablespaces in it.
* Oracle Database creates both the SYSTEM and SYSAUX tablespaces as part of every database.
* tablespace_datafile_clauses
Use these clauses to specify attributes for all data files comprising the SYSTEM and SYSAUX tablespaces in the seed PDB.
Incorrect:
Not D: a PDB can not have an undo tablespace. Instead, it uses the undo tablespace belonging to the CDB.
Note:
* Example:
CONN pdb_admin@pdb1
SELECT tablespace_name FROM dba_tablespaces;
TABLESPACE_NAME
------------------------------
SYSTEM
SYSAUX
TEMP
USERS
SQL>
NEW QUESTION 29
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 succeeds only if memory is available from the autotuned components if SGA.
- B. It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE.
- C. It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGET.
- D. It fails because the DB_8K_CACHE_SIZE parameter cannot be changed dynamically.
Answer: B
Explanation:
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 30
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
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 31
Which two statements are true about a server parameter file (SPFILE)? (Choose two.)
- A. An SPFILE can be created only before a database instance is started.
- B. A PFILE can be used to start up a databaseinstance even if an SPFILE exists.
- C. An SPFILE contains only those dynamic parameters that can be changed without having torestart the database instance.
- D. An SPFILE must reside in theORACLE_HOME/dbsdirectory.
- E. An SPFILE can be created from a PFILE or from memory.
Answer: D,E
NEW QUESTION 32
Which three statements are true concerning the multitenant architecture? (Choose three.)
- A. Each pluggable database (PDB) has its own set of background processes.
- B. Instance recovery is always performed at the CDB level.
- C. Different PDBs can have different default block sizes.
- D. PDBs can share the sysaux tablespace.
- E. PDBs share a common system tablespace.
- F. A PDB can have a private temp tablespace.
- G. Log switches occur only at the multitenant container database (CDB) level.
Answer: B,F,G
Explanation:
Explanation
Explanation:
B:
* A PDB would have its SYSTEM, SYSAUX, TEMP tablespaces. It can also contain 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 a 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 33
Which two statements are true concerning dropping a pluggable database (PDB)?
- 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:
Explanation/Reference:
Explanation:
http://docs.oracle.com/database/121/ADMIN/cdb_plug.htm#ADMIN13658
NEW QUESTION 34
Which three statements are true about automated maintenance tasks?
- A. Predefined maintenance tasks consist of automatic optimizer statistics collection, running Automatic Segment Advisor, and running Automatic SQL Tuning Advisor.
- B. They run at predefined time intervals that are intended to occur during a period of low system load.
- C. A maintenance window is automatically extended until all the maintenance tasks defined are completed.
- D. An Oracle Scheduler job is created for each maintenance task that is scheduled to run in a maintenance window.
- E. A repository is maintained in the SYSTEMtablespace to store the history of execution of all tasks.
Answer: A,B,D
Explanation:
Explanation/Reference:
References https://docs.oracle.com/cd/E11882_01/server.112/e25494/tasks.htm#ADMIN12331
NEW QUESTION 35
The ORCL database is configured to support shared server mode. You want to ensure that a user connecting remotely
to the database instance has a one-to-one ratio between client and server processes.
Which connection method guarantees that this requirement is met?
- A. connecting by using a directory naming method
- B. connecting by using an external naming method
- C. creating a service in the database by using the dbms_service.create_service procedure and using this service for
creating a local naming service - D. connecting by using the local naming method with the server = dedicated parameter set in the tnsnames.ora file
for the net service - E. connecting by using the easy connect method
Answer: A,C
NEW QUESTION 36
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. A large number COMMITS are being performed.
- B. There are frequent logons and logoffs.
- 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: C,D,E
Explanation:
Explanation/Reference:
Explanation:
https://logicalread.com/oracle-latch-free-wait-dr01/#.WQygk1i6zUI
NEW QUESTION 37
Examine the following command:
CREATE TABLE (prod_id number(4),
Prod_name varchar2 (20),
Category_id number(30),
Quantity_on_hand number (3) INVISIBLE);
Which three statements are true about using an invisible column in the PRODUCTS table?
- A. The DESCRIBE commands in SQL *Plus will not display the invisible column in the output.
- B. The invisible column cannot be made visible and can only be marked as unused.
- C. Referential integrity constraint cannot be set on the invisible column.
- D. A primary key constraint can be added on the invisible column.
- E. The %ROWTYPE attribute declarations in PL/SQL to access a row will not display the invisible column in the output.
Answer: A,D,E
Explanation:
AB: You can make individual table columns invisible. Any generic access of a table does not show the invisible columns
in the table. For example, the following operations do not display invisible columns in the output:
* SELECT * FROM statements in SQL
* DESCRIBE commands in SQL*Plus
* %ROWTYPE attribute declarations in PL/SQL
* Describes in Oracle Call Interface (OCI)
Incorrect:
Not D: You can make invisible columns visible.
You can make a column invisible during table creation or when you add a column to a table, and you can later alter
the table to make the same column visible.
References:
NEW QUESTION 38
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, and encrypts any inserted data in the EMPNAME column because the wallet needs to be open only for tablespace creation.
- B. It generates an error when creating the table because the wallet is closed.
- C. 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.
- D. It generates error when creating the table, because the salt option cannot be used with encrypted tablespaces.
Answer: A
Explanation:
*The environment setup for tablespace encryption is the same as that for transparent data encryption. Before attempting to create an encrypted tablespace, a wallet must be created to hold
the encryption key.
*Setting the tablespace master encryption key is a one-time activity. This creates the master encryption key for tablespace encryption. This key is stored in an external security module (Oracle wallet) and is used to encrypt the tablespace encryption keys.
*Before you can create an encrypted tablespace, the Oracle wallet containing the tablespace master encryption key must be open. The wallet must also be open before you can access data in an encrypted tablespace.
*Salt is a way to strengthen the security of encrypted data. It is a random string added to the data before it is encrypted, causing repetition of text in the clear to appear different when encrypted. Salt removes the one common method attackers use to steal data, namely, matching patterns of encrypted text.
*ALT | NO SALT By default the database appends a random string, called "salt," to the clear text of the column before encrypting it. This default behavior imposes some limitations on encrypted columns: / If you specify SALT during column encryption, then the database does not compress the data in the encrypted column even if you specify table compression for the table. However, the database does compress data in unencrypted columns and encrypted columns without the SALT parameter.
NEW QUESTION 39
Which two statements are true when row archival management is enabled?
- A. The ORA_ARCHIVE_STATE column visibility is controlled by the ROW ARCHIVAL VISIBILITY session parameter.
- B. The ORA_ARCHIVE_STATE column is visible if referenced in the select list of a query.
- C. The ORA_ARCHIVE_STATE column is updated automatically by the Oracle Server based on activity tracking columns, to Indicate that a row is no longer considered active.
- D. The ROW ARCHIVAL VISIBILITY session parameter defaults to active rows only.
- E. The ORA_ARCHIVE_STATE column is updated manually or by a program that could reference activity tracking columns, to indicate that a row is no longer considered active.
Answer: A,E
Explanation:
A: Below we see a case where we set the row archival visibility parameter to "all"
thereby allowing us to see all of the rows that have been logically deleted:
alter session set row archival visibility = all;
We can then turn-on row invisibility back on by changing row archival visibility = "active":
alter session set row archival visibility = all;
B: To use ora_archive_state as an alternative to deleting rows, you need the following settings and parameters:
1.Create the table with the row archival clause
create table mytab (col1 number, col2 char(200)) row archival;
2.Now that the table is marked as row archival, you have two methods for removing rows, a permanent solution with the standard delete DML, plus the new syntax where you set ora_archive_state to a non-zero value:
update mytab set ora_archive_state=2 where col2='FRED';
3.To make "invisible rows" visible again, you simply set the rows ora_archive_state to zero:
update mytab set ora_archive_state=0 where col2='FRED';
Note:
* Starting in Oracle 12c, Oracle provides a new feature that allow you to "logically delete" a row in a table without physically removing the row. This effectively makes deleted rows "invisible" to all SQL and DML, but they can be revealed at any time, providing a sort of "instant" rollback method.
To use ora_archive_state as an alternative to deleting rows.
NEW QUESTION 40
Which two statements are true about availability audit features after migration to unified auditing?
- A. Network auditing is available in the post-migrated database.
- B. Operating system audit trail is available in the post-migrated database.
- C. The ability of users to audit their own schema objects is not available in the post-migrated database.
- D. Mandatory auditing of audit administrative actions is available in the post-migrated database.
Answer: C,D
Explanation:
References:
https://docs.oracle.com/database/121/DBSEG/audit_changes.htm#DBSEG341
NEW QUESTION 41
Examine the following steps:
A DBA grants the CREATE TABLE system privilege with ADMIN OPTION to the user SIDNEY.
SIDNEY grants the CREATE TABLE system privilege to the HR user.
Which statement is true?
- A. HR can grant the CREATE TABLE system privilege to other users.
- B. Neither SIDNEY nor HR can create new tables if the DBA revokes the CREATE TABLE privilege from SIDNEY.
- C. HR still retains the CREATE TABLE system privilege if the DBA revokes the CREATE TABLE privilege from SIDNEY.
- D. SIDNEY can revoke the CREATE TABLE system privilege only from HR, to whom he granted it.
Answer: C
Explanation:
Explanation
References:
http://www.dba-oracle.com/t_with_grant_admin_privileges.htm
NEW QUESTION 42
In which situations does the Database Writer process (DBWn) write to data files? (choose two).
- A. when the RMAN recovery process starts
- B. when a user process commits a transaction
- C. when PMON cleans up dirty buffers in the database buffer cache
- D. when a tablespace is made read-only or taken offline
- E. when clean buffers for reading new blocks into the database buffer cache are not found easily
Answer: B,C
Explanation:
Explanation
References https://docs.oracle.com/cd/B19306_01/server.102/b14220/process.htm
NEW QUESTION 43
You execute the commands:
Which two statements are true?
- A. The create usercommand fails if any role with the name Sidney exists in the database.
- B. The user Sidneyis created and authenticated by the operating system.
- C. The user Sidneycan connect to the database instance but requires relevant privileges to create objects in the userstablespace.
- D. The user Sidneycan connect to the database instance but cannot perform sort operations because no space quota is specified for the temptablespace.
- E. The user Sidneyis created but cannot connect to the database instance because no profile is default.
Answer: A,C
Explanation:
Explanation/Reference:
References:
NEW QUESTION 44
......
Authentic Best resources for 1z0-062 Online Practice Exam: https://www.test4cram.com/1z0-062_real-exam-dumps.html