OCP - 随笔分类(第7页) - 巴啦啦大魔王

052-150

摘要：The user HR receives the following error while inserting data into the TTK table:ERROR at line 1:ORA-01653: unable to extend table HR.TTK by 128 in ta 阅读全文

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

052-149

摘要：You executed the following command to create a tablespace called SALES_DATA:SQL> CREATE TABLESPACE sales_data DATAFILE SIZE 100MSEGMENT SPACE MANAGEME 阅读全文

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

052-148

摘要：View the Exhibit. Which statements are true regarding the USERS tablespace? (Choose all that apply.)A.A bitmap is used to record free extents.B.Free e 阅读全文

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

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-129

摘要：A database user SMITH tries to query the V$SESSION view and fails to access it as follows:SQL> connect smith/smithConnected. SQL> SELECT * FROM v$sess 阅读全文

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

随笔分类 - OCP

公告