单选题 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"?()
No change is required to achieve the desired results.
SELECT ename, sal, 12*(sal+100) FROM emp;
SELECT ename, sal, (12*sal)+100 FROM emp;
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?()
An error is returned.
You are prompted to enter a new value.
A report is produced that matches the first report produced.
You are asked whether you want a new value or if you want to run the report based on the previous value.
单选题 You added a PHONE_NUMBER column of NUMBER data type to an existing EMPLOYEES table. The EMPLOYEES table already contains records of 100 employees. Now, you want to enter the phone numbers of each of the 100 employees into the table. Some of the employees may not have a phone number available. Which data manipulation operation do you perform?()
MERGE
INSERT
UPDATE
ADD
ENTER
You cannot enter the phone numbers for the existing employee records.
单选题 In which scenario would TOP N analysis be the best solution? ()
You want to identify the most senior employee in the company.
You want to find the manager supervising the largest number of employees.
You want to identify the person who makes the highest salary for all employees.
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?()
SELECT*FROMemp_dept_vu;
SELECTdepartment_id,SUM(salary)FROMemp_dept_vuGROUPBYdepartment_id;
SELECTdepartment_id,job_id,AVG(salary)FROMemp_dept_vuGROUPBYdepartment_id,job_id;
SELECTjob_id,SUM(salary)FROMemp_dept_vuWHEREdepartment_idIN(10,20)GROUPBYjob_idHAVINGSUM(salary)>;20000;
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"?()
SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'fmDdspth of Month YYYY fmHH:MI:SS AM') NEW_DATE FROM dual;
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;
SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'fmDdspth of Month YYYY NEW _ DATE FROM dual;
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?()
SELECT last_name, department_name FROM employees NATURAL JOIN departments;
SELECT last_name, department_name FROM employees JOIN departments ;
SELECT last_name, department_name FROM employees e JOIN departments d ON (e.department_id = d.department_id);
SELECT last_name, department_name FROM employees e RIGHT OUTER JOIN departments d ON (e.department_id = d.department_id);
SELECT last_name, department_name FROM employees FULL JOIN departments ON (e.department_id = d.department_id);
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?()
in the INTO clause of an INSERT statement
in the FROM clause of a SELECT statement
in the GROUP BY clause of a SELECT statement
in the WHERE clause of a SELECT statement
in the SET clause of an UPDATE statement
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? ()
The two statements produce identical results.
The second statement returns a syntax error.
There is no need to specify DESC because the results are sorted in descending order by default.
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?()
To find the tax percentage for each of the employees.
To list the name, job id, and manager name for all the employees.
To find the name, salary, and department name of employees who are not working with Smith.
To find the number of employees working for the Administrative department and earning less then 4000.
To display name, salary, manager ID, and department name of all the employees, even if the employees do not have a department ID assigned.
在任何情况下,伸缩调节器处轨距的要求为()。
人类有两套影响学习的记忆系统:陈述性记忆和程序记忆。陈述性记忆是对事实或者词汇之类基本认识的记忆。而程序记忆,就是一个人“不劳而获”的记忆。程序记忆是人养成习惯和习得技巧的方式,比如骑自行车。在很多时候,这种学习是无意识的。人们用早期发育的程序记忆系统来学习复杂的东西,比如语法规则。帮助人们学习词汇的陈述性记忆系统,则需要更多时问完成发育。儿童拥有程序记忆系统,并且不受陈述性记忆系统的干扰。由此可以推出()。
宋末元初四大家
公平目标的实现可以通过()实现。
荟萃分析
人员安全疏散分析的性能判定标准为:可用疏散时间(A.SET)必须()必需疏散时间(RSET)。
预防HIV感染的主要措施应当为( )
简述我国混合型债券市场的发展状况。
造成水中某些污染物在生物体内含量大大高于水体中的浓度的生物放大作用是指()
输血的适应证中,不包括()