-
编辑 删除
Oracle 日记
oracle 使用绑定变量的好处：更好的执行速度。更好的安全性，防止sql注入
-
编辑 删除
习得性无助
当个体遇到不可抗的问题的时候，一段时间后形成一种消极心态，认为某事永远无法改变。就是长期失望之后的一种状态。即时外因改变了也不做任何努力。认为是自己命苦。缺乏自信后将问题泛化。认为永远不能改变。塞...
-
编辑 删除
预法
凡是预则立不预则废，不能只看眼前而不看未来。看似现在对你毫无影响的东西，将来也许会影响很多。
-
编辑 删除
领导者应该具备的素质
共性：坚韧不拔的意志，一定要达到某种目的的决心。这种决心让你同时具有一种危机感。一般人为什么不具有这种决心？因为一般人没有强烈的愿望或者不知道不坚定的后果。或者被欲望，和舒适的生活所诱惑，便宜...
-
编辑 删除
047-272
272. Which two statements are true regarding subqueries? (Choose two.)A. The ORDER BY clause can be used in the subquery.B. A subquery can be used in the FROM clause of a SELECT statement.C. If the su...
-
编辑 删除
047-271
271. Which two statements are true regarding the types of table joinsavailable in Oracle Database 10g?(Choose two.)A. You can use the JOIN clause to join only two tables.B. You can explicitly provide ...
-
编辑 删除
047-268
268. View the Exhibit and examine the description of the ORDERS table.The orders in the ORDERS table are placed through sales representatives only.You are given the task to get the SALES_REP_ID from t...
-
编辑 删除
047-267
267. Given below is a list of datetime data types and examples of values storedin them in a random order:Datatype Example1)INTERVAL YEAR TO MONTH a) '2003-04-15 8:00:00 -8:00'2)TIMESTAMP WITH LOCAL TI...
-
编辑 删除
047-263
263. Which statement is true regarding external tables?A. The default REJECT LIMIT for external tables is UNLIMITED.B. The data and metadata for an external table are stored outside thedatabase.C. ORA...
-
编辑 删除
047-262
262. View the Exhibit and examine the description of the EMPLOYEES table.You want to calculate the total remuneration for each employee. Totalremuneration is the sum of the annual salary and the perce...
-
编辑 删除
047-252
252. View the Exhibit and examine the structure of ORDER_ITEMS and ORDERStables.You need to remove from the ORDER_ITEMS table those rows that havean order status of 0 or 1 in the ORDERS table.Which DE...
-
编辑 删除
047-250
250. A subquery is called a singlerow subquery when ____.A. the inner query returns a single value to the main queryB. the inner query uses an aggregate function and returns one or more valuesC. there...
-
编辑 删除
047-235
235. Evaluate the following CREATE TABLE commands:CREATE TABLE orders(ord_no NUMBER(2) CONSTRAINT ord_pk PRIMARY KEY,ord_date DATE,cust_id NUMBER(4));CREATE TABLE ord_items(ord_no NUMBER(2),item_no NU...
-
编辑 删除
047-218
218. Evaluate the following query:SELECT INTERVAL '300' MONTH, INTERVAL '542' YEAR TO MONTH,INTERVAL '11:12:10.1234567' HOUR TO SECOND FROM dual;What is the correct output of the above query?A. +25-00...
-
编辑 删除
047-207
207. You executed the following SQL statements in the given order:CREATE TABLE orders(order_id NUMBER(3) PRIMARY KEY,order_date DATE, customer_id number(3));INSERT INTO orders VALUES (100,'10mar2007',...
-
编辑 删除
047-207
207. You executed the following SQL statements in the given order:CREATE TABLE orders(order_id NUMBER(3) PRIMARY KEY,order_date DATE, customer_id number(3));INSERT INTO orders VALUES (100,'10mar2007',...
-
编辑 删除
047-206
206. View the Exhibit and examine the details of the PRODUCT_INFORMATIONtable.Evaluate the following SQL statement:SELECT TO_CHAR(list_price,'$9,999') FROM product_information;Which two statements wou...
-
编辑 删除
047-203
203. View the Exhibit button and examine the structures of ORDERS andORDER_ITEMS tables.In the ORDERS table, ORDER_ID is the PRIMARY KEY and inthe ORDER_ITEMS table, ORDER_ID and LINE_ITEM_ID form. th...
-
编辑 删除
047-194
194. Evaluate the following CREATE TABLE command:CREATE TABLE order_item(order_id NUMBER(3),item_id NUMBER(2),qty NUMBER(4),CONSTRAINT ord_itm_id_pk PRIMARY KEY (order_id,item_id)USING INDEX (CREATE I...
-
编辑 删除
047-192
192. Which CREATE TABLE statement is valid?A. CREATE TABLE ord_details(ord_no NUMBER(2) PRIMARY KEY,item_no NUMBER(3) PRIMARY KEY,ord_date date NOT NULL);B. CREATE TABLE ord_details(ord_no NUMBER(2) U...
