Online Access Free 1z1-074 Exam Questions

To which two components does the term "shape" refer in Oracle Database Cloud Service (DBaaS)? (Choose two.)

• A.amount of RAM
• B.number of database instances
• C.number of storage LUNs
• D.number of network interface cards (NICs)
• E.number of CPUs

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

HR.EMP.EMPLOYEE_ID is the primary key of the HR.EMP partitioned table, which contains 108 rows and resides in the EXAMPLE tablespace.
HR executes this command:
SQL> CREATE TABLE employees TABLESPACE users FOR EXCHANGE WITH TABLE hr.emp; Table created.
Which two statements are true? (Choose two.)

• A.The HR.EMPLOYEES table has 108 records.
• B.The column names HR.EMP and HR.EMPLOYEES are identical.
• C.HR.EMPLOYEES.EMPLOYEE_ID is the PRIMARY KEY of HR.EMPLOYEES
• D.HR.EMP is moved to the USERS tablespace.
• E.Dependent objects of HR.EMP are automatically created for HR.EMPLOYEES.
• F.The column order HR.EMP and HR.EMPLOYEES are identical

In your CDB1 container database, the DB_CREATE_FILE_DEST parameter is set to
'/u01/app/oracle/oradata'.
CDB1 has an application container called REGIONS_APP.
There are no seeds for REGIONS_APP and there are no other application containers.
You plan to execute this command.
CREATE PLUGGABLE DATABASE AS SEED ADMIN USER seed_adm IDENTIFIED BY admin_123; What must you do for the command to execute successfully?

• A.Set the current container to REGIONS_APP
• B.Add the FILE_NAME_CONVERT clause to the command
• C.Add the CREATE_FILE_DEST clause to the command
• D.Set the current container to CDB1
• E.Set the PDB_FILE_NAME_CONVERT parameter to '/u01/app/oracle/oradata'

A multi-tenant container database (CDB) contains three PDBs.
Which three are prerequisites for performing a cross-platform transport of any of the PDBs? (Choose three.)

• A.The COMPATIBLE parameter must be set to 12.2 or greater in the CDB.
• B.The source PDBs must be closed for a cross-platform PDB backup.
• C.The CDB should be in MOUNT state.
• D.The source and target platforms must have the same endianness.
• E.Flashback database must be enabled for the CDB.
• F.The CDB must use Automatic Memory Management.