按类别查询搜索结果
关于关键词 的检测结果,共 20055
dbwatcher | 2019-04-10 16:14:09 | 阅读(2280) | 评论(0)
博客文章除注明转载外,均为原创。转载请注明出处。Oracle sysaux表空间使用过大处理第三篇,前两篇请见Oracle sysaux表空间使用过大处理-1(http://blog.chinaunix.net/uid-31396856-id-5819732.html)和Oracle sysaux表空间使用过大处理-2(http://blog.chinaunix.net/uid-31396856-id-5819835.html)前面2篇都是用了非常...【阅读全文】
dbwatcher | 2019-04-10 15:29:01 | 阅读(1890) | 评论(0)
博客文章除注明转载外,均为原创。转载请注明出处。接上文(Oracle sysaux表空间使用过大处理-1http://blog.chinaunix.net/uid-31396856-id-5819732.html)介绍另一种处理方法:基本情况如下:sysaux空间使用很大,检查相关对象,和awr设置发现dbid=3737847129不是当前数据库,并且sysaux使用对象如下:top segment...【阅读全文】
dbwatcher | 2019-04-08 16:04:47 | 阅读(660) | 评论(0)
博客文章除注明转载外,均为原创。转载请注明出处。Oracle sysaux表空间占用过大处理办法:step1:检查表空间的使用情况sysaux表空间空间使用是很大的。step2:检查表空间被内容占用:主要是awr信息库使用了sysaux表空间,step3:检查awr相关的配置信息:有2个awr资料库,分别是dbid=3737847129,和dbid=357941...【阅读全文】
【Oracle】 Oracle重建索引
dbwatcher | 2019-04-08 13:36:39 | 阅读(170) | 评论(0)
博客文章除注明转载外,均为原创。转载请注明出处。本文链接地址:Oracle普通索引是一种B树结构,在数据查询方面有很高的效率。但是有些时候需要重建索引。1、什么时候需要重建索引(1)索引失效,比如ORA-01502错误;(2)索引碎片较多,增加了索引的查询成本和维护成本;(3)统计信息不准确,导致SQL语句的执行的时候选择...【阅读全文】
lvxing | 2019-03-25 15:59:35 | 阅读(160) | 评论(0)
oracle10 版本 jdbc 驱动中 OraclePreparedStatement 执行excuteQuery 时返回的ResultSet的日期类型字段使用getObject 获得对象时,返回的是 java.sql.Date 。 这一点和 oracle9i 及oracle 11g 驱动不同。更新驱动不慎,会造成显示的日期时间字段缺失 时 分 秒。...【阅读全文】
evan_china | 2019-03-06 12:40:00 | 阅读(4030) | 评论(0)
获取Oracle/SQL Server/MySQL获取表及字段数据字典,以及唯一索引的聚合信息【阅读全文】
unix_5359 | 2019-03-05 14:22:52 | 阅读(90) | 评论(0)
Evaluate the following SQL commands:INCREMENT BY 10MAXVALUE 9999SQL>CREATE TABLE ord_itemsitem_no NUMBER(3),expiry_date date CHECK (expiry_date > SYSDATE),CONSTRAINT ord_fk FOREIGN KEY(ord_no) REFERENCES orders(ord_no));A) You cannot use SYSDATE in the condition of a CH...【阅读全文】
unix_5359 | 2019-03-05 13:07:19 | 阅读(60) | 评论(0)
Which two statements are true regarding the USING and ON clauses in table joins?B) A maximum of one pair of columns can be joined between two tables using the ON clause.D) The WHERE clause can be used to apply additional conditions in SELECT statements containing the ON or the USING clause...【阅读全文】
unix_5359 | 2019-03-05 11:32:05 | 阅读(80) | 评论(0)
Examine the structure of the BOORSTRANSACTIONS table:Examine the SQL statement:MEMBER_ID IN ('A101', 'A102');A) It displays details only for members who have borrowed before today with RM as TRANSACTION_TYPE.C) It displays details for members who have borrowed before today with RM ...【阅读全文】
unix_5359 | 2019-03-05 10:17:29 | 阅读(70) | 评论(0)
Examine the structure of the DEPARTMENTS tableYou execute the following command:SET UNUSED (country);A) A new column, COUNTRY, can be added to the DEPARTMENTS table after executing the command.C) Unique key constraints defined on the COUNTRY column are removed.E) Views created ...【阅读全文】
unix_5359 | 2019-03-04 14:35:16 | 阅读(60) | 评论(0)
You need to create a table with the following column specifications:2. Employee Name (character data type) that stores the employee name4. Status (character data type), that contains the value 'ACTIVE' if no data is enteredWhich is the correct syntax to create this table?(emp_id NU...【阅读全文】
unix_5359 | 2019-03-04 13:58:40 | 阅读(60) | 评论(0)
Which statement is true regarding the SESSION_PRIVS dictionary view?B) It contains the system privileges granted to other users by the current user session.D) It contains the current object privileges available in the user session.(解析:SESSION_PRIVS 查看的是该当前会话所有的系统权限。...【阅读全文】
unix_5359 | 2019-03-04 13:17:14 | 阅读(50) | 评论(0)
View the Exhibit and examine the structure of the ORDER_ITEMS and ORDERS tables.You executed the following SQL statement:FROM order_itemsNATURAL JOIN orders;A) The statement would not execute because the WHERE clause is before the NATURAL JOIN clause.C) The statement would exec...【阅读全文】
unix_5359 | 2019-03-04 11:28:27 | 阅读(50) | 评论(0)
Examine the command to create the BOOKS table.(book_id CHAR(6) PRIMARY KEY,publisher_id VARCHAR2(4),The BOOK_ID value 101 does not exist in the table.SQL> INSERT INTO books(BOOK_ID, TITLE, AUTHOR_ID)Which statement is true?B) It executes successfully only if NULL is explici...【阅读全文】
unix_5359 | 2019-02-28 11:35:19 | 阅读(100) | 评论(0)
You need to calculate the number of days from 1st January 2007 till date.Which two SQL statements would give the required output?B) SELECT SYSDATE - TO_DATE ('01/JANUARY/2007') FROM DUAL;D) SELECT SYSDATE - TO_DATE ('01-JANUARY-2007') FROM DUAL;Answer:BD数据时,会实现隐式转换。...【阅读全文】
unix_5359 | 2019-02-28 10:14:47 | 阅读(120) | 评论(0)
Examine the data in the CUST_NAME column of the CUSTOMERS table.----------------------Renske LadwigJason Mallinplace of the first name as follows:-----------------------**** Manuel UrmanA) SELECT LPAD(SUBSTR(cust_name,INSTR(cust_name,' ')),LENGTH(cust_name),'*') "CUST N...【阅读全文】
unix_5359 | 2019-02-28 09:33:02 | 阅读(130) | 评论(0)
View the Exhibit and examine the data in the EMPLOYEES table.You want to generate a report showing the total compensation paid to each employee to date(迄今为止支付给每位员工的总补偿).SQL>SELECT ename ||' joined on '|| hiredate ||TO_CHAR(ROUND(ROUND(SYSDATE-hiredate)/365) * sal + comm)...【阅读全文】
unix_5359 | 2019-02-27 11:42:10 | 阅读(120) | 评论(0)
View the Exhibit and examine the details of the ORDER_ITEMS table.Evaluate the following SQL statements:SELECT MAX(unit_price*quantity) "Maximum Order"Statement 2:FROM order_itemsWhich statements are true regarding the output of these SQL statements? (Choose all that apply.)...【阅读全文】
unix_5359 | 2019-02-27 11:09:11 | 阅读(170) | 评论(0)
Which three tasks can be performed by DDL statements?B) modifying a table to prevent data that violate certain conditions from being entered in a columnD) creating multiple savepoints to enable partial rollback of a transactionAnser:BCE【阅读全文】
unix_5359 | 2019-02-27 10:32:50 | 阅读(110) | 评论(0)
Which statement is true about the Oracle SQL, DELETE and TRUNCATE statements?B) DELETE and TRUNCATE statements can have a rollback done to restore data into a table.D) DELETE but not TRUNCATE statement can be used to selectively remove rows from a table.Answer:D(解析:Truncate 是...【阅读全文】