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 14Select one:
A.
RUNSTATS TABLESPACE DB.TS REPORT NO UPDATE ACCESSPATH
B.
RUNSTATS TABLESPACE DB.TS RESET ACCESSPATH
C.
RUNSTATS TABLESPACE DB.TS INVALIDATECACHE(NO)
D.
RUNSTATS TABLESPACE DB.TS REPORT NO UPDATE SPACE

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:

The Al-Li phase diagram is shown in Figure 11-28. (a) Are any inter metallic compounds present? If so, identify them and determine whether they are stoichiometric or nonstoichiometric. Determine the...

Q:

Repeat parts (a) and (b) in Problem 1 assuming Beckett has a tax rate of 35 percent. In problem a. Calculate earnings per share, EPS, under each of the three economic scenarios before any debt is...

Q:

CALCET 8 7 . 7 . 0 2 1 . ( a ) Find the approximations T 1 0 , M 1 0 , and S 1 0 for 0 3 3 I s i n ( x ) d x . ( Round your answers to six decimal places. ) T 1 0 = M 1 0 = S 1 0 = Find the...

Q:

Non - ionizing radiation and Ionizing radiation are different because: Ionizing radiation causes cancer immediately while non - ionizing causes cancer over long periods of time Ionizing radiation...

Q:

Since the test for implementing a policy is only applicable to unionized work environments, do you think personal appearance ought to be a prohibited ground in human rights legislation? Why or why...

Q:

Your best friend has recently been appointed a shop steward of their work unit. You know the friends manager and feel the manager has always been fair in dealing with staff. What advice might you...

Q:

Sam Wong has decided to file a grievance with the shop steward, alleging that he was not promoted and a more junior (in seniority) employee was. Describe the steps in the grievance process and what...