以下设备中，只能作为输出设备的是（)。A．键盘B．打印机C．鼠标D．软盘驱动器

A. It acts as the listening endpoint for the Oracle database instance for all local and non-local user connections.

B. A single listener can service only one database instance and multiple remote client connections.

C. Service registration with the listener is performed by the process monitor (PMON) process of each database instance.

D. The listener.ora configuration file must be configured with one or more listening protocol addresses to allow remote users to connect to a database instance.

A.Itwouldbecreatedonlyifauniqueindexismanuallycreatedfirst.

B.Itwouldbecreatedandwoulduseanautomaticallycreateduniqueindex.

C.Itwouldbecreatedandwoulduseanautomaticallycreatednonuniqueindex.

D.Itwouldbecreatedandremainsinadisabledstatebecausenoindexisspecifiedinthecommand.

A.3hours

B.6months

C.untillastyear

D.untillastcommit

E.untilthepointwhentheundotablespacewasrefreshed

F.untilthedatabaseisshutdownandthememoryerased

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.

A.Thenestedqueryexecutesaftertheouterqueryreturnstherow.

B.Thenestedqueryexecutesfirstandthentheouterqueryexecutes.

C.Theouterqueryexecutesonlyoncefortheresultreturnedbytheinnerquery.

D.Eachrowreturnedbytheouterqueryisevaluatedfortheresultsreturnedbytheinnerquery.

A.TheOraclekernelwillbeplacedinthislocation.

B.TheOraclesoftwarewillbeplacedinthislocation.

C.Theserverparameterfile（SPFILE）willbeplacedinthislocation.

D.Thedatabasefileswillbeplacedinthislocation，ifnotspecifiedexplicitly.

E.ThelocationwillbeconsideredforthebaseofOracleManagedFiles（OMF）.

F.ThelocationwillbeconsideredforthebaseofOptimalFlexibleArchitecture（OFA）.

A.ThestatementwouldnotexecutebecausetablealiasesarenotallowedintheJOINclause.

B.ThestatementwouldnotexecutebecausethetablealiasprefixisnotusedintheUSINGclause.

C.ThestatementwouldnotexecutebecauseallthecolumnsintheSELECTclausearenotprefixedwithtablealiases.

D.ThestatementwouldnotexecutebecausethecolumnpartoftheUSINGclausecannothaveaqualifierintheSELECTlist.

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) ;

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.

A.AssigntheDEFAULTprofiletotheusers

B.SettheRESOURCE_LIMITparametertoTRUEintheparameterfile

C.CreateanewprofilewithCPUrestrictionsandassignittotheusers

D.SpecifytheusersasmembersoftheDEFAULT_CONSUMER_GROUP

E.RevoketheDBAroleandgrantCONNECTandRESOURCEroletotheusers