网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
多选题
You use the segment advisor to help determine objects for which space may be reclaimed. Which three statements are true about the advisor given by the segment advisor?（）
A
It may advise the use of online table redefinition for tables in dictionary managed tablespace.
B
It may advise the use of segment shrink for tables in dictionary managed tablespaces it the no chained rows.
C
It may advise the use of online table redefinition for tables in locally managed tablespaces
D
It will detect and advise about chained rows.
E
It may advise the use of segment shrink for free list managed tables.
参考答案
参考解析
解析：
暂无解析
更多 “多选题You use the segment advisor to help determine objects for which space may be reclaimed. Which three statements are true about the advisor given by the segment advisor?（）AIt may advise the use of online table redefinition for tables in dictionary managed tablespace.BIt may advise the use of segment shrink for tables in dictionary managed tablespaces it the no chained rows.CIt may advise the use of online table redefinition for tables in locally managed tablespacesDIt will detect and advise about chained rows.EIt may advise the use of segment shrink for free list managed tables.” 相关考题
考题
多选题Which three statements are true about adaptive SQL plan management?（）AIt automatically performs verification or evolves non-accepted plans, in COMPREHENSIVE mode when they perform better than existing accepted plans.BThe optimizer always uses the fixed plan, if the fixed plan exists in the plan baseline.CIt adds new, bettor plans automatically as fixed plans to the baseline.DThe non-accepted plans are automatically accepted and become usable by the optimizer if they perform better than the existing accepted plans.EThe non-accepted plans in a SQL plan baseline are automatically evolved, in COMPREHENSIVE mode, during the nightly maintenance window and a persistent verification report is generated.
考题
多选题You performed an incremental level 0 backup of a database: RMAN BACKUP INCREMENTAL LEVEL 0 DATABASE; To enable block change tracking after the incremental level 0 backup, you issued this command: SQL ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE ‘ /mydir/rman_change_track.f’; To perform an incremental level 1 cumulative backup, you issued this command: RMAN BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE; Which three statements are true?（）ABackup change tracking will sometimes reduce I/O performed during cumulative incremental backups.BThe change tracking file must always be backed up when you perform a full database backup.CBlock change tracking will always reduce I/O performed during cumulative incremental backups.DMore than one database block may be read by an incremental backup for a change made to a single block.EThe incremental level 1 backup that immediately follows the enabling of block change tracking will not read the change tracking file to discover changed blocks.
考题
单选题Your are the DBA supporting an Oracle 11g Release 2 database and wish to move a table containing several DATE, CHAR, VARCHAR2, and NUMBER data types, and the table’s indexes, to another tablespace. The table does not have a primary key and is used by an OLTP application. Which technique will move the table and indexes while maintaining the highest level of availability to the application?（）A
Oracle Data Pump.B
An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD to move the indexes.C
An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD ONLINE to move the indexes.D
Online Table Redefinition.E
Edition-Based Table Redefinition.
考题
多选题Examine these two statements:Which three are true about the MRKT tablespace?（）AThe MRKT tablespace is created as a small file tablespace, because the file size is less than the minimum required for big file files.BThe MRKT tablespace may be dropped if it has no contents.CUsers who were using the old default tablespace will have their default tablespaces changed to the MRKT tablespace.DNo more data files can be added to the tablespace.EThe relative file number of the tablespace is not stored in rowids for the table rows that are stored in the MRKT tablespace.
考题
多选题In which two scenarios do you use SQL* Loader to load data?（）ATransform the data while it is being loaded into the database.BUse transparent parallel processing without having to split the external data first.CLoad data into multiple tables during the same load statement.DGenerate unique sequential key values in specified columns.
考题
单选题You have installed two 64G flash devices to support the Database Smart Flash Cache feature on your database server that is running on Oracle Linux. You have set the DB_SMART_FLASH_FILE parameter: DB_FLASH_CACHE_FILE= ‘/dev/flash_device_1 ‘,’ /dev/flash_device_2’ How should the DB_FLASH_CACHE_SIZE be configured to use both devices?（）A
Set DB_FLASH_CACHE_SIZE=64GB
Set D3_FLASH_CACHE_SIZE=64G, 64GC
Set D3_FLASK_CACKE_SI2E=128GD
db_flash_cache_SI2E is automatically configured by the instance at startup
考题
单选题You are required to migrate your 11.2.0.3 database as a pluggable database (PDB) to a multitenant container database (CDB). The following are the possible steps to accomplish this task: 1. Place all the user-defined tablespace in read-only mode on the source database. 2. Upgrade the source database to a 12c version. 3. Create a new PDB in the target container database. 4. Perform a full transportable export on the source database with the VERSION parameter set to 12 using the expdp utility. 5. Copy the associated data files and export the dump file to the desired location in the target database. 6. Invoke the Data Pump import utility on the new PDB database as a user with the DATAPUMP_IMP_FULL_DATABASE role and specify the full transportable import options. 7. Synchronize the PDB on the target container database by using the DBMS_PDS.SYNC_ODB function. Identify the correct order of the required steps.（）A
2，1，3，4，5，6B
1，3，4，5，6，7C
1，4，3，5，6，7D
2，1，3，4，5，6，7E
1，5，6，4，3，2
考题
多选题Which three tasks can be automatically performed by the Automatic Data Optimization feature ofInformation lifecycle Management (ILM)?（）ATracking the most recent read time for a table segment in a user tablespaceBTracking the most recent write time for a table segment in a user tablespaceCTracking insert time by row for table rowsDTracking the most recent write time for a table blockETracking the most recent read time for a table segment in the SYSAUX tablespaceFTracking the most recent write time for a table segment in the SYSAUX tablespace
考题
单选题You created an encrypted tablespace: You then closed the encryption wallet because you were advised that this is secure. Later in the day, you attempt to create the EMPLOYEES table in the SECURESPACE tablespace with the SALT option on the EMPLOYEE column. Which is true about the result?（）A
It creates the table successfully but does not encrypt any inserted data in the EMPNAME column because the wallet must be opened to encrypt columns with SALT.B
It generates an error when creating the table because the wallet is closed.C
It creates the table successfully, and encrypts any inserted data in the EMPNAME column because the wallet needs to be open only for tablespace creation.D
It generates error when creating the table, because the salt option cannot be used with encrypted tablespaces.
考题
多选题You execute the following PL/SQL:Which two statements are true?（）AFine-Grained Auditing (FGA) is enabled for the PRICE column in the PRODUCTS table for SELECT statements only when a row with PRICE 10000 is accessed.BFGA is enabled for the PRODUCTS.PRICE column and an audit record is written whenever a row with PRICE 10000 is accessed.CFGA is enabled for all DML operations by JIM on the PRODUCTS.PRICE column.DFGA is enabled for the PRICE column of the PRODUCTS table and the SQL statements is captured in the FGA audit trial.
考题
多选题Which three statements are true about using flashback database in a multitenant container database(CDB)?（）AThe root container can be flashed back without flashing back the pluggable databases (PDBs).BTo enable flashback database, the CDB must be mounted.CIndividual PDBs can be flashed back without flashing back the entire cdb.DThe DB_FLASHBACK RETENTION_TARGET parameter must be set to enable flashback of the cdb.EA CDB can be flashed back specifying the desired target point in time or an SCN, but not a restore point.
热门标签
最新试卷