网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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.
参考答案
参考解析
解析：
暂无解析
更多 “单选题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 the following command:ALTER SYSTEM SET enable_ddl_logging=FALSE;Which statement is true?（）A
None of the data definition language (DDL) statements are logged in the trace file.B
Only DDL commands that resulted in errors are logged in the alert log file.C
A new log.xml file that contains the DDL statements is created, and the DDL command details are removed from the alert log file.D
Only DDL commands that resulted in the creation of new database files are logged.
考题
单选题In your multitenant container database (CDB) containing pluggable databases (PDB), users complain about performance degradation. How does real-time Automatic database Diagnostic Monitor (ADDM) check performance degradation and provide solutions?（）A
It collects data from SGA and compares it with a preserved snapshot.B
It collects data from SGA, analyzes it, and provides a report.C
It collects data from SGA and compares it with the latest snapshot.D
It collects data from both SGA and PGA, analyzes it, and provides a report
考题
多选题You run a script that completes successfully using SQL*Plus that performs these actions: 1. Creates a multitenant container database (CDB) 2. Plugs in three pluggable databases (PDBs) 3. Shuts down the CDB instance 4. Starts up the CDB instance using STARTUP OPEN READ WRITE Which two statements are true about the outcome after running the script?（）AThe seed will be in mount state.BThe seed will be opened read-only.CThe seed will be opened read/write.DThe other PDBs will be in mount state.EThe other PDBs will be opened read-only.FThe PDBs will be opened read/write.
考题
多选题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.
考题
多选题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.
考题
多选题Which two statements are true when row archival management is enabled?（）AThe ORA_ARCHIVE_STATE column visibility is controlled by the ROW ARCHIVAL VISIBILITY session parameter.BThe ORA_ARCHIVE_STATE column is updated manually or by a program that could reference activity tracking columns, to indicate that a row is no longer considered active.CThe ROW ARCHIVAL VISIBILITY session parameter defaults to active rows only.DThe ORA_ARCHIVE_STATE column is visible if referenced in the select list of a query.EThe ORA_ARCHIVE_STATE column is updated automatically by the Oracle Server based on activity tracking columns, to Indicate that a row is no longer considered active.
考题
多选题You support Oracle Database 12c Oracle Database 11g, and Oracle Database log on the same server. All databases of all versions use Automatic Storage Management (ASM). Which three statements are true about the ASM disk group compatibility attributes that are set for a disk group?（）AThe ASM compatibility attribute controls the format of the disk group metadata.BRDBMS compatibility together with the database version determines whether a database Instance can mount the ASM disk group.CThe RDBMS compatibility setting allows only databases set to the same version as the compatibility value, to mount the ASM disk group.DThe ASM compatibility attribute determines some of the ASM features that may be used by the Oracle disk group.EThe ADVM compatibility attribute determines the ACFS features that may be used by the Oracle 10g database.
考题
单选题You are connected to a pluggable database (PDB) as a common user with DBA privileges. The STATISTICS_LEVEL parameter is PDB_MODIFIABLE. You execute the following: SQL ALTER SYSTEM SET STATISTICS_LEVEL = ALL SID = ‘*’ SCOPE = SPFILE; Which is true about the result of this command?（）A
The STATISTICS_LEVEL parameter is set to all whenever this PDB is re-opened.B
The STATISTICS_LEVEL parameter is set to ALL whenever any PDB is reopened.C
The STATISTICS_LEVEL parameter is set to all whenever the multitenant container database (CDB) is restarted.D
Nothing happens; because there is no SPFILE for each PDB, the statement is ignored.
热门标签
最新试卷