随笔分类 -  SQL

上一页 1 2
053-668
摘要：Examine the following RMAN script:RMAN> run {debug on;allocate channel c1 type disk;backup datafile 5;}Which statement describes the purpose of the sc 阅读全文
posted @ 2017-11-16 13:46 巴啦啦大魔王 阅读(103) 评论(0) 推荐(0)
053-641
摘要：Which three functions are performed by the SQL Tuning Advisor? (Choose three.)A. Building the SQL profileB. Recommending optimization of materialized 阅读全文
posted @ 2017-11-16 11:20 巴啦啦大魔王 阅读(121) 评论(0) 推荐(0)
053-624
摘要：You work with a newly created database. Presently, there is no application load on the database instance. You want to create a baseline for tuning the 阅读全文
posted @ 2017-11-15 17:17 巴啦啦大魔王 阅读(103) 评论(0) 推荐(0)
053-609
摘要：Examine the following commands and their output:SQL> SELECT ename, sal FROM emp WHERE ename='JAMES';ENAME SAL JAMES 1050SQL> UPDATE emp SET sal=sal+sa 阅读全文
posted @ 2017-11-15 16:00 巴啦啦大魔王 阅读(104) 评论(0) 推荐(0)
053-675
摘要：Which two client requests are captured during database replay Capture? (Choose two)A. Flashback queriesB. Shared server requestsC. Login and logoff ac 阅读全文
posted @ 2017-11-15 15:26 巴啦啦大魔王 阅读(159) 评论(0) 推荐(0)
053-92
摘要：You observed the following output for a user session: What do you infer from the preceding output?A. Resumable set for session with sid 18B. The user 阅读全文
posted @ 2017-11-15 15:14 巴啦啦大魔王 阅读(183) 评论(0) 推荐(0)
053-708
摘要：You executed the following query: Considering that all the redo logs are available, what information can you derive from the output of the preceding q 阅读全文
posted @ 2017-11-15 14:11 巴啦啦大魔王 阅读(119) 评论(0) 推荐(0)
053-704
摘要：View the Exhibit and examine the data manipulation language (DML) operations that you performed on the NEWEMP table. Note that the first two updated a 阅读全文
posted @ 2017-11-15 14:02 巴啦啦大魔王 阅读(141) 评论(0) 推荐(0)
053-691
摘要：You work in a data warehouse environment that involves the execution of complex queries. The current content of the SQL cache contains the ideal workl 阅读全文
posted @ 2017-11-15 13:37 巴啦啦大魔王 阅读(112) 评论(0) 推荐(0)
053-470
摘要：Which NLS parameter can be used to change the default Oracle sort method from binary to linguistic for the SQL SELECT statement?A. NLS_LANGB. NLS_COMP 阅读全文
posted @ 2017-11-15 10:37 巴啦啦大魔王 阅读(91) 评论(0) 推荐(0)
053-426
摘要：The following query will provide what information about transportable tablespaces for the currentdatabase? (Choose all that apply.)select d.platform_n 阅读全文
posted @ 2017-11-14 15:09 巴啦啦大魔王 阅读(91) 评论(0) 推荐(0)
053-412
摘要：Performance divergence indicated in the Workload Replay report is most likely due to what?A. DML and SQL statement results that do not match between t 阅读全文
posted @ 2017-11-14 11:38 巴啦啦大魔王 阅读(153) 评论(0) 推荐(0)
053-408
摘要：Which statement most accurately describes the implementation of a SQL Access Advisor recommendation?A. SQL Access Advisor recommendations are automati 阅读全文
posted @ 2017-11-14 11:08 巴啦啦大魔王 阅读(151) 评论(0) 推荐(0)
053-407
摘要：Which of the following is a potential performance tuning recommendation from the SQL Access Advisor?A. Create new indexes.B. Modify existing indexes.C 阅读全文
posted @ 2017-11-14 10:59 巴啦啦大魔王 阅读(116) 评论(0) 推荐(0)
053-406
摘要：Which of these appropriately describes the results of a manual SQL Tuning Advisor task?A. A list of SQL statements and recommendations for tuningB. A 阅读全文
posted @ 2017-11-14 10:55 巴啦啦大魔王 阅读(94) 评论(0) 推荐(0)
053-405
摘要：To view the results of a manual SQL Tuning Advisor task, which steps should the DBA take?A. From the Advisor Central home page, select the tuning task 阅读全文
posted @ 2017-11-14 10:51 巴啦啦大魔王 阅读(106) 评论(0) 推荐(0)
053-404
摘要：When creating a SQL tuning set, which of the following steps allows the DBA to reduce the size of the SQL set by selecting specific operators and valu 阅读全文
posted @ 2017-11-14 10:47 巴啦啦大魔王 阅读(88) 评论(0) 推荐(0)
053-403
摘要：To view the results of the most recent Automatic SQL Tuning Advisor task, which sequence should you follow?A. EM Database home page, Software and Supp 阅读全文
posted @ 2017-11-14 10:19 巴啦啦大魔王 阅读(74) 评论(0) 推荐(0)
053-369
摘要：Which of the following identifies and creates an index to minimize the DB time for a particular SQL statement?A. The SGA Tuning AdvisorB. The SQL Acce 阅读全文
posted @ 2017-11-13 14:19 巴啦啦大魔王 阅读(167) 评论(0) 推荐(0)

上一页 1 2