- 博客(22)
- 资源 (2)
- 收藏
- 关注
RSS订阅原创 ocp-047-103
103. View the Exhibit and examine the structure of EMPLOYEES and JOB_HISTORY tables. The EMPLOYEES table maintains the most recent information regarding salary, department, and job for all the emp
2013-08-06 13:49:02
660
转载 ORACLE alter system 命令 scope解释
alter system 命令 scope解释：SCOPEThe SCOPE clause lets you specify when the change takes effect. Scope depends on whether you started up the database using a client-side parameter file (pfile) or
2013-08-06 10:06:22
908
原创 ocp-047-102 视图
102. Evaluate the following command: CREATE TABLE employees (employee_id NUMBER(2) PRIMARY KEY, last_name VARCHAR2(25) NOT NULL, department_id NUMBER(2),job_id VARCHAR2(8),salary NUMBER(10,2))
2013-08-06 09:56:26
762
原创 ocp-047-99 为啥DESC和VIEW显示不同。主键不能被带到新表，NOT NULL可以带到新表中。显示的可以，隐示不可以如主键。
CREATE TABLE new_orders(ord_id, ord_date DEFAULT SYSDATE, cust_id) AS SELECT order_id,order_date,customer_id FROM orders 既是：create table NEW_ORDERS( ORD_ID NUMBER(12), ORD_D
2013-08-05 16:47:53
1699
2
原创 ocp-047-98
create table dept (deptno varchar2(10),deptname varchar2(10), constraint pk_deptno primary key (deptno));create table emp1 (empno varchar2(10),ename varchar2(10),deptno,constraint pk_empno primary ke
2013-08-05 16:40:26
647
原创 ocp-047-96(疑问）
96. View the Exhibit and examine the structure of ORDERS and ORDER_ITEMS tables.ORDER_ID is the primary key in the ORDERS table. It is a lso the foreign key in the ORDER_ITEMS table where in it is
2013-08-05 15:28:00
680
转载 ocp-047-91
91. View the Exhibit and examine the data in the LOCATIONS table. Evaluate the following SQL statement: SELECT street_address FROM locations WHERE REGEXP_INSTR(street_address,'[^[:alpha:]]') = 1
2013-08-05 14:36:24
594
转载 ocp-047-88
GROUPING函数可以接受一列，返回0或者1。GROUPI NG只能在使用ROLLUP或CUBE的查询中使用。当需要在返回空值的地方显示某个值时，GROUPING()就非常有用。 1、在ROLLUP中对单列使用G ROUPING() SQL> select division_id,sum(salary) from employees2 group by rollu
2013-08-05 14:25:30
628
原创 ocp-047-87 where 条件限制的自连接
87. View the Exhibit and examine the structure of the EMPLOYEES table. You want to display all employees and their managers having 100 as the MANAGER_ID. You want the output in two columns: the fi
2013-08-05 14:18:59
809
原创 ocp-047-86
86. View the Exhibit and examine the description of the EMPLOYEES table. Evaluate the following SQL statement: SELECT first_name, employee_id, NEXT_DAY(ADD_MONTHS(hire_date, 6),1) "Review" FROM
2013-08-05 13:27:43
626
转载 ocp-047-85
1: 无条件 INSERT ALL 从 EMPLOYEES 中选择 EMPLOYEE_ID 大于200的雇员 EMPLOYEE_ID, HIRE_DATE, SALARY, 和 MANAGER_ID 值 用多表 INSERT 插入这些值到 SAL_HISTORY 和 MGR _HISTORY 表中 INSERT ALL INTO sal_history VALUES(EM
2013-08-05 12:56:10
643
原创 ocp-047-75 限制条件返回记录只有一条才可以
75. View the Exhibit and examine the structure of the EMPLOYEES table. You want to know the FIRST_NAME and SALARY for all employees who have the same manager as that of the employee with the first
2013-08-05 11:17:30
731
原创 ocp-047-69
69. View the Exhibit and examine the structure of the EMPLOYEES table. Evaluate the following SQL statement: SELECT employee_id, last_name, job_id, manager_id FROM employees START WITH employe
2013-08-05 10:31:22
768
原创 ocp-047-67 evaluate 是评估
68. The following are the steps for a correlated subquery , listed in random order: 1) The WHERE clause of the outer query is evaluated. 2) The candidate row is fetched from the t able specified
2013-08-02 22:13:14
733
原创 ocp-047-67
67. View the Exhibit and examine the structure of the ORDERS table. The columns ORDER_MODE and ORDER_TOTAL have the default values 'direct' and 0 respectively.Which two INSERT statements are valid
2013-08-02 16:54:43
710
转载 ocp-047-66
66. Which two statements are true regarding multiple-row subque ries? (Choose two.) A. They can contain group functions. B. They always contain a subquery within a subquery. C. They use the
2013-08-02 16:04:59
847
原创 ocp-047-61
61. Evaluate the following SQL statements that are issued in the given order: CREATE TABLE emp (emp_no NUMBER(2) CONSTRAINT emp_emp_no_pk PRIMARY KEY, ename VARCHAR2(15), salary NUMBER(8,2),
2013-08-02 15:38:20
913
原创 ocp-047-64
63. 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(
2013-08-02 15:20:20
575
原创 ocp-047-45
45. View the Exhibit and examine the structure of the CUSTOMERS table. CUSTOMER_VU is a view based on CUSTOMERS_BR1 table which has the same structure as CUSTOMERS table. CUSTOMERS needs to be upd
2013-08-01 13:48:22
871
原创 ocp-047-36（已解决）
36. Evaluate the following statements: CREATE TABLE digits (id NUMBER(2), description VARCHAR2(15)); INSERT INTO digits VALUES (1,'ONE'); UPDATE digits SET description ='TWO' WHERE id=1;
2013-08-01 09:32:00
1181
expert-oracle-architecture 2nd-edition-code.zip
2013-11-13
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人