当前位置:1Z0-007题库

问题:

[多选] Which two statements about subqueries are true? ()

A . A subquery should retrieve only one row.
B . A subquery can retrieve zero or more rows.
C . A subquery can be used only in SQL query statements.
D . Subqueries CANNOT be nested by more than two levels.
E . A subquery CANNOT be used in an SQL query statement that uses group functions.
F . When a subquery is used with an inequality comparison operator in the outer SQL statement, the column list in the SELECT clause of the subquery should contain only one column.

You have been recently hired as a database administrator. Your senior manager asks you to study the production database server and submit a report on the settings done by the previous DBA.  While observing the server settings, you find that the following parameter has been set in the parameter file of the database:  REMOTE_OS_AUTHENT = TRUE  What could have been the reason to set this parameter as TRUE?() to enable operating system authentication for a remote client。 to restrict the scope of administration to identical operating systems。 to allow the start up and shut down of the database from a remote client。 to enable the administration of the operating system from a remote client。 to disable the administration of the operating system from a remote client。 教学生识字有很多技巧,有一位教师告诉学生如何区别“买卖”两个字时说:“多了就卖,少了就买。”学生很快记住了这两个字。还有的学生把“干燥”写成“干躁”,把“急躁”写成“急燥”,老师就教学生记住:“干燥防失火,急躁必跺足。”从此以后,学生对这两个字再也不混淆了。奥苏泊尔认为,学生学习的实质是()。 有意义接受学习。 有意义发现学习。 发现学习。 探究学习。 The storage specialist is presenting the IBM System Storage TS3500 Tape Library including TS1040 and TS1130 tape drives. The customer asks which third party software supports these drives. Which of the following documents should the storage specialist consult?() TS3500 Sales Manual。 ISV Compatibility Matrix。 Internet search for "ISVs supported"。 TS3500 Installation and Maintenance Manual。 What must an administrator do to create two new volume groups on a system with only one spare disk?() Run the ‘mkvg -M’ command to create multiple volume groups on a single disk。 Add a new disk to the system or release a disk from the one of the existing volume groups。 Run the ‘mkvg’ command to create multiple volume groups on a single disk providing the disk does not have a PVID。 Run the ‘mkvg’ command to create multiple volume groups on a single disk providing the volume groups have the same PP size。 急性毒性试验中试验动物接触化学物的最常用方式为()。 经口接触。 经动脉注射接触。 经皮肤接触。 经呼吸道接触。 Which two statements about subqueries are true? ()
参考答案:

  参考解析

本题暂无解析

相关题目:

在线 客服