单选题 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 ;
单选题 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?
C、
TIMESTAMP WITH LOCAL TIMEZONE
E、 TIMESTAMP 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
单选题 
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 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
单选题 Examine the description of the PRODUCTS table:
Which query is valid?
A、
SELECT prod_id, MAX (AVG(cost)) FROM products GROUP BY prod_id;
B、
SELECT prod_id, AVG (MAX(cost)) FROM products GROUP BY prod_id;
C、
SELECT prod_id, release_date, SUM (cost) FROM products GROUP BY prod_id,release_date;
D、
SELECT prod_id, release_date, SUM(cost) FROM products GROUP BY prod_id;
单选题 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
单选题 What is true about non-equijoin 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.
2022-08-27
共324道
