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

052-192(新增70题2018)

摘要：A user complains that he gets the following error message repeatedly after executing some SQL statements. The error message forces the user to log off 阅读全文

posted @ 2018-03-16 11:11 巴啦啦大魔王阅读(249) 评论(0) 推荐(0)

052-191(新增70题2018)

摘要：Your Oracle 11g database has 6 tablespaces (view Exhibit) in which:- TEMP is the default temporary tablespace- UNDOTBS1 is the default undo tablespace 阅读全文

posted @ 2018-03-16 10:12 巴啦啦大魔王阅读(175) 评论(0) 推荐(0)

052-190(新增70题2018)

摘要：You have created a baseline metric, DISK_IO_BL, for the disk I/O metrics in your PROD database and you have been getting notifications whenever the da 阅读全文

posted @ 2018-03-15 18:41 巴啦啦大魔王阅读(125) 评论(0) 推荐(0)

052-189(新增70题2018)

摘要：View Exhibit. Which two options are used to enable the connect-time failover feature? (Choose two.) Exhibit: A. Use only the first address. B. Try one 阅读全文

posted @ 2018-03-15 18:16 巴啦啦大魔王阅读(136) 评论(0) 推荐(0)

052-188(新增70题2018)

摘要：One of the users in the PROD database, Adams, complains that his update on the table, TRANS, is taking an unusually long time to complete. You find th 阅读全文

posted @ 2018-03-15 18:01 巴啦啦大魔王阅读(173) 评论(0) 推荐(0)

052-187(新增70题2018)

摘要：What advantage would you get if you increase the length of time during which the undo information would be stored in the database? A. roll back of lar 阅读全文

posted @ 2018-03-15 17:41 巴啦啦大魔王阅读(157) 评论(0) 推荐(0)

052-186(新增70题2018)

摘要：The database users are connecting to the PROD database from different applications, thereby degrading the database performance. The senior database ad 阅读全文

posted @ 2018-03-15 17:26 巴啦啦大魔王阅读(180) 评论(0) 推荐(0)

052-184(新增70题2018)

摘要：Where do you find information about a missing redo log file? A. trace file B. audit trail C. control file D. alert log file E. event viewer Answer: DA 阅读全文

posted @ 2018-03-15 17:05 巴啦啦大魔王阅读(211) 评论(1) 推荐(0)

052-183(新增70题2018)

摘要：View Exhibit. Which statement causes more undo generation? Exhibit: A. SELECT * FROM emp; B. DELETE FROM emp WHERE empno=7934; C. UPDATE emp SET comm= 阅读全文

posted @ 2018-03-15 14:14 巴啦啦大魔王阅读(158) 评论(0) 推荐(0)

053-28

摘要：You have a range-partitioned table in your database. Each partition in the table contains thesales data for a quarter. The partition related to the cu 阅读全文

posted @ 2018-01-05 18:20 巴啦啦大魔王阅读(124) 评论(0) 推荐(0)

053-27

摘要：You are using the flash recovery area (fast recovery area in 11g Release 2) to store backup related files in your database. After regular monitoring o 阅读全文

posted @ 2018-01-05 18:13 巴啦啦大魔王阅读(178) 评论(0) 推荐(0)

053-25

摘要：You enabled Flashback Data Archive on the INVENTORY table. Which DDL operation issupported on the table after enabling Flashback Data Archive?A. Drop 阅读全文

posted @ 2018-01-05 17:52 巴啦啦大魔王阅读(154) 评论(0) 推荐(0)

053-24

摘要：Which of the following information will be gathered by the SQL Test Case Builder for the problems pertaining to SQL-related problems? (Choose all that 阅读全文

posted @ 2018-01-05 17:43 巴啦啦大魔王阅读(143) 评论(0) 推荐(0)

053-17

摘要：The INV_HISTORY table is created using the command:SQL>CREATE TABLE INV_HISTORY (inv_no NUMBER(3), inv_date DATE, inv_amt NUMBER(10,2))partition by ra 阅读全文

posted @ 2018-01-04 14:43 巴啦啦大魔王阅读(220) 评论(0) 推荐(0)

051-48

摘要：Which two statements are true regarding indexes? (Choose two.)A. They can be created on tables and clusters.B. They can be created on tables and simpl 阅读全文

posted @ 2018-01-02 16:27 巴啦啦大魔王阅读(144) 评论(0) 推荐(0)

053-11

摘要：View the Exhibit to examine the metrics with a threshold. Which statement is true regarding the Number of Transactions (per second) metric? A. Oracle 阅读全文

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

051-20

摘要：Which three statements are true regarding the data types in Oracle Database 10g/11g? (Choose three.)A. Only one LONG column can be used per table.B. A 阅读全文

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

051-17

摘要：View the E xhibit and examine the data in the EMPLOYEES table.You want to generate a report showing the total compensation paid to each employee to da 阅读全文

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

051-15

摘要：View the Exhibit and examine the data in the CUSTOMERS table.Evaluate the following query:SQL> SELECT cust_name AS "NAME", cust_credit_limit/2 AS MIDP 阅读全文

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

053-9

摘要：Which statement describes the information returned by the DBMS_SPACE.SPACE_USAGE procedure for LOB space usage?A. It returns space usage of only Basic 阅读全文

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

随笔分类 - OCP

公告