NEW QUESTION 1
Which two tasks can be performed in the NOMOUNT state? (Choose two.)

• A. re-creating control files
• B. full database recovery
• C. enabling online redo log archiving
• D. renaming data files
• E. creating a database

Answer: AE

NEW QUESTION 2
Which is true about unexpired undo?

• A. It is required when a transaction rolls back.
• B. It may be used to support flashback queries.
• C. It consists of undo only for uncommitted transactions.
• D. It is always retained for the time specified in UNDO RETENTION.
• E. It is the first type of undo overwritten when trying to avoid out-of-space errors.

Answer: D

NEW QUESTION 3
Examine this command:
CREATE TEMPORARY TABLESPACE temp_tbs TEMPFILE ‘temp01.dbf’ SIZE 10M AUTOEXTEND ON ONLINE
SEGMENT MANAGEMENT AUTO;
Which two changes must you make so that TEMP_TBS is created? (Choose two.)

• A. Add the EXTENT MANAGEMENT LOCAL UNIFORM clause.
• B. Add the NOLOGGING clause.
• C. Remove the SEGMENT MANAGEMENT AUTO clause.
• D. Remove the AUTOEXTEND ON clause.
• E. Remove the ONLINE clause.
• F. Add MAXSIZE for the AUTOEXTEND ON clause.

Answer: AF

NEW QUESTION 4
A database is configured to use automatic undo management with temporary undo enabled. An update is executed on a heap-organized table stored in the TBS1 tablespace. Where is the undo stored?

• A. in the SYSAUX tablespace
• B. in the undo tablespace
• C. in the redo logs
• D. in rollback segments
• E. in the temporary tablespace

Answer: A

NEW QUESTION 5
Which two are true about RETENTION GUARANTEE? (Choose two.)

• A. It is a tablespace attribute.
• B. It prevents FLASHBACK DATABASE operation failure.
• C. It prevents out-of-space errors.
• D. It prevents “Snapshot too old” errors.
• E. It is a static parameter.

Answer: AB

NEW QUESTION 6
In the ORCL database, UNDOTBS1 is the active undo tablespace with a fixed size of 70 MB and RETENTION GUARANTEE.
UNDO_RETENTION is set to 15 minutes and the tablespace does not have AUTOEXTEND on.
Which statement is true about a transaction if UNDOTBS1 fills with uncommitted undo within 10 minutes of the transaction’s first update?

• A. It succeeds and the generated undo is stored in SYSAUX.
• B. It succeeds and the generated undo is stored in TEMP.
• C. It fails and returns the error message “Snapshot too old”.
• D. It succeeds and the generated undo is stored in SYSTEM.
• E. It fails and returns the error message “ORA=30036”: unable to extend segment by 8 in undo tablespace ‘UNDOTBS1’”.
• F. It succeeds and the least recently used undo block UNDOTBS1 is overwritten by the generated undo.

Answer: F

NEW QUESTION 7
In your database, you want to create a tablespace of non-standard block size by using this command: CREATE TABLESPACE ns_tbs
DATAFILE ‘/u01oracle/data/nstbs_f01.dbf’ SIZE 100M BLOCKSIZE 16K;
Which is a requirement for this command to succeed?

• A. All other DB_nK_CACHE_SIZE parameters should be set to zero.
• B. The DB_16K_CACHE_SIZE parameter should be set to a value that can be accommodated in the available SGA.
• C. The value of the DB_CACHE_SIZE parameter should not be 16 KB.
• D. The DB_16K_CACHE_SIZE parameter should be set to a value less than that of DB_CACHE_SIZE.
• E. The DB_BLOCK_SIZE parameter must be set to a value greater than 16 KB.

Answer: B

NEW QUESTION 8
Your database is configured for shared server and the SGA_TARGET parameter is set to a non-zero value. Which three actions could help in handling a large number of concurrent users?

• A. using Automatic SGA Memory Management (ASMM)
• B. setting the LARGE_POOL_SIZE parameter to a non-zero value
• C. increasing the size of the PGA
• D. setting the SHARED_POOL_SIZE parameter to a non-zero value
• E. increasing the number of dispatchers

Answer: BCD

NEW QUESTION 9
Which three object types support deferred segment creation? (Choose three.)

• A. partitioned tables
• B. external tables
• C. heap organized tables
• D. clustered tables
• E. index organized tables
• F. temporary tables

Answer: ACE

NEW QUESTION 10
Which two operations can be performed on external tables? (Choose two.)

• A. creating invisible indexes
• B. creating views
• C. creating partitions
• D. creating public synonyms
• E. executing UPDATE statements

Answer: BD

NEW QUESTION 11
What three are true about Oracle Flashback technology? (Choose three.)

• A. FLASHBACK TRANSACTION can be used to undo the changes made by a committed transaction.
• B. FLASHBACK TABLE can be used to rewind a table back in time.
• C. FLASHBACK DATABASE can be used to rewind a database back and forth in time.
• D. FLASHBACK TABLE can be used to undo dropping a column from a table.
• E. FLASHBACK QUERY can be used to view committed data at any given point in time.

Answer: ACD

NEW QUESTION 12
Which three types of files are used by conventional path SQL*Loader when the TABLE option is not specified? (Choose three.)

• A. control files
• B. bad files
• C. input files
• D. password files
• E. server parameter files (SPFILE)
• F. dump files

Answer: BCD

NEW QUESTION 13
Which two functions are performed by a listener?

• A. creating a user session in the System Global Area (SGA)
• B. verifying the service name in an incoming user request
• C. verifying a user’s authentication credentials
• D. maintaining the connection to a client’s user process until the user request is completed
• E. returning the results of processing from the server process to the user process
• F. connecting a user process to a server process

Answer: EF

NEW QUESTION 14
Which statement is true about smallfile tablespaces?

• A. Extent location metadata is stored in the data dictionary by default.
• B. The number of data files is constrained only by the size of the storage array.
• C. Maximum file size can be set to unlimited only if the logical volume manager supports striping.
• D. Segments can span multiple tablespaces.
• E. Segments can span multiple data files.

Answer: E

NEW QUESTION 15
Which two backup configurations are set by default when you choose Cloud Storage Only as the backup destination? (Choose two.)

• A. encryption of backups only for Enterprise Edition databases
• B. automatic daily full database backups
• C. RMAN incremental backups in a seven-day cycle
• D. encryption of backups only for High Performance and Extreme Performance database versions
• E. on-demand backups that need to be scheduled
• F. encryption for all backups

Answer: CD

NEW QUESTION 16
Which two are true about Oracle recovery and data protection solutions? (Choose two.)

• A. RMAN can be used to FLASHBACK a database.
• B. RMAN can be used to roll back committed transactions.
• C. Data Recovery Advisor can be used to restore a single file from an RMAN backupset.
• D. Data Recovery Advisor can be used to validate backup strategies.
• E. Oracle Data Guard can prevent data loss caused by a site failure.

Answer: AE

NEW QUESTION 17
Which two statements are true about Oracle Data Pump? (Choose two.)

• A. expdp and impdp are its client components.
• B. impdp always uses conventional path inserts when importing data.
• C. The DBMS_DATAPUMP package can be used only with Data Pump clients
• D. It cannot be used to export data as of a previous SCN.
• E. impdp can change target data file names, schemas, and tablespaces during import.

Answer: AC

NEW QUESTION 18
Which three failures do not require intervention for recovery? (Choose three.)

• A. user process failure
• B. media failure
• C. statement failure
• D. network interface card (NIC) failure
• E. transaction failure

Answer: ACE

NEW QUESTION 19
Which two are segment types? (Choose two.)

• A. table partition
• B. materialized views on a prebuilt container
• C. stored procedure
• D. sequence
• E. table
• F. view

Answer: AE

NEW QUESTION 20
Which is true about the UNLIMITED TABLESPACE SYSTEM privilege?

• A. It can be granted to any user and any role.
• B. It is overridden by any specified user space quota.
• C. It allows a user to have unlimited space in any tablespace in the database.
• D. It allows a user to have unlimited space only in his or her default permanent tablespace.
• E. It can be revoked from a user and replaced with a specific space quota only if no user schema objects exist.

Answer: C

NEW QUESTION 21
Which three are true about the Oracle Optimizer? (Choose three.)

• A. It determines the optimal table join order and method.
• B. It generates execution plans for SQL statements based on relevant schema objects, system and session parameters, and information found in the Data Dictionary.
• C. It can optimize only SELECT statements.
• D. It will only generate SQL Plan Directives specific to a given SQL statement.
• E. It can re-optimize execution plans after previous executions detect suboptimal plans.
• F. It updates stale object statistics in the Data Dictionary.

Answer: ABC

NEW QUESTION 22
Which two tasks can you perform by using DBCA for a new database?

• A. Register it with an available Enterprise Manager Management server.
• B. Configure a nonstandard block size.
• C. Configure incremental backups.
• D. Enable flashback.
• E. Create user tablespaces.

Answer: AE

NEW QUESTION 23
You execute this command to connect to an instance from a client on a different machine: CONNECT username/password@net_service_name
No name servers are configured.
Which two are true about net_service_name? (Choose two.)

• A. It must contain the address protocol for only one listener.
• B. It must contain only one address protocol for one listener.
• C. It must be defined in the tnsnames.ora file on the client side.
• D. It must be defined in the tnsnames.ora file on the server side.
• E. It must have the same name as the SERVICE_NAME defined in it.

Answer: DE

NEW QUESTION 24
......