QUESTION 9 What is true about non-equijoin statement performance?

QUESTION 1 1 NLS_DATE FORMAT is set to DD-MON-YY. Which query requires explicit data type conversion?

QUESTION 18 Which is the default column or columns for sorting output from compound queries using SET operators such as INTERSECT in a SQL statement?

QUESTION 28 Examine the description of the PRODUCTS table: Which query is valid?

QUESTION 40 The EMPLOYEES table contains columns EMP_ID of data type NUMBER and HIRE_DATE of data type DATE. You want to display the date of the first Monday after the completion of six months since hiring. The NLS_TERRITORY parameter is set to AMERICA in the session and , therefore, Sunday is the first day on the wee. Which query can be used?

QUESTION 43 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?

QUESTION 44 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= 10 24 M; What is the Outcome?

QUESTION 47 Your database instance is started by using a server parameter file (SPFILE) . You execute the following command to change the value of the LOG_BUFFER initialization parameter: ALTER SYSTEM SET LOG_ BUFFER= 32M; What is the outcome of this command?

QUESTION 49 Choose the best answer. Examine this scenario: connect / as sysdba Connected. SHUTDOWN TRANSACTIONAL Database closed. Database dismounted. ORACLE instance shut down . STARTUP Now examine these steps: 1 . Oracle instance is started. 2 . The control file is read. 3 . Instance recovery is started. 4 . Datafiles and redo log files are opened. 5 . The spfile or pfile is read. 6 . The database is available for use. 7. The database is mounted. 8. Instance recovery is completed. Identify the correct steps and the order they will be executed in following this command:

QUESTION 50 Choose the best answer. All of your database instances use SPFILES. You executed this command in one of them: ALTER SYSTEM SET MEMORY_ MAX_ TARGET= 1024M; Which statement is true?

QUESTION 56 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?

QUESTION 62 Which statement is true regarding the INTERSECT operator?

QUESTION 65 In one of your databases , the user HR has the password HRMGR. You want to connect to a database instance whose listener listens on port 1531 by using this statement:CONNECT HR/HRMGR@orcl No name server is used. Which statement is true about ORCL?

QUESTION 68 Examine the description of the PROMOTIONS table: Management requires a report of unique promotion costs in each promotion category. Which query would satisfy this requirement?

QUESTION 69 In the ORCL database , UNDOTBS1 is the active undo tablespace with these properties: 1. A size Of 100 MB 2 . AUTOEXTEND is off 3 . UNDO_ RETENTION is set to 15 minutes 4 . It has RETENTION GUARANTEE UNDOTBS1 fills with uncommitted undo 10 minutes after the database opens . What will happen when the next update is attempted by any transaction?