网友您好， 请在下方输入框内输入要搜索的题目：

题目内容 （请给出正确答案）

Youhaveexecutedthiscommandtochangethesizeofthedatabasebuffercache：SQL>ALTERSYSTEMSETDB_CACHE_SIZE=2516582；Systemaltered.Toverifythechangeinsize，youexecutedthiscommand：SQL>SHOWPARAMETERDB_CACHE_SIZENAMETYPEVALUE------------------------------------------------db_cache_sizebiginteger4194304Whyisthevaluesetto4194304andnotto2516582（）

A.Because4194304isthegranulesize

B.Because4194304isthestandardblocksize

C.Because4194304isthelargestnonstandardblocksizedefinedinthedatabase

D.Because4194304isthetotalsizeofdataalreadyavailableinthedatabasebuffercache

参考答案

更多 “ Youhaveexecutedthiscommandtochangethesizeofthedatabasebuffercache：SQL>ALTERSYSTEMSETDB_CACHE_SIZE=2516582；Systemaltered.Toverifythechangeinsize，youexecutedthiscommand：SQL>SHOWPARAMETERDB_CACHE_SIZENAMETYPEVALUE------------------------------------------------db_cache_sizebiginteger4194304Whyisthevaluesetto4194304andnotto2516582（）A.Because4194304isthegranulesizeB.Because4194304isthestandardblocksizeC.Because4194304isthelargestnonstandardblocksizedefinedinthedatabaseD.Because4194304isthetotalsizeofdataalreadyavailableinthedatabasebuffercache ” 相关考题
考题 ● 首先提出支持面向对象数据模型的SQL标准是 （62） 。（62）A. SQL86B. SQL89C. SQL92D. SQL99
查看答案
考题 Which statement correctly describes SQL and ／SQL*Plus? () A. Both SQL and /SQL*plus allow manipulation of values in the database.B. /SQL* Plus recognizes SQL satement and sends them to the server; SQL is the Oracle proprietary interface for executing SQL statements.C. /SQL* Plus language for communicating with the Oracle server to access data; SQL recognizes SQL statements and sends them to the server.D. /SQL manipulates data and table definition in the database; /SQL* Plus does not allow manipulation of values in the database.
查看答案
考题 Which two are attributes of ／SQL*Plus? () A. /SQL*Plus commands cannot be abbreviated.B. /SQL*Plus commands are accesses from a browser.C. /SQL*Plus commands are used to manipulate data in tables.D. /SQL*Plus commands manipulate table definitions in the database.E. /SQL*Plus is the Oracle proprietary interface for executing SQL statements.
查看答案
考题 Youhaveexecutedthiscommandtochangethesizeofthedatabasebuffercache：SQLALTERSYSTEMSETDB_CACHE_SIZE=2516582；Systemaltered.Toverifythechangeinsize，youexecutedthiscommand：SQLSHOWPARAMETERDB_CACHE_SIZENAMETYPEVALUE------------------------------------------------db_cache_sizebiginteger4194304（4M）Whyisthevaluesetto4194304andnotto2516582（）A.because4194304isthegranulesizeB.because4194304isthestandardblocksizeC.because4194304isthelargestnonstandardblocksizedefinedinthedatabaseD.because4194304isthetotalsizeofdataalreadyavailableinthedatabasebuffercache
查看答案
考题 首先提出支持面I甸对象数据模型的SQL标准是(62)。A．SQL86B．SQL89C．SQL92D．SQL99
查看答案
考题 首先提出支持面向对象数据模型的SQL标准是(37)。A．SQL86B．SQL89C．SQL92D．SQL99
查看答案
考题 我国制定的SQL国家标准(GB12911)，等效于国际标准的________。A．SQL89B．SQL92C．SQL3D．SQL2
查看答案
考题 下列关于PL／SQL的说法正确的是() A.PL/SQL是应用于各种数据库上的通用语言B.PL/SQL是过程化的SQL语言C.PL/SQL是只能在SQL*PLUS中运行D.在PL/SQL可以直接执行所有的SQL操作
查看答案
考题 T-SQL是SQL语言的方言，Oracle的PL/SQL不是SQL方言
查看答案
热门标签
最新试卷