NO.87 Which two statements are true about the rules of precedence for operators? (Choose two.)

NO.88 Which three statements are true about single-row functions? (Choose three.)

NO.89 View the Exhibit and examine the structure of the PRODUCTS table.
Which two tasks require subqueries? (Choose two.)

NO.90 In which three situations does a new transaction always start? (Choose three.)

NO.91 Which two are true about instance recovery for a database that is open in read write mode?
(Choose two.)

NO.92 Which two are true about RETENTION GUARANTEE? (Choose two.)

NO.93 Which two statements are true about the DUAL table? (Choose two.)

NO.94 Your database instance is started with a PFILE.
Examine these parameters:

You want to increase the size of the buffer cache.
Free memory is available to increase the size of the buffer cache.
You execute the command:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE=1024M;
What is the outcome?

NO.95 The stores table has a column START_DATE of data type DATE, containing the date the row was inserted. You only want to display details of rows where START_DATE is within the last 25 months. Which where clause can be used?

NO.96 Which two statements are true about the configuration and use of UNDO_RETENTION with GURANTEED ? (Choose two.) RETENTION

NO.97 Which two statements are true about UNDO and REDO? (Choose two.)

NO.98 Which two statements are true about trace files produced by the Oracle Database server?
(Choose two.)

NO.99 Which three statements are true about the Oracle Data Dictionary? (Choose three.)

NO.100 Examine the description of the members table:

Examine the partial query:
SELECT city, last__name 1NAME FROM members
You want to display all cities that contain the string an. The cities must be returned in ascending order, with the last names further sorted in descending order.
Which two clauses must you add to the query?

NO.101 The SCOTT/TIGER user exists in two databases, BOSTON_DB and DALLAS_DB, in two different locations.
Each database has a tnsnames.ora file defining DALLAS_DB as a service name.
Examine this command:
CREATE DATABASE LINK dblink1 CONNECT TO scott IDENTIFIED BY tiger USING ‘dallas_db’; How do you execute the command so that only SCOTT in BOSTON_DB can access the SCOTT schema in DALLAS_DB?

NO.102 Which three statements are true about the Oracle join and ANSI join syntax? (Choose three.)

NO.103 Which two are true about complete and incomplete recovery? (Choose two.)

NO.104 Examine the description of the customers table:

You need to display last names and credit limits of all customers whose last name starts with A or B in lower or upper case, and whose credit limit Is below 1000.
Examine this partial query:
SELECT cust_last_name, cust_credit_limit FROM customers
Which two where conditions give the required result?
A)


C)

D)

E)

NO.105 Which two statements are true about the Oracle Data Dictionary?

NO.106 Which two statements are true about substitution variables?

NO.107 Your database instance is started with a PFILE.
Examine these parameters:

You want to increase the size of the buffer cache.
Free memory is available to increase the size of the buffer cache.
You execute the command:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE=1024M;
What is the outcome?

NO.108 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.)