Free Oracle 1Z1-083 Practice Test & Real Exam Questions, Page 4

Question #34

Which should be tuned first when doing a performance tuning exercise for an Oracle Database environment?

A. database instance memory management and sizes

B. SQL statements

C. general operating system health

D. database writer performance

E. log writer performance

Discussion 0

Correct Answer: B Vote an answer

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

Question #35

Choose the best answer. Examine this configuration:
1. CDB1 is an Oracle container database from an older release.
2. PDB1, PDB2, PDB3, and PDB4 are pluggable databases in CDB1. A priority list UpgrdList has these entries: 1, pdb2 2, pdb1, pdb3 You execute this command:
$ /u01/app/oracle/product/18.1.0/db_1/rdbms/admin/dbupgrade -L UpgrdList In which order will the upgrade occur?

A. CDB$ROOT, PDB2, PDB1, and PDB3

B. CDB$ROOT, PDB$SEED, PDB1, PDB3, PDB2, and PDB4

C. CDB$ROOT, PDB$SEED, PDB2, PDB1, PDB3, and PDB4

D. CDB$ROOT, PDB$SEED, PDB2, PDB1, and PDB3

E. CDB$ROOT, PDB1, PDB2, PDB3, and PDB4

Discussion 0

Correct Answer: C Vote an answer

Question #36

Which two are true about backup set compression using RMAN default compression? (Choose two.)

A. Compressed backups cannot have a section size defined.

B. Unused blocks below the high water mark are backed up.

C. Binary compression adds CPU overhead to backup operations.

D. Compression can be done only for locally managed tablespaces.

E. Compressed backups can be written only to media.

Discussion 0

Correct Answer: C,D Vote an answer

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

Question #37

Which two are true about creating container databases (CDBs) and pluggable databases (PDBs) in Oracle 19c and later releases?

A. A PDB snapshot must be a full copy of a source PDB.

B. A CDB can be duplicated only by using the Database Configuration Assistant (DBCA).

C. A CDB can be duplicated using the Database Configuration Assistant (DBCA) in silent mode.

D. A CDB can be duplicated using Recovery Manager (RMAN) with no configuration required before starting the duplication.

E. A PDB snapshot can be a sparse copy of a source PDB.

Discussion 0

Correct Answer: C,E Vote an answer

Question #38

Examine these actions:
1. Create a new database for a recovery catalog.
2. Create a tablespace with sufficient space in the catalog database for the recovery catalog.
3. Configure ARCHIVELOGmode for the catalog database.
4. Create a user to own the recovery catalog schema with quota on the tablespace that will contain the catalog.
5. Grant the RECOVERY_CATALOG_OWNERrole to the recovery catalog schema owner.
6. Grant the SYSBACKUP privilege to the recovery catalog schema owner.
Which are the minimum actions that must be performed before executing the CREATE CATALOG command?

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

B. 2, 4, 5

C. 1, 3, 4, 5

D. 2, 4, 5, 6

E. 1, 2, 4, 5

Discussion 0

Correct Answer: B Vote an answer

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

Question #39

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

A. They must be written to media.

B. They can be written to media.

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

D. They can be written only to disk.

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

Discussion 0

Correct Answer: B,E Vote an answer

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

Question #40

Choose the best answer. Examine this configuration:
1. CDB1 is a container database.
2.DEFAULT_SHARING is METADATA.
3. APP_ROOT is an application root contained in CDB1.
4. APP_PDB1 is an application PDB contained in APP_ROOT.
5. COMPANYAPP is an application contained in APP_ROOT.
6. EMP is a common table created in APP_ROOT and all its application PDBs, created when version 1.0 of COMPANYAPP was installed.
You execute these commands:
$ sqlplus sys/ orac1e@localhost:1521/cdb1 as sysdba
SQL> ALTER SYSTEM SET DEFAULT_SHARING=DATA; System altered.
SQL> ALTER SESSION SET CONTAINER=app_root; Session altered.
SQL> ALTER PLUGGABLE DATABASE APPLICATION companyapp BEGIN UPGRADE '1.0' TO '2.0'; pluggable database altered.
SQL> ALTER TABLE emp ADD (sal NUMBER NOT NULL) ; Table altered.
SQL> ALTER PLUGGABLE DATABASE APPLICATION companyapp END UPGRADE TO '2.0'; Pluggable database altered.
SQL> ALTER SESSION SET CONTAINER=app_pdb1; Session altered.
SQL> DESC emp; Name Null?
Type -------- ------------------------------------------------------ENO NUMBER ENAME VARCHAR2 (20) SQL> SELECT * FROM emp; ENO ENAME ---------------------------------100 Alan 200 Ben SQL> ALTER PLUGGABLE DATABASE APPLICATION companyapp SYNC; What will be the outcome and why?

A. It will return an error because EMP.SAL is empty in APP_ROOT.

B. SAL will be added to APP_PDB1.EMP, with NULLs in columns of existing rows.

C. It will return an error because EMP is not empty in APP_ROOT.

D. It will return an error because the SYNC operation is not allowed when constraints are added to common objects.

E. SAL will be added to APP_PDB1.EMP, with 0 in columns of existing rows.

Discussion 0

Correct Answer: C Vote an answer

Question #41

Which three are true about the Oracle Optimizer? (Choose three.)

A. It obeys all hints.

B. It can re-optimize execution plans after previous executions detect suboptimal plans.

C. It updates stale object statistics in the Data Dictionary.

D. It considers the filters in WHERE clauses when generating execution plans for SQL statements.

E. It considers object statistics when generating execution plans for SQL statements.

F. It can only use SQL Plan Directives tied to the SQL statement for which a plan is being generated.

Discussion 0

Correct Answer: B,D,E Vote an answer

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

Question #42

A redaction policy was added to the SALcolumn of the SCOTT.EMPtable:

All users have their default set of system privileges.
For which three situations will data not be redacted? (Choose three.)

A. SCOTT sessions, because he is the owner of the table

B. SYSTEM session, only if the MGR role is set in the session

C. SCOTT sessions, only if the MGR role is granted to SCOTT

D. SYSTEM sessions, regardless of the roles that are set in the session

E. SYS sessions, regardless of the roles that are set in the session

F. SCOTT sessions, only if the MGR role is set in the session

Discussion 0

Correct Answer: C,D,E Vote an answer

Question #43

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?

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

B. 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.

C. 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.

D. Create the database by using the CREATE DATABASE . . . command and manually import data by using Data Pump.

Discussion 0

Correct Answer: B Vote an answer

Question #44

Which four are true about performance-related Oracle tools?

A. The Automatic Database Diagnostic Monitor (ADDM) Compare Period report can compare two consecutive periods.

B. SQL Performance Analyzer can suggest schema changes.

C. The Active Session History (ASH) report is based on wait event samples.

D. SQL Performance Analyzer can identify regressed SQL statements.

E. Database Replay always uses one replay client for each original database session.

F. The Automatic Database Diagnostic Monitor (ADDM) Compare Period report can compare two non-consecutive periods.

G. Database Replay always uses one replay client for all the original database sessions.

Discussion 0

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

Free Oracle 1Z1-083 Practice Test & Real Exam Questions

Download Free Oracle 1Z1-083 Demo