Precise 1z0-074 Courses 2021

NEW QUESTION 1
From which two failure scenarios can a database be restored and recovered with theREPAIR DATABASE
command? (Choose two.)

• A. loss ofARCHIVELOGS
• B. loss of a redo log member
• C. loss of a noncritical data file
• D. loss of all copies of the control file
• E. loss of a critical data file such asSYSTEM,SYSAUXorUNDO
• F. loss ofSPFILE

Answer: DE

NEW QUESTION 2
You want to restrict PGA usage to 200 MB for a set of database users’ sessions as part of your organization’s security requirements for combating denial of service (DOS) attacks.
Which statement is true about limiting PGA usage for those users’ sessions?

• A. You can limit their PGA usage by settingSORT_AREA_SIZEto 200 MB.
• B. You cannot limit PGA for a set of database user sessions.
• C. You can limit their PGA usage by settingPGA_AGGREGATE_LIMITto 200 MB.
• D. You can limit their PGA usage by settingPGA_AGGREGATE_TARGETto 200 MB.
• E. You can limit their PGA usage by setting theSESSION_PGA_LIMITdirective by using Database ResourceManager

Answer: C

NEW QUESTION 3
You create and enable a unified audit policy on a database that has the default auditing configuration.

The OE user, who has the DBA role, executes these statements.

What is true about the SELECT statement and why?

• A. It is audited because unified auditing is disabled be default.
• B. It is audited because, by default, the database is in mixed auditing mode with default policies enabled.
• C. It is audited because, by default, all user activities in the database are audited.
• D. It is not audited because the table belongs to another schemA.
• E. It is not audited because audit records are stored only when unified auditing is enabled in the database.

Answer: C

NEW QUESTION 4
The TESTDB container database (CDB) running inARCHIVELOGmode contains two pluggable databases (PDBs)PDB1andPDB2.
A connect descriptor forTESTDBis mapped to the TNS aliastestdb in tnsnames.ora. The defaultRMANconfiguration is used.
Examine these commands:

Which files are backed up?

• A. all root andPDB1data files, and theCONTROLFILE, SPFILE, andFLASHBACKLOGS
• B. all root andPDB1data files, and theCONTROLFILE, SPFILE, andARCHIVELOGS
• C. all root andPDB1data files, and theCONTROLFILEandSPFILE
• D. all root andPDB1data files, and theCONTROLFILE, SPFILE, ONLINE REDO LOG FILES, and ARCHIVELOGS
• E. all root andPDB1data files

Answer: E

NEW QUESTION 5
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 6
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. All columns for all tables in theFS_TBStablespace are loaded into the In-Memory column store.
• B. Any data in the In-Memory column store is copied in compressed columnar format to theFS_TBS tablespace.
• C. Any data in the In-Memory column store is copied in uncompressed columnar format to theFS_TBS tablespace.
• D. Any data in the In-Memory column store is copied in row major format to theFS_TBStablespace.

Answer: A

NEW QUESTION 7
Which statement is true about policy expressions?

• A. A named policy expression is stored in the Data Masking format library.
• 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 policy expression can be applied to columns in different redacted tables.
• E. A named policy expression is stored in the Enterprise Manager Database Express repository.

Answer: C

NEW QUESTION 8
Examine these statements executed in thePROD1database:

Which statements are audited?

• A. only theCREATE USERstatement
• B. only theALTER SYSTEMstatements
• C. only theCREATE USERstatement and the first change toJOB_QUEUE_PROCESSES
• D. only the changes toJOB_QUEUE_PROCESSESand theCREATE USERstatement
• E. all the statements

Answer: D

NEW QUESTION 9
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 10
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 11
Examine this parameter:

Examine these commands:

Which three are true after executing these commands? (Choose three.) (Choose three.)

• A. All statements executed by SH are captured and included in a baseline.
• B. Statements executed by both SH and SYS may be captured and included in a baseline.
• C. Only statements executed by SYS are captured and included in a baseline.
• D. Only statements executed by SH containing the “TEST_ONLY” string are excluded from capture.
• E. Statements executed by any user containing the “TEST_ONLY” string are excluded from capture.
• F. Only repeatable statements executed by SYS and SH are considered for baselines.

Answer: AEF

NEW QUESTION 12
While performing a cross-platform PDB transport in an Oracle Database 12c Release 2 database, by usingXTTSfrom aLinux (x86-64)server to aSolaris (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.xmlfile, which contains the metadata and data of the source database.
• B. The backup fails because theUNPLUGoperation for cross-endian platforms is not supported.
• C. It successfully takes a backup but theUNPLUGoperation ofPDB_ORCLfails.
• D. It successfully completes.
• E. It creates a backupset of the source database in the/home/oracle/backupdirectory

Answer: E

NEW QUESTION 13
USER1is an OS user with the passwordoracleand is only a member of theoinstallgroup. In theORCLdatabase, theOS_AUTHEN_PREFIXvalue isops$.
Examine these commands executed by the DBA:
SQL> CREATE USER ops$user1 IDENTIFIED externally; SQL> GRANT create session TO ops$user1;
How canUSER1be given theSYSRACprivilege?

• A. MakeUser1a member of the OSDBA group in Linux or theORA_%HOMENAME%_SYSDBAgroup in Windows only.
• B. GrantSYSRACtouser1.
• C. GrantSYSRACtoops$user1.
• D. MakeUSER1a member of theOSRACDBAgroup in Linux or theORA_%HOMENAME%_SYSRACgroup in Windows.
• E. GrantSYSDBAtoops$user1

Answer: C

NEW QUESTION 14
Which two operations is theopcuser authorized to perform in an Oracle Database Cloud environment? (Choose two.)

• A. Log in to the database deployment compute node.
• B. Run some commands asroot.
• C. Run all commands asroot.
• D. Only run all commands asoracle.
• E. Only run some commands asoracle.

Answer: AC

NEW QUESTION 15
Your CDB has a PDB,EMP_PDB.
You successfully execute these commands as theSYSTEM USERinCDB$ROOT:

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

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

Answer: AE

NEW QUESTION 16
In which two situations does theINHERIT ANY PRIVILIGESprivilege regulate the privileges used?

• A. when a user creates a new user
• B. when a user performs a GRANT or REVOKE operation
• C. when a user queries aBEQUEATH CURRENT_USERview that references an invoker’s right procedure
• D. when a user runs a procedure created with invoker’s right
• E. when a user runs a procedure created with definer’s right

Answer: CD

NEW QUESTION 17
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 18
You create a refreshable copy PDB,PDB_COPY, from thePDB_ORGPDB by using theREFRESH MODE EVERY 5 MINUTESclause.
What happens every five minutes?

• A. An automatic refresh is done providedPDB_COPYis closed; otherwise the refresh is differed and attempted again after five minutes.
• B. PDB_COPYis automatically closed provided there is no ongoing transaction inPDB_ORGand then reopened as read-only after the refresh is complete.
• C. PDB_COPY’Sstate is automatically changed to read-write and back to read-only after the refresh is complete.
• D. PDB_COPY’Sstate is automatically changed to read-only and then reopened as read-write after the refresh is complete.
• E. An automatic refresh is done providedPDB_COPYis in read-only mode; otherwise the refresh is deferred and attempted again after five minutes.

Answer: E

NEW QUESTION 19
You plan to execute this command:

Which statement is true and why?

• A. It creates partitionsP1andP2whereCOUNTRYis a single column partition key andCHANNELis a subpartition key.
• B. It returns an error because only one set of multiple values can be specified for each partition.
• C. It returns an error because only a single column key can be used for a list-partitioned table.
• D. It returns an error because theAUTOMATICoption must be specified.
• E. It creates partitionsP1andP2whereCOUNTRYandCHANNELare multi-column partition keys.

Answer: E

NEW QUESTION 20
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 21
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 22
Which three database objects can have columns stored in the In-Memory (IM) column store? (Choose three.)

• A. subpartitions
• B. clustered tables
• C. materialized views
• D. index-organized tables
• E. heap tables
• F. any SYS owned objects

Answer: BDF

NEW QUESTION 23
......