1Z0-083 Actual Questions Answers PDF 100% Cover Real Exam Questions [Q61-Q83]

NEW QUESTION 61
Which three are true about an application container? (Choose three.)

It can contain a single application.

It can contain multiple applications.

It must have an application seed PDB.

It must have an application root PDB.

Two application containers can share an application seed PDB.

An application PDB can belong to multiple application containers.

NEW QUESTION 62
Which three are true about Oracle pluggable databases (PDBs)?

A PDB can be plugged into a CDB only if both are of the same Oracle Database release.

An unplugged PDB can be plugged into multiple CDBs simultaneously by sharing data files.

A PDB unplugged from a container database (CDB) can be plugged into a different CDB without altering any of its schemas.

A non-CDB can be converted into a PDB.

A PDB in a remote CDB can be accessed transparently there by aggregating results from local and remote PDBs.

A PDB created from PDB$SEED must be set to READ WRITE after loading data.

A PDB created from PDB$SEED must be set to READ ONLY after loading data.

NEW QUESTION 63
Which four are true about duplicating a database using Recovery Manager (RMAN)? (Choose four.)

Duplication can be done by having the auxiliary database instance pull backup sets from the target database instance.

A connection to an auxiliary instance is always required.

A subset of the target database can be duplicated.

A new DBID is always created for the duplicated database.

A connection to the recovery catalog instance is always required.

A backup of the target database is always required.

Duplication can be done by having the target database instance push copies to the auxiliary database instance.

A connection to the target database instance is always required.

NEW QUESTION 64
On the 10th of August, you implement an incremental database backup strategy and configure a recovery window of five days.
Level 0 backups are taken on the 10th, 17th, and 24th of August.
Differential level 1 incremental backups are taken daily between the level 0 backups.
Today is the 26th of August.
Which backups will be obsolete?

all backups prior to 10th of August

all backups prior to 22nd of August

all backups prior to 24th of August

all backups prior to 20th of August

all backups prior to 17th of August

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

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

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

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

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

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

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

NEW QUESTION 66
Which two are true about creating RMAN backups for an Oracle container database? (Choose two.)

Tablespaces from different PDBs with identical names must be backed up by connecting RMAN separately to each PDB to back up the tablespaces.

The BACKUP DATABASEcommand will create a pluggable database (PDB) backup when RMAN is connected to a PDB.

SPFILEbackups can be created while connected to an application root PDB.

The BACKUP DATABASE PLUS ARCHIVELOGcommand will back up archive logs when RMAN is connected to a PDB.

The BACKUP PLUGGABLE DATABASEcommand can be used to back up CDB$ROOT.

NEW QUESTION 67
Choose the best answer. A schema owner truncated a table in error and must recover the dat a. Which Oracle Flashback feature could be used to recover the data?

FLASHBACK DATABASE

FLASHBACK TABLE

FLASHBACK VERSION QUERY

FLASHBACK DATA ARCHIVE

FLASHBACK TRANSACTION

NEW QUESTION 68
Examine the RMAN command: RMAN> RUN { ALLOCATE CHANNEL c1 DEVICE TYPE sbt; ALLOCATE CHANNEL c2 DEVICE TYPE sbt; ALLOCATE CHANNEL c3 DEVICE TYPE sbt; BACKUP INCREMENTAL LEVEL = 0 (DATAFILE 1,4,5 CHANNEL c1) (DATAFILE 2,3,9 CHANNEL c2) (DATAFILE 6,7,8 CHANNEL c3); SQL ‘ALTER SYSTEM ARCHIVE LOG CURRENT’; } Which statement is true about the command?

It uses multisection backup.

It uses parallelization for the backup set.

It uses asynchronousI/O for the backup.

It creates compressed backup sets.

NEW QUESTION 69
Examine this configuration: 1. CDB1 is a container database. 2. COMMON_USER_PREFIX is C##. 3. PDB1 is a pluggable database contained in CDB1. 4. APP1_ROOTis an application container contained in CDB1. 5. APP1_PDB1 is an application PDB contained in APP1_ROOT. You execute these commands successfully: Which two are true? (Choose two.)

APP1_USER1can be created in PDB1.

APP1_USER1can be created in CDB1.

APP1_USER1 can have different privileges in each Application PDB contained in APP1_ROOT.

C##_APP_USER1 can be created in CDB1.

P1_USER1can be created in CDB1.

C##_USER1will have the same privileges and roles granted in all PDBs in CDB1.

NEW QUESTION 70
Which two are true about an Oracle gold image-based installation in Oracle 18c and later releases? (Choose two.)

It can be used for both Oracle Database and Oracle Grid Infrastructure installation.

It can only install and configure Oracle Database software. The database has to be created separately.

It does not require the setup wizard.

It uses a single RPM that automatically extracts and installs the Oracle Database software.

It can be used to install and upgrade Oracle Database for single-instance and cluster configurations.

NEW QUESTION 71
A user complains about poor database performance.
You want to verify if the user’s session has waited for certain types of I/O activity. Which view displays all waits waited on by a session at least once?

V$SESSION_EVENT

V$SESSTAT

V$SESSION_WAIT

V$SESSION_WAIT_CLASS

V$SESSION

NEW QUESTION 72
Which two are facets of performance planning that should always be considered or implemented for an Oracle Database environment?

the configuration of storage arrays

the physical data model

defining primary keys for all tables to speed up all queries

defining foreign keys for all tables to speed up joins

using check constraints to speed up updates

NEW QUESTION 73
A container database (CDB) contains two pluggable databases PDB1 and PDB2.
The LOCAL_UNDO_ENABLEDdatabase property is set to FALSEin the CDB.
Data file 24 of PDB2was deleted and you need to restore and recover it.
The only RMAN backup that exists was created with the BACKUP DATABASEcommand while connected to CDB$ROOT.
Which three are true? (Choose three.)

Data file 24 can be recovered only while connected to PDB2.

Data file 24 can be restored and recovered while connected to CDB$ROOT.

Data file 24 can be restored only while connected to CDB$ROOT.

Data file 24 can be restored only while connected to PDB2.

Data file 24 can be recovered while connected to PDB2.

Data file 24 can be recovered while connected to CDB$ROOT.

NEW QUESTION 74
Which two are true about data movement between a non-CDB and a PDB using Data Pump? (Choose two.)

Tablespaces are automatically created as neeed while importing full exports in either a non-CDB or a PDB.

Oracle attempts to convert conventional database users to local users when moving schemas from a non- CDB to a PDB.

A new PDB is automatically created when importing a non-CDB into a CDB.

Oracle attempts to convert common users to conventional users when moving schemas from a PDB to a non-CDB.

Moving data from a PDB to a non-CDB is only possible by using transportable tablespace export and import.

Moving data from a non-CDB to a PDB is only possible by using conventional export and import.

NEW QUESTION 75
You must transport the UNIVERSITYtablespace from one database to another.
The UNIVERSITYtablespace is currently open read/write.
The source and destination platforms have different endian formats.
Examine this list of actions:
1. Make the UNIVERSITY tablespace read-only on the source system.
2. Export the UNIVERSITYtablespace metadata using EXPDP.
3. Convert the UNIVERSITYtablespace data fies to the destination platform format using RMAN on the source system.
4. Copy the UNIVERSITYtablespace data files to the destination system.
5. Copy the Data Pump dump set to the destination system.
6. Convert the UNIVERSITYtablespace data files to the destination platform format using RMAN on the destination system.
7. Import the UNIVERSITYtablespace metadata using IMPDP.
8. Make the UNIVERSITY tablespace read/write on the destination system.
Which is the minimum number of actions required, in the correct order, to transport the UNIVERSITYtablespace?

1, 2, 4, 5, 7, 8

1, 2, 4, 6, 7, 8

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

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

2, 4, 5, 6, 7

NEW QUESTION 76
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 General Purpose database template with default memory allocation

a Data Warehouse database template, with t he dedicated server mode option and AMM enabled

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

a default database configuration

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

A duplexed backup set uses the same number of SBT channels as a non-duplexed backup set for the same number of files.

A non-duplexed backup set written to disk can be duplexed to disk by backing up the backup set that is already on disk.

A non-duplexed backup set written to SBT can be duplexed to tape by backing up the backup set that is already on tape.

A non-duplexed backup set written to disk can be duplexed to tape by backing up the backup set that is already on disk.

A non-duplexed backup set written to SBT can be duplexed to disk by backing up the backup set that is already on tape.

A duplexed backup set always uses twice as many SBT channels as a non-duplexed backup set for the same number of files.

NEW QUESTION 78
Choose the best answer. Examine this configuration: 1. CDB1 is a container database. 2. APP_ROOT is an application root in CDB1. 3. APP_PDB1 is an application PDB in APP_ROOT. 4. FLASHBACK DATABASE is ON. You execute these commands: $ sqlplus sys/orac1e_4U@localhost:1521/cdb1 SQL> SELECT current_scn FROM v$database; CURRENT_SCN ———————–2074756 SQL> CREATE TABLE cdb1_tab(c1 NUMBER) ; Table created. SQL> ALTER SESSION SET CONTAINER=app_root; Session altered. SQL> CREATE TABLE app_root_tab (c1 NUMBER) ; Table created. SQL> ALTER SESSION SET CONTAINER=app_pdb1; Session altered. SQL> CREATE TABLE app_pdb1_tab (c1 NUMBER) ; Table created. SQL> conn / as sysdba Connected. SQL> ALTER PLUGGABLE DATABASE app_root CLOSE; Pluggable database altered. SQL> FLASHBACK PLUGGABLE DATABASE app_root TO SCN 2074756; Flashback complete. Which table or set of tables will exist after the Flashback operation has completed?

CDB1_TAB, APP_ROOT_TAB, and APP_PDB1_TAB

CDB1_TAB and APP_PDB1_TAB

CDB1_TAB and APP_ROOT_TAB

CDB1_TAB only

none of the tables, because all three tables will be dropped

NEW QUESTION 79
Which two are true about Oracle Grid Infrastructure for a Standalone Server? (Choose two.)

It supports volume management, file system, and automatic restart capabilities.

It must be installed before the Oracle database software is installed.

The CSS daemon runs from the Grid Infrastructure home.

It can manage database resources on the server where it is installed or on a different server.

It requires Oracle Automatic Storage Management (ASM) components to be installed separately.

NEW QUESTION 80
Examine this command:
$ rhpctl move database -sourcehome Oracle_home_path -destinationhome Oracle_home_path For which two purposes can you use this command? (Choose two.)

to switch an existing Oracle Database home to a newer release of Oracle software on the same server

to switch to a read-only Oracle home

to switch back to the previous Oracle home as part of a rollback operation

to switch the Oracle Database home when using a centralized Rapid Home Provisioning server

to switch to a patched Oracle Database home

NEW QUESTION 81
The USERS tablespace consists of data files 3 and 4 and must always be online in read/write mode. Which two are true about using RMAN to perform an open database back up of this tablespace? (Choose two.)

Backups must be done incrementally.

Backups must be contained in backup sets.

Backups can be taken only if the database is in ARCHIVE LOG mode.

Backups can be done incrementally.

The database must be registered in an RMAN catalog.

Only consistent backups can be created.

NEW QUESTION 82
For which two requirements can you use the USER_TABLESPACE clause with the CREATE PLUGGABLE DATABASE command? (Choose two.)

to specify a default tablespace in a PDB cloned from another PDB in the same CDB.

to exclude all tablespaces except SYSTEM, SYSAUX, and TEMP when plugging in a PDB

to include specific user tablespaces only when relocating a PDB

to specify the list of user tablespaces to include when moving a non-CDB to a PDB

to exclude a temp tablespace when plugging in a PDB

to specify the list of tablespaces to include when creating a PDB from the CDB seed

NEW QUESTION 83
Which two are true about Oracle Optimizer Statistics, their use, and their collection? (Choose two.)

The number of table rows is considered when evaluating the cost of accessing a table using an index.

Index balanced B*Tree height is considered when evaluating the cost of using an index.

The Statistics Advisor can help recommend the best way to gather statistics.

Statistics collected using DBMS_STATS always yield the best optimizer result.

The Statistics Advisor generates actions for all recommendations.

Quiz Training Materials

1Z0-083 Actual Questions Answers PDF 100% Cover Real Exam Questions [Q61-Q83]

[Nov 05, 2022] Passing Key To Getting 1z0-1065-22 Certified Exam Engine PDF [Q39-Q58]

[Jul 06, 2022] Get New 1Z0-1046-21 Practice Test Questions Answers [Q57-Q73]

Leave a Reply Cancel reply

Quiz Training Materials

1Z0-083 Actual Questions Answers PDF 100% Cover Real Exam Questions [Q61-Q83]

You May Also Like...

[Nov 05, 2022] Passing Key To Getting 1z0-1065-22 Certified Exam Engine PDF [Q39-Q58]

[Jul 06, 2022] Get New 1Z0-1046-21 Practice Test Questions Answers [Q57-Q73]

Leave a Reply Cancel reply