Examinethecommand:SQLDBMS_STATS.SET_TABLE_PREFS(’SH’,’CUSTOMERS’,’PUBLISH’,’false’);Whichstatementdescribestheeffectoftheabovecommand() A.AutomaticstatisticscollectionisstoppedfortheCUSTOMERStable.B.StatisticsfortheCUSTOMERStablearelockedandcannotbeoverwritten.C.ExistingstatisticsfortheCUSTOMERStablebecomeunusableforthequeryoptimizer.D.Subsequently，statisticsgatheredontheCUSTOMERStablearestoredaspendingstatistics
Examinethecommand:SQL>DBMS_STATS.SET_TABLE_PREFS(’SH’,’CUSTOMERS’,’PUBLISH’,’false’);Whichstatementdescribestheeffectoftheabovecommand()
A.AutomaticstatisticscollectionisstoppedfortheCUSTOMERStable.
B.StatisticsfortheCUSTOMERStablearelockedandcannotbeoverwritten.
C.ExistingstatisticsfortheCUSTOMERStablebecomeunusableforthequeryoptimizer.
D.Subsequently，statisticsgatheredontheCUSTOMERStablearestoredaspendingstatistics
相关考题：
下面程序段的输出结果为( )。 pubUCClassTeS { public static voidmain(StringargS[]) { booleaha,b，c； a=(3＜5)； b=(a==tme)； System.Out.phntln("a="+a+"b="+b)； c=(b==false)； SyStem.out.println("b="+b+"C="+c)； } }A．a=tme b=falSeB．a=true b=false b=true c=false b=true C=tmeC．a=true b=trueD．a=falSe b=false b=true c=falSe b=tme c=falSe
（ 12 ）下列布尔变量定义中，正确并且规范的是A )BOOLEAN canceled = false;B)boolean canceled = false;C)boolean CANCELED = false;D)boolean canceled = FALSE;
Principles of Marketing Marketing is the part of your business where money is made. In order to succeed in business, the following two principles of marketing should be kept in mind. First, customers are the mainstay of any business. Attracting customers to a business makes the difference between succeeding and failing. Therefore, the business needs to direct all activities towards satisfying the customers’ needs. If customers are satisfied, there is a chance that they will be retained for a long time and possibly permanently. Undoubtedly they are likely to talk to other potential customers. Another principle for a business is that profitable sales volume is more important than maximum sales volume. The profitable sales volume is the volume of sales that actually will earn a business the most profit. And the maximum sales volume simply refers to the biggest sum of retail sales. Since the aim of most businesses is to make as much profit as possible, businesses value profits more than the volume of sales. A large volume of sales may result in a low profit margin, therefore, it is important for marketers to focus on their profitable sales volume. Decide if each of the following statement is TRUE (T) or FALSE (F).1. In order to succeed in business, three principles of marketing should be kept in mind.()2. If customers are satisfied, they will be likely to encourage more people to buy the products or services.()3. The profitable sales volume is the volume of sales that will bring a business profit.()4. The maximum sales volume refers to the biggest sum of retail sales.()5. Profitable sales volume is as important as the maximum sales volume.()
下面哪个函数可以返回逻辑值TRUE()。 A、AND(TRUE，TRUE，FALSE)B、OR(TRUE，TRUE，FALSE)C、OR(FALSE，FALSE，FALSE)D、NOT(TRUE)
You executed the following commands:Which statement is correct regarding the above statistics collection on the SH.CUSTOMERS table in the above session?() A. The statistics are stored in the pending statistics table in the data dictionary.B. The statistics are treated as the current statistics by the optimizer for all sessions.C. The statistics are treated as the current statistics by the optimizer for the current sessions only.D. The statistics are temporary and used by the optimizer for all sessions until this session terminates.
Examine the following command that is executed for the TRANSPORT table in the SH schema:Which statement describes the significance of this command?() A. It collects statistics into the pending area in the data dictionaryB. It creates a virtual hidden column in the CUSTOMERS_OBE tableC. It collects statistics with AUTO_SAMPLE_SIZE for ESTIMATE_PERCENTD. It creates a histogram to hold skewed information about the data in the columns
Examinethecommand:SQL>ALTERUSERskdACCOUNTLOCK;Whichtwostatementsaretrueafterthecommandisexecuted() A.TheSKDusercannotlogintothedatabaseinstance.B.TheobjectsownedbytheSKDuserarenotaccessibletoanyuser.C.TheotheruserscanaccesstheobjectsownedbytheSKDuser，onwhichtheyhaveaccess.D.ThepasswordfortheSKDuserexpiresandtheuserisforcedtochangethepasswordatthenextlogin
Youexecutedthefollowingcommands：SQLALTERSESSIONSETOPTIMIZER_USE_PENDING_STATISTICS=false；SQLEXECUTEDBMS_STATS.SET_TABLE_PREFS（’SH’，’CUSTOMERS’，’PUBLISH’，’false’）；SQLEXECUTEDBMS_STATS.GATHER_TABLE_STATS（’SH’，’CUSTOMERS’）；WhichstatementiscorrectregardingtheabovestatisticscollectionontheSH.CUSTOMERStableintheabovesession？（）A.Thestatisticsarestoredinthependingstatisticstableinthedatadictionary.B.Thestatisticsaretreatedasthecurrentstatisticsbytheoptimizerforallsessions.C.Thestatisticsaretreatedasthecurrentstatisticsbytheoptimizerforthecurrentsessionsonly.D.Thestatisticsaretemporaryandusedbytheoptimizerforallsessionsuntilthissessionterminates.
Examine this command:SQL exec DBMS_STATS.SET_TABLE_PREFS (‘SH’, ‘CUSTOMERS’, ‘PUBLISH’, ‘false’);Which three statements are true about the effect of this command?() A. Statistics collection is not done for the CUSTOMERS table when schema stats are gathered.B. Statistics collection is not done for the CUSTOMERS table when database stats are gathered.C. Any existing statistics for the CUSTOMERS table are still available to the optimizer at parse time.D. Statistics gathered on the CUSTOMERS table when schema stats are gathered are stored as pending statistics.E. Statistics gathered on the CUSTOMERS table when database stats are gathered are stored as pending statistics.
下列布尔变量定义中，正确并且规范的是A．BOOLEANcanceled=false；B．booleancanceled=false；C．booleanCANCELED=false；D．booleancanceled=FALSE；
下面程序段的输出结果为（ ）。A.a＝true b＝false b＝true C＝trueB.a＝true b＝false b＝true e＝falseC.a＝true b＝true b＝true C＝falseD.a＝false b＝false b＝true C＝false
为使标题栏上的这两个按钮消失，而保留其他按钮，没置窗体属性时，正确的是A．ControlBox=True、MaxButton=False、MinButton=TrueB．ControlBox=False、MaxButton=True、MinButton=TrueC．ControlBox=True、MaxButton=False、MinButton=FalseD．ControlBox=False、MaxButton=False、MinButton=False
下列布尔变量定义中，正确并且规范的是A．BOOLEAN canceled=false；B．boolean canceled=false；C．boolean CANCELED=false；D．boolean canceled=FALSE；
下列选项中,哪个是程序的运行结果class Test{public static void main(String[] args) {int a = 3;int b = 6;System.out.print(a==b);System.out.print(aSystem.out.print(a!=b);System.out.print(a>=b);}} A.false false true falseB.false false true trueC.false true true falseD.true false false true
Examinethecommand:ALTERDATABASEADDSUPPLEMENTALLOGDATA(PRIMARYKEY)COLUMNS;Whatdoesthecommandaccomplish?() A.Createsanadditionalcopyofthedatabaseonlineredologfiles.B.StorestheprimarykeycolumnvaluesofeachrowinvolvedinaDMLoperationintheonlineredologfiles.C.StorestheprimarykeycolumnvaluesofeachrowinvolvedinaDMLoperationinthesupplementallogfiles.D.StorestheoldandnewprimarykeycolumnvaluesofeachrowinvolvedinaDMLoperationonlywhentheprimarykeyismodifiedintheonlineredologfiles.
创建一个名为‘Customers’的新表，同时要求新表中包含表‘clients’的所有记录，sql语句是（）。A、Select*into customers from clientsB、Select into customers from clientsC、Insert into customers select*from clientsD、Insert customers select*from clients
You executed the following commands： SQL ALTER SESSION SET OPTIMIZER_USE_PENDING_STATISTICS = false； SQL EXECUTE DBMS_STATS.SET_TABLE_PREFS（’SH’， ’CUSTOMERS’， ’PUBLISH’，’false’）； SQL EXECUTE DBMS_STATS.GATHER_TABLE_STATS（’SH’， ’CUSTOMERS’）； Which statement is correct regarding the above statistics collection on the SH.CUSTOMERS table in the above session？（）A、 The statistics are stored in the pending statistics table in the data dictionary.B、 The statistics are treated as the current statistics by the optimizer for all sessions.C、 The statistics are treated as the current statistics by the optimizer for the current sessions only.D、 The statistics are temporary and used by the optimizer for all sessions until this session terminates.
Which utility allows you to pre-compile and publish your Web site to a new location？（）A、Publish Web SiteB、Web-based installationC、Web site project modeD、Web services directory
单选题You executed the following commands： SQL ALTER SESSION SET OPTIMIZER_USE_PENDING_STATISTICS = false； SQL EXECUTE DBMS_STATS.SET_TABLE_PREFS（’SH’， ’CUSTOMERS’， ’PUBLISH’，’false’）； SQL EXECUTE DBMS_STATS.GATHER_TABLE_STATS（’SH’， ’CUSTOMERS’）； Which statement is correct regarding the above statistics collection on the SH.CUSTOMERS table in the above session？（）A The statistics are stored in the pending statistics table in the data dictionary.B The statistics are treated as the current statistics by the optimizer for all sessions.C The statistics are treated as the current statistics by the optimizer for the current sessions only.D The statistics are temporary and used by the optimizer for all sessions until this session terminates.
单选题You want to capture column group usage and gather extended statistics for better cardinality estimates for the CUSTOMERS table in the SH schema. Examine the following steps: 1. Issue the SELECT DBMS_STATS.CREATE_EXTENDED_STATS (‘SH’, ‘CUSTOMERS’) FROM dual statement. 2. Execute the DBMS_STATS.SEED_COL_USAGE (null, ‘SH’, 500) procedure. 3. Execute the required queries on the CUSTOMERS table. 4. Issue the SELECT DBMS_STATS.REPORT_COL_USAGE (‘SH’, ‘CUSTOMERS’) FROM dual statement. Identify the correct sequence of steps.（）A3，2，1，4B2，3，4，1C4，1，3，2D3，2，4，1
单选题Examine the command： SQL DBMS_STATS.SET_TABLE_PREFS（’SH’， ’CUSTOMERS’， ’PUBLISH’， ’false’）； Which statementdescribes the effect of the above command（）AAutomatic statistics collection is stopped for the CUSTOMERS table.BStatistics for the CUSTOMERS table are locked and cannot be overwritten.CExisting statistics for the CUSTOMERS table become unusable for the query optimizer.DSubsequently， statistics gathered on the CUSTOMERS table are stored as pending statistics
单选题You need to produce a report for mailing labels for all customers. The mailing label must have only the customer name and address. The CUSTOMERS table has these columns: Which SELECT statement accomplishes this task?（）A SELECT* FROM customers;B SELECT name, address FROM customers;C SELECT id, name, address, phone FROM customers;D SELECT cust_name, cust_address FROM customers;E SELECT cust_id, cust_name, cust_address, cust_phone FROM customers;
多选题Examine this command: SQL exec DBMS_STATS.SET_TABLE_PREFS (‘SH’, ‘CUSTOMERS’, ‘PUBLISH’, ‘false’); Which three statements are true about the effect of this command?（）AStatistics collection is not done for the CUSTOMERS table when schema stats are gathered.BStatistics collection is not done for the CUSTOMERS table when database stats are gathered.CAny existing statistics for the CUSTOMERS table are still available to the optimizer at parse time.DStatistics gathered on the CUSTOMERS table when schema stats are gathered are stored as pending statistics.EStatistics gathered on the CUSTOMERS table when database stats are gathered are stored as pending statistics.
单选题Examine the command： SQL DBMS_STATS.SET_TABLE_PREFS（’SH’， ’CUSTOMERS’， ’PUBLISH’， ’false’）； Which statement describes the effect of the above command（）AAutomatic statistics collection is stopped for the CUSTOMERS table.BStatistics for the CUSTOMERS table are locked and cannot be overwritten.CExisting statistics for the CUSTOMERS table become unusable for the query optimizer.DSubsequently， statistics gathered on the CUSTOMERS table are stored as pending statistics.