网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
While setting up the threshold for tablespace space usage metrics for one of your tablespaces， you define the critical threshold as 60% and warning threshold as 75%. What would be the result of this setting？（）
A
It would result in an error because the warning threshold cannot be more than the critical threshold.
B
The warning threshold is ignored and alerts would be generated when space usage exceeds the critical threshold.
C
The critical threshold is ignored and alerts would be generated when space usage exceeds the warning threshold.
D
Both threshold values are used and alerts are generated when space usage exceeds the respective threshold values.
参考答案
参考解析
解析：
暂无解析
更多 “单选题While setting up the threshold for tablespace space usage metrics for one of your tablespaces， you define the critical threshold as 60% and warning threshold as 75%. What would be the result of this setting？（）A It would result in an error because the warning threshold cannot be more than the critical threshold.B The warning threshold is ignored and alerts would be generated when space usage exceeds the critical threshold.C The critical threshold is ignored and alerts would be generated when space usage exceeds the warning threshold.D Both threshold values are used and alerts are generated when space usage exceeds the respective threshold values.” 相关考题
考题
单选题You moved the index EMP_NO_INDX from one tablespace to another and then issued the following command to rebuild the index EMP_NO_INDX： SQL ALTER INDEX EMP_NO_INDX REBUILD ONLINE； Which table allows the users to access the EMP_NO_INDX index while performing the rebuild operation？（）A
Index-organized tableB
Mapping TableC
Clustered TableD
Journal Table
考题
单选题The listener has shut down unexpectedly. You want to view the listener log file and listener trace file to find the cause of the problem. How can you view the contents of the listener log file and the listener trace file？（）A
Open the file at the location specified by the BACKGROUND_DUMP_DEST parameter in the pfile.B
Open the file at the location specified by the USER_DUMP_DEST parameter in the pfile.C
Issue the SERVICES command at the LSNRCTL prompt.D
Issue the STATUS command at the LSNRCTL prompt.
考题
单选题On Monday， you dropped the DEPT table from your schema and then you re/x7fcreated the DEPT table in your schema. On Wednesday， you have a requirement to restore the DEPT table from the recycle bin. Which statement is correct？（）A
You can restore the DEPT table by using the Oracle Flashback Drop feature， provided you use the RENAME TO clause.B
You can restore the DEPT table by using the Oracle Flashback Drop feature and a systemgenerated name will be assigned to the restored table.C
You cannot restore the DEPT table by using the Oracle Flashback Drop feature because a table withthe name DEPT already exists in your schema.D
You cannot restore the DEPT table by using the Oracle Flashback Drop feature because the contents of the recycle bin are purged every 12 hours by default.
考题
单选题In which case would you use the Flashback Database feature to perform a recovery？（）A
to recover a dropped tablespaceB
to recover data from a truncated tableC
to recover a data file that has been shrunkD
to recover a database to the state that existed before the RESETLOGS operation
考题
多选题The current time zone for one of the user sessions is set to the database local time zone. For one application， the user session requires the time zone to be set to the local operating system time zone without affecting other user sessions. Which two solutions could the user implement to achieve this objective？ （）Ause the ALTER SYSTEM command to change the time zoneBuse the ALTER SESSION command to change the time zoneCuse the ALTER DATABASE command to change the time zoneDset the value for the operating system variable ORA_SDTZ on the client machineEset the value for the operating system variable ORA_SDTZ on the database server machine
考题
多选题You executed the following FLASHBACK TABLE command： FLASHBACK TABLE emp TO TIMESTAMP （’11：45’，’hh12：mi’）； Which two statements are correct？ （）AThe FLASHBACK TABLE statement will not be written to the alert log file.BThe EMP table that was dropped by mistake from the database will be restored.CThe changes made to the EMP table since the specified time will be undone.DThe FLASHBACK TABLE statement will not maintain the existing indexes on the EMP table.EThe FLASHBACK TABLE statement will be executed within a single transaction.FThe list of transactions that have modified the EMP table since the specified time will be displayed.
考题
单选题You issued the following RMAN command： RMAN CONFIGURE CONTROLFILE AUTOBACKUP ON； What is NOT an impact of using the above command？（）A
When a successful backup is recorded in the RMAN repository， then a backup of the current control file is performed.B
When a structural change is made to the database， then a backup of the current control file is performed.C
When a successful backup is performed in the RMAN repository， then a backup of the spfile is performed.D
When a structural change is made to the database， then a backup of the alert log file will be performed.
考题
多选题Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to use Recovery Manager （RMAN） to perform backups. Which two backups would you be able to perform when the database is being accessed by users？（）Abackup of offline tablespacesBbackup of readonly tablespacesCbackup of systemcritical tablespacesDbackup of online， locally managed tablespacesEbackup of read/write dictionarymanaged tablespaces
考题
单选题You accepted the recommended SQL Profile by executing the following code： DECLARE sqlprofile_name varchar2（30）； BEGIN sqlprofile_name ：= DBMS_SQLTUNE.ACCEPT_SQL_PROFILE（ task_name = ’my_task’， profile_name = ’my_profile’）； END； Which advisor will analyze this profile？（）A
SQL Access AdvisorB
Undo AdvisorC
Segment AdvisorD
SQL Tuning Advisor
考题
单选题The EMPLOYEES table is stored in the USERS tablespace. You need to check if the EMPLOYEES table is affected by the block corruption found in the USERS tablespace. Which option would you use？（）A
the DBNEWID utilityB
the ANALYZE commandC
the RMAN LIST commandD
the RMAN REPORT commandE
the RMAN CROSSCHECK commandF
the RMAN BLOCKRECOVER command
考题
多选题You are using Oracle Database 10g. You performed an incomplete recovery of your database and opened the database with the RESETLOGS option. What is the effect of opening the database with the RESETLOGS option？ （）AThis operation resets the SCN for the database.BThis operation creates a new incarnation of the database.CThis operation moves all the redo log files to a different location.DThis operation deletes the old redo log files and creates new redo log files.EThis operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.
考题
单选题Matthew has recently joined NetFx Corporation as a junior-level Database Administrator （DBA）. He is asked by his supervisor to verify the database for data block corruptions. He uses the DBVERIFY utility and finds that two data blocks are corrupted in the database. What should Matthew use to identify the corrupted blocks as well as datafiles containing these blocks？（）A
datafileB
alert logC
dynamic viewsD
control file script
考题
单选题You have created a resource plan， DB_PLAN， using DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN and you want to impose a restriction on utilization of resources by the database users. Which step must be performed before you can start using the resource plan？（）A
assign users to consumer groupsB
set the resource plan for the instanceC
configure a simple resource plan and specify plan directivesD
configure a complex resource plan and specify plan directives
考题
单选题Which view will you use to view information regarding the jobs that are currently running in a database？（）A
DBA_SCHEDULER_RUNNING_JOBSB
DBA_SCHEDULER_JOB_RUN_DETAILSC
DBA_SCHEDULER_JOBSD
DBA_SCHEDULER_JOB_LOG
考题
多选题You have created a resource plan， PROD_DB_PLAN， with the following consumer groups with the respective plan directives： Consumer group SALES with CPU_P1 as 60 and DEGREE_OF_PARALLELISM as 4. Consumer group MARKET with CPU_P1 as 20. Consumer group DEV with CPU_P1 as 20. Consumer group OTHERS with CPU_P1 as 0 and CPU_P2 as 100. Which two statements are correct in this scenario？ （）AThe maximum degree of parallelism for the members of the consumer groups is 4.BThe CPU allocation will always be equal for the consumer groups MARKET and DEV.CThe OTHERS consumer group would get 100% of the CPU if there are unused level 1 CPU resources.DThe SALES and MARKET consumer groups would get 100% of the CPU if there are unused level 2 CPU resources.EThe maximum degree of parallelism for the members of the consumer group SALES is 4 with no restriction for the remaining groups.
考题
单选题From the V$SESSION_LONGOPS view， you find that some of the database users have long-running queries that consume a lot of CPU time. This causes performance problems for other users in the database， who have much shorter queries. You would like to make sure that the users with large queries do not use all the CPU time， but you still do not want to terminate them with an error message. Which method would you follow to achieve this？（）A
set the CPU time per call in the users profileB
set the CPU time per session in the users profilesC
set the TIMED_STATISTICS parameter to TRUE in the parameter fileD
set the CPU levels for the users’ group using Resource Manager
考题
单选题The size of the largest datafile， data1.dbf， in your database is 30MB. You issued the following command： RMANCONFIGURE MAXSETSIZE 10MB； What will be the impact of the above setting？（）A
While performing the backup of the datafile，data1.dbf，one backup set is created.B
While performing the backup of the datafile，data1.dbf，two backup sets are created.C
While performing the backup of the datafile，data1.dbf，three backup sets are created.D
While performing the backup of the datafile，data1.dbf，the command for performing a backup of the datafile，data1.dbf，will fail.
考题
单选题You are maintaining the SALES database of a company. You have never backed up the USERS tablespace that is currently offline. On Sunday， you issued the following commands： CONFIGURE DEFAULT DEVICE TYPE TO sbt； CONFIGURE BACKUP OPTIMIZATION ON； CONFIGURE RETENTION POLICY TO REDUNDANCY 3； From Monday to Saturday， you performed the following actions： Day Action Monday BACKUP DATABASE Tuesday BACKUP DATABASE Wednesday BACKUP DATABASE Thursday BACKUP DATABASE Friday BACKUP DATABASE Saturday BACKUP DATABASE How many times will the backup of the USERS tablespace be performed？（）A
The backup will not be performed at all.B
three timesC
four timesD
six times
考题
多选题For an incomplete recovery， which four backup types can be used by Recovery Manager （RMAN） to restore data files？ （）ARMAN image copiesBRMAN database backupsCRMAN tablespace backupsDusermanaged backups placed in the flash recovery areaEusermanaged backups that have been cataloged with RMANFusermanaged data file backups for which the full path name is specified
考题
单选题The loss of the control file forced you to re-create the control file. After re-creating it and opening the database， you find that some of the data files are named as MISSINGnnnnn， where nnnnn is a five-digit number starting with 0. What could be the possible reason？（）A
These are the data files that are corrupted.B
There is no SYSAUX tablespace in your databaseC
There is a read-only tablespace in your database.D
These are the data files that cannot be recovered.
考题
多选题In your production database， you have observed that the database server performance degrades whenever there is a switch between the log groups. On further investigation， you find that the database is running in ARCHIVELOG mode and the archived log files are being written to the same disk that is used to store the redo log members. Which two actions would you take to improve the performance of the database server？ （）Aincrease the size of the redo log bufferBincrease the number of redo log groupsCincrease the number of log writer processesDincrease the number of ARCn processesEchange the appropriate LOG_ARCHIVE_DEST_n parameter to place the archived log files in a separate location
考题
单选题You executed the following code： SQL CREATE TABLE COUNTRY （COUNTRY_ID CHAR（2） CONSTRAINT COUNTRY_ID_nn NOT NULL， COUNTRY_NAME VARCHAR2（20）， CURRENCY_NAME VARCHAR2（20）， CONSTRAINT COUNTRY_ID_PK PRIMARY KEY （COUNTRY_ID）） ORGANIZATION INDEX； In which tablespace will the mapping table be created？（）A
SYSTEM tablespaceB
SYSAUX tablespaceC
Undo tablespaceD
The tablespace of the Index Organized Table （IOT）
考题
单选题Your database block size is 4 KB. In this database， you are required to create a tablespace with a block size of 8 KB. Which is the prerequisite for creating this tablespace？（）A
The parameter DB_CACHE_SIZE must be a multiple of 8.B
The value of the parameter SGA_MAX_SIZE must be increased.C
The tablespace must be created with a uniform extent size of 8 KBD
The parameter DB_8K_CACHE_SIZE must be defined in the parameter file.
考题
单选题You want to create a consumer group， GROUP1， and you execute the following command in the command/x7fline interface： SQL EXEC DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP （CONSUMER_GROUP =’group1’， COMMENT = ’New Group’）; This command errors out displaying the following message： ERROR at line 1： ORA/x7f01031： insufficient privileges ORA/x7f06512： at "SYS.DBMS_RMIN"， line 115 ORA/x7f06512： at SYS.DBMS_RESOURCE_MANAGER"， line 108 ORA/x7f06512： at line 1 What action would you take to overcome this error？（）A
grant SYSDBA to the userB
grant SYSOPER to the userC
grant the RESOURCE role to the userD
use the GRANT command to grant the ADMINISTER_RESOURCE_MANAGER privilege to the userE
grant the ADMINISTER_RESOURCE_MANAGER privilege to the user by using the DBMS_RESOURCE_MANAGER_PRIVS package
考题
单选题Manually， you set the consumer group of all of the newly created users to MYDB_GRP. You want the users to be able to change their consumer groups as per the application requirement. What was the first step that was needed in the process to achieve this objective？（）A
The user must have been granted the DBA role.B
The user must have been granted the switch privilege as a part of a role.C
The user must have been granted the Resource Manager administrator privilege.D
The user must have been granted the switch privilege by using the DBMS_RESOURCE_MANAGER_PRIVS package.
考题
单选题One of the tablespaces is read/x7fonly in your database. The loss of all control files forced you to re/x7fcreate the control file. Which operation do you need to perform after re/x7fcreating the control file and opening the database？（）A
drop and recreate the readonly tablespacesB
rename the readonly data files to their correct file namesC
change the tablespace status from read/write to readonlyD
recreate the readonly tablespace because it is automatically removed
考题
单选题You want to estimate the size of a table by using the Oracle Enterprise Manager. On which data is the size of the table NOT based？（）A
column sizesB
column data typesC
PCTFREED
projected number of rowE
PCTUSED
热门标签
最新试卷