⟩ What is the output of the following query SELECT TRUNC(1234.5678,-2) FROM DUAL;?
1200.
1200.
ou want to group the following set of select returns, what can you group on? Max(sum_of_cost), min(sum_of_cost), count(item_no), item_no?
What is tkprof and how is it used?
What is explain plan and how is it used?
What is the default ordering of an ORDER BY clause in a SELECT statement?
You are joining a local and a remote table, the network manager complains about the traffic involved, how can you reduce the network traffic?
You want to determine the location of identical rows in a table before attempting to place a unique index on the table, how can this be done?
How do you prevent Oracle from giving you informational messages during and after a SQL statement execution?
How do you prevent output from coming to the screen?
How do you generate file output from SQL?
How do you set the number of lines on a page of output? The width?