[Free] 2019(Nov) EnsurePass Oracle 1z0-062 Dumps with VCE and PDF 291-300

Get Full Version of the Exam
http://www.EnsurePass.com/1z0-062.html

Question No.291

Which statement is true about redo log files during instance recovery?

  1. All current, online, and archived redo logs are required to complete instance recovery.

  2. All redo log entries in the current and active logs are applied to data files to reconstruct changes made after the most recent checkpoint.

  3. All redo log entries in the current log are applied to data files until the checkpoint position is reached.

  4. All current, active, and inactive redo logs are required to complete instance recovery.

Correct Answer: C

Explanation:

https://docs.oracle.com/cd/A58617_01/server.804/a58396/ch2.htm

Question No.292

To enable faster incremental backups, you enabled block change tracking for the database. Which two statements are true about the block change tracking file? (Choose two.)

  1. Multiple change tracking files can be created for a database.

  2. The change tracking file must be created after the first level 0 backup.

  3. RMAN does not support backup and recovery of the change tracking file.

  4. The database clears the change tracking file and starts tracking changes again, after whole database restore and recovery operations.

Correct Answer: CD

Question No.293

In your database, the RESOURCE_LIMIT parameter is set to TRUE. You create the profile:

image

Which two statements are true about users and their sessions that are subject to this profile? (Choose two.)

  1. The CPU_PER_CALL is ignored in the user sessions because of the unlimited value of CPU_PER_CALL

  2. These users can never reuse a password

  3. The PASSWORD_LIFE_TIME value is ignored because of the unlimited value of PASSWORD_REUSE_MAX.

  4. In each user session, the limit for LOGICAL_READS_PER_SESSION in the same as defined in the DEFAULT profile.

Correct Answer: CD

Question No.294

Which two statements describe the relationship between a scheduler window, a resource manager plan, and a job class? (Choose two.)

  1. A scheduler window together with a job class, controls resource allocation for a job using that job class in that scheduler window.

  2. A job class specifies a scheduler window that will be open when that job class becomes active.

  3. A scheduler window specifies a resource manager plan that will be activated when that scheduler window becomes active.

  4. A scheduler window specifies a job class that will be activated when that scheduler window becomes active.

  5. A scheduler window can control resource allocation by itself.

Correct Answer: AC

Question No.295

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.

  1. 2, 5, and 6

  2. 1, 2, and 3

  3. 1 and 3

D. 2, 3, 4, and 5

Correct Answer: C

Explanation:

https://docs.oracle.com/cd/E11882_01/server.112/e40540/datadict.htm#CNCPT002

Question No.296

You want to load data from a large file into your database without causing an overhead on the SGA. Which tool would you use.

  1. external table

  2. Oracle data Pump

  3. SQL*Loader with a direct data path

  4. SQL*Loader with a conventional data path

  5. Enterprise Manager Database Express

Correct Answer: C

Explanation:

https://docs.oracle.com/cd/B19306_01/server.102/b14215/ldr_modes.htm#i1007501

Question No.297

Which statement is true about the Oracle central inventory directory (oraInventory)?

  1. oraInventory must not be shared by all Oracle software installations on a single system.

  2. If ORACLE_BASE is set to /u01/app/oracle for the oracle user during an installation, OUI creates the Oracle Inventory directory in the /u01/app/oracle/ oraInventory path.

  3. lf an OFA-compliant path is not created and the ORACLE_BASE environment variable is not set during an Oracle Database installation, the Oracle Inventory directory is placed in the home directory of the user that is performing the installation.

  4. Oracle software owners must be members of the same central oraInventory group, but they need not have this group as their primary group.

Correct Answer: D

Explanation:

https://docs.oracle.com/database/121/CWLIN/usrgrps.htm#CWLIN483

Question No.298

Which statement is true about the Database as a Service (DBaaS) instances and Database instances in Oracle Public Cloud?

  1. An Oracle database instance can support only one DBaaS instance.

  2. A DBaaS instance can support only one Oracle database instance.

  3. An Oracle database instance can support multiple DBaaS instances.

  4. A DBaaS instance can support multiple Oracle database instances.

  5. A DBaaS instance runs in a pluggable database (PDB), which is contained in a multi- tenant container database (CDB).

Correct Answer: D

Question No.299

The HR user owns the BONUSES table. HR grants privileges to the user TOM by using the command:

SQLgt; GRANT SELECT ON bonuses TO tom WITH GRANT OPTION;

TOM then executes this command to grant privileges to the user JIM: SQLgt; GRANT SELET ON hr.bonuses TO jim;

Which statement is true?

  1. TOM cannot revoke the SELECT ON HR.BONUSES privilege from JIM.

  2. HR can revoke the SELECT ON HR.BONUSES privilege from JIM.

  3. JIM can grant the SELECT ON HR.BONUSES privilege to other users, but cannot revoke the privilege from them.

  4. HR can revoke the SELECT ON HR.BONUSES privilege from TOM, which will automatically revoke the SELECT ON HR.BONUSES privilege from JIM.

Correct Answer: D

Question No.300

Which users are created and can be used for database and host management of your DBaaS database servers?

  1. opc and oracle users

  2. root, oracle and cloud users

  3. root and oracle users

  4. root, opc and oracle users

  5. cloud and oracle users

Correct Answer: A

Get Full Version of the Exam
1z0-062 Dumps
1z0-062 VCE and PDF

Leave a Reply