What effect should the loss of an index tablespace have on an Oracle instance that is running?()
You are maintaining the SALES database on Oracle 10g. You have added a new disk to a disk group. Automatic Storage Management performs the rebalancing activity. You want to speed up the rebalancing activity. Which parameter will you specify to control the speed of the rebalancing activity? ()
You are managing an Oracle Database 11g database. You want to take the backup of MULT_DATA, a big file tablespace of size 100 TB on tape drive, but you have tapedrives of only 10 GB each. Which method would accomplish the task quickly and efficiently?()
View the Exhibit. What would happen if Oracle Home is not empty()
You are installing Oracle Database 11g on a machine. When you run the installer, the Oracle Universal Installer(OUI) shows the message that says one of the product-specific prerequisite checks has failed:Checking available swap space requirements ...Expected result: 1512MBActual Result: 1018MB Check complete. The overall result of this check is: Failed <<<< Problem: The system does not have therequired swap space. What happens to the installation in this situation()
Oracle Coherence is best classified as ()?
Which NLS parameter can be used to change the default Oracle sort method from binary to linguistic for the SQL SELECT statement?()
Which two statements are true about Oracle ActiveCache ?()
While setting up an Oracle database for one of your critical applications, you want to ensure that the database is backed up at regular intervals without your intervention. What should you do to achieve the objective?()
You are identifying dictionary objects in the Oracle database. Which of the following is a view in the data dictionary?()