In your multitenant container database (CDB) with two pluggable database (PDBs). You want to create a new PDB by using SQL Developer.
Which statement is true?

• A.The CDB must be open.
• B.The CDB must be in the mount stage.
• C.The CDB must be in the nomount stage.
• D.Alt existing PDBs must be closed.

Comment: *

Name: *

Email: *

Verification: *

On your Oracle 12c database, you Issue the following commands to create indexes SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customers_id, sales_rep_id) INVISIBLE; SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customers_id, sales_rep_id); Which two statements are correct? (Choose two.)

• A.Both the indexes are created; however, only the ORD_COSTOMER index is visible.
• B.The optimizer evaluates index access from both the Indexes before deciding on which index to use for query execution plan.
• C.Only the ORD_CUSTOMER_IX1 index is created.
• D.Only the ORD_CUSTOMER_IX2 index is created.
• E.Both the indexes are updated when a new row is inserted, updated, or deleted In the orders table.

Comment: *

Name: *

Email: *

Verification: *

Examine these two statements:

Which three are true about the MRKT tablespace? (Choose three.)

• A.The MRKT tablespace is created as a small file tablespace, because the file size is less than the minimum required for big file files.
• B.The MRKT tablespace may be dropped if it has no contents.
• C.Users who were using the old default tablespace will have their default tablespaces changed to the MRKT tablespace.
• D.No more data files can be added to the tablespace.
• E.The relative file number of the tablespace is not stored in rowids for the table rows that are stored in the MRKT tablespace.

Comment: *

Name: *

Email: *

Verification: *

In order to exploit some new storage tiers that have been provisioned by a storage administrator, the partitions of a large heap table must be moved to other tablespaces in your Oracle 12c database?
Both local and global partitioned B-tree Indexes are defined on the table.
A high volume of transactions access the table during the day and a medium volume of transactions access it at night and during weekends.
Minimal disrupt ion to availability is required.
Which three statements are true about this requirement?

• A.The partitions can be moved online to new tablespaces.
• B.Global indexes must be rebuilt manually after moving the partitions.
• C.The partitions can be compressed in the same tablespaces.
• D.The partitions can be compressed in the new tablespaces.
• E.Local indexes must be rebuilt manually after moving the partitions.

Comment: *

Name: *

Email: *

Verification: *

Which four operations performed after the Oracle Restart installation are automatically added to the Oracle Restart configuration? (Choose four.)

• A.listener configured by using NETCA
• B.database service created by using SRVCTL
• C.database created by using a SQL statement
• D.database created by using DBCA
• E.ASM instance created by using ASMCA
• F.database service created by using DBMS_SERVICE.CREATE_SERVICE
• G.database service created by modifying the SERVICE_NAMES initialization parameter

Comment: *

Name: *

Email: *

Verification: *