[Jan-2022] 1z0-062 Braindumps – 1z0-062 Questions to Get Better Grades
1z0-062 Exam Dumps - Try Best 1z0-062 Exam Questions - iPassleader
Those candidates who are used to referring themselves to self-study and have enough time & motivation in reserve can utilize such study guides and books from the Amazon website:
- ‘OCA Oracle Database 12c Installation and Administration Exam Guide (Exam 1Z0-062)’ by John Watson is an exclusive Oracle Press manual that covers all of the associate-level objectives to prepare for 1Z0-062. Its author, John Watson, as an OCP-level database administrator, will show readers how to install and upgrade Oracle Database software, how to manage Oracle instances alongside database storage structures, and how to implement Oracle Database auditing. Furthermore, upon completion of this book, you will demonstrate expertise in automating tasks, data movement, and installing Oracle Grid infrastructure for a standalone server. What is peculiar about this manual is that each chapter of this resource includes realistic exercises, two-minute drills for every topic, and self-check tests so you can observe the results of your work. This guide is available in Kindle and Paperback versions for anyone interested. However, it should be noted that the electronic version of the book provides access to more than 185 practice exam questions, as well as a test engine so that you will not only get a valuable source of information for quality preparation for your forthcoming 1Z0-062 exam, but also a handy reference for further use in the workplace.
- For those wishing to begin efficient preparation for 1Z0-062, you should take a look at ‘OCA: Oracle Database 12c Administrator Certified Associate Study Guide: Exams 1Z0-061 and 1Z0-062 1st Edition’ written by an industry expert with hands-on Oracle database experience, Biju Thomas. With an extensive set of study tools, including flashcards, summary questions for each chapter, assessment tests, as well as practical labs, you will not only have a comprehensive resource for preparation but will also discover the world of day-to-day work as a database administrator. As a result, you will have honed the skills required for certification, such as restricting and sorting data, creating an Oracle Database, administering user security, and more. You can find this guide on Amazon in both Kindle and paperback versions, and in exchange, you get a convenient preparation source, including real-world scenarios, hands-on exercises, and access to exam prep software.
As you can see, there are more than enough ways for comprehensive and productive revision. Thus, each candidate can choose the preparation tool that suits his or her learning style.
NEW QUESTION 120
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. These users can never reuse a password
- B. The CPU_PER_CALL is ignored in the user sessions because of the unlimited value of CPU_PER_CALL
- C. The PASSWORD_LIFE_TIME value is ignored because of the unlimited value of PASSWORD_REUSE_MAX.
- D. In each user session, the limit for LOGICAL_READS_PER_SESSION in the same as defined in the DEFAULT profile.
Answer: C,D
NEW QUESTION 121
Which two statements are true about the Database Configuration Assistant (DBCA)?
(Choose two.)
- A. It can be used to add a new tablespace.
- B. It can generate SQL database creation scripts.
- C. It can be used to create a database template from an existing database.
- D. It can configure Automatic Storage Management (ASM) diskgroups.
- E. It can be used to copy an existing Oracle database to a new host and apply any patches necessary in the new host.
Answer: B,C
Explanation:
References:
https://docs.oracle.com/cd/E17559_01/em.111/e16599/appdx_creating_db_templates.htm# CJACEDCD
NEW QUESTION 122
You create a table with the PERIOD FOR clause to enable the use of the Temporal Validity feature of Oracle Database 12c.
Examine the table definition:
Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table? (Choose three.)
- A. The valid time columns are not populated by the Oracle Server automatically.
- B. Setting the session valid time using DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for data manipulation language (DML), data definition language (DDL), and queries performed by the session.
- C. The valid time columns employee_time_start and employee_time_end are automatically created.
- D. The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.
- E. The valid time columns are visible by default when the table is described.
Answer: A,C,D
NEW QUESTION 123
An employee salary in the non-partitioned EMPLOYEES table, has been updated but the transaction is uncommitted.
Which two types of lock are held by the transaction? (Choose two.)
- A. a null lock on the EMPLOYEES table
- B. a row level lock on the row being updated
- C. a null lock on the row being updated
- D. an exclusive lock on the EMPLOYEES table
- E. a row shared lock on the EMPLOYEES table
Answer: B,E
NEW QUESTION 124
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 cannot start up or shut down a database Instance by using EM express.
- C. You can perform basic administrative tasks for pluggable databases by using the EM express interface.
- 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: B
Explanation:
Explanation
References:
http://www.oracle.com/technetwork/database/manageability/emx-intro-1965965.html
NEW QUESTION 125
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. 1 and 2
- B. Only 3
- C. Only 2
- D. 3 and 1
- E. Only 1
Answer: B
Explanation:
Example (see step23):
Step 1:
Run the RMAN FLASHBACK DATABASE command.
You can specify the target time by using a form of the command shown in the following examples:
FLASHBACK DATABASE TO SCN 46963;
FLASHBACK DATABASE
TO RESTORE POINT BEFORE_CHANGES;
FLASHBACK DATABASE TO TIME
"TO_DATE('09/20/05','MM/DD/YY')";
When the FLASHBACK DATABASE command completes, the database is left mounted and
recovered to the specified target time.
Step 2:
Make the database available for updates by opening the database with the RESETLOGS option. If
the database is currently open read-only, then execute the following commands in SQL*Plus:
SHUTDOWN IMMEDIATE
STARTUP MOUNT
ALTER DATABASE OPEN RESETLOGS;
NEW QUESTION 126
In your Database, the TBS PERCENT USED parameter is set to 60 and the TBS PERCENT FREE parameter is set to 20.
Which two storage-tiering actions might be automated when using information Lifecycle Management (ILM) to
automate data movement?
- A. Setting the target tablespace to read-only
- B. Setting the target tablespace offline
- C. The movement of some blocks to a target tablespace with a lower degree of compression, on a different storage
ti er, when the source tablespace exceeds TBS PERCENT USED - D. The movement of some segments to a target tablespace with a higher degree of compression, on a different
storage tier, when the source tablespace exceeds TBS PERCENT USED - E. The movement of all segments to a target tablespace with a higher degree of compression, on a different storage
ti er, when the source tablespace exceeds TBS PERCENT USED
Answer: A,D
Explanation:
The value for TBS_PERCENT_USED specifies the percentage of the tablespace quota when a tablespace is considered
full. The value for TBS_PERCENT_FREE specifies the targeted free percentage for the tablespace. When the
percentage of the tablespace quota reaches the value of TBS_PERCENT_USED, ADO begins to move data so that
percent free of the tablespace quota approaches the value of TBS_PERCENT_FREE. This action by ADO is a best effort
and not a guarantee.
NEW QUESTION 127
You install a non-RAC Oracle Database. During Installation, the Oracle Universal Installer
(OUI) prompts you to enter the path of the Inventory directory and also to specify an operating system group name.
Which statement is true?
- A. The installation is being performed by the root user.
- B. The operating system group that is specified must have permission to write to the inventory directory.
- C. The operating system group that is specified should have the root user as its member.
- D. The ORACLE_BASE base parameter is not set.
Answer: B
Explanation:
Note:
Providing a UNIX Group Name
If you are installing a product on a UNIX system, the Installer will also prompt you to provide the name of the group which should own the base directory.
You must choose a UNIX group name which will have permissions to update, install, and deinstall Oracle software. Members of this group must have write permissions to the base directory chosen.
Only users who belong to this group are able to install or deinstall software on this machine.
NEW QUESTION 128
Which three are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when it is enabled?
- A. Reduced CPU utilization
- B. Reduced physical I/O
- C. Reduced virtual memory utilization
- D. Improved Serial Execution performance
- E. Reduced logical I/O
- F. Improved parallel Execution performance
Answer: A,C,F
Explanation:
* Multiprocess and Multithreaded Oracle Database Systems
Multiprocess Oracle Database (also called multiuser Oracle Database) uses several processes to run different parts of the Oracle Database code and additional Oracle processes for the users-either one process for each connected user or one or more processes shared by multiple users. Most databases are multiuser because a primary advantage of a database is managing data needed by multiple users simultaneously.
Each process in a database instance performs a specific job. By dividing the work of the database and applications into several processes, multiple users and applications can connect to an instance simultaneously while the system gives good performance.
* In previous releases, Oracle processes did not run as threads on UNIX and Linux systems. Starting in Oracle Database 12c, the multithreaded Oracle Database model enables Oracle processes to execute as operating system threads in separate address spaces.
NEW QUESTION 129
Which two statements are true?
- A. A role can be granted to other roles.
- B. A role cannot be assigned external authentication.
- C. The predefined connect role is always automatically granted to all new usersat the time of their creation.
- D. All roles are owned by the sys user.
- E. The predefined resource role includes the unlimited_tablespace privilege.
- F. A role can contain both system and object privileges.
Answer: A,F
Explanation:
References:
NEW QUESTION 130
Which statement is true regarding the startup of a database instance?
- A. Instance recovery is not required if the database instance was shut down by using SHUTDOWN IMMEDIATE.
- B. Media recovery is required when the database is shut down by using either the IMMEDIATE option or the ABORT option.
- C. Uncommitted transactions are rolled back during the startup of the database instance after a shutdown using the immediate option.
- D. The instance does not start up normally and requires manual media recovery after a shutdown using the ABORT option.
- E. There is no difference in the underlying mechanics of the startup whether the database is shut down by using the IMMEDIATE option or the ABORT option.
Answer: A
Explanation:
Explanation
References:
http://docs.oracle.com/cd/A87860_01/doc/server.817/a76956/start.htm
NEW QUESTION 131
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?
- A. Assign the appropriate operatingsystem groups to SYSBACKUP, SYSDG, SYSKM.
- B. Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege and the
FORCE argument set to No. - C. Re-create the password file withSYSBACKUP, SYSDG, and SYSKM privilege, and
FORCE arguments set to Yes. - D. Re-create the password file in the Oracle Database 12c format.
- E. Grant SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.
Answer: C,E
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 connectwith 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 132
You executed this command to create a password file:
$ orapwd file = orapworcl entries = 10 ignorecase = N
Which two statements are true about the password file? (Choose two.)
- A. It contains usernames and passwords of database users who are members of the OSDBA operating system group.
- B. It will permit the use of uppercase passwords for database users who have been granted the SYSOPER role.
- C. It will permit the use of lowercase passwords for database users who have granted the SYSDBA role.
- D. It will not permit the use of mixed case passwords for the database users who have been granted the SYSDBA role.
- E. It contains username and passwords of database users who are members of the OSOPER operating system group.
Answer: B,C
Explanation:
Explanation
* You can create a password file using the password file creation utility, ORAPWD.
* Adding Users to a Password File
When you grant SYSDBA or SYSOPER privileges to a user, that user's name and privilege information are added to the password file. If the server does not have an EXCLUSIVE password file (that is, if the initialization parameter REMOTE_LOGIN_PASSWORDFILE is NONE or SHARED, or the password file is missing), Oracle Database issues an error if you attempt to grant these privileges.
A user's name remains in the password file only as long as that user has at least one of these two privileges. If you revoke both of these privileges, Oracle Database removes the user from the password file.
* The syntax of the ORAPWD command is as follows:
ORAPWD FILE=filename [ENTRIES=numusers]
[FORCE={Y|N}] [IGNORECASE={Y|N}] [NOSYSDBA={Y|N}]
* IGNORECASE
If this argument is set to y, passwords are case-insensitive. That is, case is ignored when comparing the password that the user supplies during login with the password in the password file.
NEW QUESTION 133
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. These users can never reuse a password
- B. The CPU_PER_CALL is ignored in the user sessions because of the unlimited value of CPU_PER_CALL
- C. The PASSWORD_LIFE_TIME value is ignored because of the unlimited value of PASSWORD_REUSE_MAX.
- D. In each user session, the limit for LOGICAL_READS_PER_SESSION in the same as defined in the DEFAULT profile.
Answer: C,D
NEW QUESTION 134
Which component resides in the System Global Area (SGA) of a database instance only in shared server connections?
- A. User Global Area
- B. PL/SQL Function Result Cache
- C. Programs Global Area
- D. SQL Query Result Cache
Answer: A
NEW QUESTION 135
Identify three benefits of Unified Auditing.
- A. Decreased use of storage to store audit trail rows in the database.
- B. The audit trail cannot be easily modified because it is read-only.
- C. It guarantees zero-loss auditing.
- D. It automatically audits Recovery Manager (RMAN) events.
- E. It improves overall auditing performance.
Answer: A,D,E
Explanation:
A: Starting with 12c, Oracle has unified all of the auditing types into one single unit called Unified auditing. You don't
have to turn on or off all of the different auidting types individually and as a matter of fact auditing is enabled by
default right out of the box. The AUD$ and FGA$ tables have been replaced with one single audit trail table. All of the
audit data is now stored in Secure Files table thus improving the overall management aspects of audit data itself.
B: Further the audit data can also be buffered solving most of the common performance related problems seen on
busy environments.
E: Unified Auditing is able to collect audit data for Fine Grained Audit, RMAN, Data Pump, Label Security, Database
Vault and Real Application Security operations.
Note:
* Benefits of the Unified Audit Trail
The benefits of a unified audit trail are many:
/ (B) Overall auditing performance is greatly improved. The default mode that unified audit works is Queued Write
mode. In this mode, the audit records are batched in SGA queue and is persisted in a periodic way. Because the audit
records are written to SGA queue, there is a significant performance improvement.
/ The unified auditing functionality is always enabled and does not depend on the initialization parameters that were
used in previous releases
/ (A) The audit records, including records from the SYS audit trail, for all the audited components of your Oracle
Database installation are placed in one location and in one format, rather than your having to look in different places
to find audit trails in varying formats. This consolidated view enables auditors to co-relate audit information from
different components. For example, if an error occurred during an INSERT statement, standard auditing can indicate
the error number and the SQL that was executed. Oracle Database Vault-specific information can indicate whether
this error happened because of a command rule violation or realm violation. Note that there will be two audit records
with a distinct AUDIT_TYPE. With this unification in place, SYS audit records appear with AUDIT_TYPE set to Standard
Audit.
/ The management and security of the audit trail is also improved by having it in single audit trail.
/ You can create named audit policies that enable you to audit the supported components listed at the beginning of
this section, as well as SYS administrative users. Furthermore, you can build conditions and exclusions into your
policies.
* Oracle Database 12c Unified Auditing enables selective and effective auditing inside the Oracle database using
policies and conditions. The new policy based syntax simplifies management of auditing within the database and
provides the ability to accelerate auditing based on conditions.
* The new architecture unifies the existing audit trails into a single audit trail, enabling simplified management and
increasing the security of audit data generated by the database.
NEW QUESTION 136
Identify the access that is initially available to connect to your Database as a Service (DBaaS) environment.
- A. telnet on port 23
- B. SSH on port 22
- C. Cloud Control on port 7799
- D. Enterprise Manager on port 1158
- E. SSL/TLS on port 443
Answer: B
NEW QUESTION 137
Examine the details of the uncompressed, non-partitioned heap table CITIES.
Examine the command:
SQL>ALTER TABLE cities SHRINK SPACE COMPACT;
What must you do before executing it?
- A. Ensure there are no pending transactions on the table.
- B. Ensure free space that is approximately equal to the space used by the table should be available.
- C. Disable all indexes on the table.
- D. Enable row movement is enabled.
Answer: D
NEW QUESTION 138
You want to create a database and you have the following:
- Oracle Grid Infrastructure is installed and configured.
- Oracle Database Vault is installed in ORACLE_HOME to be used for this database.
- Oracle Enterprise Manager Cloud Control is available and an agent is deployed on the database server.
Examine the requirements:
1. configuring the database instance to support shared server mode
2. using Automatic Storage Management (ASM) for storing database files.
3. configuring a naming method to help a remote user connect to a database instance
4. configuring the Fast Recovery Area
5. configuring Database Vault
6. configuring Enterprise Manager (EM) Database Express
7. registering with EM Cloud Control
8. configuring remote log archive destinations
9. enabling daily incremental backups
10. configuring a nondefault block size for nondefault block size tablespaces
Which of these requirements can be met while creating a database by using the Database Configuration Assistant (DBCA)?
- A. 1, 2, 3, 8, 9 and 10
- B. 1, 2, 4, 5, 6, 7 and 8
- C. 1, 2, 4, 5, 7, 8, 9 and 10
- D. 1, 2, 3, 4, 6, 8, 9 and 10
- E. 1, 2, 4, 5, 6 and 7
Answer: D
NEW QUESTION 139
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: D
Explanation:
Explanation/Reference:
Explanation:
You can issue the ALTER TABLESPACE...READ ONLY statement while the database is processing transactions. After the statement is issued, the tablespace is put into a transitional read-only state. No transactions are allowed to make further changes (using DML statements) to the tablespace. If a transaction attempts further changes, it is terminated and rolled back. However, transactions that already made changes and that attempt no further changes are allowed to commit or roll back.
NEW QUESTION 140
Which two statements are true about the Oracle Direct Network File system (DNFS)? (Choose two.)
- A. It utilizes the OS file system cache.
- B. Direct NFS is available only in UNIX platforms.
- C. Direct NFS can load-balance I/O traffic across multiple network adapters.
- D. Oracle Disk Manager can manage NFS on its own, without using the operating kernel NFS driver.
- E. A traditional NFS mount is not required when using Direct NFS.
Answer: C,D
Explanation:
Explanation/Reference:
Explanation:
E: Performance is improved by load balancing across multiple network interfaces (if available).
Note:
* To enable Direct NFS Client, you must replace the standard Oracle Disk Manager (ODM) library with one that supports Direct NFS Client.
Incorrect:
Not A: Direct NFS Client is capable of performing concurrent direct I/O, which bypasses any operating system level caches and eliminates any operating system write-ordering locks Not B:
* To use Direct NFS Client, the NFS file systems must first be mounted and available over regular NFS mounts.
* Oracle Direct NFS (dNFS) is an optimized NFS (Network File System) client that provides faster and more scalable access to NFS storage located on NAS storage devices (accessible over TCP/IP).
Not D: Direct NFS is provided as part of the database kernel, and is thus available on all supported database platforms - even those that don't support NFS natively, like Windows.
Note:
* Oracle Direct NFS (dNFS) is an optimized NFS (Network File System) client that provides faster and more scalable access to NFS storage located on NAS storage devices (accessible over TCP/IP). Direct NFS is built directly into the database kernel - just like ASM which is mainly used when using DAS or SAN storage.
* Oracle Direct NFS (dNFS) is an internal I/O layer that provides faster access to large NFS files than traditional NFS clients.
NEW QUESTION 141
Which two statements are true about the logical storage structure of an Oracle database?
- A. An extent contains data blocks that are always physically contiguous on disk.
- B. Each data block always corresponds to one operating system block.
- C. An extent can span multiple segments.
- D. A data block is the smallest unit of I/O in data files.
- E. It is possible to have tablespaces of different block sizes.
Answer: C,E
Explanation:
Explanation/Reference:
References:
NEW QUESTION 142
......
The Oracle 1Z0-062 is one of the two certification exams that you need to pass in order to get the Oracle Database 12c Administrator Certified Associate certificate. The second test is 1Z0-071. The target audience for this exam is those individuals who want to prove their skills in fundamental database terminologies and concepts to guide vital functions for businesses, processes, and systems.
Verified 1z0-062 exam dumps Q&As with Correct 380 Questions and Answers: https://www.ipassleader.com/Oracle/1z0-062-practice-exam-dumps.html
Get New 1z0-062 Certification – Valid Exam Dumps Questions: https://drive.google.com/open?id=1ADPHMePpQFxbcCAl2O_BH-03CMcmx_3L