You executed the following query in your database: SELECT oldest_flashback_scn, oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output?()
A database user SMITH tries to query the V$SESSION view and fails to access it as follows: SQL> connect smith/smith Connected. SQL> SELECT * FROM v$session; SELECT * FROM v$session * ERROR at line 1: ORA-00942: table or view does not exist Which are the two possible solutions to enable SMITH to query the data in V$SESSION()
Examine the query and its output executed In an RDBMS Instance:Which three statements are true about the users (other than sys) in the output?()
Which two EIGRP options will limit a query domain?()
Which of the following statements best describes Flashback Versions Query?()
Which view should a user query to display the columns associated with the constraints on a table owned by the user? ()
Which of the following dynamic view would you query to identify the online CURRENT redo log group?()
As the DBA, you run the following query on your ASM instance. What is the implication of the results of the query?() SQL> select group_number, name, state from v$ASM_DISKGROUP; GROUP_NUMBER NAME STATE 0 DGROUP1 DISMOUNTED 2 DGROUP2 MOUNTED 3 DGROUP3 MOUNTED
You find this query being used in your Oracle 12c database: Which method a used by the optimizer to limit the rows being returned?()
Which two statements are correct regarding the Flashback Versions Query feature?()