单选题Which SQL statement displays the date March 19, 2001 in a format that appears as "Nineteenth of March 2001 12:00:00 AM"? （）A SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'fmDdspth of Month YYYY fmHH:MI:SS AM') NEW_DATE FROM dual;B SELECT TO_CH

题目
单选题
Which SQL statement displays the date March 19, 2001 in a format that appears as "Nineteenth of March 2001 12:00:00 AM"? （）
A

SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'fmDdspth of Month YYYY fmHH:MI:SS AM') NEW_DATE FROM dual;

B

SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'Ddspth of Month YYYY fmHH:MI:SS AM') NEW_DATE HH:MI:SS AM') NEW _ DATE FROM dual;

C

SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'fmDdspth of Month YYYY NEW _ DATE FROM dual;

D

SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY), 'fmDdspth of Month YYYYfmtHH:HI:SS AM')NEW_DATE FROM dual;

相似考题

1.Which of the following financial statements reports information as of a specific date? ()A. income statementB. statement of owner's equityC. statement of cash flowsD. balance sheet

2.The EMP table has these columns:ENAME VARCHAR2(35)SALARY NUMBER(8,2)HIRE_DATE DATEManagement wants a list of names of employees who have been with the company for more than five years. Which SQL statement displays the required results? （）A. SELECT ENAME FROM EMP WHERE SYSDATE-HIRE_DATE >5;B. SELECT ENAME FROM EMP WHERE HIRE_DATE-SYSDATE >5;C. SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)/365 >5;D. SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)*/365 >5;

3.Examine the SQL statement that creates ORDERS table:CREATE TABLE orders (SER_NO NUMBER UNIQUE, ORDER_ID NUMBER, ORDER_DATE DATE NOT NULL, STATUS VARCHAR2(10) CHECK (status IN (‘CREDIT‘, ‘CASH‘)), PROD_ID NUMBER REFERENCES PRODUCTS(PRODUCT_ID), ORD_TOTAL NUMBER, PRIMARY KEY (order_id, order_date));For which columns would an index be automatically created when you execute the above SQL statement? （）A. SER_NOB. ORDER_IDC. STATUSD. PROD_IDE. ORD_TOTALF. composite index on ORDER_ID and ORDER_DATE

4.You run the SQL Tuning Advisor (STA) to tune a SQL statement that is part of a fixed SQL plan baseline. The STA generates a SQL profile for the SQL statement, which recommends that you accept the profile. Which statement is true when you accept the suggested SQL profile?（）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.

更多“Which SQL statement displays the date March 19, 2001 in a fo”相关问题

  • 第1题：

    Examine the SQL statements that creates ORDERS table:For which columns would an index be automatically created when you execute the above SQL statement? ()

    A. SER_NO

    B. ORDER_ID

    C. STATUS

    D. PROD_ID

    E. ORD_TOTAL

    F. Composite index on ORDER_ID and ORDER_DATE


    参考答案：A, F

  • 第2题：

    Evaluate the set of SQL statements:What is true about the set?()

    A. The DESCRIBE DEPT statement displays the structure of the DEPT table.

    B. The ROLLBACK statement frees the storage space occupies by the DEPT table.

    C. The DESCRIBE DEPT statement returns an error ORA-04043: object DEPT does not exist.

    D. The DESCRIBE DEPT statement displays the structure of the DEPT table only if there is a COMMIT statement introduced before the ROLLBACK statement.


    参考答案：A

  • 第3题：

    Evaluate the set of SQL statements: CREATE TABLE dept (deptno NUMBER(2), dname VARCHAR2(14), loc VARCHAR2(13)); ROLLBACK; DESCRIBE DEPT What is true about the set?（）

    • A、The DESCRIBE DEPT statement displays the structure of the DEPT table.
    • B、The ROLLBACK statement frees the storage space occupied by the DEPT table.
    • C、The DESCRIBE DEPT statement returns an error ORA-04043: object DEPT does not exist.
    • D、The DESCRIBE DEPT statement displays the structure of the DEPT table only if there is a COMMIT statement introduced before the ROLLBACK statement.

    正确答案:A

  • 第4题：

    Your boss at Certkiller .com wants you to clarify Oracle 10g. Which statement regarding the contents of the V$PARAMETER view is true？（）

    • A、Displays only the list of default values
    • B、Displays only the list of all basic parameters
    • C、Displays the currently in effect parameter values
    • D、Displays only the list of all advanced parameters
    • E、Displays the list of all the parameter files of a database
    • F、Displays the current contents of the server parameter file.

    正确答案:C

  • 第5题：

    Which statement regarding the contents of the V$PARAMETER view is true？（）

    • A、displays only the list of default values
    • B、displays only the list of all basic parameters
    • C、displays the currently in effect parameter values
    • D、displays only the list of all advanced parameters
    • E、displays the list of all the parameter files of a database

    正确答案:C

  • 第6题：

    Which of the following cannot be used as input to the SQL Tuning Advisor？（）

    • A、 A single SQL statement provided by a user
    • B、 An existing SQL Tuning Set （STS）
    • C、 A preprocessed Database Replay workload
    • D、 A schema name
    • E、 SQL statement identified in EM as using excessive resources

    正确答案:C,D

  • 第7题：

    单选题
    You want to display the titles of books that meet these criteria: 1. Purchased before January 21, 2001 2. Price is less then $500 or greater than $900 You want to sort the results by their data of purchase, starting with the most recently bought book. Which statement should you use?（）
    A

    SELECT book_title FROM books WHERE price between 500 and 900 AND purchase_date < '21-JAN-2001' ORDER BY purchase_date;

    B

    SELECT book_title FROM books WHERE price IN (500,900) AND purchase_date < '21-JAN-2001' ORDER BY purchase date ASC;

    C

    SELECT book_title FROM books WHERE price < 500 or > 900 AND purchase_date < '21-JAN-2001' ORDER BY purchase date DESC;

    D

    SELECT book_title FROM books WHERE (price < 500 OR price > 900) AND purchase_date < '21-JAN-2001' ORDER BY purchase date DESC;


    正确答案： A
    解析： 暂无解析

  • 第8题：

    单选题
    View the Exhibit and examine the structure of the ORDERS and ORDERJTEMS tables.  Evaluate the following SQL statement：   SELECT oi.order_id， product_jd， order_date   FROM order_items oi JOIN orders o   USING （order_id）；   Which statement is true regarding the execution of this SQL statement？（）
    A

     The statement would not execute because table aliases are not allowed in the JOIN clause.

    B

     The statement would not execute because the table alias prefix is not used in the USING clause.

    C

     The statement would not execute because all the columns in the SELECT clause are not prefixed with table aliases.

    D

     The statement would not execute because the column part of the USING clause cannot have a qualifier in the SELECT list.


    正确答案： B
    解析： 暂无解析

  • 第9题：

    单选题
    The EMP table has these columns: ENAME VARCHAR2(35) SALARY NUMBER(8,2) HIRE_DATE DATE Management wants a list of names of employees who have been with the company for more than five years. Which SQL statement displays the required results? （）
    A

    SELECT ENAME FROM EMP WHERE SYSDATE-HIRE_DATE >5;

    B

    SELECT ENAME FROM EMP WHERE HIRE_DATE-SYSDATE >5;

    C

    SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)/365 >5;

    D

    SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)*/365 >5;


    正确答案： C
    解析： 暂无解析

  • 第10题：

    单选题
    You run the SQL Tuning Advisor (STA) to tune a SQL statement that is part of a fixed SQL plan baseline. The STA generates a SQL profile for the SQL statement, which recommends that you accept the profile. Which statement is true when you accept the suggested SQL profile?（）
    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.


    正确答案： C
    解析： 暂无解析

  • 第11题：

    单选题
    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.


    正确答案： D
    解析： 暂无解析

  • 第12题：

    多选题
    Examine the SQL statement that creates ORDERS table: CREATE TABLE orders (SER_NO NUMBER UNIQUE, ORDER_ID NUMBER, ORDER_DATE DATE NOT NULL, STATUS VARCHAR2(10) CHECK (status IN ('CREDIT', 'CASH')), PROD_ID NUMBER REFERENCES PRODUCTS(PRODUCT_ID), ORD_TOTAL NUMBER, PRIMARY KEY (order_id, order_date)); For which columns would an index be automatically created when you execute the above SQL statement? （）
    A

    SER_NO

    B

    ORDER_ID

    C

    STATUS

    D

    PROD_ID

    E

    ORD_TOTAL

    F

    composite index on ORDER_ID and ORDER_DATE


    正确答案： A,F
    解析： 暂无解析

  • 第13题：

    Examine the structure of the EMPLOYEES and DEPARTMENTS tables:Evaluate this SQL statement:Which SQL statement is equivalent to the above SQL statement?()

    A.

    B.

    C.

    D.


    参考答案：C

  • 第14题：

    In the video form. the OrderDate field (Which shows When the video may be ordered)is calculated based on the Date field (Which displays the release date ). The order date is 30 days prior to  the release date. Which one the following formulas will calculate the OrderDate value?（）

    • A、@Number(Date)-30       
    • B、@Adjust(Date;0;0;30;0;0;0) 
    • C、@Adjust(Date;0;0;-30;0;0;0) 
    • D、@If(Date!="";Date-30;@Failure(There is no current release date")) 

    正确答案:C

  • 第15题：

    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.

    正确答案:D

  • 第16题：

    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 Peeking
    • B、SQL Plan Baselines
    • C、Adaptive Cursor Sharing
    • D、Bind variable used in a SQL statement
    • E、Literals in a SQL statement

    正确答案:A,C,E

  • 第17题：

    Which SQL statement displays the date March 19, 2001 in a format that appears as "Nineteenth of March 2001 12:00:00 AM"?（）

    • A、SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'fmDdspth "of" Month YYYY fmHH:MI:SS AM') NEW_DATE FROM dual;
    • B、SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'Ddspth "of" Month YYYY fmHH:MI:SS AM') NEW_DATE FROM dual;
    • C、SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'fmDdspth "of" Month YYYY HH:MI:SS AM') NEW_DATE FROM dual;
    • D、SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'fmtDdspth "of" Month YYYY fmtHH:MI:SS AM') NEW_DATE FROM dual;

    正确答案:A

  • 第18题：

    单选题
    In the video form. the OrderDate field (Which shows When the video may be ordered)is calculated based on the Date field (Which displays the release date ). The order date is 30 days prior to  the release date. Which one the following formulas will calculate the OrderDate value?（）
    A

    @Number(Date)-30       

    B

    @Adjust(Date;0;0;30;0;0;0) 

    C

    @Adjust(Date;0;0;-30;0;0;0) 

    D

    @If(Date!=;Date-30;@Failure(There is no current release date)) 


    正确答案： B
    解析： 暂无解析

  • 第19题：

    单选题
    The EMP table has these columns: ENAME VARCHAR2(35) SALARY NUMBER(8,2) HIRE_DATE DATE Management wants a list of names of employees who have been with the company for more than five years. Which SQL statement displays the required results? （）
    A

    SELECT ENAME FROM EMP WHERE SYSDATE-HIRE_DATE >5;

    B

    SELECT ENAME FROM EMP WHERE HIRE_DATE-SYSDATE >5;

    C

    SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)/365 >5;

    D

    SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)*/365 >5;


    正确答案： B
    解析： 暂无解析

  • 第20题：

    单选题
    Evaluate the set of SQL statements: CREATE TABLE dept (deptno NUMBER(2), dname VARCHAR2(14), loc VARCHAR2(13)); ROLLBACK; DESCRIBE DEPT What is true about the set?（）
    A

    The DESCRIBE DEPT statement displays the structure of the DEPT table.

    B

    The ROLLBACK statement frees the storage space occupied by the DEPT table.

    C

    The DESCRIBE DEPT statement returns an error ORA-04043: object DEPT does not exist.

    D

    The DESCRIBE DEPT statement displays the structure of the DEPT table only if there is a COMMIT statement introduced before the ROLLBACK statement.


    正确答案： A
    解析： 暂无解析

  • 第21题：

    多选题
    Examine the SQL statement that creates ORDERS table: CREATE TABLE orders (SER_NO NUMBER UNIQUE, ORDER_ID NUMBER, ORDER_DATE DATE NOT NULL, STATUS VARCHAR2(10) CHECK (status IN ('CREDIT', 'CASH')), PROD_ID NUMBER REFERENCES PRODUCTS(PRODUCT_ID), ORD_TOTAL NUMBER, PRIMARY KEY (order_id, order_date)); For which columns would an index be automatically created when you execute the above SQL statement? （）
    A

    SER_NO

    B

    ORDER_ID

    C

    STATUS

    D

    PROD_ID

    E

    ORD_TOTAL

    F

    composite index on ORDER_ID and ORDER_DATE


    正确答案： B,A
    解析： 暂无解析

  • 第22题：

    单选题
    Which SQL statement returns a numeric value?（）
    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;


    正确答案： B
    解析： 暂无解析

  • 第23题：

    单选题
    Which SQL statement displays the date March 19, 2001 in a format that appears as "Nineteenth of March 2001 12:00:00 AM"? （）
    A

    SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'fmDdspth of Month YYYY fmHH:MI:SS AM') NEW_DATE FROM dual;

    B

    SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'Ddspth of Month YYYY fmHH:MI:SS AM') NEW_DATE HH:MI:SS AM') NEW _ DATE FROM dual;

    C

    SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'fmDdspth of Month YYYY NEW _ DATE FROM dual;

    D

    SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY), 'fmDdspth of Month YYYYfmtHH:HI:SS AM')NEW_DATE FROM dual;


    正确答案： B
    解析： 暂无解析

  • 第24题：

    多选题
    Examine the SQL statements that creates ORDERS table: For which columns would an index be automatically created when you execute the above SQL statement? （）
    A

    SER_NO

    B

    ORDER_ID

    C

    STATUS

    D

    PROD_ID

    E

    ORD_TOTAL

    F

    Composite index on ORDER_ID and ORDER_DATE


    正确答案： C,F
    解析： 暂无解析

相关内容