多选题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 PERFORMA

题目
多选题
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

相似考题

1.在Visual FoxPro中，删除数据库表S的SQL命令是______。A．DROP TABLESB．DELETE TABLESC．DELETE TABLES.DBFD．ERASE TABLES

2.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

3.Examine the data in the EMPLOYEES and DEPARTMENTS tables:Also examine the SQL statements that create the EMPLOYEES and DEPARTMENTS tables:On the EMPLOYEES table, EMPLOYEE_ID is the primary key.MGR_ID is the ID of managers and refers to the EMPLOYEE_ID.DEPT_ID is foreign key to DEPARTMENT_ID column of the DEPARTMENTS table.On the DEPARTMENTS table, DEPARTMENT_ID is the primary key.Examine this DELETE statement:What happens when you execute the DELETE statement?（）A. Only the row with department ID 40 is deleted in the DEPARTMENTS table.B. The statement fails because there are child records in the EMPLOYEES table with department ID 40.C. The row with department ID 40 is deleted in the DEPARTMENTS table. Also the rows with employee IDs 110 and 106 are deleted from the EMPLOYEES table.D. The row with department ID 40 is deleted in the DEPARTMENTS table. Also the rows with employee IDs 106 and 110 and the employees working under employee 110 are deleted from the EMPLOYEES table.E. The row with department ID 40 is deleted in the DEPARTMENTS table. Also all the rows in the EMPLOYEES table are deleted.F. The statement fails because there are no columns specifies in the DELETE clause of the DELETE statement.

4.Examine the statement:GRANT select, insert, updateON student_gradesTO managerWITH GRANT OPTION;Which two are true?()A. MANAGER must be a role.B. It allows the MANAGER to pass the specified privileges on to other users.C. It allows the MANAGER to create tables that refer to the STUDENT_GRADES table.D. It allows the MANAGER to apply all DML statements on the STUDENT_GRADES table.E. It allows the MANAGER the ability to select from, insert into, and update the STUDENT_GRADES table.F. It allows the MANAGER the ability to select from, delete from, and update the STUDENT_GRADES table.

更多“多选题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 PERFORMA”相关问题

  • 第1题：

    There are two tables: students, and scores, in the mysql database (4.0+) exactly like this:

    SN | Name SN | Score

    ------------- -------------

    1 | Jerry 1 | 48

    ------------- -------------

    2 | Lily 2 | 50

    ------------- -------------

    3 | Roy

    -------------

    where the SN is the foreigh key. Write an SQL statement to delete all the names that have no score.


    正确答案：
     

  • 第2题：

    重新设置所有BGP连接的命令是什么()

    A. reset bgp group

    B. delete bgp group

    C. reset bgp all

    D. delete bgp all


    参考答案：C

  • 第3题：

    In which of the following situations should correlation names be used?（）

    • A、A table referenced in the FROM clause has no indexed column.
    • B、The table referenced in the FROM clause has more than 200 columns.
    • C、Two or more tables in the FROM clause have identical column names.
    • D、The FROM clause contains two or more tables in the SELECT statement.

    正确答案:C

  • 第4题：

    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

    正确答案:D,F

  • 第5题：

    Which two statements are true about the Automatic Workload Repository （AWR）（）

    • A、All AWR tables belong to the SYSTEM schema.
    • B、The AWR contains systemwide tracing and logging information.
    • C、The snapshots collected by the AWR are accessible through data dictionary views.
    • D、The snapshots collected by the AWR are used by self-tuning components in the database.

    正确答案:C,D

  • 第6题：

    Which two statements about views are true?（）

    • A、A view can be created as read only.
    • B、A view can be created as a join on two or more tables.
    • C、A view cannot have an ORDER BY clause in the SELECT statement.
    • D、A view cannot be created with a GROUP BY clause in the SELECT statement.
    • E、A view must have aliases defined for the column names in the SELECT statement.

    正确答案:A,B

  • 第7题：

    Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables: EMPLOYEES EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE NEW_EMPLOYEES EMPLOYEE_ID NUMBER Primary Key NAME VARCHAR2(60) Which DELETE statement is valid?（）

    • A、DELETE FROM employees WHERE employee_id = (SELECT employee_id FROM employees);
    • B、DELETE * FROM employees WHERE employee_id = (SELECT employee_id FROM new_employees);
    • C、DELETE FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE name ='Carrey');
    • D、DELETE * FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE last_name ='Carrey');

    正确答案:C

  • 第8题：

    多选题
    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


    正确答案： D,F
    解析： 暂无解析

  • 第9题：

    单选题
    已知：DataSet data=new DataSet（）；则删除数据集data中person数据表的第5行数据的方法为（）
    A

     data.Tables[person ].Rows[5].Delete（）；

    B

     data.Tables[person ].Rows.Delete（5）；

    C

     data.Tables[person ].Rows[4].Delete（）；

    D

     data.Tables[person ].Rows[].Delete（4）；


    正确答案： D
    解析： 暂无解析

  • 第10题：

    多选题
    Which two statements are true about the Automatic Workload Repository （AWR）（）
    A

    All AWR tables belong to the SYSTEM schema.

    B

    The AWR contains systemwide tracing and logging information.

    C

    The snapshots collected by the AWR are accessible through data dictionary views.

    D

    The snapshots collected by the AWR are used by self-tuning components in the database.


    正确答案： B,D
    解析： AWR 基础结构由两个主要部分组成：  • 一个内存中统计信息收集工具，Oracle Database 11g组件使用它来收集统计信息。出于性能方面的考虑，这些统计信息存储在内存中。可以通过动态性能(V$) 视图访问存储在内存中的统计信息。  • 代表该工具持久部分的AWR 快照。AWR 快照可以通过数据字典视图和EnterpriseManager Database Control 来访问。  它为内部Oracle 服务器组件提供服务来收集、处理、维护和使用性能统计信息，以便进行问题检测和自优化。 AWR 中包含数百个表，所有这些表均属于SYSMAN方案且存储在SYSAUX表空间中。

  • 第11题：

    多选题
    Which two are true regarding external tables？ （）
    A

    External tables can be updated.

    B

    External tables are read-only tables.

    C

    Indexes can be created on external tables.

    D

    Indexes cannot be created on external tables.


    正确答案： B,A
    解析： 暂无解析

  • 第12题：

    单选题
    In which of the following situations should correlation names be used?（）
    A

    A table referenced in the FROM clause has no indexed column.

    B

    The table referenced in the FROM clause has more than 200 columns.

    C

    Two or more tables in the FROM clause have identical column names.

    D

    The FROM clause contains two or more tables in the SELECT statement.


    正确答案： B
    解析： 暂无解析

  • 第13题：

    In which of the following situations should correlation names be used?()

    A.A table referenced in the FROM clause has no indexed column.

    B.The table referenced in the FROM clause has more than 200 columns.

    C.Two or more tables in the FROM clause have identical column names.

    D.The FROM clause contains two or more tables in the SELECT statement.


    参考答案：C

  • 第14题：

    Which two statements are true regarding the USING clause in table joins?（）

    • A、It can be used to join a maximum of three tables 
    • B、It can be used to restrict the number of columns used in a NATURAL join 
    • C、It can be used to access data from tables through equijoins as well as nonequijoins 
    • D、It can be used to join tables that have columns with the same name and compatible data types

    正确答案:B,D

  • 第15题：

    已知：DataSet data=new DataSet（）；则删除数据集data中person数据表的第5行数据的方法为（）

    • A、 data.Tables["person "].Rows[5].Delete（）；
    • B、 data.Tables["person "].Rows.Delete（5）；
    • C、 data.Tables["person "].Rows[4].Delete（）；
    • D、 data.Tables["person "].Rows[].Delete（4）；

    正确答案:C

  • 第16题：

    What is true about joining tables through an equijoin?（）

    • A、You can join a maximum of two tables through an equijoin.
    • B、You can join a maximum of two columns through an equijoin.
    • C、You specify an equijoin condition in the SELECT or FROM clauses of a SELECT statement.
    • D、To join two tables through an equijoin, the columns in the join condition must be primary key and foreign key columns.
    • E、You can join n tables (all having single column primary keys) in a SQL statement by specifying a minimum of n-1 join conditions.

    正确答案:E

  • 第17题：

    Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables: EMPLOYEES EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE NEW_EMPLOYEES EMPLOYEE_ID NUMBER Primary Key NAME VARCHAR2 (60) Which DELETE statement is valid?（）

    • A、DELETE FROM employees WHERE employee_id = (SELECT employee_id FROM employees);
    • B、DELETE * FROM employees WHERE employee_id = (SELECT employee_id FROM new_ employees);
    • C、DELETE FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE name = 'carrey');
    • D、DELETE * FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE name = 'carrey');

    正确答案:C

  • 第18题：

    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.

    正确答案:B

  • 第19题：

    单选题
    You have forgotten the root user account password. You decide to reset the password and execute the following: Shell＞ /etc/init.d/mysql stop Shell＞ /etc/init.d/mysql start – skip-grant tables Which additional argument makes this operation safer?（）
    A

    –skip-networking, to prohibit access from remote locations

    B

    –reset-grant-tables, to start the server with only the mysql database accessible

    C

    –read-only,to set all data to read-only except for super users

    D

    –old-passwords, to start Mysql to use the old password format while running without the grant tables


    正确答案： D
    解析： 暂无解析

  • 第20题：

    单选题
    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.


    正确答案： C
    解析： 暂无解析

  • 第21题：

    多选题
    Which two statements about views are true?（）
    A

    A view can be created as read only.

    B

    A view can be created as a join on two or more tables.

    C

    A view cannot have an ORDER BY clause in the SELECT statement.

    D

    A view cannot be created with a GROUP BY clause in the SELECT statement.

    E

    A view must have aliases defined for the column names in the SELECT statement.


    正确答案： D,E
    解析： 暂无解析

  • 第22题：

    多选题
    Examine the statement: GRANT select, insert, update ON student_grades TO manager WITH GRANT OPTION; Which two are true?（）
    A

    MANAGER must be a role.

    B

    It allows the MANAGER to pass the specified privileges on to other users.

    C

    It allows the MANAGER to create tables that refer to the STUDENT_GRADES table.

    D

    It allows the MANAGER to apply all DML statements on the STUDENT_GRADES table.

    E

    It allows the MANAGER the ability to select from, insert into, and update the STUDENT_GRADES table.

    F

    It allows the MANAGER the ability to select from, delete from, and update the STUDENT_GRADES table.


    正确答案： B,A
    解析： 暂无解析

  • 第23题：

    多选题
    Which two statements are true regarding routing tables?（）
    A

    The routing table is populated by the forwarding table.

    B

    Devices running the Junos OS can accommodate multiple routing tables.

    C

    Information learned from routing protocols is stored in the routing table.

    D

    The primary routing table for IPv4 unicast routes is inet.4.


    正确答案： A,C
    解析： 暂无解析

相关内容