网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
多选题
Which three operations can be performed as multipartition operations in Oracle?（）
A
Merge partitions of a list partitioned table
B
Drop partitions of a list partitioned table
C
Coalesce partitions of a hash-partitioned global index.
D
Move partitions of a range-partitioned table
E
Rename partitions of a range partitioned table
F
Merge partitions of a reference partitioned index
参考答案
参考解析
解析：
暂无解析
更多 “多选题Which three operations can be performed as multipartition operations in Oracle?（）AMerge partitions of a list partitioned tableBDrop partitions of a list partitioned tableCCoalesce partitions of a hash-partitioned global index.DMove partitions of a range-partitioned tableERename partitions of a range partitioned tableFMerge partitions of a reference partitioned index” 相关考题
考题
Which three tasks can be performed by using the performance Schema?()
A.Finding queries that are not using indexesB.Finding rows that are locked by InnoDBC.Finding client connection attributesD.Finding the part of a code in which a single query is spending timeE.Finding the size of each table
考题
Which three tasks can be performed using a duplicate database? ()(Choose three.)
A. Testing the backup and recovery proceduresB. Testing the upgrade of an Oracle database to a new releaseC. Testing the effect of an application changes on database performanceD. Continuously updating archive log files from the target database to support failover
考题
Which three operations can be performed as multipartition operations in Oracle?()
A. Merge partitions of a list partitioned tableB. Drop partitions of a list partitioned tableC. Coalesce partitions of a hash-partitioned global index.D. Move partitions of a range-partitioned tableE. Rename partitions of a range partitioned tableF. Merge partitions of a reference partitioned index
考题
Which three service components are in the operate phase？（）A、System MonitoringB、Operations ImplementationC、Incident and Problem ManagementD、Change ManagementE、Operations PlanF、Project Close Out
考题
Which three wireless service components belong to the operate phase？（）A、operations planB、operations assessmentC、security administrationD、system monitoringE、operations implementationF、incident management
考题
Which three service components belong to the operate phase（）A、Change ManagementB、Operations ImplementationC、System monitoringD、Incident ManagementE、Operations Assessment
考题
Which three tasks can be performed using regular expression support in Oracle Database 10g？（）A、 it can be used to concatenate two strings.B、 it can be used to find out the total length of the string.C、 it can be used for string manipulation and searching operations.D、 it can be used to format the output for a column or expression having string data.E、 it can be used to find and replace operations for a column or expression having string data.
考题
Which two statements are true about the duplexing of the backups taken by RMAN? （）(Choose two.)A、It's only supported for the backups performed on the tapeB、It is not supported for backup operations that produce image copiesC、Duplex backups need a parallelism for the device to be equal to number of copiesD、Duplex backups can be performed to either disk or tape, but cannot be performed on tape and disk simultaneously
考题
Which two statements are correct regarding the Flashback Versions Query feature？（）A、 You can use this feature to identify the committed versions of the rows， but not the uncommitted versions.B、 You can use this feature to identify the versions of V$ views.C、 You can use this feature to identify the inserts， deletes， and updates performed on a particular row but not the data definition language （DDL） operations performed on the table.D、 You can use this feature for a table only if row movement is enabled for the table.E、 You can use this feature to identify the versions of external and fixed tables.
考题
Which two statements are true about the duplexing of the backups taken by RMAN？（） A、 It’s only supported for the backups performed on the tapeB、 It is not supported for backup operations that produce image copiesC、 Duplex backups need a parallelism for the device to be equal to number of copiesD、 Duplex backups can be performed to either disk or tape， but cannot be performed on tape and disk simultaneously
考题
Which three tasks can be performed by using the performance Schema?（）A、Finding queries that are not using indexesB、Finding rows that are locked by InnoDBC、Finding client connection attributesD、Finding the part of a code in which a single query is spending timeE、Finding the size of each table
考题
Which three operations can be performed as multipartition operations in Oracle?（）A、Merge partitions of a list partitioned tableB、Drop partitions of a list partitioned tableC、Coalesce partitions of a hash-partitioned global index.D、Move partitions of a range-partitioned tableE、Rename partitions of a range partitioned tableF、Merge partitions of a reference partitioned index
考题
Which two database operations can be performed at the MOUNT stage of database startup？（）A、renaming of data filesB、dropping the database userC、renaming of control filesD、multiplexing of control filesE、configuring the database in ARCHIVELOG mode
考题
In your production database， you observe that users’ transactions are consuming a lot of resources and you plan to impose resource restrictions by using Resource Manager. For which three resources can you enable usage restrictions by using Resource Manager？（）A、CPU usageB、degree of parallelismC、number of open cursorsD、number of sorts performedE、idle time for blocking sessionsF、number of disk I/O operations performedG、number of memory I/O operations performed
考题
多选题Which three tasks can be performed using regular expression support in Oracle Database 10g？（）Ait can be used to concatenate two strings.Bit can be used to find out the total length of the string.Cit can be used for string manipulation and searching operations.Dit can be used to format the output for a column or expression having string data.Eit can be used to find and replace operations for a column or expression having string data.
考题
单选题Your test database is running in NOARCHIVELOG mode. Which statement is true regarding the type ofbackups that can be performed on the database（）A
You can perform online whole database backups.B
You can performofflinewhole database backups.C
You cannot perform schema-level export/import operations.D
You can perform the backup of only the SYSTEM tablespace when the database is open.
考题
多选题ou need to create a data block for query operations in the RETIRED_EMPLOYEES form module. Which three data sources can you use for this block?（）AvectorBdatabase viewCdatabase tableDtransactional triggerEPL/SQL table of recordsFmulti-dimensional array
考题
多选题Which three tasks can be performed by using the performance Schema?（）AFinding queries that are not using indexesBFinding rows that are locked by InnoDBCFinding client connection attributesDFinding the part of a code in which a single query is spending timeEFinding the size of each table
考题
多选题Examine the query and its output executed In an RDBMS Instance:Which three statements are true about the users (other than sys) in the output?（）AThe C # # B_ADMIN user can perform all backup and recovery operations using RMAN only.BThe C # # C_ADMIN user can perform the data guard operation with Data Guard Broker.CThe C # # A_ADMIN user can perform wallet operations.DThe C # # D_ADMIN user can perform backup and recovery operations for Automatic Storage Management (ASM).EThe C # # B_ADMIN user can perform all backup and recovery operations using RMAN or SQL* Plus.
考题
多选题Which three tasks can be performed using a duplicate database? （）(Choose three.)ATesting the backup and recovery proceduresBTesting the upgrade of an Oracle database to a new releaseCTesting the effect of an application changes on database performanceDContinuously updating archive log files from the target database to support failover
考题
多选题Which two statements are true about simple views？（）AViews can be created as read only.BViews are data segments like tables.CViews can be created on the basis of more than one table.DData manipulation language （DML） operations cannot be performed on views.
考题
多选题In your production database， you observe that users’ transactions are consuming a lot of resources and you plan to impose resource restrictions by using Resource Manager. For which three resources can you enable usage restrictions by using Resource Manager？ （）ACPU usageBdegree of parallelismCnumber of open cursorsDnumber of sorts performedEidle time for blocking sessionsFnumber of disk I/O operations performedGnumber of memory I/O operations performed
考题
多选题Which two database operations can be performed at the MOUNT stage of database startup？（）Arenaming of data filesBdropping the database userCrenaming of control filesDmultiplexing of control filesEconfiguring the database in ARCHIVELOG mode
考题
多选题Which two operations can be performed on an external table（）ACreate a view on the table.BCreate an index on the table.CCreate a synonym on the table.DAdd a virtual column to the table.EUpdate the table using the UPDATE statement.FDelete rows in the table using the DELETE command
考题
多选题Which two statements are true about the duplexing of the backups taken by RMAN？（）AIt’s only supported for the backups performed on the tapeBIt is not supported for backup operations that produce image copiesCDuplex backups need a parallelism for the device to be equal to number of copiesDDuplex backups can be performed to either disk or tape， but cannot be performed on tape and disk simultaneously
考题
多选题Which three operations can be performed as multipartition operations in Oracle?（）AMerge partitions of a list partitioned tableBDrop partitions of a list partitioned tableCCoalesce partitions of a hash-partitioned global index.DMove partitions of a range-partitioned tableERename partitions of a range partitioned tableFMerge partitions of a reference partitioned index
考题
多选题You work as a database administrator at Certkiller .com. In your production database， you observe that users’ transactions are consuming a lot of resource and you plan to impose resource restrictions by using Resource Manager. For which three resources can you enable usage restrictions by using Resource Manager？ （）ACPU usageBdegree of parallelismCnumber of open cursorsDnumber of sorts performedEidle time for blocking sessionsFnumber of disk I/O operations performedGnumber of memory I/O operations performed
考题
多选题Which two statements are true about the duplexing of the backups taken by RMAN? （）(Choose two.)AIt's only supported for the backups performed on the tapeBIt is not supported for backup operations that produce image copiesCDuplex backups need a parallelism for the device to be equal to number of copiesDDuplex backups can be performed to either disk or tape, but cannot be performed on tape and disk simultaneously
热门标签
最新试卷
