Which two statements are true about INTERVAL data types
Correct Answer: A,E
Regarding INTERVAL data types in Oracle Database 12c: * A. INTERVAL YEAR TO MONTH columns only support monthly intervals within a range of years. This is true. The INTERVAL YEAR TO MONTH data type stores a period of time using years and months. * E. INTERVAL DAY TO SECOND columns support fractions of seconds. This is true. The INTERVAL DAY TO SECOND data type can store days, hours, minutes, seconds, and fractional seconds. Options B, C, D, and F are incorrect: * B is incorrect because data types between INTERVAL DAY TO SECOND and INTERVAL YEAR TO MONTH are not compatible. * C is incorrect as it incorrectly limits INTERVAL YEAR TO MONTH to a single year. * D is incorrect; the YEAR field can be negative to represent a past interval. * F is incorrect as INTERVAL YEAR TO MONTH supports intervals that can span multiple years, not just annual increments.
View the exhibit and examine the descriptions of the DEPT and LOCATIONS tables. You want to update the CITY column of the DEPT table for all the rows with the corresponding value in the CITY column of the LOCATIONS table for each department. Which SQL statement would you execute to accomplish the task?
Correct Answer: D
Question 69
Examine the structure of the INVOICE table. Which two SQL statements would execute successfully? (Choose two.)
Correct Answer: A,D
Question 70
Which three statements are true about views in an Oracle database?
Correct Answer: B,E,G
For question 138 regarding Oracle views, the correct answers are B, E, and G: B . The WITH CHECK OPTION clause prevents certain rows from being updated or inserted: This clause ensures that all data modifications performed through the view result in data that conforms to the view's defining query. E . Deleting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error: Views that involve aggregate functions, GROUP BY clauses, or DISTINCT cannot be directly modified with DML operations such as DELETE, because the underlying data manipulation would be ambiguous. G . Inserting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error: Similarly to DELETE, INSERT operations into a view that uses a GROUP BY clause are generally not allowed because it's unclear how the new rows should be aggregated into the existing groups. Other options are incorrect because: A: The WITH CHECK OPTION clause does not prevent rows from being displayed; it restricts DML operations. C: Views can be created with non-existent underlying tables or views using the FORCE option in Oracle. D: Not all views are updatable, especially those involving joins, group functions, or distinct aggregation. F: Updating a view does not impact the granted privileges unless the definition of the view changes.
