Everything You Need to Pass: oracle 1Z0_051

Which constraint can be defined only at the column level?

What is true about the WITH GRANT OPTION clause?

Here is the structure and data of the CUST_TRANS table:Exhibit:CUST_TRANS -Name Null? Type-------------- ----------------- ------------------CUSTNO NOT NULL CHAR (2)TRANSDATE DATETRANSAMT NUMBER (6, 2)CUSTNO TRANSDATE TRANSAMT------------- ----------------------- -----------------------11 01-JAN-07 100022 01-FEB-07 200033 01-MAR-07 3000Dates are stored in the default date format dd-mm-rr in the CUST_TRANS table.Which three SQL statements would execute successfully? (Choose three.)

Which substitution variable would you use if you want to reuse the variable without prompting the user each time?

The EMPLOYEES table has these columns:LAST NAMEVARCHAR2(35)SALARYNUMBER(8,2)HIRE_DATEDATE -Management wants to add a default value to the SALARY column. You plan to alter the table by using this SQL statement:ALTER TABLE EMPLOYEES -MODIFY (SALARY DEFAULT 5000);What is true about your ALTER statement?

Evaluate the SQL statement:TRUNCATE TABLE DEPT;Which three are true about the SQL statement? (Choose three.)