网友您好，请在下方输入框内输入要搜索的题目：

搜题

题目内容（请给出正确答案）

提问人：网友fz_1981 发布时间：2022-01-07

[主观题]

The EMP table has these columns:ENAME VARCHAR2（35)SALARY NUMBER（8,2)HIRE_DATE DATEManageme

The EMP table has these columns:ENAME VARCHAR2(35)SALARY NUMBER(8,2)HIRE_DATE DATEManagement wants a list of names of employees who have been with the company for more than five years.Which SQL statement displays the required results？（）

A. SELECT ENAME FROM EMP WHERE SYSDATE-HIRE_DATE ＞5;

B. SELECT ENAME FROM EMP WHERE HIRE_DATE-SYSDATE ＞5;

C. SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)/365 ＞5;

D. SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)*/365 ＞5;

简答题官方参考答案（由简答题聘请的专业题库老师提供的解答）

查看官方参考答案

更多“The EMP table has these columns:ENAME VARCHAR2（35)SALARY NUMBER（8,2)HIRE_DATE DATEManageme”相关的问题

第1题

¿En qué año estableció el gobierno chino la ¨Semana de Oro¨ con el motivo del Día Nacional?

A、1982

B、1992

C、1999

D、

点击查看答案

第2题

The EMPLOYEES table has these columns:LAST_NAME VARCHAR2(35)SALARY NUMBER(8,2)HIRE_DATE DATEManagement wants to add a default value to the SALARY column. You plan to alter the table by using this SQL statement:ALTER TABLE EMPLOYEESMODIFY (SALARY DEFAULT 5000);Which is true about your ALTER statement?（）

A.Column definitions cannot be altered to add DEFAULT values.

B.A change to the DEFAULT value affects only subsequent insertions to the table.

C.Column definitions cannot be altered to add DEFAULT values for columns with a NUMBER data type.

D.All the rows that have a NULL value for the SALARY column will be updated with the value 5000.

点击查看答案

第3题

The STUDENT_GRADES table has these columns:STUDENT_ID NUMBER(12)SEMESTER_END DATEGPA NUMBER(4,3)The registrar has asked for a report on the average grade point average (GPA) for students enrolled during semesters that end in the year 2000. Which statement accomplish this? （）

A. SELECT AVERAGE(gpa) FROM student_grades WHERE semester _ end > ‘01-JAN-2000‘ and semester end <31-DEC-2000‘;

B. SELECT COUNT(gpa) FROM student grades WHERE semester _ end > ‘01-JAN-2000‘ and semester end <31-DEC-2000‘;

C. SELECT MIN(gpa) FROM student grades WHERE semester _ end > ‘01-JAN-2000‘ and semester end <31-DEC-2000‘;

D. SELECT AVG(gpa) FROM student_grades WHERE semester _ end BETWEEN ‘01-JAN-2000‘ and ‘31-DEC-2000‘;

E. SELECT SUM(gpa) FROM student grades WHERE semester _ end > ‘01-JAN-2000‘ and semester end <31-DEC-2000‘;

F. SELECT MEDIAN(gpa) FROM student_grades WHERE semester _ end > ‘01-JAN-2000‘ and semester end <31-DEC-2000‘;

点击查看答案

第4题

The STUDENT_GRADES table has these columns:STUDENT_ID NUMBER(12)SEMESTER_END DATEGPA NUMBER(4,3)The registrar requested a report listing the students‘ grade point averages (GPA) sorted from highest grade point average to lowest.Which statement produces a report that displays the student ID and GPA in the sorted order requested by the registrar?（）

A. SELECT student_id, gpa FROM student_grades ORDER BY gpa ASC;

B. SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa ASC;

C. SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa;

D. SELECT student_id, gpa FROM student_grades ORDER BY gpa;

E. SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa DESC;

F. SELECT student_id, gpa FROM student_grades ORDER BY gpa DESC;

点击查看答案

第5题

Examine the structure of the EMPLOYEES table:

EMPLOYEE_ID NUMBER Primary Key

FIRST_NAME VARCHAR2(25)

LAST_NAME VARCHAR2(25)

HIRE_DATE DATE

Which UPDATE statement is valid?（）

A. UPDATE employees SET first_name = 'John' SET last_name ='Smith' WHERE employee_id = 180;

B. UPDATE employees SET first_name = 'John', SET last_name ='Smith' WHERE employee_id = 180;

C. UPDATE employees SET first_name = 'John' AND last_name ='Smith' WHERE employee_id = 180;

D. UPDATE employees SET first_name = 'John', last_name ='Smith' WHERE employee_id = 180

点击查看答案

第6题

Examine the structure of the EMPLOYEES table:EMPLOYEE_ID NUMBER Primary KeyFIRST_NAME VARCHAR2(25)LAST_NAME VARCHAR2(25)HIRE_DATE DATEYou issue these statements:CREATE table new_emp ( employe_id NUMBER, name VARCGAR2(30)); INSERT INTO new_emp SELECT employee_id, last_name from employees; Savepoint s1;UPDATE new_emp set name = UPPER(name);Savepoint s2;Delete from new_emp;Rollback to s2;Delete from new_emp where employee_id=180;UPDATE new_emp set name = ‘James‘;Rollback to s2;UPDATE new_emp sey name = ‘James‘ Where employee_id=180;Rollback;At the end of this transaction, what is true?（）

A. You have no rows in the table.

B. You have an employee with the name of James.

C. You cannot roll back to the same savepoint more than once.

D. Your last update fails to update any rows because employee ID 180 was already deleted.

点击查看答案

第7题

Examine the structure of the EMPLOYEES table:EMPLOYEE_ID NUMBER Primary KeyFIRST_NAME VARCHAR2(25)LAST_NAME VARCHAR2(25)HIRE_DATE DATEYou issue these statements:CREATE table new_emp ( employee_id NUMBER, name VARCHAR2(30)); INSERT INTO new_emp SELECT employee_id , last_name from employees;Savepoint s1;UPDATE new_emp set name = UPPER(name);Savepoint s2;Delete from new_emp;Rollback to s2;Delete from new_emp where employee_id =180;UPDATE new_emp set name = ‘James‘;Rollback to s2;UPDATE new_emp set name = ‘James‘ WHERE employee_id =180;Rollback;At the end of this transaction, what is true?（）

A.You have no rows in the table.

B.You have an employee with the name of James.

C.You cannot roll back to the same savepoint more than once.

D.Your last update fails to update any rows because employee ID 180 was already deleted.

点击查看答案

第8题

Examine the structure of the EMPLOYEES table:Column name Data type RemarksEMPLOYEE_ID NUMBER NOT NULL, Primary KeyLAST_NAME VARCNAR2(30)FIRST_NAME VARCNAR2(30)JOB_ID NUMBERSAL NUMBERMGR_ID NUMBER References EMPLOYEE_ID columnDEPARTMENT_ID NUMBERYou need to create an index called NAME_IDX on the first name and last name fields of the EMPLOYEES table. Which SQL statement would you use to perform this task?（）

A. CREATE INDEX NAME _IDX (first_name, last_name);

B. CREATE INDEX NAME _IDX (first_name, AND last_name)

C. CREATE INDEX NAME_IDX ON (First_name, last_name);

D. CREATE INDEX NAME_IDX ON employees (First_name, AND last_name);

E. CREATE INDEX NAME_IDX ON employees (First_name, last_name);

F. CREATE INDEX NAME_IDX FOR employees (First_name, last_name);

点击查看答案

第9题

Youconfiguredtheflashrecoveryareainthedatabase.Whichtwofileswouldyouexpecttofindintheflashrecoveryarea?()

A.backuppieces

B.copiesofalltheparameterfiles

C.tracefilegeneratedusingBACKUPCONTROLFILETOTRACE

D.controlfileautobackups

点击查看答案

账号：尚未登录

登录没有账号？去注册

搜题记录

联系客服

购买搜题卡

考试指南全部 >

自考本科在哪里考报名流程是怎样 2024年每年自考本科的报名时间考哪些内容 2024年女生最实用的自考专业含金量高的推荐 2024年成人高考和成人自考哪个更好有什么区别 2024年自考本科网上报名条件考试科目有什么 2024成人高中学历怎么提升学历考哪些内容 2024年自考成人本科考哪些科目合格标准是多少 2024年自考什么时候报名考哪些内容 2024年本科自考报考时间考哪些内容 2024年自考本科在哪里报名报考条件有哪些

购买搜题卡查看答案

购买前请仔细阅读《购买须知》

请选择支付方式

微信支付

支付宝支付

点击支付即表示你同意并接受《服务协议》和《购买须知》

立即支付已付款，但不能查看答案，请点这里登录即可>>

搜题卡使用说明

1. 搜题次数扣减规则：

功能	扣减规则
功能	基础费（查看答案）	加收费（AI功能）
文字搜题、查看答案	1/每题	0/每次
语音搜题、查看答案	1/每题	2/每次
单题拍照识别、查看答案	1/每题	2/每次
整页拍照识别、查看答案	1/每题	5/每次