Examine this statement: SELECT1 AS id,‘ John’ AS first_name, NULL AS commission FROM dual INTERSECT SELECT 1,’John’ null FROM dual ORDER BY 3; What is returned upon execution? A) 2 rows B) 0 rows ...

Which three actions can you perform by using the ALTER TABLE command? A) Drop pseudo columns from a table. B) Restrict all DML statements on a table. C) Drop all columns simultaneously from a table. ...

An Oracle database server session has an uncommitted transaction in progress which updated 5000 rows in a table. In which three situations does the transact ion complete thereby committing the updates ...

View the exhibit and the examine the description of the tables. You e x ecu t e this SQL s t a t e m e n t : I N SERT INTO s al e s VALUES 23, 2 3 00 , S Y S D A T E , ( S E LE C T channel i d FRO ...

The STORES table has a column START_DATE of data type DATE, containing the datethe row was inserted. You only want to display details of rows where START_DATEis within the last 25 months.which WHERE c ...

Which two statements are true regarding a SAVEPOINT? A) Rolling back to a SAVEPOINT can undo a CREATE INDEX statement. B) Only one SAVEPOINT may be issued in a transaction. C) A SAVEPOINT does not iss ...

Examine the command to create the BOOKS table. SQL> create table books(book id CHAR(6) PRIMARY KEY, title VARCHAR2(100) NOT NULL, publisher_id VARCHAR2(4)， author_id VARCHAR2 (50)); The BOOK ID value ...

Evaluate the following SQL statement SQL>SELECT promo_id, prom _category FROM promotionsWHERE promo_category=’Internet’ ORDER BY promo_id UNION SELECT promo_id, promo_category FROM Pomotions WHERE p ...