1Z0-052章節(jié)練習(xí)(2019.05.09)

View the Exhibit to observe the roles assigned to the SL_REP user. 
Which statement is true about theassignment of the SELECT_CATALOG_ROLE role to the SL_REP user（）

You want to enable archiving on your database. Presently， the database is running in NOARCHIVELOG mode.Given below are the steps to accomplish the task in random order：
1. Shut down the instance.
2. Execute the ALTER DATABASE ARCHIVELOG command.
3. Start up the instance and mount the database.
4. Set the DB_RECOVERY_FILE_DEST initialization parameter to $ORACLE_HOME/dest_1.
5. Open the database.
Which is the correct sequence of steps for accomplishing the task（）

You are working on a new Oracle Database 11g server， where only the software is installed and no database iscreated. You plan to create a database on this server using the Database Configuration Assistant （DBCA）.Some of the requirements set for your database creation task are：
1.Configure the database to operate in shared server mode.
2.Disable automatic maintenance tasks such as optimizer statistics collection.
3.Configure a naming method to help the remote user connect to the database instance.
4.Use Automatic Storage Management （ASM） for storing the database files.
5.Configure daily database backup to flash recovery area.
6.Configure Enterprise Manager Database Control to manage the database. 
Which of these requirements can be met while creating the database（）

You want to configure and schedule offline database backups to run automatically. 
Which tool or utility wouldyou use to achieve this（）