Which of the following NLS_SORT parameter values would result in case-insensitive and accent-insensitive binary sorts?()
第1题:
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.
第2题:
A. V$VALID_NLS_VALUES
B. NLS_VALID_VALUES
C. NLS_VALUE_OPTIONS
D. V$NLS_VALUE_OPTIONS
E. V$NLS_VALID_VALUES
第3题:
A.Binary backups are usually faster than text backups
B.Binary backups are usually slower than text backups
C.Text backups are human-readable while binary backups are not
D.Binary backups are not portable across different operating systems
第4题:
Case-insensitive sorts are always accent insensitive by default.()
第5题:
A.It deletes all binary log files, except ‘mysql-in.010‘
B.It deletes all binary log files up to and including ‘mysql-bin.010‘
C.It deletes all binary log files before ‘mysql-bin.010‘
D.It deletes all binary log files after ‘mysql-bin.010‘
第6题:
A. 1 is a monolingual sort.
B. 2 is a monolingual sort.
C. 1 is case insensitive.
D. Both 1 and 2 are case insensitive.
E.Case sensitivity is unknown.
第7题:
A. WHERE clause WHERE
B. ORDER BY clause
C. BETWEEN clause
D. NLSSORT function
E. NLS_SORT function
第8题:
A. True
B. False
第9题:
You are trying to determine how many disk sorts are happening on the database right now. Which of the following dictionary tables would you use to find that information?()
第10题:
A user executes the statement; PURGE BINARY LOGS TO 'mysql-bin.010'; What is the result?()