1z0-074 무료 덤프문제 온라인 액세스

Your CDB has a PDB, EMP_PDB.
You successfully execute these commands as the SYSTEM USER in CDB$ROOT:

Which two statements are true about C##USR1? (Choose two.)

• A.It is a common user.
• B.It can connect to EMP_PDB but cannot view the data in any table in it.
• C.It can connect to EMP_PDB and view the data only in tables created by common users.
• D.It is a local user.
• E.It can connect only to the root.

In which situation can the optimizer choose a hash join?

• A.when an equality operator is used
• B.when a non-equijoin is used and the join column in at least one of the tables is a primary key
• C.when a non-equijoin is used between a table and a sorted hash cluster
• D.when any self-join is done
• E.when a non-equijoin is used and the join column for both tables is a primary key

While performing a cross-platform PDB transport in an Oracle Database 12c Release 2 database, by using XTTS from a Linux (x86-64) server to a Solaris (x86-64) server, this command is executed to back up the files in a compatible format:

What will be the outcome?

• A.It creates the /tmp/pdb_orcl.xml file, which contains the metadata and data of the source database.
• B.The backup fails because the UNPLUG operation for cross-endian platforms is not supported.
• C.It creates a backupset of the source database in the /home/oracle/backup directory
• D.It successfully completes.
• E.It successfully takes a backup but the UNPLUG operation of PDB_ORCL fails.

In a database on an Oracle Exadata Database machine, a DBA executes this command:
SQL> exec DBMS_INMEMORY_ADMIN.ENABLE_FASTSTART ('fs_tbs');
What is the result?

• A.Any data in the In-Memory column store is copied in uncompressed columnar format to the FS_TBS tablespace.
• B.Any data in the In-Memory column store is copied in compressed columnar format to the FS_TBS tablespace.
• C.Any data in the In-Memory column store is copied in row major format to the FS_TBS tablespace.
• D.All columns for all tables in the FS_TBS tablespace are loaded into the In-Memory column store.

APP1 is an application container that has an application seed and two application PDBs, APP_PDB1 and APP_PDB2.
1.0 is the current version of the application.
You execute this block in the application root:

What is the outcome?

• A.An error is thrown because the version number should be sequential, either 1.1 or 2.0.
• B.A common role is created only in the application root and application seed.
• C.An error is thrown because the CONTAINER=ALL clause is missing.
• D.A common role is created only in the application root.
• E.A common role is created in the application root, application seed, APP_PDB1, and APP_PDB2.
• F.An error is thrown because the c## prefix is missing in the role name.