QUESTION 71 View the Exhibits and examine the structure of the COSTS and PROMOTIONS tables . You want to display PROD_IDS whose promotion cost is less than the highest cost PROD_ID in a promotion time interval. Examine this SQL statement: CUUG,What will be the result?

QUESTION 76 Examine the description of the EMPLOYEES table: Which query is valid?

QUESTION 81 Examine this command and some partial output: Why does the DB01.abc .com service show Unknown status?

QUESTION 86 Examine the following command ; ALTER SYSTEM SET enable_ddl_logging = TRUE; Which statement is true?

QUESTION 89 Choose one Examine the parameters for a database instance: NAME TYPE VALUE Temp_undo_enabled boolean TRUE undo_ management string AUTO undo _retention Integer 900 undo _tablespace string UNDOTBS1 Your database has three undo tablespaces and the default Undo tablespace is not autoextensible. Resumable space allocation is not enabled for any sessions in the database instance. What is the effect on new transactions when all undo space in the default undo tablespace is in use by active transactions?

QUESTION 100 View the Exhibit and examine the structure of the CUSTOMERS table . Using the CUSTOMERS table, you must generate a report that displays a cred it limit increase of 15% for all customers. Customers with no credit limit should have “ Not Available” displayed. Which SQL statement would produce the required result?

QUESTION 101 Which statement is true about aggregate functions?

QUESTION 105 Examine the details of the uncompressed , non-partitioned heap table CITIES. Name CITYID CITY_ NAME Null? NOT NULL Type NUMBER (4 ) VARCHAR2 ( 50) Examine the command: SQL>ALTER TABLE cities SHRINK SPACE COMPACT; What must you do before executing it?

QUESTION 106 You want to reduce fragmentation and reclaim unused space for the sales table but not its dependent objects. During this operation, you want to ensure the following: i. Long-running queries are not Affected. ii. No extra space is used. iii. Data manipulation language (DML) operations on the table Succeed at all times throughout the process iv. Unused space is reclaimed both above and below the high water mark. Which alter TABLE option would you recommend?

QUESTION 109 .A script abc.sql must be executed to perform a job. A database user HR, who is defined in this database, executes this command: $ sqlplus hr/ hr@ orcl @ abc. sql What will happen upon execution?

QUESTION 113 Choose the best answer. Examine these commands: CONNECT / AS SYSDBA CREATE DIRECTORY dumpdir AS ‘/u01/app ’ ; Directory created. GRANT READ ,WRITE ON DIRECTORY dumpdir TO PUBLIC; Grant succeeded. GRANT USER TEST IDENTIFIED BY test; User created. GRANT CREATE SESSION ,RESOURCE , UNLIMITED TABLESPACE TO test; Grant succeeded. CONN test/test. Connected. CREATE TABLE test_employees (id NUMBER(3), name VARCHAR2( 20) , salary NUMBER ( 7 )); Table created. SQL> CREATE SYNONYM emp FOR test_employees; Synonym create . Now examine this command : $ expdp test/test DIRECTORY=dumpdir DUMPFILE=test_emp.dmp LOGFILE=test.log TABLES=emp Which is true?

QUESTION 122 You plan to create a database by using the Database Configuration Assistant (DBCA), with t he Following specifications: Applications will connect to the database via a middle tier. The number of Concurrent user connections will be high. The database will have mixed workload, with t he execution of complex BI queries scheduled at night. Which DBCA option must you choose to create the Database?

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

QUESTION 127 In the SALES database , DEFERRED_SEGMENT_CREATION is TRUE. Examine this command : SQL> CREATE TABLE T1( c1 INT PRIMARY KEY, c2 CLOB) ; Which segment or segments, if any, are created as a result of executing the command?

QUESTION 128 Choose the best answer. Which statement is true about database links?