You execute this command: ALTER TABLE employees SET UNUSED(department_id) Which two are true? (Choose two.) A. No updates can be made to the data in the DEPARTMENT_ID column. B. A new column with the name DEPARTMENT_ID can be added to…
You have been tasked to create a table for a banking application. One of the columns must meet three requirements: 1) Be stored in a format supporting date arithmetic without using conversion functions 2) Store a load period of up…
Examine the description of the MEMBERS table: Examine the partial query: SELECT city, last_name LNAME FROM members …; You want to display all cities that contain the string AN. The cities must be returned in ascending order, with the last…
Which three privileges can be restricted to a subset of columns in a table? (Choose three.) A. ALTER B. DELETE C. UPDATE D. SELECT E. INDEX F. REFERENCES G. INSERT
Which two statements are true regarding a SAVEPOINT? (Choose two.) A. A SAVEPOINT does not issue a COMMIT B. Only one SAVEPOINT may be issued in a transaction C. Rolling back to a SAVEPOINT can undo a TRUNCATE statement D.…
Which three statements are true about single-row functions? (Choose three.) A. They can be nested to any level B. The data type returned can be different from the data type of the argument C. They can accept only one argument…
You need to calculate the number of days from 1st January 2019 until today. Dates are stored in the default format of DD-MON-RR. Which two queries give the required output? A. SELECT TO_CHAR(SYSDATE, ‘DD-MON-YYYY’) – ’01-JAN-2019′ FROM DUAL; B. SELECT…
Which three actions can you perform by using the ORACLE_DATAPUMP access driver? (Choose three.) A. Read data from an external table and load it into a table in the database B. Create a directory object for an external table C.…
Which three are true about the CREATE TABLE command? (Choose three.) A. It can include the CREATE..INDEX statement for creating an index to enforce the primary key constraint B. It implicitly executes a commit C. A user must have the…
Examine this query: SELECT TRUNC(ROUND(156.00, -2), -1) FROM DUAL; What is the result? A. 16 B. 200 C. 100 D. 160 E. 150