QUESTION 178 Choose the best answer. Examine this statement: SELECT 1 AS id, 'John' AS first_name, NULL AS commission FROM DUAL INTERSECT SELECT 1, 'John' ,NULL FROM DUAL ORDER BY 3; What is returned upon execution? | 1Z0-082（322题）更20241031

单选题 QUESTION 28 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;

查看答案

单选题 QUESTION 40 The EMPLOYEES table contains columns EMP_ID of data type NUMBER and HIRE_DATE of data type DATE. You want to display the date of the first Monday after the completion of six months since hiring. The NLS_TERRITORY parameter is set to AMERICA in the session and , therefore, Sunday is the first day on the wee. Which query can be used?

A、 SELECT emp_ id, ADD_ MONTHS( hire_date, 6 ) , NEXT_ DAY(‘MONDAY’) FROM Employees;

B、 SELECT emp_ id, NEXT_ DAY(ADD_ MONTHS( hire_date, 6 ) , ‘ MONDAY’) FROM employees;

C、 SELECT emp_ id, NEXT_ DAY( MONTHS_ BETWEEN( hire_date, SYSDATE) , 6 ) FROM employees;

D、 SELECT emp_id, NEXT_ DAY(ADD_ MONTHS( hire_date, 6 ) , 1 ) FROM employees;

查看答案

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

查看答案

单选题 QUESTION 44 Your database instance is started with a PFILE. Examine these parameters: You want to increase the size of the buffer cache. Free memory is available to increase the size of the buffer cache. You execute the command: SQL> ALTER SYSTEM SET DB_CACHE_SIZE= 10 24 M; What is the Outcome?

A、 he value is changed only in the PFILE and takes effect at the next instance startup

B、 The value is changed for the current instance and in the PFILE

C、 It fails because the SCOPE clause is missing

D、 Change is applied to the current instance, but does not persist after instance restart

查看答案

单选题 QUESTION 1 1 NLS_DATE FORMAT is set to DD-MON-YY. Which query requires explicit data type conversion?

A、 SELECT salary+ ' 120 .50' FROM employees;

B、 SELECTjoin date 11 ' ' 11 salary FROM employees;

C、 sELECTjoin 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;

查看答案

单选题 QUESTION 47 Your database instance is started by using a server parameter file (SPFILE) . You execute the following command to change the value of the LOG_BUFFER initialization parameter: ALTER SYSTEM SET LOG_ BUFFER= 32M; What is the outcome of this command?

A、 The parameter value is changed and it comes into effect as soon as space becomes available in the SGA.

B、 The parameter value is changed and it comes into effect at the next instance startup.

C、 It returns an error because SCOPE should be set to MEMORY.

D、 It returns an error because the value of this parameter cannot be changed dynamically.

查看答案

单选题 QUESTION 43 Examine the description of the SALES1 table: SALES2 is a table with the same description as SALES1 . Some sales data is duplicated in both tables. You want to display the rows from the SALES1 table which are not present in the SALES2 table. Which set operator generates the required output?

A、 INTERSECT

B、 UNION ALL

C、 UNION

D、 SUBTRACT

E、 MINUS

查看答案

单选题 QUESTION 18 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

查看答案