Which three descriptions are correct about the effects of the TRUNCATE command on a table()
时间:2022-09-18
Which two statements are true about checkpointing()
时间:2022-09-17
Which two files in the database can be configured for automatic backups by using the autobackupfeature in Recovery Manager (RMAN)()
时间:2022-09-15
You execute the following command toauditdatabase activities: SQL>AUDITDROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL; What is the effect of this command()
You execute this command to drop the ITEM table, which has the primary key referred in the ORDERtable: SQL> DROP TABLE scott.item CASCADE CONSTRAINTS PURGE; Which two statements are true about the effect of the command()
You notice that the performance of the database has degraded because of frequent checkpoints. Which two actions resolve the issue()
View the Exhibit to examine the details for an incident. Which statement is true regarding the status of theincident()https://assets.asklib.com/images/image2/2018080117523734517.jpg
时间:2022-09-12
You are in the middle of a transaction updating a very important table. The machine on which a database wasrunning reboots because of power outage. This caused a database instance failure. Which statement is true inthis situation()
Which task would you perform before you run Oracle Universal Installer (OUI) in silent or suppressedmode for an installation()
View the Exhibit to examine the output for the CROSSCHECK BACKUP command. Which statement is trueabout the output of the command() https://assets.asklib.com/images/image2/2018080117575419854.jpg
时间:2022-09-11
Identify three situations in which you would NOT be able to drop a tablespace. ()
Which two statements are true about alerts()
时间:2022-09-10
Examine the following statement that is used to modify the primary key constraint on the SALES table: SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE; Which three statements aretrue regarding the above command()
ote the following structures in your database server: 1:Extents 2:OS Blocks 3:Tablespace 4:Segments 5:Oracle Data Block Which option has the correct arrangement of these structures from the smallest to the largest()
You have set Tablespace Full Metrics Threshold values for the USERS tablespace as follows: Warning (%): 90 Critical (%): 95 Which background process is responsible for issuing alerts when the threshold is crossed()
时间:2022-09-07