خذ اختبارات أخرى عبر الإنترنت

السؤال #1

You plan to migrate your database from a File system to Automata Storage Management (ASM) on same platform. Which two methods or commands would you use to accomplish this task? (Choose two.)

A. RMAN CONVERT command

B. Data Pump Export and import

C. Conventional Export and Import

D. The BACKUP AS COPY DATABASE

E. DBMS_FILE_TRANSFER with transportable tablespace

عرض الإجابة

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

السؤال #2

Which two statements are true concerning the Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)? (Choose two.)

A. If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that PDB

B. In a PDB plan, subplans may be used with up to eight consumer groups

C. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups across all PDBs in the CDB

D. If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated

E. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan

عرض الإجابة

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

السؤال #3

Your multitenant container database (CDB) contains a pluggable database, HR_PDB. The default permanent tablespace in HR_PDB is USERDATA. The container database (CDB) is open and you connect RMAN. You want to issue the following RMAN command: RMAN > BACKUP TABLESPACE hr_pdb:userdata; Which task should you perform before issuing the command?

A. Place the root container in ARHCHIVELOG mode

B. Take the user data tablespace offline

C. Place the root container in the nomount stage

D. Ensure that HR_PDB is ope

عرض الإجابة

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

السؤال #4

Which action takes place when a file checkpoint occurs?

A. The checkpoint position is advanced in the checkpoint queue

B. All buffers for a checkpointed file that were modified before a specific SCN are written to disk by DBWn and the SCN is stored in the control file

C. The Database Writer process (DBWn) writes all dirty buffers in the buffer cache to data files

D. The Log Writer process (LGWR) writes all redo entries in the log buffer to online redo log file

عرض الإجابة

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

السؤال #5

You executed a DROP USER CASCADE on an Oracle 11g release 1 database and immediately realized that you forgot to copy the OCA.EXAM_RESULTS table to the OCP schema. The RECYCLE_BIN enabled before the DROP USER was executed and the OCP user has been granted the FLASHBACK ANY TABLE system privilege. What is the quickest way to recover the contents of the OCA.EXAM_RESULTS table to the OCP schema?

A. Execute FLASHBACK TABLE OCA

B. Recover the table using traditional Tablespace Point In Time Recovery

C. Recover the table using Automated Tablespace Point In Time Recovery

D. Recovery the table using Database Point In Time Recovery

E. Execute FLASHBACK TABLE OCA

عرض الإجابة

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

السؤال #6

Which statement is true about the Database as a Service (DBaaS) instances and Database instances in Oracle Public Cloud

A. An Oracle database instance can support only one DBaaS instance

B. ADBaaS instance can support only one Oracle database instance

C. An Oracle database instance can support multiple DBaaS instances

D. ADBaaS instance can support multiple Oracle database instances

E. ADBaaS instance runs in a pluggable database (PDB), which is contained in a multi-tenant container database (CDB)

عرض الإجابة

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

السؤال #7

You want to create a table, DAILY_ORDERS, for an OLTP application, where data should be compressed during both direct-path INSERT and conventional DML. The table will also be used for queries. Which compression option should be used?

A. ROW STORE COMPRESS

B. COLUMN STORE COMPRESS FOR QUERY

C. COLUMN STORE COMPRESS FOR ARCHIVE LOW

D. ROW STORE COMPRESS ADVANCED

عرض الإجابة

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

السؤال #8

Which three statements are true about a job chain? (Choose three.)

A. It can contain a nested chain of jobs

B. It can be used to implement dependency-based scheduling

C. It cannot invoke the same program or nested chain in multiple steps in the chain

D. It cannot have more than one dependency

E. It can be executed using event-based or time-based schedules

عرض الإجابة

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

السؤال #9

Which two statements are true about SQL*Loader Express Mode in an Oracle 12c database? (Choose two.)

A. It loads data faster than conventional SQL*Loader

B. No data file needs to be specified

C. It can load data in parallel

D. It loads data more efficiently than conventional SQL*Loader

E. It requires Enterprise Manager Express to be configured

عرض الإجابة

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

السؤال #10

You plan to install the Oracle Database 12c software. You want to use Oracle Automatic Storage Management (ASM) for storage and Oracle Restart for managing components. Oracle Grid Infrastructure for a Standalone Server is already installed on the server. Which three statements must be true for successful installation of the Oracle Database 12c software? (Choose three.)

A. The OSBACKUPDBA, OSDGDBA, and OSKMDBA OS groups must be created

B. An operating system OSDBA group must be created for users with the SYSDBA system privilege

C. The Oracle Database 12c software owner and the Oracle Grid Infrastructure owner must belong to the same Oracle Inventory Group

D. The Oracle Database 12c installation must have a separate Oracle inventory directory

E. An operating system OSOPER group be created for users with the SYSOPER system privileg

عرض الإجابة

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

السؤال #11

You create a new pluggable database, HR_PDB, from the seed database. Which three tablespaces are created by default in HR_PDB? (Choose three.)

A. SYSTEM

B. SYSAUX

C. EXAMPLE

D. UNDO

E. TEMP

F. USERS

عرض الإجابة

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

السؤال #12

You conned using SQL Plus to the root container of a multitenant container database (CDB) with SYSDBA privilege. The CDB has several pluggable databases (PDBs) open in the read/write mode. There are ongoing transactions in both the CDB and PDBs. What happens alter issuing the SHUTDOWN TRANSACTIONAL statement?

A. The shutdown proceeds immediatel

B. The shutdown proceeds as soon as all transactions in the PDBs are either committed or rolled hack

C. The shutdown proceeds as soon as all transactions in the CDB are either committed or rolled back

D. The shutdown proceeds as soon as all transactions in both the CDB and PDBs are either committed or rolled back

E. The statement results in an error because there are open PDBs

عرض الإجابة

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

السؤال #13

Examine this command: SQL> ALTER SYSTEM SET ENABLE_DDL_LOGGING=TRUE; Which two statements are true? (Choose two.)

A. All data definition language (DDL) statements are written to the control file

B. Some DDL statements are written to an XML file in the ADR home

C. All DDL statements are logged in to a text file in Automatic Diagnostic Repository (ADR) home

D. Some data definition language (DDL) statements are written to the control file

E. Some DDL statements are written to a text file in the ADR home

F. The Alert Log still contains some DDL statements

عرض الإجابة

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

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

يرجى إرسال البريد الإلكتروني الخاص بك والواتس اب للحصول على إجابات الأسئلة.

ملحوظة: يرجى التأكد من صلاحية معرف البريد الإلكتروني وWhatsApp حتى تتمكن من الحصول على نتائج الاختبار الصحيحة.

بريد إلكتروني:

رقم الواتس اب/الهاتف:

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

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

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

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

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

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

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