Online Access Free 1z0-074 Practice Test

USER1 is an OS user with the password oracle and is only a member of the oinstall group.
In the ORCL database, the OS_AUTHEN_PREFIX value is ops$.
Examine these commands executed by the DBA:
SQL> CREATE USER ops$user1 IDENTIFIED externally;
SQL> GRANT create session TO ops$user1;
How can USER1 be given the SYSRAC privilege?

• A.Grant SYSDBA to ops$user1
• B.Grant SYSRAC to user1.
• C.Make User1 a member of the OSDBA group in Linux or the ORA_%HOMENAME%_SYSDBA group in Windows only.
• D.Make USER1 a member of the OSRACDBA group in Linux or the ORA_%HOMENAME%_SYSRAC group in Windows.
• E.Grant SYSRAC to ops$user1.

Examine these parameters in a PFILE used to start database instance.

Which two statements are true after an instance restart is attempted and why? (Choose two.)

• A.The MEMORY_MAX_TARGET parameter is set to zero for the instance.
• B.The instance does not start because AMM is enabled but PGA_AGGREGATE_TARGET and SGA_TARGET are set to nonzero values.
• C.MEMORY_MAX_TARGET is automatically set to 4G for the instance.
• D.PGA_AGGREGATE_TARGET and SGA_TARGET remain 1G and 2G respectively.
• E.PGA_AGGREGATE_TARGET and SGA_TARGET are set to zero for the instance.

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

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

Which statement is true about policy expressions?

• A.A named policy expression is stored in the Enterprise Manager Database Express repository.
• B.A named policy expression applied to a column in a redacted table overrides the default expression of its redaction policy.
• C.A redacted table can have only one policy expression defined on it.
• D.A named policy expression is stored in the Data Masking format library.
• E.A policy expression can be applied to columns in different redacted tables.