网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
多选题
Consider the events_% tables in performance Schema. Which two methods will clear or reset the collected events in the tables?（）
A
Using DELETE statements, for example, DELETE FROM performance_schema.events_watis_current
B
Using the statement RESET PERFORMANCE CACHE
C
Using the statement FLUSH PERFORMANCE CACHE
D
Using TRUNCATE statements, for example, TRUNATE TABLE performance_schema.events_waits_current
E
Disabling and re-enabling all instruments
F
Restarting Mysql
参考答案
参考解析
解析：
暂无解析
更多 “多选题Consider the events_% tables in performance Schema. Which two methods will clear or reset the collected events in the tables?（）AUsing DELETE statements, for example, DELETE FROM performance_schema.events_watis_currentBUsing the statement RESET PERFORMANCE CACHECUsing the statement FLUSH PERFORMANCE CACHEDUsing TRUNCATE statements, for example, TRUNATE TABLE performance_schema.events_waits_currentEDisabling and re-enabling all instrumentsFRestarting Mysql” 相关考题
考题
Which of the following is least likely to be used in explaining to a team member why you consider his/her performance substandard?A Project office memoB counseling sessionC project team meetingD formal letterE individual conversation
考题
50 Which of the following is least likely to be used in explaining to a team member why you consider his/her performance substandard?A. Project office memoB. counseling sessionC. project team meetingD. formal letterE. individual conversation
考题
(ii) the recent financial performance of Merton plc from a shareholder perspective. Clearly identify anyissues that you consider should be brought to the attention of the ordinary shareholders. (15 marks)
考题
Note: requirement (a) includes 4 professional marks.A central feature of the performance measurement system at TSC is the widespread use of league tables that displayeach depot’s performance relative to one another.Required:(b) Evaluate the potential benefits and problems associated with the use of ‘league tables’ as a means ofmeasuring performance. (6 marks)
考题
Consider the events_% tables in performance Schema.Which two methods will clear or reset the collected events in the tables?()
A.Using DELETE statements, for example, DELETE FROM performance_schema.events_watis_currentB.Using the statement RESET PERFORMANCE CACHEC.Using the statement FLUSH PERFORMANCE CACHED.Using TRUNCATE statements, for example, TRUNATE TABLE performance_schema.events_waits_currentE.Disabling and re-enabling all instrumentsF.Restarting Mysql
考题
The datum from which the predicted heights of tides are reckoned in the tide tables is ______.A.mean low waterB.the same as that used for the charts of the localityC.the highest possible levelD.given in table three of the tide tables
考题
Which statement is true about the forwarding plane?（）A、It uses ASICs for increased performance.B、It is the intelligence of the platform.C、It maintains the routing tables.D、It is based on an x86 architecture.
考题
Consider the events_% tables in performance Schema. Which two methods will clear or reset the collected events in the tables?（）A、Using DELETE statements, for example, DELETE FROM performance_schema.events_watis_currentB、Using the statement RESET PERFORMANCE CACHEC、Using the statement FLUSH PERFORMANCE CACHED、Using TRUNCATE statements, for example, TRUNATE TABLE performance_schema.events_waits_currentE、Disabling and re-enabling all instrumentsF、Restarting Mysql
考题
As a database administrator you spend a lot of time observing and setting various storage parameter values for your application tables in order to gain performance benefits. Which task would you perform to reduce this overhead？（）A、Coalesce the application tables at a regular interval.B、Export and Import the application tables a regular interval.C、Drop and recreate the application tables at a regular interval.D、Move the application tables to a tablespace with less space usage.E、Distribute the application tables across multiple tablespaces depending on usage.F、Move the application tables to automatic segment space management tablespace.
考题
The customer and order tables are often used in joins， thereby resulting in complex queries. You created views to simplify the writing of queries. These views are stored in（）.A、user tablesB、view segmentC、table segmentD、data dictionaryE、object segmentF、performance tables
考题
Identify a performance impact when using the Performance Schema.（）A、There is no impact on performanceB、The overhead depends on the settings of the Performance SchemaC、There is an overhead for querying the Performance Schema but not for having it enabledD、There is a constant overhead regardless of settings and workload
考题
You need to improve the performance of the tempdb database on SQL1.Which two actions should you perform？（）A、Move tempdb onto a faster disk volume.B、Increase the initial size of tempdb to 1.5 GBC、Increase the size of the data files in the Tracking database.D、Decrease the file growth increment for tempdb to 25 MBE、Use more local temporary tables and fewer global temporary tables in the Tracking database.
考题
单选题On Tuesday， a junior DBA dropped an important application user account， whose schema has important tables. You are asked to recover all the objects in the schema. On investigation， you find that the user account was dropped at 11：00 a.m. and Sunday’s backup is the most recent backup.Which flashback feature would you use？（）A
Flashback DropB
Flashback TableC
Flashback DatabaseD
Flashback Version QueryE
Flashback Transaction Query
考题
多选题Which two are true regarding external tables？ （）AExternal tables can be updated.BExternal tables are read-only tables.CIndexes can be created on external tables.DIndexes cannot be created on external tables.
考题
单选题Identify a performance impact when using the Performance Schema.（）A
There is no impact on performanceB
The overhead depends on the settings of the Performance SchemaC
There is an overhead for querying the Performance Schema but not for having it enabledD
There is a constant overhead regardless of settings and workload
考题
单选题The rows inside three Oracle tables supporting a customer order entry system are frequently accessed together by means of a table join. Because data is always being added to the tables, you leave a lot of extra space inside each block to accommodate growth. Which of the following types of tables would be useful for storing the data in this context?（）A
Temporary tables B
Index-organized tables C
Cluster tables D
Standard Oracle tables
考题
单选题You discover that your Recycle Bin contains two tables with the same name， MY_TABLE. You also have a table named MY_TABLE in your schema. You execute the following statement： FLASHBACK TABLE my_table TO BEFORE DROP RENAME TO my_table2； What will be the result of executing this statement？（）A
One of the tables is recovered from the Recycle Bin using a First In First Out （FIFO） approach.B
One of the tables is recovered from the Recycle Bin using a Last In First Out （LIFO） approach.C
Both the tables are recovered from the Recycle Bin with one table renamed to MY_TABLE2 and the other to a system-generated name.D
None of the tables are recovered from the Recycle Bin， and the statement returns an error.
考题
单选题You discover that your Recycle Bin contains two tables with the same name, MY_TABLE. You also have a table named MY_TABLE in your schema. You execute the following statement: FLASHBACK TABLE my_table TO BEFORE DROP RENAME TO my_table2; What will be the result of executing this statement?（）A
One of the tables is recovered from the Recycle Bin using a First In First Out (FIFO) approach.B
One of the tables is recovered from the Recycle Bin using a Last In First Out (LIFO) approach.C
Both the tables are recovered from the Recycle Bin with one table renamed to MY_TABLE2 and the other to a system-generated name.D
None of the tables are recovered from the Recycle Bin, and the statement returns an error.
考题
多选题Which three statements are correct about temporary tables？（）AIndexes and views can be created on temporary tables.BBoth the data and the structure of temporary tables can be exported.CTemporary tables are always created in a user’s temporary tablespace.DThe data inserted into a temporary table in a session is available to other sessions.EData manipulation language （DML） locks are never acquired on the data of temporary tables.
考题
单选题On Tuesday， a junior DBA dropped an important application user account， whose schema has important tables. You are asked to recover all the objects in the schema. On investigation， you find that the user account was dropped at 11：00 a.m. and Sunday’s backup is the most recent backup. Which flashback feature would you use？（）A
Flashback DropB
Flashback TableC
Flashback DatabaseD
Flashback Version QueryE
Flashback Transaction Query
考题
多选题Which statements are correct about temporary tables（）AIndexes and views can be created on temporary tables.BBoth the data and the structure of temporary tables can be exported.CTemporary tables are always created in a user’s temporary tablespace.DThe data inserted into a temporary table in a session is available to other sessions.EData manipulation language （DML） locks are never acquired on the data of temporary tables
考题
多选题You need to improve the performance of the tempdb database on SQL1.Which two actions should you perform？（）AMove tempdb onto a faster disk volume.BIncrease the initial size of tempdb to 1.5 GBCIncrease the size of the data files in the Tracking database.DDecrease the file growth increment for tempdb to 25 MBEUse more local temporary tables and fewer global temporary tables in the Tracking database.
考题
多选题Consider the events_% tables in performance Schema. Which two methods will clear or reset the collected events in the tables?（）AUsing DELETE statements, for example, DELETE FROM performance_schema.events_watis_currentBUsing the statement RESET PERFORMANCE CACHECUsing the statement FLUSH PERFORMANCE CACHEDUsing TRUNCATE statements, for example, TRUNATE TABLE performance_schema.events_waits_currentEDisabling and re-enabling all instrumentsFRestarting Mysql
考题
单选题A university researcher needs a large server with high numeric computing capacity to do computational fluid dynamics calculations. The pSeries technical specialist has a recent pSeries and RS/6000 Performance Report. Which of the following tables should be consulted to advise the customer concerning relative performance of various models？（）A
rPerfB
ROLTPC
SPECfpD
SPECint
考题
单选题You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. The instance contains a database named DB1. An application which is continuously connected uses DB1. The application extensively uses the INSERT command and triggers the population of multiple tables. Now you notice that the application has a poor performance. You doubt that this problem has something to do with blocking. You have to monitor the state of the instance at regular intervals while not affecting the application performance further. Which tool should you use? （）A
You should use Dynamic Management Views B
You should use SQL Server Resource Governor C
You should use SQL Server Profiler D
You should use Windows System Monitor
考题
单选题Which statement is true about the forwarding plane?（）A
It uses ASICs for increased performance.B
It is the intelligence of the platform.C
It maintains the routing tables.D
It is based on an x86 architecture.
考题
单选题The datum from which the predicted heights of tides are reckoned in the tide tables is（）.A
mean low waterB
the same as that used for the charts of the localityC
the highest possible levelD
given in table three of the tide tables
热门标签
最新试卷
