NEW QUESTION 1
You execute this query:
SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE), ‘MON’), ‘dd “Monday for” fmMonth rrrr’) What is the result?

• A. It executes successfully but does not return any result
• B. It returns the date for the first Monday of the next month
• C. It generates an error
• D. It returns the date for the last Monday of the current month

Answer: B

NEW QUESTION 2
Which two statements are true about trace files produced by the Oracle Database server? (Choose two.)

• A. They can be written by server processes
• B. Trace files are written to the Fast Recovery Area (FRA)
• C. They can be written by background processes
• D. All trace files contain error information that require contacting Oracle Support
• E. Trace file names are based on the database name concatenated with a sequential number

Answer: AC

NEW QUESTION 3
The CUSTOMERS table has a CUST_CREDIT_LIMIT column of data type NUMBER. Which two queries execute successfully? (Choose two.)

• A. SELECT NVL(cust_credit_linit * .15, ‘Not Available’) FROM customers;
• B. SELECT NVL2(cust_credit_linit * .15, ‘Not Available’) FROM customers;
• C. SELECT NVL(TO_CHAR(cust_credit_limit * .15), ‘Not Available’) FROM customers;
• D. SELECT TO_CHAR(NVL(cust_credit_limit * .15, ‘Not Available’)) FROM customers;
• E. SELECT NVL2(cust_credit_limit, TO_CHAR(cust_credit_limit * .15), ‘Not Available’) FROM customers;

Answer: BC

NEW QUESTION 4
Which three are types of segments in an Oracle Database? (Choose three.)

• A. undo
• B. index
• C. stored procedures
• D. sequences
• E. tables
• F. clusters

Answer: BEF

NEW QUESTION 5
You want to use table compression suitable for OLTP that will:
Compress rows for all DML statements on that table
Minimize the overheads associated with compression
Which compression option is best suited for this?

• A. COLUMN STORE COMPRESS FOR QUERY LOW
• B. ROW STORE COMPRESS BASIC
• C. COLUMN STORE COMPRESS FOR ARCHIVE LOW
• D. COLUMN STORE COMPRESS FOR ARCHIVE HIGH
• E. ROW STORE COMPRESS ADVANCED

Answer: E

NEW QUESTION 6
Which three statements are true about a self-join? (Choose three.)

• A. The ON clause must be used
• B. The query must use two different aliases for the table
• C. It must be an equi join
• D. It must be an inner join
• E. The ON clause can be used
• F. It can be an outer join

Answer: BDE

NEW QUESTION 7
Which two statements are true about UNDO and REDO? (Choose two.)

• A. The generation of UNDO generates REDO
• B. DML modifies Oracle database objects and only generates UNDO
• C. The generation of REDO generates UNDO
• D. DML modifies Oracle database objects and only generates REDO

Answer: AC

NEW QUESTION 8
Examine the description of the CUSTOMERS table:

You want to display details of all customers who reside in cities starting with the letter D followed by at least two characters.
Which query can be used?

• A. SELECT * FROM customers WHERE city LIKE ‘D_%’;
• B. SELECT * FROM customers WHERE city = ‘%D_’;
• C. SELECT * FROM customers WHERE city LIKE ‘D_’;
• D. SELECT * FROM customers WHERE city = ‘D_%’;

Answer: A

NEW QUESTION 9
Which two statements are true about date/time functions in a session where NLS_DATE_FORMAT is set to DD-MON-YYYY HH24:MI:SS? (Choose two.)

• A. CURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of fractional seconds
• B. SYSDATE can be queried only from the DUAL table
• C. CURRENT_DATE returns the current date and time as per the session time zone
• D. SYSDATE can be used in expressions only if the default date format is DD-MON-RR
• E. SYSDATE and CURRENT_DATE return the current date and time set for the operating system of the database server
• F. CURRENT_TIMESTAMP returns the same date as CURRENT_DATE

Answer: BC

NEW QUESTION 10
Which three statements are true about dropping and unused columns in an Oracle database? (Choose three.)

• A. A primary key column referenced by another column as a foreign key can be dropped if using the CASCADE option.
• B. An UNUSED column’s space is reclaimed automatically when the block containing that column is next queried.
• C. An UNUSED column’s space is reclaimed automatically when the row containing that column is next queried.
• D. Partition key columns cannot be dropped.
• E. A DROP COLUMN command can be rolled back
• F. A column that is set to UNUSED still counts towards the limit of 1000 columns per table

Answer: ABF

NEW QUESTION 11
Which three statements are true about GLOBAL TEMPORARY TABLES? (Choose three.)

• A. A TRUNCATE command issued in a session causes all rows in a GLOBAL TEMPORARY TABLE for the issuing session to be deleted.
• B. GLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session whose user has been granted select on the table.
• C. GLOBAL TEMPORARY TABLE space allocation occurs at session start.
• D. Any GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted.
• E. A GLOBAL TEMPORARY TABLE’S definition is available to multiple sessions.
• F. A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back.

Answer: BCF

NEW QUESTION 12
Which two statements are true about the results of using the INTERSECT operator in compound queries? (Choose two.)

• A. Column names in each SELECT in the compound query can be different
• B. The number of columns in each SELECT in the compound query can be different
• C. Reversing the order of the intersected tables can sometimes affect the output
• D. INTERSECT returns rows common to both sides of the compound query
• E. INTERSECT ignores NULLs

Answer: AE

NEW QUESTION 13
Which three statements are true about time zones, date data types, and timestamp data types in an Oracle database? (Choose three.)

• A. The CURRENT_TIMESTAMP function returns data without time zone information
• B. A TIMESTAMP WITH LOCAL TIMEZONE data type column is stored in the database using the time zone of the session that inserted the row
• C. A TIMESTAMP data type column contains information about year, month, and day
• D. The DBTIMEZONE function can return an offset from Universal Coordinated Time (UTC)
• E. The SESSIONTIMEZONE function can return an offset from Universal Coordinated Time (UTC)

Answer: ADE

NEW QUESTION 14
Which statement is true about the INTERSECT operator used in compound queries?

• A. Multiple INTERSECT operators are not possible in the same SQL statement
• B. It processes NULLs in the selected columns
• C. INTERSECT is of lower precedence than UNION or UNION ALL
• D. It ignores NULLs

Answer: B

NEW QUESTION 15
A database is configured to use automatic undo management with temporary undo enabled. An UPDATE is executed on a temporary table.
Where is the UNDO stored?

• A. in the undo tablespace
• B. in the SYSAUX tablespace
• C. in the SGA
• D. in the PGA
• E. in the temporary tablespace

Answer: A

NEW QUESTION 16
Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)

• A. The ADR base defaults to $ORACLE_HOME/rdbms/admin ifneither DIAGNOSTIC_DEST nor ORACLE_BASE is set
• B. The ADR base defaults to $ORACLE_HOME/dbs if the DIAGNOSTIC_DEST parameter and the ORACLE_BASE environment variable are not set
• C. It supports diagnostics for Automatic Storage Management (ASM)
• D. It supports diagnostics for Oracle Clusterware
• E. It is held inside an Oracle database schema

Answer: AE

NEW QUESTION 17
Examine this command:

Which two statements are true? (Choose two.)

• A. DML may be performed on tables with one or more extents in this data file during the execution of this command.
• B. The tablespace containing SALES1.DBF must be altered READ ONLY before executing the command.
• C. The tablespace containing SALES1.DBF must be altered OFFLINE before executing the command.
• D. If Oracle Managed Files (OMF) is used, then the file is renamed but moved to DB_CREATE_FILE_DEST.
• E. The file is renamed and stored in the same location

Answer: AB

NEW QUESTION 18
In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1.
The TNSNAMES.ORA file in $ORACLE_HOME/network/admin in the database home contains:

Which statement is true?

• A. Dynamic service registration cannot be used for this database instance
• B. The LREG process registers services dynamically with the LISTENER_1 listener
• C. LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration
• D. There are two listeners named LISTENER and LISTENER_1 running simultaneously using port 1521 on the same host as the database instances
• E. The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registration

Answer: C

NEW QUESTION 19
Which two statements are true regarding Oracle database space management within blocks managed by Automatic Segment Space Management (ASSM)? (Choose two.)

• A. PCTFREE defaults to 10% for all blocks in all segments for all compression methods
• B. ASSM assigns blocks to one of four fullness categories based on what percentage of the block is allocated for rows
• C. Update operations always attempt to find blocks with free space appropriate to the length of the row being updated
• D. Insert operations always attempt to find blocks with free space appropriate to the length of the row being inserted
• E. A block will always be eligible for inserts if the row is short enough to fit into the block

Answer: CE

NEW QUESTION 20
Examine this command and some partial output:

Why does the DB01.abc.com service show unknown status?

• A. The service DB01.abc.com is dynamically registered
• B. The LOCAL_LISTENER database parameter is not set to a service name that refers to LISTENER_1
• C. The service DB01.abc.com is statically registered
• D. The listener is not listening on the default port 1521
• E. The SID_LIST_LISTENER section is not contained in the LISTENER.ORA file

Answer: B

NEW QUESTION 21
Which two statements are true about the PMON background process? (Choose two.)

• A. It registers database services with all local and remote listeners known to the database instance
• B. It frees resources held by abnormally terminated processes
• C. It records checkpoint information in the control file
• D. It frees unused temporary segments
• E. It kills sessions that exceed idle time

Answer: AB

NEW QUESTION 22
Which three Oracle database space management features will work with both Dictionary and Locally managed tablespaces? (Choose three.)

• A. Oracle Managed Files (OMF)
• B. Online table segment shrink
• C. Online index segment shrink
• D. Automatic data file extension (AUTOEXTEND)
• E. Capacity planning growth reports based on historical data in the Automatic Workload Repository (AWR)

Answer: ADE

NEW QUESTION 23
You want to write a query that prompts for two column names and the WHERE condition each time it is executed in a session but only prompts for the table name the first time it is executed.
The variables used in your query are never undefined in your session. Which query can be used?

• A. SELECT &&col1, &&col2FROM &tableWHERE &&condition = &&cond;
• B. SELECT &col1, &col2FROM &&tableWHERE &condition;
• C. SELECT &col1, &col2FROM “&table”WHERE &condition;
• D. SELECT ‘&&col1’, ‘&&col2’FROM &tableWHERE ‘&&condition’ = ‘&cond’;
• E. SELECT &&col1, &&col2FROM &tableWHERE &&condition;

Answer: B

NEW QUESTION 24
......