Choose two Examine the description of the BOOKS_TRANSACTIONS table Name Null? Type ---------------------------------------------------- ...

Choose two. 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 SYSDA ...

Choose the best answer Examine the description of the PRODUCT_INFORMATION table: Name NULL? Type --------------------------------------------------------------- ...

Choose three Which three statements are true about sequences in a single instance Oracle database? A) A sequence's unallocated cached values are lost if the instance shuts down. B) Two or more tables ...

Choose two Which two statements are true about the COUNT function? A) It can only be used for NUMBER data types. B) COUNT (DISTINCT inv_amt) returns the number of rows excluding rows containing duplic ...

Choose two. Which two statements are true about the results of using the INTERSECT operator in compound queries? A) Reversing the order of the intersected tables can sometimes affect the output. B) Co ...

Choose three. Which three statements are true about a self join? A) It must be an inner join. B) It can be an outer join. C) The ON clause must be used. D) It must be an equijoin. E) The query must us ...

Choose three Examine this SQL statement: SELECT cust_id, cus_last_name "Last Name" FROM customers WHERE country_id = 10 UNION SELECT cust_id CUST_NO, cust_last_name FROM customers WHERE country_id = 3 ...