摘要：
Which tablespaces are mandatory in an Oracle database for it to be operational? (Choose all that apply.)A.Undo tablespaceB.USERS tablespaceC.SYSAUX ta 阅读全文
posted @ 2017-12-13 15:45
巴啦啦大魔王
阅读(151)
评论(0)
推荐(0)
摘要：
Identify two situations in which the block header grows in a data block. (Choose two.)A.when row directories need more row entriesB.when there is row 阅读全文
posted @ 2017-12-13 15:42
巴啦啦大魔王
阅读(122)
评论(0)
推荐(0)
摘要：
Which two statements are true regarding a tablespace? (Choose two.)A.It can span multiple databases.B.It can consist of multiple data files.C.It can c 阅读全文
posted @ 2017-12-13 15:37
巴啦啦大魔王
阅读(133)
评论(0)
推荐(0)
摘要：
Your database is configured in shared server mode. However, your senior DBA asks you to modify the value of the PRIVATE_SGA limit in the profile of th 阅读全文
posted @ 2017-12-13 15:31
巴啦啦大魔王
阅读(171)
评论(0)
推荐(0)
摘要：
Your database instance is currently configured to support 1,500 connections. The Web application that uses the database allows a large number of users 阅读全文
posted @ 2017-12-13 15:28
巴啦啦大魔王
阅读(147)
评论(0)
推荐(0)
摘要：
In which situation would you use static database registration for a listener?A.when multiple databases are to be registered with the listenerB.when DB 阅读全文
posted @ 2017-12-13 15:19
巴啦啦大魔王
阅读(149)
评论(0)
推荐(0)
摘要：
View the Exhibit and examine the output. A. The ORCL instance is registered dynamically with the listener.B. The ORCL instance is registered staticall 阅读全文
posted @ 2017-12-13 15:17
巴啦啦大魔王
阅读(151)
评论(0)
推荐(0)
摘要：
Your database is open and the LISTENER listener is running. The new DBA of the system stops the listener by using the command: LSNRCTL> STOPWhat happe 阅读全文
posted @ 2017-12-13 15:13
巴啦啦大魔王
阅读(132)
评论(0)
推荐(0)
摘要：
The tnsnames.ora file has an entry for the service alias ORCL as follows:ORCL =( DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 10.156.24.216)(PORT = 阅读全文
posted @ 2017-12-13 15:11
巴啦啦大魔王
阅读(176)
评论(0)
推荐(0)
摘要：
Which naming method uses the tnsnames.ora file to store the connect descriptor used by the client while connecting to the database instance from a rem 阅读全文
posted @ 2017-12-13 15:08
巴啦啦大魔王
阅读(141)
评论(0)
推荐(0)
摘要：
--1.正则判断,适用于10g以上版本 --非正整数 select 字段 from 表 where regexp_replace(字段,'\d','') is not null; --非数值类型 select 字段 from 表 where regexp_replace(字段,'^[-\+]?\d+(\.\d+)?$','') is not null; --2.自定义函数,判断非值类型 cre... 阅读全文
posted @ 2017-12-13 14:35
巴啦啦大魔王
阅读(171)
评论(0)
推荐(0)
浙公网安备 33010602011771号