Which script must you to query to display the code associated with RMAN stored scripts?()
You have an SQL query that takes one minute to execute. You use the following code segment to execute the SQL query asynchronously.IAsyncResult ar = cmd.BeginExecuteReader( );You need to execute a method named Do Work( ) that takes one second to run while the SQL query is executing. DoWork( ) must run as many times as possible while the SQL query is executing. Which code segment should you use? ()
Which statement is true regarding Flashback Version Query?()
When a valid SQL Query in a DB Read step returns 0 rows, which branch of the step will be executed? ()
Evaluate the following query: SQL> SELECT TRUNC(ROUND(156.00,-1),-1)FROM DUAL; What would be the outcome?()
Which data dictionary table should you query to view the object privileges granted to the user on specific columns?()
Which command will enable the administrator to query the current network adapter configuration?()
Consider the query: Mysql> SET @run = 15; Mysql> EXPLAIN SELECT objective, stage, COUNT (stage) FROM iteminformation WHERE run=@run AND objective=’7.1’ GROUP BY objective,stage ORDER BY stage; The iteminformation table has the following indexes; Mysql> SHOW INDEXES FROM iteminformation: This query is run several times in an application with different values in the WHERE clause in a growing data set. What is the primary improvement that can be made for this scenario?()
In which scenario will you use the Flashback Transaction Query feature?()
Examine the output of the query that you executed to list the objects in the recycle bin: You verified that no table named SALES_TAB exists in the schema. Then you executed the following command to purge the objects in the recycle bin: SQL> PURGE TABLE sales_tab; What would be the outcome of this command?()