NEW QUESTION 1
Which three statements are true about the Oracle join and ANSI join syntax? (Choose three.)

• A. The Oracle join syntax supports creation of a Cartesian product of two tables
• B. The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax
• C. The SQL:1999 compliant ANSI join syntax supports natural joins
• D. The SQL:1999 compliant ANSI join syntax supports creation of a Cartesian product of two tables
• E. The Oracle join syntax only supports right outer joins
• F. The Oracle join syntax supports natural joins
• G. The Oracle join syntax performs less well than the SQL:1999 compliant ANSI join syntax

Answer: CDF

NEW QUESTION 2
Which three statements are true about Oracle synonyms? (Choose three.)

• A. A synonym cannot be created for a PL/SQL package
• B. A synonym can be available to all users
• C. A SEQUENCE can have a synonym
• D. A synonym created by one user can refer to an object belonging to another user
• E. Any user can drop a PUBLIC synonym

Answer: BCD

NEW QUESTION 3
In one of your databases, you create a user, HR, and then execute this command: GRANT CREATE SESSION TO hr WITH ADMIN OPTION;
Which three actions can HR perform? (Choose three.)

• A. Revoke the CREATE SESSION privilege from other users
• B. Revoke the CREATE SESSION privilege from user HR
• C. Log in to the database instance
• D. Grant the CREATE SESSION privilege with ADMIN OPTION to other users
• E. Execute DDL statements in the HR schema
• F. Execute DML statements in the HR schema

Answer: ADE

NEW QUESTION 4
You execute this command:

Sufficient storage is available in filesystem /u01.
Which two statements are true about the BIG_TBS tablespace? (Choose two.)

• A. AUTOEXTEND is possible for the datafile
• B. It must be bigger than the largest SMALLFILE tablespace
• C. Additional data files may not be added
• D. It will be a dictionary-managed tablespace by default
• E. It will always have a 32K blocksize

Answer: AB

NEW QUESTION 5
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 6
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 7
Which statement is true about aggregate functions?

• A. Aggregate functions can be nested to any number of levels
• B. The AVG function implicitly converts NULLS to zero
• C. Aggregate functions can be used in any clause of a SELECT statement
• D. The MAX and MIN functions can be used on columns with character data types

Answer: A

NEW QUESTION 8
You execute this command:
CREATE SMALLFILE TABLESPACE sales
DATAFILE ‘/u01/app/oracle/sales01.dbf SIZE 5G
SEGMENT SPACE MANAGEMENT AUTO;
Which two actions must you take to ensure UNDOTBS01 is used as the default UNDO tablespace? (Choose two.)

• A. It must be smaller than the smallest BIGFILE tablespace
• B. Free space is managed using freelists
• C. Any data files added to the tablespace must have a size of 5 gigabytes
• D. It uses the database default blocksize
• E. It is a locally managed tablespace

Answer: DE

NEW QUESTION 9
Which two statements are true about the rules of precedence for operators? (Choose two.)

• A. The concatenation operator | | is always evaluated before addition and subtraction in an expression
• B. NULLS influence the precedence of operators in an expression
• C. The + binary operator has the highest precedence in an expression in a SQL statement
• D. Arithmetic operators with equal precedence are evaluated from left to right within an expression
• E. Multiple parentheses can be used to override the default precedence of operators in an expression

Answer: CE

NEW QUESTION 10
You need to calculate the number of days from 1st January 2021 until today. Dates are stored in the default format of DD-MON-RR.
Which two queries give the required output? (Choose two.)

• A. SELECT TO_CHAR(SYSDATE, ‘DD-MON-YYYY’) – ’01-JAN-2021’ FROM DUAL;
• B. SELECT ROUND(SYSDATE – ’01-JAN-2021’) FROM DUAL;
• C. SELECT ROUND(SYSDATE – TO_DATE(‘01/JANUARY/2021’)) FROM DUAL;
• D. SELECT TO_DATE(SYSDATE, ‘DD/MONTH/YYYY’) – ‘01/JANUARY/2021’ FROM DUAL;
• E. SELECT SYSDATE – TO_DATE(’01-JANUARY-2021’) FROM DUAL;

Answer: AB

NEW QUESTION 11
Examine this description of the TRANSACTIONS table:

Which two SQL statements execute successfully? (Choose two.)

• A. SELECT customer_id AS “CUSTOMER-ID”, transaction_date AS DATE, amount + 100 “DUES” FROM transactions;
• B. SELECT customer_id AS “CUSTOMER-ID”, transaction_date AS “DATE”, amount + 100 DUES FROM transactions;
• C. SELECT customer_id AS CUSTOMER-ID, transaction_date AS TRANS_DATE, amount + 100 “DUES AMOUNT” FROM transactions;
• D. SELECT customer_id CUSTID, transaction_date TRANS_DATE, amount + 100 DUES FROM transactions;
• E. SELECT customer_id AS ‘CUSTOMER-ID’, transaction_date AS DATE, amount + 100 ‘DUES AMOUNT’ FROM transactions;

Answer: BD

NEW QUESTION 12
Which two statements are true about the DUAL table? (Choose two.)

• A. It can be accessed only by the SYS user
• B. It consists of a single row and single column of VARCHAR2 data type
• C. It can display multiple rows but only a single column
• D. It can be used to display only constants or pseudo columns
• E. It can be accessed by any user who has the SELECT privilege in any schema
• F. It can display multiple rows and columns

Answer: AB

NEW QUESTION 13
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 14
Which three statements are true about undo segments and the use of undo by transactions in an Oracle database instance? (Choose three.)

• A. An undo segment may be used by multiple transactions simultaneously
• B. Undo segments can wrap around to the first extent when a transaction fills the last extend of the undo segment
• C. Undo segments have a minimum of three extents
• D. Undo segments can extend when a transaction fills the last extent of the undo segment
• E. A single transaction may use multiple undo segments simultaneously
• F. Undo segments must be stored in a BIGFILE tablespace
• G. Undo segments must be stored in a SMALLFILE tablespace

Answer: ADG

NEW QUESTION 15
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 16
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 17
View the Exhibit and examine the structure of the PRODUCTS table. Which two tasks require subqueries? (Choose two.)

• A. Display the number of products whose PROD_LIST_PRICE is more than the average PROD_LIST_PRICE
• B. Display suppliers whose PROD_LIST_PRICE is less than 1000
• C. Display products whose PROD_MIN_PRICE is more than the average PROD_LIST_PRICE of all products, and whose status is orderable
• D. Display the total number of products supplied by supplier 102 which have a product status of obsolete
• E. Display the minimum PROD_LIST_PRICE for each product status

Answer: AC

NEW QUESTION 18
The INVOICE table has a QTY_SOLD column of data type NUMBER and an INVOICE_DATE column of data type DATE.
NLS_DATE_FORMAT is set to DD-MON-RR.
Which two are true about data type conversions involving these columns in query expressions? (Choose two.)

• A. CONCAT (qty_sold, invoice_date) : requires explicit conversion
• B. invoice_date = ’15-march-2021’ : uses implicit conversion
• C. invoie_date > ’01-02-2021’ : uses implicit conversion
• D. qty_sold BETWEEN ‘101’ AND ’110’ : uses implicit conversion
• E. qty_sold = ‘0554982’ uses implicit conversion

Answer: BD

NEW QUESTION 19
Which two statements are true regarding a SAVEPOINT? (Choose two.)

• A. Rolling back to a SAVEPOINT can undo a CREATE INDEX statement
• B. Rolling back to a SAVEPOINT can undo a TRUNCATE statement
• C. Only one SAVEPOINT may be issued in a transaction
• D. A SAVEPOINT does not issue a COMMIT
• E. Rolling back to a SAVEPOINT can undo a DELETE statement

Answer: DE

NEW QUESTION 20
Which three statements are true about table data storage in an Oracle Database? (Choose three.)

• A. Data block headers contain their own Data Block Address (DBA)
• B. A table row piece can be chained across several database blocks
• C. Multiple row pieces from the same row may be stored in different database blocks
• D. Multiple row pieces from the same row may be stored in the same block
• E. Data block free space is always contiguous in the middle of the block
• F. Index block free space is always contiguous in the middle of the block

Answer: BCE

NEW QUESTION 21
Which two statements are true about single row functions? (Choose two.)

• A. MOD : returns the quotient of a division operation
• B. FLOOR : returns the smallest integer greater than or equal to a specified number
• C. TRUNC : can be used to combine any number of values
• D. CONCAT : can be used to combine any number of values
• E. CEIL : can be used for positive and negative numbers

Answer: AC

NEW QUESTION 22
Examine the description of the SALES1 table:

SALES2 is a table with the same description as SALES1. Some sales data is duplicated in both tables.
You want to display the rows from the SALES1 table which are not present in the SALES2 table. Which set operator generates the required output?

• A. INTERSECT
• B. UNION ALL
• C. UNION
• D. SUBTRACT
• E. MINUS

Answer: E

NEW QUESTION 23
In your data center, Oracle Managed Files (OMF) is used for all databases. All tablespaces are smallfile tablespaces.
SALES_Q1 is a permanent user-defined tablespace in the SALES database.
Examine this command which is about to be issued by a DBA logged in to the SALES database: ALTER TABLESPACE sales_q1 ADD DATAFILE;
Which are two actions, either one of which you could take to ensure that the command executes successfully? (Choose two.)

• A. Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify with at least50 Mb of available space.
• B. Specify a path in the DATAFILE clause of the command specifying a location with at least 100M of available space.
• C. Ensure that DB_CREATE_FILE_DEST specifies a location with at least 100 Mb of available space.
• D. Add the AUTOEXTEND ON clause with NEXT set to 100M.
• E. Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify locations with at least 50 Mb of available space.

Answer: BD

NEW QUESTION 24
Which two statements are true about the ORDER BY clause when used with a SQL statement containing a SET operator such as UNION? (Choose two.)

• A. Column positions must be used in the ORDER BY clause
• B. Only column names from the first SELECT statement in the compound query are recognized
• C. The first column in the first SELECT of the compound query with the UNION operator is used by default to sort output in the absence of an ORDER BY clause
• D. Each SELECT statement in the compound query must have its own ORDER BY clause
• E. Each SELECT statement in the compound query can have its own ORDER BY clause

Answer: BE

NEW QUESTION 25
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 26
......