A、SELECT ADD_MONTHS(MAX(hire_Date), 6) FROM EMP;
B、SELECT ROUND(hire_date) FROM EMP;
C、SELECT sysdate-hire_date FROM EMP;
D、SELECT TO_NUMBER(hire_date + 7) FROM EMP;
更多“Which SQL statement returns a numeric value?（）”相关的问题
A、The SQL Repair Advisor can be invoked to tune the performance of the regressed SQL statements. B、The SQL Repair Advisor can be invoked even when the incident is not active for a SQL statement crash. C、The SQL Repair Advisor is invoked by the Health Monitor when it encounters the problematic SQL statement. D、The DBA can invoke the SQL Repair Advisor when he or she receives an alert generated when a SQL statement crashes and an incident is created in the ADR.
A、Bind Variable Peeking B、SQL Plan Baselines C、Adaptive Cursor Sharing D、Bind variable used in a SQL statement E、Literals in a SQL statement
A、Both SQL and /SQL*plus allow manipulation of values in the database. B、/SQL* Plus recognizes SQL satement and sends them to the server; SQL is the Oracle proprietary interface for executing SQL statements. C、/SQL* Plus language for communicating with the Oracle server to access data; SQL recognizes SQL statements and sends them to the server. D、/SQL manipulates data and table definition in the database; /SQL* Plus does not allow manipulation of values in the database.
A、A. Both SQL and /SQL*plus allow manipulation of values in the database. B、B. /SQL* Plus recognizes SQL satement and sends them to the server; SQL is the Oracle proprietary interface for executing SQL statements. C、C. /SQL* Plus language for communicating with the Oracle server to access data; SQL recognizes SQL statements and sends them to the server. D、D. /SQL manipulates data and table definition in the database; /SQL* Plus does not allow manipulation of values in the database.
A、The tuned plan is not added to the SQL plan baseline. B、The tuned plan is added to the fixed SQL plan baseline as a fixed plan. C、The tuned plan is added to the fixed SQL plan baseline as a nonfixed plan. D、The tuned plan is added to a new nonfixed SQL plan baseline as a nonfixed plan.
A、The tuned plan is not added to the SQL plan baseline. B、The tuned plan is added to the fixed SQL plan baseline as a fixed plan. C、The tuned plan is added to the fixed SQL plan baseline as a nonfixed plan. D、The tuned plan is added to a new nonfixed SQL plan baseline as a nonfixed plan.
A、Accept the recommended SQL profile. B、Collect statistics for the related objects. C、Run the Access Advisor for the SQL statement. D、Run the Segment Advisor for recommendations.
客服
TOP
查看正确答案
