A Review Of Real 1z0-074 Free Practice Test

NEW QUESTION 1
Which statement is true about transportable tablespaces?

• A. The tablespace data file or data files to be plugged in to the target database cannot have a different block size than any of the source database’s data file or files.
• B. The cannot be dictionary-managed tablespaces
• C. The source tablespace can be encrypted
• D. They can be administrative tablespaces such asSYSTEMorSYSAUX

Answer: A

NEW QUESTION 2
ACDB,CDB1, has aLOCATIONSapplication container. NORTH_PDBandSOUTH_PDBare two application PDBs inLOCATIONS.
Both application PDBs are synchronized with the application installed in theLOCATIONS root… InCDB2, you create a remote clone,LOC_R, of theLOCATIONSapplication root.
You want to query data across theLOCATIONSapplication PDBs created inCDB1andCDB2. How can you do this?

• A. by creating a proxy PDB inLOCATIONS_ROOTinCDB1, referencingLOC_R
• B. by creating a proxy PDB inCDB1root, referencingLOC_R
• C. by using private database links created inCDB1andCDB2
• D. by using public database links created inCDB1andCDB2
• E. by creating a proxy PDB inCDB2root, referencingLOC_R

Answer: E

NEW QUESTION 3
In a Database Cloud Service (DBCS) environment, which pre-created user hassudoprivileges to run certainrootcommands?

• A. grid
• B. oracle
• C. opc
• D. nobody
• E. oinstall

Answer: C

NEW QUESTION 4
Examine these steps to create a Transparent Sensitive Data Protection (TSDP) policy with unified auditing to protect sensitive data in certain table columns:
Create a TSDP policy and define the audit parameter for the audited columns.
Create a TSDP sensitive type usingDBMS_TSDP_MANAGE.ADD_SENSITIVE_TYPE. Associate the TSDP policy with the sensitive type by
usingDBMS_TSDP_PROTECT.ASSOCIATE_POLICY.
Enable the TSDP policy at the sensitive type level.
Associate the column to be audited to the sensitive type by using DBMS_TSDP_MANAGE.ADD_SENSITIVE_COLUMN.
Identify the steps in the correct sequence.

• A. 1, 2, 3, 4, 5
• B. 2, 1, 4, 5, 3
• C. 2, 5, 1, 3, 4
• D. 1, 2, 4, 3, 5
• E. 2, 1, 5, 3, 4

Answer: C

NEW QUESTION 5
Which two statements are true about a PDB lockdown profile? (Choose two.)

• A. It is created by a local user with the SYSDBA privilege in each PDB where it needs to be applied.
• B. It is created by a common user with the SYSDBA privilege inCDB$ROOT.
• C. It is created by a common user with the SYSDBA privilege in each PDB where it needs to be applied.
• D. It is enabled by default on creation.
• E. It is enabled by using thePDB_LOCKDOWNparameter in each PDBs where it needs to be applied.
• F. It is enabled in PDBs only after the CDB to which the PDBs belong is restarted.

Answer: BC

NEW QUESTION 6
APP1is an application container that has an application seed and two application PDBs,APP_PDB1andAPP_PDB2.
1.1 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. An error is thrown because theCONTAINER=ALLclause is missing.
• C. An error is thrown because thec##prefix is missing in the role name.
• D. A common role is created only in the application root.
• E. A common role is created only in the application root and application seed.
• F. A common role is created in the application root, application seed,APP_PDB1, andAPP_PDB2.

Answer: D

NEW QUESTION 7
TheCOMPATIBLEparameter is set to 12.2.0.0.0.
Which two statements are true about SQL identifier lengths? (Choose two.)

• A. Disk group, PDB, and tablespace names are limited to 30 bytes.
• B. Table names can be as long as 128 bytes.
• C. Database names can be as long as 30 bytes.
• D. Database link names can be as long as 30 bytes.
• E. Database names can be as long as 128 bytes.

Answer: BE

NEW QUESTION 8
TheORCLCDB has a PDB,ORCL_PDB.
Examine these parameters inORCL:

Examine these parameters inORCL_PDB:

You switch toORCL_PDBand plan to execute these commands:

What will be the outcome?

• A. SGA_TARGETis set to 600M.The other values remain unchanged in bothORCLandORCL_PDB.
• B. SGA_TARGETis set to 600M andDB_CACHE_SIZEto 200M inORCL_PD
• C. The other values remain unchanged in bothORCLandORCL_PDB.
• D. SGA_TARGETandSGA_MAX_SIZEare set to 600M andDB_CACHE_SIZEto 200M inORCL_PD
• E. SGA_TARGETandSGA_MAX_SIZEare set to (1360-600)M andDB_CACHE_SIZEto 200M inORCL.
• F. Altering theDB_CACHE_SIZEresults in an error becauseSGA_TARGETshould be altered to 600M first.
• G. Altering theDB_CACHE_SIZEresults in an error because it cannot be altered in a PD
• H. SGA_TARGETsize is changed to 600 M.

Answer: D

NEW QUESTION 9
In which situation can the optimizer choose a hash join?

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

Answer: D

NEW QUESTION 10
Which two statements are true about FLEX ASM? (Choose two.)

• A. A database instance on any node can connect to an ASM instance on any node.
• B. A separate ASM network is required.
• C. It is impossible to connect to a database instance on one node if the database password file for the same database is corrupt on another node in the cluster.
• D. Database instances that depend on an ASM instance that is terminated fail over to a node that has a surviving ASM instance.
• E. Database instances that depend on an ASM instance that is terminated connect to a surviving ASMinstance.

Answer: DE

NEW QUESTION 11
Examine these commands executed in thecdb1container database:

Which statement is true about thec##USER1account?

• A. It is locked for two days after the password expires.
• B. It is locked if the password is not changed within three weeks.
• C. It is locked for 90 minutes after four failed login attempts.
• D. It is locked after for consecutive failed login attempts.
• E. It is not affected by the profile because the user has theSYSDBAprivilege.

Answer: D

NEW QUESTION 12
You execute this command in your database:
ALTER SYSTEM SET ENCRYPT_NEW_TABLESPACES = DDL;
How does this affect the creation of tablespaces?

• A. User tablespaces with noENCRYPTIONclause specified in theCREATE TABLESPACEstatement are not encrypted anywhere.
• B. TEMPandUNDOtablespaces are transparently encrypted with AES128 by default only in the cloud.
• C. TEMPandUNDOtablespaces are transparently encrypted with AES128 by default in an on-premise database.
• D. User tablespaces with noENCRYPTIONclause specified in theCREATE TABLESPACEstatement are transparently encrypted with AES128 only in an on-premise database.
• E. User tablespaces with noENCRYPTIONclause specified in theCREATE TABLESPACEstatement are transparently encrypted with AES128 only in the cloud.

Answer: B

NEW QUESTION 13
Which two statements are true about the In-Memory (IM) column store? (Choose two.)

• A. It may be used for columns in Index Organized Tables (IOTs)
• B. It may be used for columns in clustered tables
• C. IM area size is not controlled by Oracle Automatic Memory Management
• D. IM area size can be set at the CDB and PDB levels
• E. IM area size can be increased or decreased dynamically
• F. It is not used for partitioned tables

Answer: AE

NEW QUESTION 14
Examine these parameters in aPFILEused to start database instance.

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

• A. PGA_AGGREGATE_TARGETandSGA_TARGETremain1Gand2Grespectively.
• B. PGA_AGGREGATE_TARGETandSGA_TARGETare set to zero for the instance.
• C. TheMEMORY_MAX_TARGETparameter is set to zero for the instance.
• D. MEMORY_MAX_TARGETis automatically set to 4G for the instance.
• E. The instance does not start because AMM is enabled butPGA_AGGREGATE_TARGETandSGA_TARGETare set to nonzero values.

Answer: CD

NEW QUESTION 15
The In-Memory compression level is set toMEMCOMPRESS FOR QUERY HIGH. For what purpose is this optimized?

• A. for parallel query performance only
• B. for query performance and space saving
• C. for query performance and space saving with greater bias toward space saving
• D. for query performance only
• E. for space saving only

Answer: B

NEW QUESTION 16
TheTESTDBcontainer database (CDB) contains two pluggable databases (PDBs),PDB1andPDB2. USER1is a local user inPDB1and has theSYSBACKUPprivilege.
Connect descriptors for PDB1 and PDB2 are mapped to TNS aliasespdb1andPDB2intnsnames.ora. Examine these commands executed by USER1 when all PDBs are open:

What is the outcome and why?

• A. An error is returned because the user is connected to a pluggable database.
• B. The current date is displayed.
• C. An error is returned because SQL commands cannot be executed from RMAN without using the SQL shell syntax:SQL”<command>”.
• D. An error is returned because the user is notSYS.
• E. An error is returned because the user is not a common user.

Answer: C

NEW QUESTION 17
Which statement is true about the Automatic Diagnostic Repository (ADR)?

• A. Space used by the ADR can be limited to a user-specified value.
• B. Space used by the ADR is limited based only on the retention period.
• C. The retention period for the ADR is set based on the space limit specified.
• D. When the ADR reaches the space limit, it deletes incident dumps and metadata before deleting old core dumps.
• E. Manual purging of all types of ADR files is allowed.

Answer: E

NEW QUESTION 18
You notice a large number oflatch: cache buffers lru chain and latch: cache buffers chainswait events.
Which four might be reasons for these? (Choose four.)

• A. The same small number of blocks are repeatedly accessed by different sessions simultaneously.
• B. The buffer cache is undersized.
• C. Cursors are closed explicitly after each execution.
• D. A large number of connected user sessions are idle.
• E. DBWR is not writing the dirty buffers fast enough.
• F. Blocks are ageing out of the buffer cache frequently.
• G. Too many sort operations are being performed.

Answer: AEFG

NEW QUESTION 19
You set the maximum size of the diagnostic collection repository by issuing this command asroot.tfact1 set reposizeMB=5120
You then notice that the current repository size is 5 GB and that old files are not being purged. Which statement is true?

• A. Thetfact1command fails because it can be set only by the Oracle software owner.
• B. TFA collects new diagnostic data if theMax Size of TFA Log parameter value is greater than 5 GB.
• C. TFA does not collect new diagnostic data when the maximum repository size is reached.
• D. TFA collects new diagnostic data but logs a warning message.
• E. TFA collects new diagnostic data while the repository directory’s file system has free space.

Answer: A

NEW QUESTION 20
In which three situations would you recommend DB Replay to be used? (Choose three.)

• A. to check the impact of schema changes such as adding new indexes or materialized views
• B. to check the impact of database migration to the cloud
• C. to check the impact of changing the storage system or the network
• D. to check the impact of partitioning a table
• E. to check the impact of new optimizer statistics
• F. to check the impact of upgrading and patching databases

Answer: BCF

NEW QUESTION 21
Which three tasks are performed automatically byDatabase Upgrade Assistant (DBUA)when the
database to be upgraded is in archivelog mode and has the database flashback feature enabled? (Choose three.)

• A. It changes Oracle kernel parameters if required
• B. It creates a restore point to restore the database if the upgrade fails
• C. It drops all the invalid objects
• D. It calls thecatctl.plscript to perform the upgrade process in parallel
• E. It automatically resets theCOMPATIBLEparameter value to12.0.0
• F. It modifies or creates new tablespaces as required

Answer: BCD

NEW QUESTION 22
......