Examine the parameter settings in your database.Which statement is correct about the database?
memory_target big integer 808Mpga_aggregate_target big integer 0sga_target big integer 0SQL> SHOW PARAMETER SGA_MAX_SIZENAME TYPE VALUE -------------------------------------------------------------------------------------------------- sga_max_size big integer 808MWhich statement is correct about the database?
The DB_BLOCK_CHECKING parameter is set to FALSE.What level of block checking will be performed?
As part of archiving the historical data, you want to transfer data from one database to another database, whichis on another server. All tablespaces in the source database are read/write and online. The source and targetdatabases use the same compatibility level and character sets. View the Exhibit and examine the features inthe source and target database.Which of the following steps are required to transport a tablespace from the database to the targetdatabase:1. Make the tablespace read-only at the source database.2. Export metadata from the source database.3. Convert data filed by using Recovery Manager (RMAN).4. Transfer the dump file and data filed to the target machine.5. Import metadata at the target database.6. Make the tablespace read/write at the target database.Exhibit:
You are in the process of creating a virtual private catalog in your Oracle Database 11g database. The PROD1,PROD2, and PROD3 Oracle Database 10g databases are registered in the base recovery catalog. The databaseuser who owns the base recovery catalog is CATOWNER. CATOWNER executes the following command to grantprivileges to a new user VPC1 using Oracle Database 11g RMAN executables:RMAN> GRANT CATALOG FOR DATABASE prod1, prod2 TO vpc1;Then you issue the following commands:RMAN> CONNECT CATALOG vpc1/oracle@catdb;RMAN> SQL "EXEC catowner.dbms_rcvcat.create_virtual_catalog;"What is the outcome of the above commands?
Which two statements are true about setting the FAST_ START_ MTTR_ TARGET initialization parameter to a nonzero value?
