在Internet中,目前使用的IP地址采用()位二进制代码。
A.16
B.32
C.64
D.128
第1题
A. The procedure may be used for some components to relocate component data to the SYSAUX tablespace from its current tablespace.
B. The procedure may be used for some components to relocate component data from the SYSAUX tablespace to another tablespace.
C. All the components may be moved into SYSAUX tablespace.
D. All the components may be moved from the SYSAUX tablespace.
第2题
A.Thenestedqueryexecutesaftertheouterqueryreturnstherow.
B.Thenestedqueryexecutesfirstandthentheouterqueryexecutes.
C.Theouterqueryexecutesonlyoncefortheresultreturnedbytheinnerquery.
D.Eachrowreturnedbytheouterqueryisevaluatedfortheresultsreturnedbytheinnerquery.
第3题
A.TheOraclekernelwillbeplacedinthislocation.
B.TheOraclesoftwarewillbeplacedinthislocation.
C.Theserverparameterfile(SPFILE)willbeplacedinthislocation.
D.Thedatabasefileswillbeplacedinthislocation,ifnotspecifiedexplicitly.
E.ThelocationwillbeconsideredforthebaseofOracleManagedFiles(OMF).
F.ThelocationwillbeconsideredforthebaseofOptimalFlexibleArchitecture(OFA).
第4题
A.ThestatementwouldnotexecutebecausetablealiasesarenotallowedintheJOINclause.
B.ThestatementwouldnotexecutebecausethetablealiasprefixisnotusedintheUSINGclause.
C.ThestatementwouldnotexecutebecauseallthecolumnsintheSELECTclausearenotprefixedwithtablealiases.
D.ThestatementwouldnotexecutebecausethecolumnpartoftheUSINGclausecannothaveaqualifierintheSELECTlist.
第5题
A.SELECT last_name, manager_id, department_name FROM employees e FULL OUTER JOIN departments d ON (e.department_id = d.department_id);
B.SELECT e.last_name, m.last_name, department_name FROM employees e LEFT OUTER JOIN employees m on ( e.manager_id = m.employee_id) LEFT OUTER JOIN departments d ON (e.department_id = d.department_id);
C.SELECT e.last_name, m.last_name, department_name FROM employees e RIGHT OUTER JOIN employees m on ( e.manager_id = m.employee_id) LEFT OUTER JOIN departments d ON (e.department_id = d.department_id);
D.SELECT e.last_name, m.last_name, department_name FROM employees e LEFT OUTER JOIN employees m on ( e.manager_id = m.employee_id) RIGHT OUTER JOIN departments d ON (e.department_id = d.department_id);
E.SELECT e.last_name, m.last_name, department_name FROM employees e RIGHT OUTER JOIN employees m on ( e.manager_id = m.employee_id) RIGHT OUTER JOIN departments d ON (e.department_id = d.department_id);
F.SELECT last_name, manager_id, department_name FROM employees e JOIN departments d ON (e.department_id = d.department_id) ;
第6题
A. All the triggers for the table are disabled without changing any of the column names or column types in the table.
B. The primary key constraint on the EMPLOYEES table is disabled during redefinition.
C. VPD policies are copied from the original table to the new table during online redefinition.
D. You must copy the VPD policies manually from the original table to the new table during online redefinition.
第7题
A.AssigntheDEFAULTprofiletotheusers
B.SettheRESOURCE_LIMITparametertoTRUEintheparameterfile
C.CreateanewprofilewithCPUrestrictionsandassignittotheusers
D.SpecifytheusersasmembersoftheDEFAULT_CONSUMER_GROUP
E.RevoketheDBAroleandgrantCONNECTandRESOURCEroletotheusers
第8题
A.Undodatabecomesobsoleteafter1,000seconds.
B.Undodatagetsrefreshedafter1,000seconds.
C.Undodatawillbestoredpermanentlyafter1,000seconds.
D.Committedundodatawouldberetainedfor1,000secondsiffreeundospaceisavailable.
E.UndodatawillberetainedintheUNDOtablespacefor1,000seconds,thenitgetsmovedmovedtotheTEMPORARYtablespacetoprovidereadconsistency.
第9题
A.Untillastcommit
B.Untilthetimeyouperformrecovery
C.Untilthetimethedatefilegotcorrupted
D.Untilthepointwherethelasttransactionbegun
E.YoucannotrecovertheSYSTEMtablespaceandmustre-createthedatabase.
第10题
A.dropandre-createtheread-onlytablespaces
B.renametheread-onlydatafilestotheircorrectfilenames
C.changethetablespacestatusfromread/writetoread-only
D.re-createtheread-onlytablespacebecauseitisautomaticallyremoved
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!