SELECT ADD_MONTHS(MAX(hire_Date), 6) FROM EMP;
SELECT ROUND(hire_date) FROM EMP;
SELECT sysdate-hire_date FROM EMP;
SELECT TO_NUMBER(hire_date + 7) FROM EMP;
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 variableB、 the value of the NLS_TERRITORY variableC、 the value of the NLS_CURRENCY variableD、the character encoding scheme used by the client application
点击查看答案
You issue this statement:ALTER DATABASE BACKUP CONTROLFILE TO TRACE; What does the statement generate?()A、A text copy of the control file.B、A binary copy of the control file.C、A file containing a SQL statement which will re-create the database.D、A file containing a SQL statement which will re-create the control file.
Which three features work together, to allow a SQL statement to have different cursors for the samestatement based on different selectivity ranges?()A、Bind Variable PeekingB、SQL Plan BaselinesC、Adaptive Cursor SharingD、Bind variable used in a SQL statementE、Literals in a SQL statement
When a valid SQL Query in a DB Read step returns 0 rows, which branch of the step will be executed? ()A、Timeout B、SQL Error C、Successful D、Connection Not Available
Which two statements are true about mouse button variables?()A、SYSTEM.MOUSE_BUTTON_PRESSED returns a string. B、SYSTEM.MOUSE_BUTTON_PRESSED returns a numeric value. 1Z0-132 World Leaders In Certifications Material - Test-king.com C、A possible value for SYSTEM.MOUSE_BUTTON_MODIFIERS is Control+Alt+Delete. D、SYSTEM.MOUSE_BUTTON_MODIFIERS can only be references in form-level triggers. E、SYSTEM.MOUSE_BUTTON_MODIFIERS identifies which special key was pressed in conjunction with the usual mouse button action.
Which four statements correctly describe functions that are available in SQL? ()A、INSTR returns the numeric position of a named character.B、NVL2 returns the first non-null expression in the expression list.C、TRUNCATE rounds the column, expression, or value to n decimal places.D、DECODE translates an expression after comparing it to each search value.E、TRIM trims the heading of trailing characters (or both) from a character string.F、NVL compares two expressions and returns null if they are equal, or the first expression of they are not equal.G、NULLIF compares twp expressions and returns null if they are equal, or the first expression if they are not equal.
Which of the following cannot be used as input to the SQL Tuning Advisor?() (Choose all that apply.)A、A single SQL statement provided by a userB、An existing SQL Tuning Set (STS)C、A preprocessed Database Replay workloadD、A schema nameE、SQL statement identified in EM as using excessive resources