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

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

Question No.321

You install Oracle Grid Infrastructure for a standalone server. Which two components are automatically included in the Oracle Restart configuration? (Choose two.)

  1. A pre-existing Oracle Net Listener

  2. Oracle Notification services

  3. A pre-existing database

  4. A pre-existing Oracle management agent

  5. Oracle CSSD service

Correct Answer: BE

Explanation:

https://docs.oracle.com/database/121/LADBI/oraclerestart.htm#LADBI999

Question No.322

Which statement is true about the loss of a data file belonging to the default undo tablespace?

  1. The database remains open in read-only mode.

  2. The database is put in MOUNT state and requires recovery to be opened.

  3. The database remains open for querying but no DML statements can be executed except by the users with SYSDBA privilege.

  4. All the noncommitted transactions are lost.

  5. The database instance aborts.

Correct Answer: C

Question No.323

Which three statements are true about Enterprise Manager Database Express? (Choose three.)

  1. It can be used to perform database backup operations.

  2. It can use the HTTP protocol.

  3. The same port number is used for multiple Database Express configurations on the same host.

  4. It can use the HTTPS protocol.

  5. It is available only when the database is open.

Correct Answer: BDE

Question No.324

Your database is open in read/write mode and multiple users are connected to the database instance.

You execute the following command:

SQLgt; ALTER SYSTEM ENABLE RESTRICTED SESSION;

What would be the effect on current sessions?

  1. They are not terminated but may only issue queries.

  2. They are not affected.

  3. They are terminated immediately.

  4. They are terminated after completing the transaction.

Correct Answer: B

Question No.325

You want to create a test database as a replica of your production database with minimum intervention from a DBA. Which method would you use?

  1. Use DBCA to create a template from the existing database to contain the database structure and then manually copy the data by using Oracle Data Pump.

  2. Use Database Configuration Assistant (DBCA) to create a template from the existing database to contain the database structure.

  3. Create the database by using the CREATE DATAEASE. . . command and manually import data by using Data Pump.

  4. Use DBCA to create a template from the existing database to contain the database structure with data files and then use the same template to create the database in the new location.

Correct Answer: A

Question No.326

Your database is configured for ARCHIVELOG mode, and a daily full database backup is taken. RMAN is configured to perform control file autobackup. In which three scenarios do you need media recovery? (Choose three.)

  1. loss of all the copies of the control file

  2. loss of all the inactive online redo log group members

  3. loss of a data file that belongs to the active undo tablespace

  4. loss of data files that belong to the SYSTEM tablespace

  5. logical corruption of data that is caused by a wrong transaction

  6. abnormal termination of the database instance

Correct Answer: ACD

Question No.327

Which two statements are true about using SQL*Loader? (Choose two.)

  1. It can load data from external files by using the direct path only.

  2. It can load data into multiple tables using the same load statement.

  3. It can load data into only one table at a time.

  4. It can generate unique sequential key values in specified columns.

  5. It can load data from external files by using the conventional path only.

Correct Answer: AC

Question No.328

Your database instance has the following parameter setting: OS_AUTHENT_PREFIX = OPS$

You execute the following command:

image

And then grant OPS$GUEST_USER the CREATE SESSION privilege. Which two statements are true? (Choose two.)

  1. GUEST_USER can query the tables created in the USERS tablespace by default.

  2. The authentication details for GUEST_USER are stored in the database password file.

  3. A local GUEST_USER OS account should exist before GUEST_USER can log on to the database.

  4. D.GUEST_USER can log on to the database without specifying a username and password.

  5. GUEST_USER is forced to change the password at the first login.

Correct Answer: CD

Question No.329

Which two options can be configured for an existing database by using the Database Configuration Assistant (DBCA)? (Choose two.)

  1. Configure Label Security

  2. Database Vault in ORACLE_HOME

  3. Oracle Suggested Backup Strategy

  4. Database Resident Connection Pooling

  5. Nondefault blocksize tablespaces

Correct Answer: AB

Question No.330

You configured the flash recovery area in the database. Which two files would you expect to find in the flash recovery area? (Choose two.)

  1. backup pieces

  2. copies of all parameter files

  3. trace file generated using BACKUP CONTROLFILE TO TRACE

  4. control file autobackups

Correct Answer: AD

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

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.