Online Access Free 1Z1-050 Practice Test

You are in the process of creating a virtual private catalog in your Oracle Database 11 g database. The PROD1 , PROD and PROD3 Oracle Database 10g databases are registered in the base recovery catalog. The database user who own the base recovery catalog is CATOWNER. CATOWNER executes the following command to grant privileges to a new user VPC1 using Oracle Database 11 g 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?

• A.They produce an error because you need to connect to the target database to execute this packaged procedure.
• B.They produce an error because you need to connect as CATOWNER to execute this packaged procedure.
• C.They produce an error because PROD1 and PROD2 databases belong to the older version.
• D.They execute and create a virtual catalog for pre-Oracle 11 g clients.

You are managing the APPPROD database as a DBA. You plan to duplicate this database in the same system with the name DUPDB. You issued the following RMAN commands to create a duplicate database: RMAN> CONNECT target sys/sys@APPPROD RMAN> DUPLICATE TARGET DATABASE
TO dupdb FROM ACTIVE DATABASE DB_FILE_NAME_CONVERT '/oracIe/oradata/prod/1, '/scratch/oracIe/oradata/dupdb/1 SPILE PARAMETER_VALUE_CONVERT'/oracle/oradata/prod/1, '/scratch/oracIe/oradata/dupdb/1 SET SGA_MAX_SIZE = '300M1 SET SGA_TARGET = '250M' SET LOG_FILE_NAME_CONVERT '/oracle/oradata/prod/redo/', '/scratch/oracIe/oradata/dupdb/redo/1;
Which three are the prerequisites for the successful execution of the above command? (Choose three.)

• A.The source database should be open.
• B.The target database backups should be copied to the source database backup directories.
• C.The password file must exist for the source database and have the same SYS user password as the target.
• D.The target database should be in ARCHIVELOG mode if it is open.
• E.RMAN should be connected to both the instances as SYSDBA

You want to track and store all transactional changes to a table over its lifetime. To accomplish this task, you enabled Flashback Data Archive with the retention of 5 years. After some time, the business requirement changed and you were asked to change the retention from 5 years to 3 years. To accomplish this, you issued the following command: ALTER FLASHBACK ARCHIVE fla1 MODIFY RETENTION 3 YEAR;
What is the implication of this command?

• A.All historical data older than three years is purged from the flashback archive FLA1.
• B.The command produces an error because the retention time cannot be reduced.
• C.All historical data is retained but the subsequent flashback data archives are maintained for only three years.
• D.All historical data is purged and the new flashback data archives are maintained for three years.

Which statements describe the capabilities of the DBMS_NETWORK_ACL_ADMIN package? (Choose all that apply.)

• A.It can be used to selectively restrict the access for each user in a database to different host computers.
• B.It can be used to allow the access privilege settings for users but not roles.
• C.It can be used to selectively restrict a user's access to different applications in a specific host computer.
• D.It can be used to allow the access privilege settings for users as well as roles.
• E.It can be used to control the time interval for which the access privilege is available to a user.

You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the userRC011. The INST1 database contains an Oracle Database version 10.1 catalog schema owned by the user RCAT10.
You want the RMAN to import metadata for database IDs 1423241 and 1423242, registered in RCAT10, into the recovery catalog owned by RC011. You executed the following commands:
RMAN> CONNECT CATALOG rco11/password@catdb RMAN> IMPORT CATALOG rcat1 0/oracle@inst1 NO UNREGISTER;
Which two statements are true regarding the tasks accomplished with these commands? (Choose two.)

• A.They unregister the database from the RCAT10 catalog.
• B.They do not register the databases registered in the RCAT10 catalog.
• C.They import all metadata from the RCAT10 catalog.
• D.They register all databases registered in the RCAT10 catalog.