Delete the newly created password file and re-create another password file with the password admin, without shutting down the database.
Enable the operating system authentication, shut down the database, disable the operating system authentication, and restart the database using the password file.
Enable the operating system authentication, shut down the database, re-create the password file using the same ORAPWD command, and restart the database using the password file.
Delete the newly created password file, enable operating system authentication and shut down the database. Then, re-create another password file using the same ORAPWD command and restart the database using this password file.
第1题:
open the database with the RESTRICTED option
open the database with the RESETLOGS option
recover to the required SCN only that data file in which the error occurred
recover all the data files to the same system change number (SCN)
第2题:
The copy of the datafile created is stored in the RMAN repository.
The copy of the datafile created can be viewed using the LIST BACKUP command.
The copy of the datafile created using this COPY command can be placed only on the disk.
The copy of the datafile created is similar to the backup of the file created using the BACKUP command.
The copy of the datafile created can be used for recovering the database using the user-managed recovery method.
第3题:
The code will be executed successfully.
The code will not be executed successfully because the value of the VALUE parameter must be 1, 2, or 3.
The code will not be executed successfully because the value of the VALUE parameter must range between 1 and 5.
The code will not be executed successfully because no SET_ATTRIBUTE procedure exists in the DBMS_SCHDULER package.
第4题:
by using the Flashback Database feature
by using RMAN incomplete recovery
by performing a user-managed incomplete recovery
by dropping and re-creating the index tablespace
第5题:
enable index monitoring and query the DBA_OBJECTS view
enable index monitoring and query the DBA_INDEXES view
enable index monitoring and query the V$OBJECT_USAGE view
enable index monitoring and view the DBA_INDEXTYPE_COMMENTS view
第6题:
Only one nested subplan is allowed.
The plans can be nested up to four levels.
Resource Manager does not support nested plans.
Nested plans control only the degree of parallelism but not the CPU.
Each nested plan gets a proportion of the CPU resources assigned to its parent group.
第7题:
Memory Advisor
Segment Advisor
SQL Access Advisor
Automatic Workload Repository (AWR)
Automatic Database Diagnostic Monitor (ADDM)
第8题:
The index tablespace contains bitmap indexes.
The index tablespace contains more than one data file.
The index tablespace supports only complete recovery.
The index tablespace is not a dictionary-managed tablespace.
There is a dependency relationship between a table and its indexes.
第9题:
assign users to consumer groups
set the resource plan for the instance
configure a simple resource plan and specify plan directives
configure a complex resource plan and specify plan directives
第10题:
The maximum degree of parallelism for the members of the consumer groups is 4.
The CPU allocation will always be equal for the consumer groups MARKET and DEV.
The OTHERS consumer group would get 100% of the CPU if there are unused level 1 CPU resources.
The SALES and MARKET consumer groups would get 100% of the CPU if there are unused level 2 CPU resources.
The maximum degree of parallelism for the members of the consumer group SALES is 4 with no restriction for the remaining groups.