1z0-071 Exam Question 146
Examine this statement:
SELECT1 AS id,' John' AS first_name, NULL AS commission FROM dual
INTERSECT
SELECT 1,'John' null FROM dual ORDER BY 3;
What is returned upon execution?[
SELECT1 AS id,' John' AS first_name, NULL AS commission FROM dual
INTERSECT
SELECT 1,'John' null FROM dual ORDER BY 3;
What is returned upon execution?[
1z0-071 Exam Question 147
Examine the data in the CUST_NAMEcolumn of the CUSTOMERStable.
You want to extract only those customer names that have three names and display the * symbol in place of the first name as follows:
Which two queries give the required output? (Choose two.)
You want to extract only those customer names that have three names and display the * symbol in place of the first name as follows:
Which two queries give the required output? (Choose two.)
1z0-071 Exam Question 148
Which three are true about privileges and roles?
1z0-071 Exam Question 149
In your session NLS_ DATE_ FORMAT is set to DD-MON_RR.
Which two queries display the year as four digits?
Which two queries display the year as four digits?
1z0-071 Exam Question 150
Examine the description of the SALES1 table:
SALES2 is a table with the same description as SALES1,
Some sales data is duplicated In both tables.
You want to display the rows from the SALES1 table which are not present in the SALIES2 table.
Which set operator generates the required output?
SALES2 is a table with the same description as SALES1,
Some sales data is duplicated In both tables.
You want to display the rows from the SALES1 table which are not present in the SALIES2 table.
Which set operator generates the required output?