Database Practice

. Which of the following functions will truncate a numeric value to a specific position? 1. TRUND 2. TRUNCATE 3. TRUNC 4. none of the above 2. Which of the following represents the number of days that have passed since January 1, 4712 B.C.? 1. Cartesian date 2. Julian date 3. Extended date 4. none of the above 3. Which of the following functions can be used to change the format of a date that has been entered by a user to the default storage format use by Oracle12c? 1. TO_DATE 2. DEFAULT 3. TO_CHAR 4. DATE 4. Which statement is true about the view created with the following command? CREATE VIEW outstanding AS SELECT customer#, order#, orderdate, shipdate FROM orders WHERE shipdate IS NULL WITH CHECK OPTION; 1. The shipping date of an order cannot be changed through the view. 2. No DML operations are permitted through the view. 3. The order# of an order cannot be changed through the view. 4. none of the above