You executed the following query: SELECT oldest_flashback_scn, oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG; Considering that all the redo logs are available, what information can you derive from the output of the preceding query?

In your database, USERS is the default permanent tablespace. Examine the commands and their outcome: You plan to execute the commands: Which two statements are true? (Choose two.)

In your Oracle 12c database, you plan to execute the command: SQL> CREATE TABLESPACE tbs1 DATAFILE ‘/u02/oracle/data/tbs01.dbf’ SIZE 50M; The u02 file system has 1 GB of free space available. What is the outcome?

Which users are created and can be used for database and host management of your DBaaS database servers?

Identify three uses of the CROSSCHECK command (Choose three.)

You want to create a locally managed tablespace called NEWTBS to store segments with different extent sizes. Which set of tablespace attributes can be specified for a tablespace that satisfies the requirements?

You have altered a non-unique index to be invisible to determine if queries execute within an acceptable response time without using this index. Which two are possible if table updates are performed which affect the invisible index columns? (Choose two.)

Which three statements are true about naming methods? (Choose three.)

Which three operations can be performed as multipartition operations in Oracle? (Choose three.)

You are administering a database that supports an OLTP workload. The default UNDO tablespace is a fixed size tablespace with the RETENTION NOGUARATNEE clause and undo retention set to 12 minutes. The user SCOTT queries a large table during peak activity. The query runs for more than 15 minutes and then SCOTT receives the following error: ORA-01555: snapshot too old Which is possible reason for this?