You upgraded your database from pre-12c to a multitenant container database (CDB) containing pluggable databases (PDBs). Examine the query and its output: Which two tasks must you perform to add users with SYSBACKUP, SYSDG, and SYSKM privilege to the pas

题目

You upgraded your database from pre-12c to a multitenant container database (CDB) containing pluggable databases (PDBs). Examine the query and its output: Which two tasks must you perform to add users with SYSBACKUP, SYSDG, and SYSKM privilege to the password file?（）

A、Assign the appropriate operating system groups to SYSBACKUP, SYSDG, SYSKM.
B、Grant SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.
C、Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege and the FORCE argument set to No.
D、Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege, and FORCE arguments set to Yes.
E、Re-create the password file in the Oracle Database 12c format.

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

相似问题和答案

第1题：

The database administrator of your company created a public synonym called HR for the HUMAN_RESOURCES table of the GENERAL schema, because many users frequently use this table. As a user of the database, you created a table called HR in your schema. What happens when you execute this query? SELECT * FROM HR; （）

A、You obtain the results retrieved from the public synonym HR created by the database administrator.
B、You obtain the results retrieved from the HR table that belongs to your schema.
C、You get an error message because you cannot retrieve from a table that has the same name as a public synonym.
D、You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a Cartesian product.
E、You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a FULL JOIN.

正确答案:B

第2题：

You are maintaining your database in Oracle10g. You find that the number of languages that should be supported in your database has increased. The character set of your database is UTF8. You decide to migrate your database to the AL16UTF16 national character set. How will you migrate your database from UTF8 to AL16UTF16？（）

A、 by using the RMAN utility
B、 by using the export/import utility
C、 by using the ALTER DATABASE command
D、 by enabling the change tracking feature

正确答案:C

第3题：

You realize that the control file is damaged in your production database.After restoring the control file from autobackup, what is the next step that you must do to proceed with the database recovery?（）

A. Mount the database

B. Open the database in NORMAL mode

C. Open the database in RESTRICTED mode

D. Open the database with the RESETLOGS option

参考答案：A

第4题：

You are maintaining the PROD database for NetFx Corporation. You have configured controlfile autobackup in your database. At 6：00 P.M. on Monday， you issue the following command： RMAN>BACKUP DATABASE； At 8：00 A.M. on Tuesday， you are unable to start the database because all the control files are missing. You decide to restore the control files from the backup by using the RMAN> RESTORE CONTROLFILE FROM AUTOBACKUP； command. Which operation should you perform before using the RMAN> RESTORE CONTROLFILE FROM AUTOBACKUP； command？（）

A、 Start the database in the MOUNT stage.
B、 Back up the control file to trace.
C、 Set the DBID
D、 Issue the RECOVER DATABASE command.

正确答案:C

第5题：

Your database is in NOARCHIVELOG mode. After which two operations you should take the backup of control file？（）

A、adding a new user to the database
B、dropping a user from the database
C、dropping a table from the database
D、dropping a data file from a tablespace
E、adding a new tablespace to the database

正确答案:D,E

第6题：

Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt： RMAN> CONFIGURE CONTROLFILE AUTOBACKUP OFF； RMAN> BACKUP DATABASE； Which files from the database will be backed up as a result of this BACKUP command？（）

A、 control file
B、 all datafiles
C、 password file
D、 online redo log file
E、 archive redo log file
F、 server parameter file
G、 only the SYSTEM datafile

正确答案:A,B,F

第7题：

A、Mount the database
B、Open the database in NORMAL mode
C、Open the database in RESTRICTED mode
D、Open the database with the RESETLOGS option

正确答案:A

第8题：

You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process, you execute the following script:SQL>@utlu111i.sqlWhich statement about the execution of this script is true?（）

A. It must be executed from the Oracle Database 11g environment.

B. It must be executed only after the SYSAUX tablespace has been created.

C. It must be executed from the environment of the database that is being upgraded.

D. It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.

E. It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.

参考答案：C

第9题：

You executed the following query in your database： SELECT oldest_flashback_scn， oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG； What would you determine from the output？（）

A、 The time when the last flashback operation in your database was performed.
B、 The time when the first flashback operation in your database was performed.
C、 A list of flashback operations performed in your database using SCN and time.
D、 The approximate time and the lowest system change number （SCN） to which you can flash back your database.

正确答案:D

第10题：

You executed the following query in your database： FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output？（）

A、the time when the last flashback operation in your database was performed
B、the time when the first flashback operation in your database was performed
C、a list of flashback operations performed in your database using SCN and time
D、the approximate time and the lowest system change number （SCN） to which you can flash back your database

正确答案:D

You upgraded your database from

题目

相似问题和答案

更多相关问题

相关内容