For which two actions can you use the TO_DATE function? （）

第1题：

Which two statements apply to policy scheduling?（） (Choose two.)

• A、An individual policy can have only one scheduler applied.
• B、You must manually configure system-time updates.
• C、Multiple policies can use the same scheduler.
• D、Policies that do not have schedulers are not active.

第2题：

Which two are true about aggregate functions?（）

• A、You can use aggregate functions in any clause of a SELECT statement.
• B、You can use aggregate functions only in the column list of the select clause and in the WHERE clause of a SELECT statement.
• C、You can mix single row columns with aggregate functions in the column list of a SELECT statement by grouping on the single row columns.
• D、You can pass column names, expressions, constants, or functions as parameter to an aggregate function.
• E、You can use aggregate functions on a table, only by grouping the whole table as one single group.
• F、You cannot group the rows of a table by more than one column while using aggregate functions.

第3题：

第4题：

You need to calculate the total of all salaries in the accounting department. Which group function should you use?（）

• A、MAX
• B、MIN
• C、SUM
• D、COUNT
• E、TOTAL
• F、LARGEST

第5题：

Which two statements are correct regarding the Flashback Versions Query feature？（）

• A、 You can use this feature to identify the committed versions of the rows， but not the uncommitted versions.
• B、 You can use this feature to identify the versions of V$ views.
• C、 You can use this feature to identify the inserts， deletes， and updates performed on a particular row but not the data definition language （DDL） operations performed on the table.
• D、 You can use this feature for a table only if row movement is enabled for the table.
• E、 You can use this feature to identify the versions of external and fixed tables.

第6题：

For which action can you use the TO_DATE function?（）

• A、Convert any date literal to a date
• B、Convert any numeric literal to a date
• C、Convert any character literal to a date
• D、Convert any date to a character literal
• E、Format '10-JAN-99' to 'January 10 1999'

第7题：

You are preparing for a new installation of SQL Server 2005. You need to select the protocols that client computers might use to connect to the server.  Which two protocols can you use to achieve this goal？（）

• A、Named Pipes
• B、TCP/IP
• C、Shared Memory
• D、Virtual Interface Adapter （VIA）
• E、Multiprotocol

第8题：

第9题：

For which of the following can you use Segment Shrink？（）

• A、 Heap tables
• B、 Tables with function-based indexes
• C、 Indexes
• D、 Partitions and subpartitions
• E、 None of the above

第10题：

You have an image that is used to deploy Windows 7 on client computers.   You need to add drivers to the Windows 7 image.   Which two actions should you perform？（）

• A、Use the Deployment Image Servicing and Management （DISM） tool online.
• B、Use the Deployment Image Servicing and Management （DISM） tool offline.
• C、Use INF files for driver packages.
• D、Use executable files for driver packages.
• E、Use Windows Installer files for driver packages.