移动端

  • 题王微信公众号

    题王微信公众号

    微信搜“题王网”真题密题、最新资讯、考试攻略、轻松拿下考试

计算机考试 | Oracle认证考试

模式切换

0 0 0
我的错题 我的收藏 学习笔记

章节目录

单选题 Evaluate this SQL statement: SELECT ename, sal, 12*sal+100 FROM emp; The SAL column stores the monthly salary of the employee. Which change must be made to the above syntax to calculate the annual compensation as "monthly salary plus a monthly bonus of $100, multiplied by 12"?()

A

No change is required to achieve the desired results.

B

SELECT ename, sal, 12*(sal+100) FROM emp;

C

SELECT ename, sal, (12*sal)+100 FROM emp;

D

SELECT ename, sal+100,*12 FROM emp;

单选题 Examine this statement: SELECT student_id, gpa FROM student_grades WHERE gpa > &&value; You run the statement once, and when prompted you enter a value of 2.0. A report is produced. What happens when you run the statement a second time?()

A

An error is returned.

B

You are prompted to enter a new value.

C

A report is produced that matches the first report produced.

D

You are asked whether you want a new value or if you want to run the report based on the previous value.

单选题 In which scenario would TOP N analysis be the best solution? ()

A

You want to identify the most senior employee in the company.

B

You want to find the manager supervising the largest number of employees.

C

You want to identify the person who makes the highest salary for all employees.

D

You want to rank the top three sales representatives who have sold the maximum number of products.

单选题 Examine the structure of the EMP_DEPT_VU view: Column Name Type Remarks EMPLOYEE_ID NUMBER From the EMPLOYEES table EMP_NAME VARCHAR2(30) From the EMPLOYEES table JOB_ID VARCHAR2(20) From the EMPLOYEES table SALARY NUMBER From the EMPLOYEES table DEPARTMENT_ID NUMBER From the DEPARTMENTS table DEPT_NAME VARCHAR2(30) From the DEPARTMENTS table Which SQL statement produces an error?()

A

SELECT*FROMemp_dept_vu;

B

SELECTdepartment_id,SUM(salary)FROMemp_dept_vuGROUPBYdepartment_id;

C

SELECTdepartment_id,job_id,AVG(salary)FROMemp_dept_vuGROUPBYdepartment_id,job_id;

D

SELECTjob_id,SUM(salary)FROMemp_dept_vuWHEREdepartment_idIN(10,20)GROUPBYjob_idHAVINGSUM(salary)>;20000;

E

Noneofthestatementsproduceanerror;allarevalid

单选题 Which SQL statement displays the date March 19, 2001 in a format that appears as "Nineteenth of March 2001 12:00:00 AM"?()

A

SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'fmDdspth of Month YYYY fmHH:MI:SS AM') NEW_DATE FROM dual;

B

SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'Ddspth of Month YYYY fmHH:MI:SS AM') NEW_DATE HH:MI:SS AM') NEW _ DATE FROM dual;

C

SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'fmDdspth of Month YYYY NEW _ DATE FROM dual;

D

SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY), 'fmDdspth of Month YYYYfmtHH:HI:SS AM')NEW_DATE FROM dual;

单选题 Click the Exhibit button and examine the data in the EMPLOYEES and DEPARTMENTS tables. You want to retrieve all employees, whether or not they have matching departments in the departments table. Which query would you use?()

A

SELECT last_name, department_name FROM employees NATURAL JOIN departments;

B

SELECT last_name, department_name FROM employees JOIN departments ;

C

SELECT last_name, department_name FROM employees e JOIN departments d ON (e.department_id = d.department_id);

D

SELECT last_name, department_name FROM employees e RIGHT OUTER JOIN departments d ON (e.department_id = d.department_id); 

E

SELECT last_name, department_name FROM employees FULL JOIN departments ON (e.department_id = d.department_id);

F

SELECT last_name, department_name FROM employees e LEFT OUTER JOIN departments d ON (e.department_id = d.department_id);

多选题 In which four clauses can a subquery be used?()

A

in the INTO clause of an INSERT statement

B

in the FROM clause of a SELECT statement

C

in the GROUP BY clause of a SELECT statement

D

in the WHERE clause of a SELECT statement

E

in the SET clause of an UPDATE statement

F

in the VALUES clause of an INSERT statement

单选题 Evaluate these two SQL statements: SELECT last_name, salary , hire_date FROM EMPLOYEES ORDER BY salary DESC; SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY 2 DESC; What is true about them? ()

A

The two statements produce identical results.

B

The second statement returns a syntax error.

C

There is no need to specify DESC because the results are sorted in descending order by default.

D

The two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement.

单选题 Examine the structure of the EMPLOYEES, DEPARTMENTS, and TAX tables. For which situation would you use a nonequijoin query?()

A

To find the tax percentage for each of the employees.

B

To list the name, job id, and manager name for all the employees.

C

To find the name, salary, and department name of employees who are not working with Smith.

D

To find the number of employees working for the Administrative department and earning less then 4000.

E

To display name, salary, manager ID, and department name of all the employees, even if the employees do not have a department ID assigned.

最新资讯

首页 上一页 1 2 3 4 5 下一页 尾页 /

到第