You executed the following commands to find the location of the alert log file: Where is the alert log file stored()
Examine the following commands executed in your database: SQL> ALTER SESSION RECYCLEBIN=ON; Session altered SQL> CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees; Table created. Further, you executed the following command to drop the table: SQL> DROP TABLE emp; Table dropped. What happens in this scenario? ()
You executed the following command: RMAN> RECOVER COPY OF DATAFILE '/u01/app/oracle/oradata/orcl/users01.dbf'; Which statement regarding the above command is correct?()
You started a long transaction. Before committing, you executed a query on one of the tables currently being modified. You received the following error: ORA-01555: snapshot too old How would you prevent such an error in the future?()
You executed the following query: SELECT operation, undo_sql, table_name FROM flashback_transaction_query; Which statement is correct regarding the query output?()
You executed the following command to perform a backup of the USERS tablespace: SQL> ALTER TABLESPACE users BEGIN BACKUP; ALTER TABLESPACE users BEGIN BACKUP * ERROR at line 1: ORA-01123: cannot start online backup; media recovery not enabled What could be the reason for this error()
Which of the following commands cannot be executed when the database open?()
You executed the following query in your database: FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output?()
Which script is executed during system startup to set the system hostname, default gateway and static routes?()
You executed the following command to create a tablespace called SALES_DATA: SQL> CREATE TABLESPACE sales_data DATAFILE SIZE 100M SEGMENT SPACE MANAGEMENT AUTO; Which two statements are true about the SALES_DATA tablespace()