السؤال #1

Which three are true about Oracle Grid Infrastructure for a Standalone Server?

A. t requires Oracle ASMLib to manage Automatic Storage Managerment (ASMl) disks

B. t creates one disk group during installation

C. t includes both Oracle Restart and Oracle Automatic Storage Management (ASM) software

D. utomatic Storage Management (ASM requires that ars groups OSASM and OSDBA be assigned assecondary groups for its installation owner

E. t requires the operating system ORACLE_BASDE environment variable to be predefined before installation

F. t requires Oracle ASM Filter Drver (ASMFD) to manage Automatic Storage Managemernt (AsM) disks

عرض الإجابة

اجابة صحيحة: BCD

السؤال #2

Which three are true about Oracle Grid Infrastructure for a Standalone Server?

A. It includes both Oracle Restart and OracleAutomatic Storage Management (ASM) software

B. It creates one disk group during installation

C. It requires the operating system oracle_base environment variable to be predefined before installation

D. It requires Oracle ASM Filter Driver (ASMFD) to manage Automatic Storage Management (ASM) disks

E. It requires Oracle ASMLibto manage Automatic Storage Management (ASM) disks

F. Automatic Storage Management (ASM) requires that O/S groups OSASM and OSDBA be assigned as secondary groups for its installationowner

عرض الإجابة

اجابة صحيحة: DE

السؤال #3

Choose three. Which three actions are mandatory post database upgrade?

A. Updating client scripts with the new Oracle home

B. Resetting passwords to enforce case-sensitivity

C. Run OPatch commands from the new Oracle home

D. Setting threshold values for tablespace alerts

E. Migration to unified auditing

F. Upgrading user tables that depend on Oracle-maintained abstract data types

عرض الإجابة

اجابة صحيحة: ACF

السؤال #4

Choose the best answer. Examine this configuration: 1. CDB1 is a container database. 2.DEFAULT_SHARING is METADAT

A. SAL will be added to APP_PDB1

B. SAL will be added to APP_PDB1

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

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

E. It will return an error because EMP

عرض الإجابة

اجابة صحيحة: D

السؤال #5

Choose two. Which two are prerequisites for using FLASHBACK TABLE?

A. A table's constraints must be disabled before issuing the flashback

B. The FLASHBACK ANY TABLE system privilege or the FLASHBACK object privilege must be granted to the user performing the flashback

C. Row Movement must be enabled on the table being flashed back

D. A table's indexes must be set to unusable before issuing the flashback

E. The FLASHBACK ANY TABLE system privilege or the FLASHBACK object privilege must be granted to the table owner

عرض الإجابة

اجابة صحيحة: BC

السؤال #6

Choose three. Which three are true about post-upgrade activities when upgrading an Oracledatabase using Database Upgrade Assistant?

A. Any Recovery Manager (RMAN) recovery catalog must be upgraded manually

B. After a manual upgrade, TNSNAMES

C. Time zone files must be upgraded manually using the DBMS_DST PL/SQL package

D. The new extended data type capability must be enabled by running the utlrp

E. The Oracle Application Express configuration should be updated after upgrading Oracle Database

عرض الإجابة

اجابة صحيحة: ADE

السؤال #7

Choose two. Which two are true about an Oracle gold image-based installation in Oracle 18c andlater releases?

A. It does not require the setup wizard

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

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

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

E. It can only install and configure Oracle Database software

عرض الإجابة

اجابة صحيحة: CE

السؤال #8

Choose the best answer. Examine this configuration: 1. CDB1 is an Oracle container database from anolder release. 2. PDB1, PDB2, PDB3, and PDB4 are pluggable databases in CDB1. A priority listUpgrdList 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 theupgrade occur?

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

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

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

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

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

عرض الإجابة

اجابة صحيحة: A

السؤال #9

Choose three. Which three are true about backing up the control file?

A. t cannot be backed up manually as a binary copy

B. t gets backed up automatically by RMAN as a trace file containing SQL statements for control file recreation when a database backup occurs

C. t can be backed up manually as a binary copy

D. t can get backed up automatically as a binary copy

E. t gets backed up automatically by RMAN when the BACKUP SPFILE command is used

F. t can be backed up manually as a trace file containing SQL statements for control file recreation

عرض الإجابة

اجابة صحيحة: CDF

السؤال #10

Choose three. You must migrate a non-CDB Oracle 11g Database to a CDB without first performing anupgrade to the non-CDB. User-defined objects are stored in several tablespaces in the non-CDB.Which three methods can you use?

A. Data Pump full database export and import

B. cloning the non-CDB as a PDB

C. replication using GoldenGate

D. Data Pump transportable tablespaces

E. Data Pump full transportable database

F. the DBMS_PDB package

عرض الإجابة

اجابة صحيحة: ACD

السؤال #11

You execute this command successfully: SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE; What is the outcome?

A. t creates a binary backup of the control file

B. t updates the alert log with the location and contents of the control file

C. t creates a file that contains SQL statements to re-create the control file

D. t creates a file that contains RMAN scripts to create a duplicate database

E. t creates a copy of the control file in the fast recovery area (FRA)

عرض الإجابة

اجابة صحيحة: C

السؤال #12

Which two arc true about the Automatic Database Diagnostic Monitor (ADDM)?

A. y default it analyzes a period of time corresponding to the last 4 hours of activity

B. hen ADDM reports multiple findings, summing all their impacts can yield to more than 100% of DB time

C. y default it analyzes a period of time corresponding to the last 24 hours of activity

D. t runs automatically after each AWR snapshot

E. esults are written to the alert log

عرض الإجابة

اجابة صحيحة: BD

السؤال #13

Choose two. Your database is in ARCHIVELOG mode and you plan to use Flashback Database. Whichtwo 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

عرض الإجابة

اجابة صحيحة: AD

السؤال #14

Choose two. Which two are true about an RPM-based Oracle Database installation?

A. It includes the Oracle Preinstallation RPM

B. From Oracle Database 18c, a single RPM can be used to install only Oracle Database Server for a single instance

C. It requires an Unbreakable Linux Network (ULN) subscription

D. It performs a software-only Oracle Database installation

E. It uses a service configuration script to create a single-instance database as part of the installation

عرض الإجابة

اجابة صحيحة: BD

السؤال #15

Choose two. Which two are true about PDB archive files?

A. DBMS_PDB

B. They contain a PDB manifest file and all the data files in uncompressed form for a PDB

C. They contain all the data files only in uncompressed form for a PDB

D. They must be created using the DBMS_PDB package

E. They contain a PDB manifest file and all the data files in compressed form for a PDB

F. They contain all the data files only in compressed form for a PDB

عرض الإجابة

اجابة صحيحة: AE

السؤال #16

Choose three. Which three are true about a container database (CDB)?

A. It can be created from a non-CDB

B. It can contain only one PDB$SEED, which is created when the CDB is created

C. It can have local users with the same name in different PDBs

D. It can contain only one Application Container seed, which is created when the Application Container is created

E. It can be created by cloning an existing CDB

F. It can have any number of pluggable databases (PDBs) limited only by space availability

G. It contains predefined common roles in both the root and the seed

عرض الإجابة

اجابة صحيحة: BEG

السؤال #17

Choose the best answer. Examine this configuration: 1. CDB1 is a container database. 2.COMMON_USER_PREFIX is set to an empty string. 3. PDB1 is a pluggable database in CDB1. 4.APP1_ROOT is an application container in CDB1. 5. APP1_PDB1 is an application PDB in APP1_ROOT.You execute these commands: S sqlplus sys/oracle@localhost:1521/cdb1 as sysdba SQL> CREATEROLE role1 CONTAINER=CURRENT; Which is true?

A. It will return an error because creation of a local role is not allowed in CDB$ROOT

B. ROLE1 will be created only in CDB$ROOT

C. It will return an error because common roles must start with C##

D. ROLE1 will be created only in CDB$ROOT and APP1_ROOT

E. ROLE1 will be created in CDB$ROOT, PDB1, APP1_ROOT, and APP1_PDB1

عرض الإجابة

اجابة صحيحة: A

السؤال #18

Choose two. Examine this configuration: 1. CDB1 is a container database. 2. APP1_ROOT is anapplication container contained in CDB1. 3. APP1_ROOT$SEED is the application seed contained inAPP1_ROOT and synchronized with APP1_ROOT. 4. APP1_PDB1 and APP1_PDB2 are application PDBscontained in APP1_ROOT. 5. APP1_USER_APP is an application installed in APP1_ROOT at version1.0. 6. USER1 is a common user in APP1_ROOT and all its application PDBs, created when version 1.0ofAPP1_USER_APPwasinstalled.Youexecutethesecom

A. USER1 can connect to CDB1

B. USER1 can connect to APP1_ROOT and APP1_PDB1

C. USER1 can connect to APP1_ROOT, APP1_ROOT$SEED, and APP1_PDB1

D. USER1 is defined in APP1_PDB2

E. USER1 can connect only to APP1_ROOT

عرض الإجابة

اجابة صحيحة: BD

السؤال #19

Choose two. Which two are true about backup encryption?

A. The Transparent Data Encryption (TDE) keystore is backed up using RMAN

B. Vendor-specific media management software can be used for making encrypted RMAN backups to media

C. The BACKUP BACKUPSET command can encrypt and decrypt backup sets

D. Image copies can be encrypted

E. Keystore-based encryption is the default mode for RMAN backup encryption

F. Backup encryption can be enabled selectively for specific tablespaces

عرض الإجابة

اجابة صحيحة: CE

السؤال #20

Choose three. Which three are true about Recovery Manager (RMAN) active database duplication?

A. Pre-existing backups of the database to be duplicated are required for the "push" method of duplication

B. Pre-existing backups of the database to be duplicated are required for the "pull" method of duplication

C. Pre-existing backups of the database to be duplicated are always used if they exist

D. Image copies can be used to duplicate the active database

E. The active database must be duplicated while in OPEN state

F. No connection to the recovery catalog is required for active database duplication

G. Backup sets can be used to duplicate the active database

عرض الإجابة

اجابة صحيحة: DFG

السؤال #21

Choose two. Which two are true about backup encryption?

A. he Transparent Data Encryption (TDE) keystore is backed up using RMAN

B. endor-specific media management software can be used for making encrypted RMAN backups to media

C. he BACKUP BACKUPSET command can encrypt and decrypt backup sets

D. mage copies can be encrypted

E. eystore-based encryption is the default mode for RMAN backup encryption

F. ackup encryption can be enabled selectively for specific tablespaces

عرض الإجابة

اجابة صحيحة: CE

لا تريد أن تفوت شيئا؟

اجتياز اختبار الممارسة Cisco وPMP وCISA وCISM وAWS بنسبة 100% للبيع!
احصل الان

عرض الإجابات بعد التقديم

لا تريد أن تفوت شيئا؟

اجتياز اختبار الممارسة Cisco وPMP وCISA وCISM وAWS بنسبة 100% للبيع! احصل الان

عرض الإجابات بعد التقديم

اجتياز اختبار الممارسة Cisco وPMP وCISA وCISM وAWS بنسبة 100% للبيع!
احصل الان