[Free] 2018(Jan) EnsurePass Passguide Oracle 1z0-063 Dumps with VCE and PDF 51-60

Ensurepass.com : Ensure you pass the IT Exams
2018 Jan Oracle Official New Released 1z0-063
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/1z0-063.html

Oracle Database 12c: Advanced Administration

Question No: 51

Which three statements are true about the startup and shutdown of multitenant container databases (CDBs) and pluggable databases (PDBs)?

  1. A PDB opened in restricted mode allows only local users to connect.

  2. When a CDB is open in restricted mode, PDBs must also be opened in restricted mode.

  3. When a CDB is in mount state, PDBs are automatically placed in mount state.

  4. All PDBs must be shut down before shutting down a CDB instance.

  5. When a CDB instance is started, PDBs can be placed in open state by using database triggers or by executing the alter pluggable databasecommand.

Answer: B,C,E

Question No: 52

Which two statements are true abouta multitenant architecture?

  1. Each pluggable database (PDB) has its own initialization parameter file.

  2. A PDB can have a private undo tablespace.

  3. Log switches occur only at the container database level.

  4. A PDB can have a private temporary tablespace.

  5. Each PDB has a private control file.

Answer: C,D

Question No: 53

The environmental variable oracle_Base is set to /u01/app/oracleand oracle_home is set to

/u01/app/oracle/product/12.1.0/db 1.

You want to check the diagnostic files created as part of the Automatic Diagnostic Repository (ADR). Examine the initialization parameters set in your database.

NAMETYPEVALUE

———————- ———- ————————

audit_file_deststring/u01/app/oracle/admin/eml2rep/adump background_dump_deststring

core_dump_deststring db_create_file_deststring

db_recovery_file_deststring/u01/app/oracle/fast_recovery_area diagnostic_deststring

What is the location of the ADR base?

  1. It is set to/u01/app/oracle/product:/12.1.0/db_1/log.

  2. It is set to /u01/app/oracle/admin/enl2ramp;p/adump.

  3. It is set to /u01/app/oracle.

  4. It is set to/u01/app/oracle/flash_recovery_area.

Answer: A Explanation:

http://docs.oracle.com/cd/B28359_01/server.111/b28310/diag001.htm#ADMIN11008

The Automatic Diagnostic Repository (ADR) is a directory structure that is stored outside of the database. It is therefore available for problem diagnosis when the database is down.

The ADR root directory is known as ADR base. Its location is set by the DIAGNOSTIC_DEST initialization parameter. If this parameter is omitted or left null, the database sets DIAGNOSTIC_DEST upon startup as follows:

If environment variable ORACLE_BASE is set, DIAGNOSTIC_DEST is set to the directory designated by ORACLE_BASE.

If environment variable ORACLE_BASE is not set, DIAGNOSTIC_DEST is set to ORACLE_HOME/log.

Question No: 54

View the SPFILE parameter settings in the Exhibit.

Ensurepass 2018 PDF and VCE

You issue this command and get errors: SQLgt; startup

ORA-00824:cannotsetSGAJTARGET or MEMORY_TARGET dueto existing internalsettings,seealertlog for moreinformation

Why did the instance fail to start?

  1. because pga_aggregate_target is not set

  2. because statistics_level is set to basic

  3. because memory_target and memory_max_target cannot be equal

  4. because sga_target and memory_target are both set

Answer: B

Question No: 55

You are connected to a pluggable database (PDB) as a common user with the sysdba privilege. The PDB is open and you issue the shutdown immediate command.

What is the outcome?

  1. The PDB is closed.

  2. The PDB is placed in mount state.

  3. The command executes only if the common user is granted the set container privilege for the PDB.

  4. The command results in an error because the PDB can be shut down only by a local user.

Answer: A

Reference:http://docs.oracle.com/database/121/ADMIN/cdb_pdb_admin.htm#ADMIN13652

Question No: 56

Identify three benefits of unified auditing.

  1. It helps to reduce disk space used to store an audit trail in a database.

  2. It guarantees zero-loss auditing.

  3. It reduces overhead on a database caused by auditing,by having a single audit trail.

  4. An audit trail cannot be modified because it is read-only.

  5. It automatically audits Recovery Manager (RMAN) events.

Answer: C,D,E

Question No: 57

Your database is running in archivelog mode. You are taking a backup of your database by using RMAN with a recovery catalog. Because of a media failure, one of the data files and all the control files are lost.

Examine the steps to recover the database:

1.Restore the control filesby using the RMAN restore controlfile command. 2.Mount the database.

3.Restore the data files by using the RMAN restore database command. 4.Open the database with the resetlogs option.

  1. Recover the data files by using the RMAN recover using backup controlfile command.

  2. Start the database instance in nomount state.

  3. Connect to the target database by using a recovery catalog. 8.Open the database.

9.Restore the data file. 10.Recover the data file.

Identify the required steps in the correct order.

A. 7,6, 1, 2, 3, 5, 4

B. 7, 2, 1, 3, 5, 8

C. 7, 6, 1, 2, 9, 10, 8

D. 7, 6, 1, 2, 9, 10, 4

Answer: D

Question No: 58

You want RMAN to make duplicate copies of data files when using the backup command. What must you set using the RMAN configure command to achieve this?

  1. MAXSETSIZE TO 2;

  2. DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;

  3. CHANNEL DEVICE TYPE DISK FORMAT #39;/disk1/%U#39; , #39;/disk2/%U#39;;

  4. DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;

Answer: D

e:http://docs.oracle.com/cd/B14117_01/server.101/b10734/rcmconfg.htm http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmconfa.htm#BRADV137

Question No: 59

You created a tablespace with this statement:

CREATE BIGFILE TABLESPACE adtbs

DATAFILE #39;/proddb/data/adtbs.dbf#39; SIZE 10G;

The tablespace is nearly full and youneed to avoid any out of space errors for the load of a 5 gig table.

Which two alter statements will achieve this?

  1. ALTER TA3LESPACE adtbs RESI2E 20G;

  2. ALTER TA3LESPACE adtbs ADD DATAFILE;

  3. ALTER TABLESPACE adtbs AUTOEXTEND ON;

  4. ALTER TA3LESPACE adtbs ADD DATAFILE #39;/proddb/data/adtbsl.dbf#39; SIZE 1QG;

  5. ALTER TA3LESPACE adtbs MODIFY DATAFILE #39;/proddb/data/adtbs.dbf AUTOEXTEND ON;

Answer: A,C

Explanation: http://www.techonthenet.com/oracle/tablespaces/alter_tablespace.php

Question No: 60

Which two statements are true about a common user?

  1. A common user connected to a pluggable database (PDB) can exercise privileges across other PDBs.

  2. A common user with the create user privilege can createother common users, as well as local users.

  3. A common user can be granted only a common role.

  4. A common user can have a local schema in a PDB.

  5. A common user always uses the global temporary tablespace that is defined at the CDB level as the default temporary tablespace.

Answer: C,D

100% Ensurepass Free Download!
Download Free Demo:1z0-063 Demo PDF
100% Ensurepass Free Guaranteed!
1z0-063 Dumps

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

Leave a Reply

Your email address will not be published. Required fields are marked *