Which NLS parameter can be used to change the default Oracle sort method from binary to linguistic for the SQL SELECT statement？（）A、 NLS_LANGB、 NLS_COMPC、 NLS_SORTD、 None of the above

第1题：

You issued the following statement：   SQL> ALTER SESSION SET NLS_LANG=FRENCH_CANADA.WE8ISO8859P1；   Which parameter is NOT overridden by using the above statement？（）  

• A、 the value of the NLS_LANGUAGE variable
• B、 the value of the NLS_TERRITORY variable
• C、 the value of the NLS_CURRENCY variable
• D、the character encoding scheme used by the client application

第2题：

Which two statements are true about the Automatic Diagnostic Repository （ADR）？（） 

• A、 The ADR base keeps all diagnostic information in binary format
• B、 SQL*Plus provides the ADRI script， which can be used to work with ADR
• C、 The ADR can be used for problem diagnosis only when the database is open
• D、 The ADR can be disabled by settting the DIAGNOSTIC_DEST parameter to null
• E、 The ADR can be used for problem diagnosis even when the database instance is down
• F、 The ADR base is shared across multiple instances

第3题：

In which four clauses can a subquery be used? （）

• A、in the INTO clause of an INSERT statement
• B、in the FROM clause of a SELECT statement
• C、in the GROUP BY clause of a SELECT statement
• D、in the WHERE clause of a SELECT statement
• E、in the SET clause of an UPDATE statement
• F、in the VALUES clause of an INSERT statement

第4题：

Evaluate this SQL statement: SELECT ename, sal, 12* sal+100 FROM emp; The SAL column stores the monthly salary of the employee. Which change must be made to the above syntax to calculate the annual compensation as "monthly salary plus a monthly bonus of $100, multiplied by 12"?（）

• A、No change is required to achieve the desired results.
• B、SELECT ename, sal, 12* (sal+100) FROM emp;
• C、SELECT ename, sal, (12* sal)+100 FROM emp;
• D、SELECT ename, sal +100,*12 FROM emp;

第5题：

Where can subqueries be used?（）

• A、field names in the SELECT statement 
• B、the FROM clause in the SELECT statement 
• C、the HAVING clause in the SELECT statement
• D、the GROUP BY clause in the SELECT statement 
• E、the WHERE clause in only the SELECT statement 
• F、the WHERE clause in SELECT as well as all DML statements

第6题：

The NLS_SORT parameter sets the default sort method for which of the following operations？（）

• A、 WHERE clause
• B、 ORDER BY clause
• C、 BETWEEN clause
• D、 NLSSORT function
• E、 NLS_SORT function

第7题：

The NLS_TERRITORY parameter specifies the default conventions to be used for which of the following globalization elements？（） 

• A、 Date format
• B、 Decimal character
• C、 Group separator
• D、 First day of the month
• E、 None of the above
• F、 All of the above

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

Given the following function: CREATE FUNCTION emplist （　） RETURNS TABLE ( id CHAR(6) , firstname VARCHAR(12) , lastname VARCHAR(15) ) LANGUAGE SQL BEGIN ATOMIC RETURN SELECT EMPNO, FIRSTNME, LASTNAME FROM EMPLOYEE WHERE WORKDEPT IN ('A00', 'B00'); END How can this function be used in an SQL statement?

• A、SELECT TABLE(EMPLIST()) FROM EMPLOYEE
• B、SELECT TABLE(EMPLIST()) AS t FROM EMPLOYEE
• C、SELECT EMPLIST(id, firstname, lastname) FROM EMPLOYEE
• D、SELECT id, firstname, lastname FROM TABLE(EMPLIST()) AS t

第14题：

Which of the following NLS_SORT parameter values would result in case-insensitive and accent-insensitive binary sorts?（）

• A、NLS_SORT = BINARY
• B、NLS_SORT = BINARY_AI
• C、NLS_SORT = BINARY_CI
• D、NLS_SORT = BINARY_AI_CI
• E、Binary sorts are case insensitive and accent insensitive by default.

第15题：

Which of the following NLS_SORT parameter values would result in case-insensitive and accent-insensitive binary sorts？（）  

• A、 NLS_SORT = BINARY
• B、 NLS_SORT = BINARY_AI
• C、 NLS_SORT = BINARY_CI
• D、 NLS_SORT = BINARY_AI_CI
• E、 Binary sorts are case insensitive and accent insensitive by default

第16题：

You are required to remove the default EXTPROC entry from the default listener configuration to create a listener that will listen specifically for EXTPROC calls. Which two methods can you use to remove the default EXTPROC entry from the default listener configuration？ （）

• A、 the RMAN utility
• B、 the import/export utility
• C、 the Oracle Enterprise Manager
• D、 the change tracking feature
• E、 the Net Manager utility

第17题：

Which NLS parameter directly governs linguistic searches？（）

• A、 NLS_SEARCH_L
• B、 NLS_SORT
• C、 NLS_SEARCH
• D、 NLS_SORT_L
• E、 None of the above

第18题：

The NLS_SORT parameter sets the default sort method for which of the following operations?（）

• A、WHERE clause WHERE
• B、ORDER BY clause
• C、BETWEEN clause
• D、NLSSORT function
• E、NLS_SORT function

第19题：

第20题：

第21题：

第22题：

第23题：