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

单选题 QUESTION 69 In the ORCL database , UNDOTBS1 is the active undo tablespace with these properties: 1. A size Of 100 MB 2 . AUTOEXTEND is off 3 . UNDO_ RETENTION is set to 15 minutes 4 . It has RETENTION GUARANTEE UNDOTBS1 fills with uncommitted undo 10 minutes after the database opens . What will happen when the next update is attempted by any transaction?

A、 It succeeds and the generated undo is stored in SYSTEM.
B、 It fails and returns the error message “ ORA-30036: unable to extend segment by 8 in Undo tablespace ‘ UNDOTBS1 ’ “ .
C、 It succeeds and the least recently written undo block of UNDOTBS1 is overwritten by the generated undo.
D、 It succeeds and the generated undo is stored in SYSAUX.
E、 It succeeds and the least recently read undo block of UNDOTBS1 is overwritten by the generated undo.
查看答案

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

相关试题

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