Online Access Free 1Z0-052 Exam Questions

Which two are true about consistent database backups? (Choose two.)

• A.They can only be taken by using RMAN command.
• B.They can only be taken by using RMAIN when the database is in MOUNT state.
• C.They can only be taken if the database is in ARCHIVELOG mode.
• D.They can only be taken if a NORMAL, TRANSACTIONAL, OR IMMEDIATE shutdown has been performed and the backup is taken before the database is reopened.
• E.They can only be taken when a RECOVERY CATALOG is used.

Which two statements are true regarding a PL/SQL package body? (Choose two.)

• A.It can contain only the subprograms defined in the package specification.
• B.It can be changed and recompiled without making the package specification invalid.
• C.It cannot be created without a package specification.
• D.It cannot invoke subprograms defined in other packages.

You configured the Flash Recovery Area (FRA) for your database. The database instance is running in ARCHIVELOG mode. The default location for the archived redo log files is the Flash Recovery Area. Which two files are removed automatically if the space is required in the FRA as per the retention policy? (Choose two.)

• A.Archived redo log files that have multiple copies in a different archive location and not backed up
• B.Flashback log files
• C.User managed backups of the data files and control files
• D.Backups that have become obsolete

Examine the following steps performed on a database instance:
1. The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION
2 . The SKD user creates a table
3 . The SKD user grants the CREATE TABLE system privilege to the HR user
4 . The HR user creates a table
5 . The DBA revokes the CREATE TABLE system privilege from SKD
Which statement is true after step 5 is performed?

• A.The table created by HR remains and HR still has the CREATE TABLE system privilege
• B.The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users
• C.The table created by SKD is not accessible and SKD cannot create new tables
• D.The tables created by SKD and HR remain, but both cannot create new tables

View the Exhibit and examine the privileges granted to the SL_REP user.

The EMP table is owned by the SCOTT user. The SL_REP user executes the following command: SQL> GRANT SELECT ON scott.emp TO hr; Which statement describes the outcome of the command?

• A.The command produces an error because SL_REP has the GRANT ANY OBJECT PRIVILEGE without ADMIN_OPTION
• B.The command produces an error because the EMP table is owned by SCOTT
• C.The command executes successfully
• D.The command produces an error because SL_REP does not have the SELECT privilege with GRANT_OPTION on the EMP table