Examine the description of the products tableName Null type-----------------------------------------------------PROD_ID NOT NULL NUMBERPROD_NAME VARCHAR2(40)COST NUMBER(8,2)PRLEASE_DATE DATEWhich query is valid?

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

Examine the description of the SATES1 tableName Null type-----------------------------------------------------SALES_ID NOT NULL NUMBERSTORE_ID NOT NULL NUMBERITMES_ID NUMBERUANTITY NUMBERSALES_DATE DATESALES2 is a table with the same description as sAleS1Some sales data is contained erroneously in both tablesYou must display rows from sAlEs1 and SALES and wish to see the duplicates tooWhich set operator generates the required output?

Which compression method is recommended for Direct-Path Insert operations?

Examine the description of the EMPLOYEES tableNIS DATE FORMAT is set to DD-MON-YYWhich query requires explicit data type conversion?

Your database instance is started with an SPFILEA PFILE is also availableYou execute this commandALTER SYSTEM SET DB CACHE SIZE=100KWhere is the value changed?

View the Exhibits and examine the structure of the costs and PROMOTIONS tablesYou want to display PROD IDS whose promotion cost is less than the highest cost PROD ID in aPromotion time intervalExamine this SQL statementSELECT prod_id FROM costs WHERE promo_id IN (SELECT promo_id FROM promotions WHERE promo_cost < ALL (SELECT MAX(promo_cost) FROM promotions GROUP BY (promo end date - promo begin date)));What will be the result?

In the spfile of a single instance database, LOCAL LISTENER is set to LISTENER 1.The TNSNAMES ORA file in SORACLE HOME/network/admin in the database home contains:LISTENER 1 =(ADDRESS=(PROTOCOL= TCP)(HOST =host1 abc. com)(PORT=1521)) Which statement is true?

Which statement is true about database links?

The CUSTOMERS table has a CUST_LAST NAME column of data type VARCHAR2The table has two rows whose CUST_LAST NAME values are Anderson and AussonWhich query produces output for CUST_LAST NAME containing oder for the first row and AusFor theSecond?

What is true about non-equijoin statement performance?

Examine this query:SELECT TRUNC(ROUND（156.00,-2),-1) FROM DUAL;What is the result?

Which two statements are true about space-saving features in an OracleDatabase?

Which two statements are true about views?

You currently have an active transaction in your session and have been granted select accessTo VSTRANSACTIONIn which three situations will re-executing this query still return a row but with a different XIDIndicating a new transaction has started?Select xid, status FROM v$transcation;In your session returns:XID STATUS-------------------------------0A007000A070000 ACTIVE