Which SELECT statement should you use to extract the year from the system date and display it in the format "1998"? （）
You define the following regular expression of currency values:
regex tx = new regex("^-?\d+(\.\d{2})?$")
You are required to write code that will be used to find whether a string in the variable named Bill matches the regular expression or not. You are also required to use this code as the expression in a conditional statement and need to know which code segment to use.
What should you do?（）
You use this statement to retrieve data from a data table for（）。
You want to display the titles of books that meet these criteria:
1. Purchased before January 21, 2001
2. Price is less then $500 or greater than $900
You want to sort the results by their data of purchase, starting with the most recently bought book.
Which statement should you use?（）
You want to display the titles of books that meet these criteria:
1. Purchased before January 21, 2001
2. Price is less then $500 or greater than $900
You want to sort the results by their data of purchase, starting with the most recently bought book. Which statement should you use? （）
You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference.
Which method or feature should you use?（）
You need to create a view EMP_VU. The view should allow the users to manipulate the records of only the employees that are working for departments 10 or 20.
Which SQL statement would you use to create the view EMP_VU?（）
From SQL*Plus, you issue this SELECT statement:
SELECT*
FROM order;
You use this statement to retrieve data from a data table for （）.
免费的网站请分享给朋友吧