Oracle认证考试

Which three statements describe how the strict SQL mode provides added security?（）A、It rejects statements that try to insert out-of-range valuesB、It rejects invalid datesC、It limits the operations that the server can performD、It rejects queries that produ

题目

Which three statements describe how the strict SQL mode provides added security?（）

  • A、It rejects statements that try to insert out-of-range values
  • B、It rejects invalid dates
  • C、It limits the operations that the server can perform
  • D、It rejects queries that produce out-of-range values
  • E、It rejects dates with zero day or month values
参考答案和解析
正确答案:A,B,E
如果没有搜索结果，请直接 联系老师 获取答案。
相似问题和答案

第1题：

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.


参考答案：A, C

第2题：

Which three statements describe how the strict SQL mode provides added security?()

A.It rejects statements that try to insert out-of-range values

B.It rejects invalid dates

C.It limits the operations that the server can perform

D.It rejects queries that produce out-of-range values

E.It rejects dates with zero day or month values


参考答案：A, B, E

第3题：

Markets are the system that ()some people’s demands and some other people’s supplies.

A、meets

B、bridges

C、rejects


参考答案：B

第4题：

While deploying a new application module, the software vendor ships the application software along with appropriate SQL plan baselines for the new SQLs being introduced. Which two statements describe the consequences?（）

  • A、The plan baselines can be evolved over time to produce better performance.
  • B、The newly generated plans are directly placed into the SQL plan baseline without being verified.
  • C、The new SQL statements initially run with the plans that are known to produce good performance under standard test configuration.
  • D、The optimizer does not generate new plans for the SQL statements for which the SQL plan baseline has been imported.

正确答案:A,C

第5题：

Which two statements describe the behavior of the server's SQL mode?（）

  • A、The server's SQL mode determines how the server should behave when performing data validation check and interpreting different forms of syntax
  • B、The server's SQL mode determines whether the server should be read-only or should accept commands such as INSERT and UPDATE
  • C、The server's SQL mode can be changed at the session level with a SET SESSION sql_mode="new_value" command
  • D、The server's SQL mode, when globally set on a slave server, applies to events sent from the master

正确答案:A,C

第6题：

Which three statements about performance analysis by SQL Performance Analyzer are true? ()(Choose three.)

A. It detects changes in SQL execution plans.

B. It produces results that can be used to create the SQL plan baseline.

C. The importance of SQL statements is based on the size of the objects accessed.

D. It generates recommendations to run SQL Tuning Advisor to tune regressed SQLs.

E. It shows only the overall impact on workload and not the net SQL impact on workload.


参考答案：A, B, D

第7题：

Which two statements correctly describe VTP？（）

  • A、Transparent mode always has a configuration revision number of 0.
  • B、Transparent mode cannot modify a VLAN database.
  • C、Client mode cannot forward received VTP advertisements.
  • D、Client mode synchronizes its VLAN database from VTP advertisements.
  • E、Server mode can synchronize across VTP domains.

正确答案:A,D

第8题：

YouaredevelopingaWebpage.Theusertypesacreditcardnumberintoaninputcontrolnamedccandclicksabuttonnamedsubmit.Thesubmitbuttonsendsthecreditcardnumbertotheserver.AJavaScriptlibraryincludesaCheckCreditCardfunctionthatreturnsavalueoftrueifthecreditcardappearstobevalid,basedonitschecksum.Youneedtoensurethattheformcannotbeusedtosubmitinvalidcreditcardnumberstotheserver.Whatshouldyoudo?（）

A.Configuretheinputcontroltorunontheserver.Onthesubmitbutton，addaserver-sideOnClickhandlerthatcallsCheckCreditCard and rejects the form submissioniftheinputisinvalid.

B.Ontheinputcontrol，addanonChangehandlerthatcallsCheckCreditCardandcancelstheformsubmissionwhenthe input is invalid.

C.Configuretheinputcontrolandthesubmitbuttontorunontheserver.Addasubmit_OnClickhandlerthatcallsCheckCreditCard and rejects the form submission if theinputisinvalid.

D.Ontheform，addanonSubmithandlerthatcallsCheckCreditCardandcancelstheformsubmissioniftheinput is invalid.


参考答案：D

第9题：

You are developing a Web page. The user types a credit card number into an input control named cc and clicks a button named submit. The submit button sends the credit card number to the server. A JavaScript library includes a CheckCreditCard function that returns a value of true if the credit card appears to be valid, based on its checksum. You need to ensure that the form cannot be used to submit invalid credit card numbers to the server. What should you do?（）

  • A、Configure the input control to run on the server. On the submit button， add a server-side OnClick handler that calls CheckCreditCard  and  rejects  the form submission if the input is invalid.
  • B、On the input control，add an onChange handler that calls CheckCreditCard and cancels the form submission when the  input  is invalid.
  • C、Configure the input control and the submit button to run on the server. Add a submit_OnClick handler that calls CheckCreditCard  and  rejects  the  form  submission  if  the input is invalid.
  • D、On the form， add an onSubmit handler that calls CheckCreditCard and cancels the form submission if the input  is invalid.

正确答案:D

第10题：

Which three statements are valid SDM configuration wizards？ （）

  • A、NAT
  • B、VPN
  • C、STP
  • D、Security Audit

正确答案:A,B,D

更多相关问题
相关内容