Latest Oracle 1Z0-083 Actual Free Exam Questions & Community Discussion, Page 1

Question #1

Which two are true about unplugging an application container from a container database and plugging it into a different container database?

A. Plugging the application root into a different CDB plugs In all its application PDBs.

B. It requires local undo mode in both container databases.

C. Application PDBs In the applic tion container must be unplugged before the application root Is unplugged.

D. Unplugging the application root from a CDB unplugs all its application PDBs.

E. It requires only local undo mode in the database where the application container will be unplugged.

F. The application root of an application container should be plugged Into the other CDB before Its application PDBs are plugged in.

Discussion 0

Correct Answer: C,F Vote an answer

Question #2

Which two are true about various Oracle security and auditing capabilities?

A. Application-common Transparent Security Data Protection (TSDP) policies can be created only if all the PDBs in the application container are closed.

B. Unified auditing can be automatically synchronized to all application PDBs in an application container.

C. Application-common TSDP policies are always container specific.

D. Fine-grained auditing (FGA) policies in an application root are automatically synchronized to all application PDBs contained in the application container when they are updated.

E. Application-common OLS policies can be created only if all the PDBs in the application container are closed.

Discussion 0

Correct Answer: B,D Vote an answer

Question #3

Which two are true about RMAN duplexed backup sets? (Choose two.)

A. They must be written to media.

B. They can be written only to disk.

C. They can be written to media.

D. They can be created only by using the COPIES option of a BACKUP command.

E. They can be created by using the RMAN CONFIGURE command to specify duplexing before taking a backup.

Discussion 0

Correct Answer: C,E Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #4

Which two are true about the character sets used in an Oracle database? (Choose two.)

A. Multibyte character sets allow more efficient space utilization than single byte character sets.

B. Single-byte character sets always use 7-bit encoding schemes.

C. Unicode enables information from any language to be stored using a single character set.

D. Unicode is the only supported character set for Oracle databases created using Database Configuration Assistant (DBCA).

E. Single-byte character sets always use 8-bit encoding schemes.

F. Single-byte character sets provide better performance than multibyte character sets.

Discussion 0

Correct Answer: C,F Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #5

To schema owned by the RC12C user. The RCAT11 database contains an Oracle Database version 11g catalog schema owned by the RC11 user in which several databases are registered.
Both the databases are open. You execute the RMAN commands:
RMAN> CONNECT CATALOG rcl2c/passl2c@catdbl2c RMAN> IMPORT CATALOG
rcll/pwdcatll@ractll
Which two tasks are performed as part of the import?

A. Local and global stored scripts that have the same name as existing scripts in the RC12C catalog are automatically renamed.

B. Databases from the RC12C catalog are implicitly unregistered if the RC11 catalog has registered databases with same name.

C. Imported databases are unregistered from the RC11 catalog.

D. Recovery catalog is resynchronized with the control files of the registered databases.

E. All databases registered in the RC11 catalog are registered in the RC12C catalog.

Discussion 0

Correct Answer: A,E Vote an answer

Question #6

You plan to create a database by using the Database Configuration Assistant (DBCA), with t he 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 t he 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 t he dedicated server mode option and AMM enabled

C. a General Purpose database template, with t he shared server mode option and Automatic Memory Management (AMM) enabled

D. a default database configuration

Discussion 0

Correct Answer: C Vote an answer

Question #7

Which two are facets of performance planning that should always be considered or implemented for an Oracle Database environment? (Choose two.)

A. the configuration of storage arrays

B. the physical data model

C. defining primary keys for all tables to speed up all queries

D. using check constraints to speed up updates

E. defining foreign keys for all tables to speed up joins

Discussion 0

Correct Answer: A,B Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #8

Examine this configuration:
4. CDB1is an Oracle Database 12c Release 2 database containing pluggable databases PDB$SEED, PDB1, and PDB2.
5. PDB$SEEDis open READ ONLY
6. PDB1is open READ WRITE
7. PDB2 is MOUNTED.
8. ORACLE_HOMEis /u01/app/oracle/product/18.1.0/dbhome_1.
You execute these commands before upgrading the database to the current release:

For which databases will fixup scripts be created?

A. CDB1 and PDB$SEED only

B. CDB1, PDB$SEED, PDB1, and PDB2

C. PDB$SEED, PDB1, and PDB2 only

D. CDB1, PDB1, and PDB2 only

E. CDB1, PDB$SEED, and PDB1 only

Discussion 0

Correct Answer: E Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #9

SQL Performance Analyzer (SPA) has reported several regressed SQL statements for one of your databases.
Which action could help in the performance management of these regressed SQL statements?

A. Use The SQL Tuning Advisor for each of the regressed statements.

B. Use the SQL Access Advisor for each of the regressed statements.

C. Create an adaptive execution plan for each of the regressed statements

D. Create SQL plan directives for each of the regressed statements.

Discussion 0

Correct Answer: A Vote an answer

Question #10

Which three are true? (Choose three.)

A. Virtual Private Database (VPD) policies on objects in an application root are automatically synchronized with all application PDBs contained in the application container.

B. Application-common Oracle Label Security (OLS) policies cannot be created in an application root outside an install/patch BEGIN-ENDblock.

C. Fine-grained auditing (FGA) policies in an application root are automatically synchronized to all application PDBs contained in the application container.

D. Application-common OLS policies can be created in an application root inside an install/patch BEGIN-ENDblock.

E. Unified auditing can be automatically synchronized to all application PDBs in an application container.

F. Application-common TSDP policies are always container specific.

G. Application-common Transparent Security Data Protection (TSDP) policies can be created only within an application install/patch BEGIN-ENDblock.

Discussion 0

Correct Answer: B,E,F Vote an answer

Question #11

Which three are true about Automatic Workload Repository (AWR) snapshots? (Choose three.)

A. They are generated if STATISTICS_LEVEL is set to BASIC.

B. They are always created automatically.

C. They are generated if STATISTICS_LEVEL is set to ALL.

D. They are always created manually.

E. They can be retained forever.

F. They are generated if STATISTICS_LEVEL is set to TYPICAL.

Discussion 0

Correct Answer: C,E,F Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #12

The persistent configuration settings for RMAN have default for all parameters. Identify four RMAN commands that produce a multi-section backup.

A. BACKUP INCREMENTAL LEVEL 0 TABLESPACE SYSAUX SECTION SIZE 100M;

B. BACKUP AS COPY TABLESPACE SYSTEM SECTION SIZE 100M;

C. BACKUP TABLESPACE "UNDO" INCLUDE CURRENT CONTROLFILE SECTION SIZE
100M;

D. BACKUP TABLESPACE "TEMP" SECTION SIZE 10M;

E. BACKUP SPFILE SECTION SIZE 1M;

F. BACKUP TABLESPACE SYSTEM SECTION SIZE 100M;

G. BACKUP ARCHIVELOG ALL SECTION SIZE 25M;

Discussion 0

Correct Answer: A,B,F,G Vote an answer

Question #13

Examine the command for creating pluggable database PDB2 in container database CDB2.

Select three options, any one of which is required for it to execute successfully. (Choose three.)

A. Add the FILE_NAME_CONVERT clause to the statement and set the
PDB_FILE_NAME_CONVERT parameter.

B. Enable only OMF.

C. Add the FILE_NAME_CONVERT clause to the statement and enable Oracle Managed Files (OMF)

D. Set only the PDB_FILE_NAME_CONVERT parameter.

E. Add only the CREATE_FILE_DEST clause to the statement.

F. Set the PDB_FILE_NAME_CONVERT parameter and enable OMF.

Discussion 0

Correct Answer: B,D,E Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #14

Which two are true about RMAN image copies?

A. They can only be written to disk.

B. They can be used as a level 0 incremental backup.

C. They can be used as a level 1 incremental backup.

D. They can be encrypted using Transparent Data Encryption (TDE).

E. They are the only backup option available for databases in NOARCHIVELOG mode.

Discussion 0

Correct Answer: A,B Vote an answer

Oracle 1Z0-083 Actual Free Exam Questions & Community Discussion

Download Free Oracle 1Z0-083 Demo