New 2021 1z0-062 exam questions Welcome to download the newest Prep4pass 1z0-062 PDF dumps (380 Q&As)
P.S. Free 2021 Oracle Database 1z0-062 dumps are available on Google Drive shared by Prep4pass
NEW QUESTION 28
You plan to create a database by using the Database Configuration Assistant (DBCA), with the following specifications:
– Applications will connect to the database via a middle tier.
– The number of concurrent user connections will be high.
– The database will have mixed workload, with the execution of complex BI queries scheduled at night.
Which DBCA option must you choose to create the database?
- A. a General Purpose database template with default memory allocation
- B. a Data Warehouse database template, with the dedicated server mode option and AMM enabled
- C. a default database configuration
- D. a General Purpose database template, with the shared server mode option and Automatic Memory Management (AMM) enabled
Answer: D
Explanation:
Explanation/Reference:
References:
NEW QUESTION 29
Which statement is true about redo log files during instance recovery?
- A. All redo log entries in the current log are applied to data files until the checkpoint position is reached.
- B. All current, active, and inactive redo logs are required to complete instance recovery.
- C. All redo log entries in the current and active logs are applied to data files to reconstruct changes made
after the most recent checkpoint. - D. All current, online, and archived redo logs are required to complete instance recovery.
Answer: A
Explanation:
Explanation/Reference:
References: https://docs.oracle.com/cd/A58617_01/server.804/a58396/ch2.htm
NEW QUESTION 30
Which three statements are true regarding the use of the Database Migration Assistant for Unicode (DMU)?
- A. The DMU can report columns that are too long in the converted characterset.
- B. The release of the database to be converted can be any release since 9.2.0.8.
- C. The DMU can report columns that are not represented in the converted characterset.
- D. A DBA can check specific tables with the DMU
- E. The database to be migrated must be opened read-only.
Answer: A,C,D
Explanation:
A: In certain situations, you may want to exclude selected columns or tables from
scanning or conversion steps of the migration process.
D: Exceed column limit
The cell data will not fit into a column after conversion.
E: Need conversion
The cell data needs to be converted, because its binary representation in the target character set is different than the
representation in the current character set, but neither length limit issues nor invalid representation issues have been
found.
* Oracle Database Migration Assistant for Unicode (DMU) is a unique next-generation migration tool providing an
end-to-end solution for migrating your databases from legacy encodings to Unicode.
Incorrect:
Not C: The release of Oracle Database must be 10.2.0.4, 10.2.0.5, 11.1.0.7, 11.2.0.1, or later.
NEW QUESTION 31
Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?
- A. By default, EM express is available for a database after database creation.
- B. You can perform basic administrative tasks for pluggable databases by using the EM express interface.
- C. You cannot start up or shut down a database Instance by using EM express.
- D. You can use EM express to manage multiple databases running on the same server.
- E. You can create and configure pluggable databases by using EM express.
Answer: A
Explanation:
EM Express is built inside the database.
Note:
Oracle Enterprise Manager Database Express (EM Express) is a web-based database
management tool that is built inside the Oracle Database. It supports key performance
management and basic database administration functions. From an architectural perspective, EM
Express has no mid-tier or middleware components, ensuring that its overhead on the database
server is negligible.
NEW QUESTION 32
What can be automatically implemented after the SQL Tuning Advisor is run as part of the Automated Maintenance
Task?
- A. SQL profile recommendations
- B. statistics recommendations
- C. creation of materialized views to improve query performance
- D. SQL statement restructure recommendations
Answer: A
Explanation:
References:
http://docs.oracle.com/cd/B28359_01/server.111/b28274/sql_tune.htm#i36217
NEW QUESTION 33
You want to upgrade an Oracle Database running Oracle Database 11g to Oracle Database 12c.
Which three tasks should be performed before a manual upgrade?
- A. running utlu121s.sql from the new Oracle home to display information about the required initialization parameters
- B. copying the initialization parameter file to the new Oracle home
- C. copying the password file to the new Oracle home
- D. copying net configuration files to the new Oracle home
- E. running preupgrad.sql in Oracle Database 11g to generate fix-up scripts and a log file
Answer: B,D,E
NEW QUESTION 34
Your multitenant container database (CDB) contains some pluggable databases (PDBs), you execute the
following command in the root container:
Which two statements are true? (Choose two.)
- 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
Explanation:
Explanation/Reference:
Explanation:
NEW QUESTION 35
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? (Choose three.)
- A. Specify all files in the CREATE DATABASE statement without using Oracle managed Files (OMF).
- B. Specify the PDB_FILE_NAME_CONVERT initialization parameter.
- C. Use Oracle Managed Files (OMF).
- D. Specify the DB_FILE_NAMECONVERT initialization parameter.
- E. Specify the SEED FILE_NAME_CONVERT clause.
Answer: B,C,E
Explanation:
Explanation/Reference:
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 36
A user establishes a connection to a database instance by using an Oracle Net.
You want to ensure that:
1. The user account must be locked after five consecutive unsuccessful login attempts.
2. Data read per session must be limited for the user.
3. The user cannot have more than three simultaneous sessions.
4. The user must have a maximum of 10 minutes session idle time before being logged off automatically.
Which two would you do to implement this?
- A. by using appropriate KERNEL parameters set in the profile assigned to the user
- B. by alerting the appropriate user attributes with an ALTER USER command
- C. by using appropriate PASSWORD parameters set in the profile assigned to the user
- D. by implementing Database Resource Manager and assign it a profile for the user
- E. by implementing Database Resource Manager and assign it a role for the user
Answer: D
NEW QUESTION 37
Backup requirements for a database:
* Level 0 backup on Sunday
* Cumulative incremental level 1 backup on Monday, Wednesday, and Saturday
* Differential incremental level 1 backup on Tuesday, Thursday, and Friday
Which three statements are true about the strategy? (Choose three.)
- A. Level 1 backup on Tuesday, Thursday, and Friday contains all the blocks that have been changed since the last level 1 backup.
- B. Level 1 backup on Monday, Wednesday, and Saturday contains all the blocks thathave been changed since the last level 0 backup.
- C. Level 1 backup on Tuesday, Thursday, and Friday contains all the blocks that have been changed since the last level 0 backup.
- D. Level 0 backup on Sunday contains all the blocks that have been changed since the last level 1 backup.
- E. Level 0 backup on Sunday contains all the blocks that have been formatted.
Answer: B,C,D
NEW QUESTION 38
You create a new pluggable database, HR_PDB, from the seed database. Which three tablespaces are created by default in HR_PDB? (Choose three.)
- A. SYSAUX
- B. SYSTEM
- C. EXAMPLE
- D. TEMP
- E. UNDO
- F. USERS
Answer: A,B,D
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 39
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:
* 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 40
Examine the command:
SQL> CREATE TABLESPACE test1
DATAFILE '/u01/app/oracle/oradata/orc1/test01.dbf' SIZE 5M
AUTOEXTEND ON UNIFORM;
Which statement is true?
- A. The tablespace, TEST1, can contain a maximum of one data file.
- B. Allocated and free extents are tracked using bitmaps.
- C. The data file, TEST01.DBF, can be auto extended to a maximum size of 5M.
- D. Segment free space is tracked in the data dictionary.
Answer: B
NEW QUESTION 41
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 hangs until all transactions on the objects in the tablespace commit or rollback, and then the tablespace is placed in readonly mode.
- C. The transaction in Scott's session is rolled back and the tablespace becomes readonly.
- D. The command waits and the user SCOTT can execute data manipulation language (DML) statements only as part of the current transaction.
Answer: C
NEW QUESTION 42
What is the result of executing a TRUNCATE TABLE command on a table that has Flashback Archiving
enabled?
- A. The rows in both the table and the archive are truncated.
- B. It fails with the ORA-665610 Invalid DDL statement on history-tracked message
- C. The rows in the table are truncated without being archived.
- D. The rows in the table are archived, and then truncated.
Answer: D
NEW QUESTION 43
You upgraded your database from pre-12c to a multitenant container database (CDB) containing pluggable databases (PDBs).
Examine the query and its output:
Which two tasks must you perform to add users with SYSBACKUP, SYSDG, and SYSKM privilege to the password file? (Choose two.)
- A. Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege and the FORCE argument set to No.
- B. Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege, and FORCE arguments set to Yes.
- C. Grant SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.
- D. Re-create the password file in the Oracle Database 12c format.
- E. Assign the appropriate operating system groups to SYSBACKUP, SYSDG, SYSKM.
Answer: B,C
Explanation:
Explanation
* orapwd
/ You can create a database password file using the password file creation utility, ORAPWD.
The syntax of the ORAPWD command is as follows:
orapwd FILE=filename [ENTRIES=numusers] [FORCE={y|n}] [ASM={y|n}]
[DBUNIQUENAME=dbname] [FORMAT={12|legacy}] [SYSBACKUP={y|n}] [SYSDG={y|n}]
[SYSKM={y|n}] [DELETE={y|n}] [INPUT_FILE=input-fname]
force - whether to overwrite existing file (optional),
* v$PWFILE_users
/ 12c: V$PWFILE_USERS lists all users in the password file, and indicates whether the user has been granted the SYSDBA, SYSOPER, SYSASM, SYSBACKUP, SYSDG, and SYSKM privileges.
/ 10c: sts users who have been granted SYSDBA and SYSOPER privileges as derived from the password file.
ColumnDatatypeDescription
USERNAMEVARCHAR2(30)The name of the user that is contained in the password file SYSDBAVARCHAR2(5)If TRUE, the user can connect with SYSDBA privileges SYSOPERVARCHAR2(5)If TRUE, the user can connect with SYSOPER privileges Incorrect:
not E: The format of the v$PWFILE_users file is already in 12c format.
NEW QUESTION 44
Flashback is enabled for your multitenant container database (CDB), which contains two pluggable database (PDBs). A local user was accidently dropped from one of the PDBs.
You want to flash back the PDB to the time before the local user was dropped. You connect to the CDB and execute the following commands:
SQL > SHUTDOWN IMMEDIATE
SQL > STARTUP MOUNT
SQL > FLASHBACK DATABASE to TIME "TO_DATE ('08/20/12' , 'MM/DD/YY')";
Examine following commands:
1. ALTER PLUGGABLE DATABASE ALL OPEN;
2. ALTER DATABASE OPEN;
3. ALTER DATABASE OPEN RESETLOGS;
Which command or commands should you execute next to allow updates to the flashback back schema?
- A. 3 and 1
- B. Only 3
- C. 1 and 2
- D. Only 1
- E. Only 2
Answer: A
Explanation:
Explanation/Reference:
Explanation:
NEW QUESTION 45
......
1z0-062 exam questions from Prep4pass dumps: https://www.prep4pass.com/1z0-062_exam-braindumps.html (380 Q&As)
Free 2021 Oracle Database 1z0-062 dumps are available on Google Drive shared by Prep4pass: https://drive.google.com/open?id=1UhvOjMl6TNoOGDNMDWh7ukFco6yttdvY
