A creating a table in your schema and you exceed your allocated space quota on the tablespace
B executing a long query that involves a sort operation and the statement runs out of temporary space
C loading data into tables by using the SQL*Loader and the number of extents in the table reaches the maximum limit
D creating a table in a dictionary-managed tablespace with an explicit MAXEXTENTS setting which results in an out of space error
In which scenario, will you issue the following command?() RMAN> REPORT NEED BACKUP DAYS 7;
单选题查看答案
You issue these LSNRCTL commands: LSNRCTL> SET CURRENT_LISTENER listener01 LSNRCTL> START listener02 What is the result of issuing these commands?()
单选题查看答案
You issued the following statement: SQL>ALTER DATABASE ENABLE RESUMABLE TIMEOUT n; What will be the result of issuing the above statement?()
单选题查看答案
You issue this statement:ALTER DATABASE BACKUP CONTROLFILE TO TRACE; What does the statement generate?()
单选题查看答案
You are maintaining the database of a company. The listener process, listener1, is configured for remote access. You have issued the following command: LSNRCTL>STATUS listener1 Which information will NOT be displayed when you issue the above command?()
单选题查看答案
You issued the following command at the UNIX environment: % setenv ORA_SDTZ ’OZ_TZ’ What will be the impact of issuing the above command?()
单选题查看答案
You notice that the performance of the database has degraded because of frequent checkpoints. Which twoactions resolve the issue()
多选题查看答案
You enable block change tracking. You issue the following command: BACKUP INCREMENTAL LEVEL 0 DATABASE; The next day,you issue the following command: BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE; Which statement about the use of the change tracking file is true?()
单选题查看答案
You issued the RMAN>SHOW ALL; command. The output of this command is as follows: After analyzing the output, which conclusion will you draw?()
单选题查看答案
You issued the RMAN> SHOW ALL; command. The output of this command is as follows: After analyzing the output, which conclusion will you draw?()
单选题查看答案