Question: A DBA wants to invalidate the dynamic statement cache for dynamic SQL statements which are referencing the object DB . TS . Which of the

A DBA wants to invalidate the dynamic statement cache for dynamic SQL statements which are referencing the object DB.TS. Which of the following RUNSTATS control cards will do this invalidation?
Question 20Select one:
A.
RUNSTATS TABLESPACE DB.TS RESET ACCESSPATH
B.
RUNSTATS TABLESPACE DB.TS REPORT NO UPDATE SPACE
C.
RUNSTATS TABLESPACE DB.TS REPORT NO UPDATE ACCESSPATH
D.
RUNSTATS TABLESPACE DB.TS INVALIDATECACHE(NO)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

A DBA wants to invalidate the dynamic statement cache for dynamic SQL statements which are referencing the object DB . TS . Which of the following RUNSTATS control cards will do this invalidation?...

Q:

Database Administration CHAPTER OBJECTIVES I Understand the need for and importance of database I ttno'illI the meaning of ACID transaction administralin - Learn the tour 1992 ANSI standard isolation...

Q:

You have been provided with the description of a programming language, J, intended for scripting applications. Its syntax is similar to a cut-down version of Java in that it consists of function...

Q:

44. Attorney Joe told his client Tasha to sign over her real estate to him because of a tax benefit. Trusting him, she does so. Later she wants to invalidate that contract once she learns that the...

Q:

a) Explain how a Domain Name Server (DNS) cache poisoning can be initiated by a network hacker. Propose a method that can mitigate or eliminate such an attack. (7 marks) b) Discuss TWO (2) suitable...

Q:

A DBA wants to convert a segmented table space into a partition - by - growth table space. The DBA executes the following ALTER statement: ALTER TABLESPACE DB 1 . TS 1 MAXPARTITIONS 5 ; What is the...

Q:

A DBA wants to convert a segmented table space into a partition - by - growth table space. The DBA executes the following ALTER statement: ALTER TABLESPACE DB 1 . TS 1 MAXPARTITIONS 5 ; What is the...

Q:

Audit and trial are used to manage the history of all relevant data that a DBA wants to audit because this data is most critical. Suppose we have to write an FGA on the budget table. DBA wants to...

Q:

1 . 0 p 3 Consider a database with the following relational schema: Person ( id , name, address, city, gender ) The role Job has no privileges on the database. The DBA wants Job to have the following...

Q:

A DBA's most frequent day to day activity? ( 1 Point ) * Migration Upgrade Database refresh Deployment and disaster recovery A DBA wants to restore a backup file to a different server with different...

Q:

1. Describe the capital budgeting steps that would be necessary to determine whether this proposed project is feasible, as related to this specific situation. 2. Explain why there is uncertainty...

Q:

The manufacturer of Boston and Vermont asphalt shingles provides its customers with a 20year warranty on most of its products. To determine whether a shingle will last the entire warranty period,...

Q:

Which of these must be greater than or equal to - 1 AND less than or equal to 1 ? correlation variance volatility covariance

Q:

Calculate the minimum and maximum takt time for the given

Q:

3. Design a checklist for carrying out a safety inspection in the workplace. Use your checklist to actually carry out an inspection of a designated area either at work or in your college. Write a...

Q:

explain the terms used for companies which operate on an international basis such as international, multinational and global enterprise

Q:

5. Imagine that you are a consultant employed to select a job evaluation scheme for an organisation that employs 500 employees in a large range of clerical jobs. Write a report to the human resource...