Summer Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: ecus65

Oracle 1z0-083 - Oracle Database Administration II

Oracle 1z0-083 Premium Access     Download Demo    
Page: 4 / 9
Total 286 questions

You create a table with the PERIOD FOR clause to enable the use of the Temporal Validity feature of Oracle Database 12c. Examine the table definition: create table employees (empno number, salary number, deptid number, name varchar2(100), period for employee_time); Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table?

A.

The valid time columns employee_time_start and employee_time_end are automatically created.

B.

Thesamestatementmayfilteronbothtransactiontimeandvalidtemporaltimebyusingthe AS OF TIMESTAMP and PERIOD FOR clauses.

C.

The valid time columns are not populated by the Oracle Server automatically.

D.

The valid time columns are visible by default when the table is described.

E.

Setting the session valid time using DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for data manipulation language (DML), data definition language (DDL), and queries performed by the session.

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

our SALES_ROOT application container has two application PDBs. The SALES_APP application has a common table, FIN.REVENUE, in the two PDBs. Examine this query and its output: Which two are true? (Choose two.)

A.

The CONTAINERS clause cannot be used in queries on the REVENUE table.

B.

The REVENUE table must be a list-partitioned table.

C.

The MAPTABLE tables defines a logical partition key on a commonly used column for the REVENUE table.

D.

The MAPTABLE table is a metadata-linked table.

E.

A container map exists for the REVENUE table, but is not enabled.

F.

The REVENUE table partitions are not pruned across the PDBs automatically.

Choose two. Which two are true about memory advisors?

A.

If Automatic Memory Management is enabled, no memory advisors are available.

B.

If Automatic Memory Management is enabled, the Shared Pool Advisor and Buffer Cache Advisor are available to set the maximum size for these individual System Global Area components.

C.

All memory advisors use data from Automatic Workload Repository.

D.

If Automatic Shared Memory Management is enabled, both the SGA Advisor and PGA Advisor are always available.

E.

If Manual Shared Memory Management is enabled, only the Shared Pool Advisor and Buffer Cache Advisor are available.

Choose two. Your database is in ARCHIVELOG mode and you plan to use Flashback Database. Which two features or parameters manage space availability in the fast recovery area?

A.

the backup retention policy

B.

the backup optimization policy

C.

the DB_CREATE_ONLINE_LOG_DEST_n parameter setting

D.

the archived log deletion policy

E.

the DB_RECOVERY_FILE_DEST parameter setting

F.

using guaranteed UNDO retention

Choose the best answer. You want to transport the UNIVERSITY tablespace from one database to another. The UNIVERSITY tablespace is currently open read/write. The source and destination platforms have the same endian Examine this list of steps:. 1. Make the UNIVERSITY tablespace read-only on the source 2. Export the UNIVERSITY tablespace metadata using EXPDP. 3. Create a cross-platform backup set from the UNIVERSITY source system, using an RMAN command that includes the DATAPUMP clause. 4. Copy the cross-platform backup sets to the destination system. 5. Copy the Data Pump dump set from the source to the destination system. 6. Restore the cross-platform backup set on the destination system using an RMAN command that includes the DATAPUMP clause. 7. Import the UNIVERSITY tablespace metadata using IMPDP. 8. Make the UNIVERSITY tablespace read/write on the destination system. Which are the minimum number of steps required, in the correct order, to transport the UNIVERSITY tablespace?

A.

3,4,6

B.

2,3,4,5,6,7

C.

1,3,4,6,8

D.

1,2,3,4,5,6,7,8

Examine this configuration: 1. CDB1 is an Oracle Database 12c Release 2 database containing pluggable databases PDB$SEED, PDB1, and PDB2. 2. PDB$SEED is open READ ONLY 3. PDB1 is open READ WRITE 4. PDB2 is MOUNTED. 5. ORACLE_HOME is /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, PDB$SEED, PDB1, and PDB2

B.

PDB$SEED, PDB1, and PDB2 only

C.

CDB1 and PDB$SEED only

D.

CDB1, PDB1, and PDB2 only

E.

CDB1, PDB$SEED, and PDB1 only

Choose two. You plan to perform cross-platform PDB transport using XTTS. Which two are true?

A.

Automatic conversion of endianess occurs.

B.

The source and target platforms must have the same endianess.

C.

The source PDB can be in MOUNT or OPEN state.

D.

The source PDB must not be an application root.

E.

The source PDB must be in MOUNT state.

F.

A backup of the PDB must exist, taken using the BACKUP command with the To PLATFORM clause.

choose one You enable Flashback Data Archive for a table for which you want to track and save all transactions for four years. After some time, the requirement changes for keeping transactions from four to two years. You execute the following command to change the requirement: SQL> ALTER FLASHBACK ARCHIVE fdal MODIFY RETENTION 2 YEAR; What is the outcome?

A.

All historical data older than two years, if any, is purged from the flashback archive FDA1.

B.

An error is returned because the retention period cannot be reduced.

C.

All the flashback data archives are purged and the subsequently created flashback archives are maintained for two years

D.

All historical data older than two years, if any, is archived to flashback logs and the flashback archive is set to new retention time.

Which two arc true about Optimizer Statistics ?

A.

They can be gathered by the DBMS_STATE package.

B.

They are ignored by Optimizer if they are state.

C.

They are gathered by the SQL Tuning Advisor.

D.

By default, they are automatically gathered by a maintenance job.

E.

They provide real-time data about schema objects.