多选题 In the PROMOTIONS table, the PROMO BEGIN DATE column is of data type DATE and the default date format is DD-MON-RR. Which two statements are true about expressions using PROMO BEGIN DATE contained in a query?

A、 TO_NUMBER(PROMO_BEGIN_DAT

B、 - 5 will return a number.

C、 PROMO_BEGIN_DATE - SYSDATE will return an error.

D、 RROMO_BEGIN_DATE - 5 will return a date.

E、 PROMO_BEGIN_DATE - SYSDATE will return a number.

F、 TO_DATE(RROMO _BEGIN_ DATE* 5) will return a date.

查看答案

由4l***8a提供分享举报纠错

相关试题

单选题 You have been tasked to create a table for a banking application. One of the columns must meet three requirements: Be stored in a format supporting date arithmetic without using conversion functions， Store a loan period of up to 10 years 。Be used for calculating interest for the number of days the loan remains unpaid。 Which data type should you use?

A、INTERVAL YEAR TO MONTH

B、INTERVAL DAY TO SECOND

C、TIMESTAMP WITH LOCAL TIMEZONE

D、TIMESTAMP

E、SIMESTAMP WITH TIMEZONE

查看答案

单选题 In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1. The TNSNAMES.ORA file in $ORACLE_HOME/network/admin in the database home contains: Which statement is true?

A、Dynamic service registration cannot be used for this database instance

B、The LREG process registers services dynamically with the LISTENER_1 listener

C、LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration

D、There are two listeners named LISTENER and LISTENER_1 running simultaneously using port 1521 on the same host as the database instances

E、The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service Registration

查看答案

单选题 What is true about non-equi join statement performance?

A、The Oracle join syntax performs less well than the SQI:1999 compliant ANSI join syntax.

B、The BETWEEN condition used with an non-equijoin always performs better than when using the >= and <= conditions.

C、The BETWEEN condition used with an non-equijoin sometimes performs better than using the >= and <= conditions.

D、The join syntax used makes no difference to performance.

E、The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax.

查看答案

单选题 Examine the description of the EMPLOYEES table: NLS_DATE FORMAT is set to DD-MON-YY. Which query requires explicit data type conversion?

A、SELECT salary+ '120.50' FROM employees;

B、SELECT join date 11 ' ' 11 salary FROM employees;

C、SELECT join date FROM employees WHERE join date > '10-02-2018';

D、SELECT join_ date + '20' FROM employees;

E、SELECT SUBSTR(join date, 1, 2) - 10 FROM employees;

查看答案

单选题 Which statement is true about the INTERSECT operator used in compound queries?

A、Multiple INTERSECT operators are not possible in the same SQL statement

B、It processes NULLs in the selected columns

C、INTERSECT is of lower precedence than UNION or UNION ALL

D、It ignores NULLs

查看答案

单选题 A database is configured to use automatic undo management with temporary undo enabled. An UPDATE is executed on a temporary table. Where is the UNDO stored?

A、in the undo table space

B、in the SYSAUX table space

C、in the SGA

D、in the PGA

E、in the temporary table space

查看答案

单选题 Which is the default column or columns for sorting output from compound queries using SET operators such as INTERSECT in a SQL statement?

A、the first NUMBER column in the first SELECT of the compound query

B、the first column in the first SELECT of the compound query

C、the first NUMBER or VARCHR2 column in the last SELECE of the compound query

D、the first VARCHAR2 column in the first SELECT of the compound query

E、the first column in the last SELECT of the compound query

查看答案

单选题 The CUSTOMERS table has a CUST LAST NAME column of data type VARCHAR2. The table has two rows whose CUST LAST NAME values are Anderson and Ausson. Which query produces output for CUST LAST NAME containing oder for the first row and Aus for the second?

A、SELECT REPLACE (SUBSTR(Cust. last name, -3)， An', 'O') FROM customers;

B、SELECT REPLACE (REPLACE (cust last name,'son' ' ' ) 'An', 'O') FROM customers ;

C、SELECT INITCAP (EPLACE (TRIM('son' FROM cust_ last_ name), 'An', 'o')) FROM customers;

D、SELECT REPLACE (TRIM (TRAILING 'son' FROM cust_last_ name)，'AN' , 'O' ROM customers ;

查看答案