Bissoy.com
Doctors Medicines MCQs Q&A

What is the syntax for DBCC FREEPROCCACHE with all the optional parameters in T-SQL? b) DBCC FREEPROCCACHE c) DBCC FREEPROCCACHE d) None of the mentioned

What is the syntax for DBCC FREEPROCCACHE with all the optional parameters in T-SQL? b) DBCC FREEPROCCACHE c) DBCC FREEPROCCACHE d) None of the mentioned Correct Answer ( { plan_handle | sql_handle | pool_name } )

DBCC FREEPROCCACHE removes all elements from the plan cache, removes a specific plan from the plan cache by specifying a plan handle or SQL handle, or removes all cache entries associated with a specified resource pool.

Related Questions

How is 'No' coded in the code language ? Statements : I. 'Ne Pa Sic Lo' means 'But No None And' and 'Pa Lo Le Ne' means 'If None And But'. II. 'Le Se Ne Sic' means 'If No None Will' and 'Le Pi Se Be' means 'Not None If All'.
Question : How is 'No' coded in the code language ?

Statements :
I. 'Ne Pa Sic Lo' means 'But No None And' and 'Pa Lo Le Ne' means 'If None And But'.
II. 'Le Se Ne Sic' means 'If No None Will' and 'Le Pi Se Be' means 'Not None If All'.
What is the difference between %e and %g? m.dddddd or m.dddddExx where no.of ds are optional b) %e always formats in the format m.dddddd or m.dddddExx where no.of ds are optional and output formatting depends on the argument c) No differences d) Depends on the standard
Nine individuals - Z, Y, X, W, V, U, T, S and R - are the only candidates, who can serve on three committees-K1, K2 and K3, and each candidate should serve on exactly one of the committees. Committee K1 should consist of exactly one member more than committee K2. It is possible that there are no members in committee K3. Among Z, Y and X none can serve on committee 10. Among W, V and U none can serve on committee K2. Among T, S and R none can serve on committee K3. In case committee K2 is served by T and Z only, how many of the nine individuals should serve on committee K3?  Of the nine individuals, the largest number that can serve together on committee K3 is:
Nine individuals - Z, Y, X, W, V, U, T, S and R - are the only candidates, who can serve on three committees-K1, K2 and K3, and each candidate should serve on exactly one of the committees. Committee K1 should consist of exactly one member more than committee K2. It is possible that there are no members in committee K3. Among Z, Y and X none can serve on committee 10. Among W, V and U none can serve on committee K2. Among T, S and R none can serve on committee K3. In case committee K2 is served by T and Z only, how many of the nine individuals should serve on committee K3? 
What is the correct syntax to declare a function foo() which receives an array of structure in function? ); c) void foo(struct var); d) none of the mentioned
What is the correct syntax of open() function? ) b) file object = open(file_name ) c) file object = open(file_name) d) none of the mentioned
Syntax for creating database snapshot in SQL Server is _______________ ; b) DELETE DATABASE ; c) DROP Snapshot ; d) None of the mentioned
Which of the following is syntax for sp_add_collector_type procedure? ‘collector_type_uid’ b) core.sp_add_collector_type . c) core.sp_add_collector_type ‘collector_type_uid’ d) none of the mentioned
Study the following information carefully and answer the following questions. Dhawan plans to buy a flat at Shyamla Society. Shyamala Society has placed the following conditions for allotment of flats in its society: Applicant: (I). State domicile certificate must be submitted. (II). Must have done a job of at least 5 years. (III). If needed, he will be ready to pay the entire amount in 5 years. (IV). Should not be the owner or co-owner (if spouse) of the residential facility in that city (V). Should not be below 35 years of age as on 31 December 2016.   In the case of the applicant who fulfils all other criteria except: A) (I) As mentioned above, should be referred to the chairman of the city council. B) (II) As mentioned above, prepared to provide Aadhaar card. To be referred to the vice-chairman of the committee C) (III) As mentioned above, but a freedom fighter or ex-soldier or the first relationship with these should be referred to a member of the committee. The last date for receipt of applications was 31 December 2016. The conditions of 31 December 2016 are to be met. Based on these criteria, decide whether you have to allot the flat in the following case given on 1 January 2017. Dhawan is an industrialist and from another state who established his factory in 2000 and has a state residence certificate. He is ready to pay the full amount in 4 years if necessary. He does not have a house in that city but his wife has a flat. His date of birth is 11 November 1970.