ocp-其他 - 随笔分类(第3页) - 巴啦啦大魔王

052-147

摘要：View the Exhibit. You want to create a tablespace to contain objects with block size 16 KB. But while configuring thestorage you find that the block s 阅读全文

posted @ 2017-12-14 13:47 巴啦啦大魔王阅读(157) 评论(0) 推荐(0)

052-146

摘要：Identify three situations in which you would NOT be able to drop a tablespace. (Choose three.)A.when the tablespace is onlineB.when the tablespace has 阅读全文

posted @ 2017-12-14 13:41 巴啦啦大魔王阅读(134) 评论(0) 推荐(0)

052-145

摘要：Examine the commands executed in a DBA session:SQL> CREATE BIGFILE TABLESPACE MRKT2 DATAFILE '/u01/app/oracle/oradata/orcl/mrkt.dbf' size 10M LOGGING3 阅读全文

posted @ 2017-12-14 13:40 巴啦啦大魔王阅读(96) 评论(0) 推荐(0)

052-144

摘要：You execute the following command to change the status of the SALES tablespace:SQL> ALTER TABLESPACE sales OFFLINE;Which statements describe the effec 阅读全文

posted @ 2017-12-14 13:32 巴啦啦大魔王阅读(154) 评论(0) 推荐(0)

052-143

摘要：You execute a command to resize a data file, sales.dbf, of size 200 MB in your database:ALTER DATABASE DATAFILE '/remorse/sales.dbf' RESIZE 150M;Which 阅读全文

posted @ 2017-12-14 13:27 巴啦啦大魔王阅读(146) 评论(0) 推荐(0)

052-141

摘要：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 巴啦啦大魔王阅读(150) 评论(0) 推荐(0)

052-140

摘要：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)

052-139

摘要：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)

052-138

摘要：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)

052-137

摘要：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)

052-135

摘要：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 巴啦啦大魔王阅读(148) 评论(0) 推荐(0)

052-134

摘要：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)

052-133

摘要：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)

052-132

摘要：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)

052-131

摘要：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)

052-130

摘要：Which two statements are true regarding listeners? (Choose two.)A.Listeners use only the TCP/IP protocol.B.Multiple listener processes can run simulta 阅读全文

posted @ 2017-12-12 18:34 巴啦啦大魔王阅读(116) 评论(0) 推荐(0)

052-126&127

摘要：Identify the two situations in which the alert log file is updated with details. (Choose two.)A. Running a query on a table returns "ORA-600: Internal 阅读全文

posted @ 2017-12-12 17:50 巴啦啦大魔王阅读(189) 评论(0) 推荐(0)

052-125

摘要：You want to check the details of few errors that users have reported. You search for the alert log file and execute few commands to find the location 阅读全文

posted @ 2017-12-12 17:26 巴啦啦大魔王阅读(103) 评论(0) 推荐(0)

052-124

摘要：You executed the following commands to find the location of the alert log file:SQL> SHOW PARAMETER BACKGROUND_DUMP_DESTNAME TYPE VALUE background_dump 阅读全文

posted @ 2017-12-12 17:15 巴啦啦大魔王阅读(131) 评论(0) 推荐(0)

052-122

摘要：View the Exhibit and note the files available in the $ORACLE_HOME/dbs folder. The ASM instance is already running. You used the following steps to sta 阅读全文

posted @ 2017-12-12 16:51 巴啦啦大魔王阅读(136) 评论(0) 推荐(0)

随笔分类 - ocp-其他

公告