2. What is true about joining tables through an equijoin?A) You can join a maximum of two tables through an equijoin.
B) You can join a maximum of two columns through an equijoin.
C) You specify an equijoin condition in the SELECT or FROM clauses of a SELECT statement.
D) To join two tables through an equijoin, the columns in the join condition must be primary key and foreign key columns.
E) You can join n tables (all having single column primary keys) in a SQL statement by specifying a minimum of n-1 join conditions.
3. The EMP table contains these columns:
LAST NAME VARCHAR2(25)
SALARY NUMBER(6,2)
DEPARTMENT_ID NUMBER(6)
You need to display the employees who have not been assigned to any department.
You write the SELECT statement:
SELECT LAST_NAME, SALARY, DEPARTMENT_ID FROM EMP WHERE DEPARTMENT_ID = NULL;
What is true about this SQL statement?
A) The SQL statement displays the desired results.
B) The column in the WHERE clause should be changed to display the desired results.
C) The operator in the WHERE clause should be changed to display the desired results.
D) The WHERE clause should be changed to use an outer join to display the desired results.
4. Please select the correct statements about Statement in JDBC.A) One PreparedSatement instance is compiled when it is run at the first time,
B) Statement is used to run simple SQL only once.
C) CallableSlatement is used to run stored procedure.
D) CallableStatement could register output parameter
15. Examine the description of the EMPLOYEES table:
EMP ID NUMBER(4) NOT NULL
LAST_NAME VARCHAR2(30) NOT NULL
FIRST_NAME VARCHAR2(30)
DEPT_ID NUMBER(2)
JOB_CAT VARCHARD2(30)
SALARY NUMBER(8,2)
Which statement shows the maximum salary paid in each job category of each department?
A) SELECT dept_id, job_cat, MAX(salary) FROM employees WHERE salary > MAX(salary);
B) SELECT dept_id, job_cat, MAX(salary) FROM employees GROUP BY dept_id,job_cat;
C) SELECT dept_id, job_cat, MAX(salary) FROM employees;
D) SELECT dept_id, job_cat, MAX(salary) FROM employees GROUP BY dept_id;
E) SELECT dept_id, job_cat, MAX(salary) FROM employees GROUP BY dept_id job_cat, salary;
B) You can join a maximum of two columns through an equijoin.
C) You specify an equijoin condition in the SELECT or FROM clauses of a SELECT statement.
D) To join two tables through an equijoin, the columns in the join condition must be primary key and foreign key columns.
E) You can join n tables (all having single column primary keys) in a SQL statement by specifying a minimum of n-1 join conditions.
3. The EMP table contains these columns:
LAST NAME VARCHAR2(25)
SALARY NUMBER(6,2)
DEPARTMENT_ID NUMBER(6)
You need to display the employees who have not been assigned to any department.
You write the SELECT statement:
SELECT LAST_NAME, SALARY, DEPARTMENT_ID FROM EMP WHERE DEPARTMENT_ID = NULL;
What is true about this SQL statement?
A) The SQL statement displays the desired results.
B) The column in the WHERE clause should be changed to display the desired results.
C) The operator in the WHERE clause should be changed to display the desired results.
D) The WHERE clause should be changed to use an outer join to display the desired results.
4. Please select the correct statements about Statement in JDBC.A) One PreparedSatement instance is compiled when it is run at the first time,
B) Statement is used to run simple SQL only once.
C) CallableSlatement is used to run stored procedure.
D) CallableStatement could register output parameter
15. Examine the description of the EMPLOYEES table:
EMP ID NUMBER(4) NOT NULL
LAST_NAME VARCHAR2(30) NOT NULL
FIRST_NAME VARCHAR2(30)
DEPT_ID NUMBER(2)
JOB_CAT VARCHARD2(30)
SALARY NUMBER(8,2)
Which statement shows the maximum salary paid in each job category of each department?
A) SELECT dept_id, job_cat, MAX(salary) FROM employees WHERE salary > MAX(salary);
B) SELECT dept_id, job_cat, MAX(salary) FROM employees GROUP BY dept_id,job_cat;
C) SELECT dept_id, job_cat, MAX(salary) FROM employees;
D) SELECT dept_id, job_cat, MAX(salary) FROM employees GROUP BY dept_id;
E) SELECT dept_id, job_cat, MAX(salary) FROM employees GROUP BY dept_id job_cat, salary;
解决方案 »
- Oracle SQL Developer 新建连接问题
- oracle异构mysql 求解
- 使用 logminer 分析日志出现 ORA-04030: out of process memory when trying to allocate 5148
- 如何输出字长符串
- Oracle的时间差是什么意思?
- 哪位大侠有oracle10g的教材呀
- Excel 如何把 statspack 生成的采样报告以报表的形式呈现
- 请教一个存储过程中未获取到数据集时如何处理的问题,详情见内!
- 着急的很
- 200万数据查询问题
- Win7上面装Oracle10g报错求助
- dbms_output.put_line()改變打印長度
3.C
4.ACD
5.B