网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
多选题
You configured the Flash Recovery Area （FRA） for your database. The database instance is running inARCHIVELOG mode. The default location for the archived redo log files is the Flash Recovery Area. Which twofiles are removed automatically if the space is required in the FRA as per the retention policy（）
A
Flashback log files
B
Backups that have become obsolete
C
User managed backups of the data files and control files
D
Archived redo log files that have multiple copies in a different archive location and not backed up
参考答案
参考解析
解析：
暂无解析
更多 “多选题You configured the Flash Recovery Area （FRA） for your database. The database instance is running inARCHIVELOG mode. The default location for the archived redo log files is the Flash Recovery Area. Which twofiles are removed automatically if the space is required in the FRA as per the retention policy（）AFlashback log filesBBackups that have become obsoleteCUser managed backups of the data files and control filesDArchived redo log files that have multiple copies in a different archive location and not backed up” 相关考题
考题
单选题ou have a large amount of historical data in a flat file. Some analysts in your organization need to query thisdata in the file. The file is too large to load the data in it into your current database. Which is the most effectivemethod to access this data in your database（）A
Use the database link.B
Use the SQL*Loader utility.C
Use the Oracle Data Pump utility.D
Create an external table and leave the data in the flat file
考题
多选题Identify three situations in which you would NOT be able to drop a tablespace. （）Awhen the tablespace is onlineBwhen the tablespace has segments with data in itCwhen the tablespace is a default permanent tablespace for the databaseDwhen the tablespace contains a table that is currently being used by transactionsEwhen the tablespace contains undo data that is needed to rollback an uncommitted transaction
考题
单选题You executed the following command to perform a backup of the USERS tablespace： SQL ALTER TABLESPACE users BEGIN BACKUP； ALTER TABLESPACE users BEGIN BACKUP * ERROR at line 1： ORA-01123： cannot start online backup； media recovery not enabled What could be the reason for this error（）A
The MTTR Advisor is disabled.B
The database is in NOARCHIVELOG mode.C
The tablespace is already in backup mode.D
The Flash Recovery Area is not configured.
考题
单选题Your database instance is started using the server parameter file （SPFILE）. You executed acommand to change the value of the LOG_BUFFER initialization parameter： ALTER SYSTEM SET LOG_BUFFER=32M SCOPE=BOTH； What would be the outcome of this command（）A
The command succeeds only if Automatic Memory Management is not enabled.B
The command succeeds， but you need to restart the database for changes to take effect.C
The command returns an error because the size of the redo log buffer cannot be changed dynamically.D
The parameter value is changed and it comes into effect as soon as space becomes available in the System Global Area （SGA）.
考题
多选题Your database instance is running with full workload after database creation. You have decided to useafixed-sizeundo tablespace. You want to use the Undo Advisor to estimate the capacity of the undotablespace. Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace（）Athe retention period to support flashbackBthe expected length of the longest-running queryCthe number of undo tablespaces in the databaseDthe size of the Flash Recovery Area for the database instance
考题
多选题Which two statements are true regarding the MRKT tablespace（）ANo more data files can be added to the tablespace.BSegment space is managed by free lists in the tablespace.CA user created without being assigned a default tablespace uses this tablespace.DThe tablespace can be dropped with the current setting with segments present in it.
考题
单选题In your database instance， the user sessions are connected to the database server from the remote machines.You want to achieve the following for these users： 1. The user account must be locked after four unsuccessful login attempts. 2. The user must be prompted to change the password at regular intervals. 3. The user may not have more than three simultaneous sessions. 4. The user session must automatically be logged off if more than 10 minutes elapsed time used. How would you accomplish the above（）A
By assigning profiles for the usersB
By implementing Fine-Grained Auditing （FGA）C
By granting a secure application role to the usersD
By implementing the Database Resource Manager plan
热门标签
最新试卷
