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
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
相关考题：
3．Why not_________your position?A． considering changingB． considering to changeC． consider changeD． consider changing
若要在基本表S中增加一列CN(课程名)，可用( )。A．ADD TABLES (CN CHAR (8))B．ADD TABLES ALTER (CN CHAR (8))C．ALTER TABLES ADD (CN CHAR (8))D．ALTTER TABLES ADD(CN CHAR (8))
Which describes the default behavior when you create a table? () A. The table is accessible to all users.B. Tables are created in the public schema.C. Tables are created in your schema.D. Tables are created in the DBA schema.E. You must specify the schema when the table is created.
What is necessary for your query on an existing view to execute successfully? () A. The underlying tables must have data.B. You need SELECT privileges on the view.C. The underlying tables must be in the same schema.D. You need SELECT privileges only on the underlying tables.
In which case would you use a FULL OUTER JOIN? () A. Both tables have NULL values.B. You want all unmatched data from one table.C. You want all matched data from both tables.D. You want all unmatched data from both tables.E. One of the tables has more data than the other.F. You want all matched and unmatched data from only one table.
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
You are the administrator of a database that contains 64 lookup tables. These tables store static data that should not change. However, users report that some of this data is being changed. You need to prevent users from modifying the data.You want to minimize changes to your security model and to your database applications. How should you modify the database?A．Create a filegroup named LOOKUP. Move the lookup tables to this filegroup. Select the read only check box for the filegroup.B．Create a database role named datamodifier. Grant SELECT permissions to the datamodifier role. Add all users to the role.C．Deny INSERT, UPDATE, and DELETE permissions for all users. Create stored procedures that modify data in all tables except lookup tables. Require users to modify data through these stored procedures.D．Create a view of the lookup tables. Use the view to allow users access to the lookup tables.
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
In which two cases would you use an outer join? （）A、The tables being joined have NOT NULL columns.B、The tables being joined have only matched data.C、The columns being joined have NULL values.D、The tables being joined have only unmatched data.E、The tables being joined have both matched and unmatched data.F、Only when the tables have a primary key-foreign key relationship.
What are two reasons to create synonyms?（）A、You have too many tables.B、Your tables are too long.C、Your tables have difficult names.D、You want to work on your own tables.E、You want to use another schema's tables.F、You have too many columns in your tables.
已知：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）；
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.
What is necessary for your query on an existing view to execute successfully?（）A、The underlying tables must have data.B、You need SELECT privileges on the view.C、The underlying tables must be in the same schema.D、You need SELECT privileges only on the underlying tables.
多选题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.
单选题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?（）ATemporary tables BIndex-organized tables CCluster tables DStandard Oracle tables
多选题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.
单选题You design a Business Intelligence （BI） solution by using SQL Server 2008. You plan to create a SQL Server 2008 Reporting Services （SSRS） solution. Developers generate random reports against a data source that contains 200 tables. Power users generate random reports against four of the 200 tables. You need to design a strategy for the SSRS solution to meet the following requirements： ·Uses minimum amount of development effort. ·Provides two sets of tables in SSRS to the developers group and the power users group. Which strategy should you use？（）A Create two Report Builder models.Include the four frequently used tables in the first model and all the tables in the second model.B Create a Report Builder model by using all the tables.Create a perspective within the model to use only the four frequently used tables.C Create a Report Builder model by using all the tables. Create two folders.Place the four frequently used tables in the first folder and the remaining tables in the second folder.D Create two Data Source Views.Include all the tables in one Data Source View and the four frequently used tables in the other Data Source View.Create two Report Builder models so that each model uses one of the Data Source Views.
多选题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
多选题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
多选题In which two cases would you use an outer join? （）AThe tables being joined have NOT NULL columns.BThe tables being joined have only matched data.CThe columns being joined have NULL values.DThe tables being joined have only unmatched data.EThe tables being joined have both matched and unmatched data.FOnly when the tables have a primary key-foreign key relationship.
单选题What is necessary for your query on an existing view to execute successfully?（）AThe underlying tables must have data.BYou need SELECT privileges on the view.CThe underlying tables must be in the same schema.DYou need SELECT privileges only on the underlying tables.
单选题To predict the actual depth of water using the Tide Tables，the number obtained from the Tide Tables is（）.Athe actual depthBadded to or subtracted from the charted depthCmultiplied by the charted depthDdivided by the charted depth
单选题In which case would you use a FULL OUTER JOIN? （）ABoth tables have NULL values.BYou want all unmatched data from one table.CYou want all matched data from both tables.DYou want all unmatched data from both tables.EOne of the tables has more data than the other.FYou want all matched and unmatched data from only one table.
多选题What are two reasons to create synonyms? （）AYou have too many tables.BYour tables are too long.CYour tables have difficult names.DYou want to work on your own tables.EYou want to use another schema's tables.FYou have too many columns in your tables.