Oracle OCP 1Z0 053 Q461(NLS_SORT)
461.The NLS_SORT parameter sets the default sort method for which of the following
operations?(Choose all that apply.)
A. WHERE clause
B. ORDER BY clause
C. BETWEEN clause
D. NLSSORT function
E. NLS_SORT function
Answer: AD
The NLS_SORT parameter defines the default sort method (binary or linguistic)
for both SQL WHERE clause operations and NLSSORT function operations. The default
sort method for ORDER_BY and BETWEEN (and all other SQL operations that support
linguistic sorts) is defined by the NLS_COMP parameter. NLS_SORT is an invalid
function name.
參考:http://www.aiotestking.com/oracle/which-of-the-following-operations/
operations?(Choose all that apply.)
A. WHERE clause
B. ORDER BY clause
C. BETWEEN clause
D. NLSSORT function
E. NLS_SORT function
Answer: AD
The NLS_SORT parameter defines the default sort method (binary or linguistic)
for both SQL WHERE clause operations and NLSSORT function operations. The default
sort method for ORDER_BY and BETWEEN (and all other SQL operations that support
linguistic sorts) is defined by the NLS_COMP parameter. NLS_SORT is an invalid
function name.
參考:http://www.aiotestking.com/oracle/which-of-the-following-operations/
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/8520577/viewspace-2074854/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle OCP(56)Oracle
- Oracle OCP(23):序列Oracle
- Oracle OCP(29):PROFILEOracle
- Oracle OCP(54):EXPOracle
- Oracle OCP(54):IMPOracle
- Oracle OCP(57):IMPDPOracle
- Oracle OCP(44):LSNRCTLOracle
- Oracle OCP(28):USEROracle
- Oracle OCP(25):索引Oracle索引
- Oracle OCP(30):ROLEOracle
- Oracle OCP(33):官方文件Oracle
- Oracle OCP(20):建立表Oracle
- Oracle OCP(21):管理表Oracle
- Oracle OCP(12):ROLLUP & CUBEOracle
- Oracle OCP(48):UNDO TABLESPACEOracle
- Oracle OCP(58):ARCHIVELOG 管理OracleHive
- Oracle OCP(24):檢視Oracle
- Oracle OCP(26):其它ObjectOracleObject
- Oracle OCP(32):SUPPORT:MOSOracle
- Oracle OCP(35):Database 安裝OracleDatabase
- Oracle OCP(36):DBCA建庫Oracle
- Oracle OCP(04):聚合函式Oracle函式
- Oracle OCP(43):listener.oraOracle
- Oracle OCP(40):程式結構Oracle
- Oracle OCP(18):命名規則Oracle
- Oracle OCP(60):RMAN 備份Oracle
- Oracle OCP(45):sqlnet.oraOracleSQL
- Oracle OCP(45):TNSNAMES.oraOracle
- Oracle OCP(62):熱備份Oracle
- Oracle OCP(60):冷備份Oracle
- Oracle OCP和MySQL OCP認證考試內容有哪些?OracleMySql
- Oracle OCP(02):條件和排序Oracle排序
- Oracle OCP(41):邏輯結構Oracle
- Oracle OCP(38):Database 物理結構OracleDatabase
- Oracle OCP(15):分層檢索Oracle
- Oracle OCP(19):資料型別Oracle資料型別
- Oracle OCP(08):使用子查詢Oracle
- Oracle OCP(09):使用集合運算子Oracle
- Oracle OCP(10):運算元據Oracle