Chinaunix首页 | 论坛 | 博客
  • 博客访问: 11289
  • 博文数量: 36
  • 博客积分: 0
  • 博客等级: 民兵
  • 技术积分: 210
  • 用 户 组: 普通用户
  • 注册时间: 2021-11-30 10:47




发布时间:2021-12-28 17:22:18

Which three statements are true concerning logical and physical database structures? (Choose three.)A. All tablespaces may have one or more data filesB. The extents of a segment must always reside in the same datafileC. A smallfile tablespace might be bigger than a bigfile tablespace.........【阅读全文】

阅读(324) | 评论(0) | 转发(0)

发布时间:2021-12-27 17:00:35

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:LISTENER_1=(ADDRESS=(PROTOCOL=TCP)( statement is true?A. Dyna.........【阅读全文】

阅读(216) | 评论(0) | 转发(0)

发布时间:2021-12-24 15:28:01

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 functionsStore a loan period of up to 10 yearsBe used for calculating interest for the number .........【阅读全文】

阅读(230) | 评论(0) | 转发(0)

发布时间:2021-12-23 14:36:21

5.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 tablespaceB. in the SYSAUX tablespaceC. in the SGAD. in the PGAE. in the temporary tablespaceS.........【阅读全文】

阅读(313) | 评论(0) | 转发(0)

发布时间:2021-12-22 13:48:16

4.Which two statements are true about date/time functions in a session where NLS_DATE_FORMAT is set to DD-MON-YYYY HH24:MI:SS? (Choose two.)A. CURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of fractional secondsB. SYSDATE can be queried only from the DU.........【阅读全文】

阅读(373) | 评论(0) | 转发(0)

登录 注册