搜索答案
登录 注册
首页  /  试题详情

单选题 QUESTION 89 Choose one Examine the parameters for a database instance: NAME TYPE VALUE Temp_undo_enabled boolean TRUE undo_ management string AUTO undo _retention Integer 900 undo _tablespace string UNDOTBS1 Your database has three undo tablespaces and the default Undo tablespace is not autoextensible. Resumable space allocation is not enabled for any sessions in the database instance. What is the effect on new transactions when all undo space in the default undo tablespace is in use by active transactions?

A、 Transactions wait until space becomes available in UNDOTBS1 .
B、 Transactions write their undo in a temporary tablespace .
C、 Transactions fail.
D、 Transactions write their undo in the SYSTEM undo segment.
查看答案

微信扫一扫
扫一扫下载APP
微信小程序答题 下载APP答题
由4l***wy提供 分享 举报 纠错
相关题库推荐
1Z0-082（322题）更20241031
2024-11-21
共322道

相关试题

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

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