NameNu11?Type

PROD_IDNOT NULL NUMBER

PROD NAMEVARCHAR2(40)

COSTNUMBER(8,2)

RELEASE DATEDATE

Which query is valid?

NAME                        Null                        Type

---------------------    ---------------        --------------------------------------

SALSS_ID

STOR_ID

ITEMS_ID

QUANTITY

SALES_DATE

SALES2 is a table with the same description as SALES1 Some sales data is contained erroneously in both tables

You must display rows from SALES1 and SALES and wish to see the duplicates too.

Which set operator generates the required output?

Which query requires explicit_data type conversion?

A PFILE is also available

You execute this command

ALTER SYSTEM SET DB CACHE_SIZE=100K

Where is the value changed?

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

What will be the result?

The TNSNAMES.ORA file in $ORACLE HOME/network/admin in the database home contains:

LISTENER 1=

(ADDRESS= (PROTOCOL=TCP)

(HOST=hostl.abc.com)(PORT=1521)

)

Which statement is true?

The table has two rows whose CUST_LAST_NAME values are ANderson and Ausson

Which query produces output for CUST_LAST_NAME containing Oder for the first row and Aus for the second?

Name                          Nu11?                            Type

---------------------     ----------------------      --------------------

PROD_ID                     NOT NULL                     NUMBER(2)

PROD_NAME                                                    VARCHAR2(10)

LIST_PRICE                                                        NUMBER(6,2)

Which query retrieves the number of products with a null list price?

GRANT CREATE VIEW TO usrl WITH ADMIN OPTION;

USR1 then executes this command:

GRANT CREATE VIEW TO usr2 WITH ADMIN OPTION;

USR2 then executes this command:

GRANT CREATE VIEW TO usr3;

Which statement is true?

SELECT TRUNC (ROUND(156.00,-2),-1) FROM DUAL;

What is the result?

An UPDATE is executed on a temporary table.

Where is the UNDO stored?

Executing:

SELECT xid, status FROM v$$transaction;

In your session retuIrns:

XID                             STATUS

-------------------  -----------------

0A0007000A070000  ACTIVE

In which three situations will re-executing this query still return a row but with a different XID indicating a new transaction has started?

Name                           Nu11?                          Type

----------------------    ---------------              ---------------------

TRANSACTION ID      NOT NULL                    VARCHAR2 (6)

TRANSACTION_TYPE                                      VARCHAR2 (3)

BORROWED_DATE                                          DATE

BOOK ID                                                         VARCHAR2 (6)

MEMBER ID                                                    VARCHAR2 (6)

Examine this partial SQL statement:

SELECT * FROM books transactions

<strong>Which two WHERE conditions give the same result?</strong>