Which statements are true regarding the Query Result Cache? () A. It can be set at the system, session, or table level.B. It is used only across statements in the same session.C. It can store the results from normal as well as flashback queries.D. It can store the results of queries based on normal, temporary, and dictionary tables.
Which statements are true regarding the Query Result Cache? ()
A. It can be set at the system, session, or table level.
B. It is used only across statements in the same session.
C. It can store the results from normal as well as flashback queries.
D. It can store the results of queries based on normal, temporary, and dictionary tables.
相关考题：
以下程序booleana=false;booleanb=true;ooleanc=(abintresult=c==false?1:2;执行完后,c与result的值是()。 A.c=false;result=1;B.c=true;result=2;C.c=true;result=1;D.c=false;result=2;
You have applications that have frequently executed queries, and produce small and static result sets.You configure the sqlnet.ora file in the client machine to set a nonzero value for the OCI_RESULT_CACHE_MAX_SIZE parameter. What is the purpose of this configuration?（）A. to avoid round trips to the server by enabling caching of query results in client memoryB. to improve performance by storing a copy of the data from the private SQL area of the PGAC. to enhance the query performance by creating a cache in the client memory for sorting operationsD. to avoid the storing of query plans and results in the server by creating a cache in the client memory
Inyourdatabase，theRESULT_CACHE_MODEparameterhasbeensettoMANUALintheinitializationparameterfile.Youissuedthefollowingcommand：SQLSELECT/*+RESULT_CACHE*/sale_category，sum（sale_amt）FROMsalesGROUPBYsale_category；Wherewouldtheresultofthisquerybestored（）？A.databasebuffercacheB.sharedpoolC.PGAD.largepool
boolean a=false;boolean b=true;boolean c=(ab)(!b);boolean result=(ab)(!b)； boolean result=(ab)(!b)； 执行完后，正确的结果是( )。A．c=false；result=falseB．c=true,result=trueC．c=true；result=falseD．c=false；result=true
下面程序段： boolean a=false； boolean b=true； boolean c=(a||b)(b)； boolean result=(a|b)(b)； 执行完后，正确的结果是A．c=false；result=falseB．c=true,result=trueC．c=true；result=falseD．c=false；result=true
下面程序段： boolean a=false; boolean b=true; boolean c=(aB) (!B) ; boolean result=(aB) (!B) ; 执行完后，正确的结果是( )。A．c=false;result=falseB．c=true,result=trueC．c=tree;result=falseD．c=false;result=trae
下面程序段：boolean a=false；boolean b=true；boolean c=(ab)(!b)；boolean result=(ab)(!b)；执行完后，正确的结果是A．c=false；result=falseB．c=true,result=trueC．c=true；result=falseD．c=false；result=true
下面程序段； boolean a=false； boolean b=true； boolean c=(a||b)(b); boolean result=(a|b)(b); 执行完后，正确的结果是A．c=false；result=falseB．c=true；result=trueC．c=true；result=falseD．c=false；result=true
1、定义变量d1为布尔型，并赋初值为“true”,写出代码_________ 2、请写出程序运行的输出结果：_______ int a=3; int b=9; int result=0; result=a＞b？a-b:b-a; Console.WriteLine（result);
4、请为下列程序写注释，并写出程序运行的结果。 bool a = true; int b = 30; bool result=a（b＞50？true :false); result = !result; Console.WriteLine（result);