niusouti.com

单选题The EMP table contains these columns: EMPLOYEE_ID NUMBER(4) EMPNAME VARCHAR2 (25) SALARY NUMBER(9,2) HIRE_DATE DATE You query the database with this SQL statement: SELECT empname,hire_date HIREDATE, salary FROM EMP ORDER BY hire_date; How will the resu

题目
单选题
The EMP table contains these columns: EMPLOYEE_ID NUMBER(4) EMPNAME VARCHAR2 (25) SALARY NUMBER(9,2) HIRE_DATE DATE You query the database with this SQL statement: SELECT empname,hire_date HIREDATE, salary FROM EMP ORDER BY hire_date; How will the results be sorted?（）
A

randomly

B

ascending by date

C

descending by date

D

ascending alphabetically

E

descending alphabetically

相似考题

1.Which is a valid CREATE TABLE statement? ()A. CREATE TABLE EMP9$# AS (empid number(2));B. CREATE TABLE EMP*123 AS (empid number(2));C. CREATE TABLE PACKAGE AS (packid number(2));D. CREATE TABLE 1EMP_TEST AS (empid number(2));

2. The EMP table contains these columns: EMPLOYEE_ID NUMBER(4) EMPNAME VARCHAR2 (25) SALARY NUMBER(9,2) HIRE_DATE DATE You query the database with this SQL statement: SELECT empname,hire_date HIREDATE, salary FROM EMP ORDER BY hire_date; How will the results be sorted?（）A、randomlyB、ascending by dateC、descending by dateD、ascending alphabeticallyE、descending alphabetically

3.单选题Examine the structure if the EMPLOYEES table: Column name Data Type Remarks EMPLOYEE_ID NUMBER NOT NULL, Primary Key EMP_NAME VARCHAR2(30) JOB_ID VARCHAR2(20) NOT NULL SAL NUMBER MGR_ID NUMBER References EMPLOYEE_ID column DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID column of the DEPARTMENTS table You need to create a view called EMP_VU that allows the user to insert rows through the view. Which SQL statement, when used to create the EMP_VU view, allows the user to insert rows?（）A CREATE VIEW emp_Vu AS SELECT employee_id, emp_name, department_id FROM employees WHERE mgr_id IN (102, 120);B CREATE VIEW emp_Vu AS SELECT employee_id, emp_name, job_id department_id FROM employees WHERE mgr_id IN (102, 120);C CREATE VIEW emp_Vu AS SELECT department_id, SUM(sal) TOTALSAL FROM employees WHERE mgr_id IN (102, 120) GROUP BY department_ id;D CREATE VIEW emp_Vu AS SELECT employee_id, emp_name, job_id, DISTINCT department_id FROM employees;

4.The EMP table contains these columns:EMPLOYEE_ID NUMBER(4)EMPNAME VARCHAR2 (25)SALARY NUMBER(9,2)HIRE_DATE DATEYou query the database with this SQL statement:SELECT empname,hire_date HIREDATE, salaryFROM EMPORDER BY hire_date;How will the results be sorted?（）A.randomlyB.ascending by dateC.descending by dateD.ascending alphabeticallyE.descending alphabetically

更多“The EMP table contains these columns: EMPLOYEE_ID NUMBER(4)”相关问题

  • 第1题：

    单选题
    The EMP table contains these columns: EMPLOYEE_ID NUMBER(4) EMPNAME VARCHAR2 (25) SALARY NUMBER(9,2) HIRE_DATE DATE You query the database with this SQL statement: SELECT empname,hire_date HIREDATE, salary FROM EMP ORDER BY hire_date; How will the results be sorted?（）
    A

    randomly

    B

    ascending by date

    C

    descending by date

    D

    ascending alphabetically

    E

    descending alphabetically


    正确答案： D
    解析： 暂无解析

  • 第2题：

    单选题
    Which SQL statement defines a FOREIGN KEY constraint on the DEPTNO column of the EMP table?（）
    A

    CREATE TABLE EMP (empno NUMBER(4), ename VARCHAR2(35), deptno NUMBER(7,2) NOT NULL, CONSTRAINT emp_deptno_fk FOREIGN KEY deptno REFERENCES dept deptno);

    B

    CREATE TABLE EMP (empno NUMBER(4), ename VARCHAR2(35), deptno NUMBER(7,2) CONSTRAINT emp_deptno_fk REFERENCES dept (deptno));

    C

    CREATE TABLE EMP (empno NUMBER(4), ename VARCHAR2(35), deptno NUMBER(7,2) NOT NULL, CONSTRAINT emp_deptno_fk REFERENCES dept (deptno) FOREIGN KEY (deptno));

    D

    CREATE TABLE EMP (empno NUMBER(4), ename VARCHAR2(35), deptno NUMBER(7,2) FOREIGN KEY CONSTRAINT emp_deptno_fk REFERENCES dept (deptno));


    正确答案： A
    解析： 暂无解析

  • 第3题：

    单选题
    The EMPLOYEES table contains these columns: EMPLOYEE_ID NUMBER(4) LAST_NAME VARCHAR2 (25) JOB_ID VARCHAR2(10) You want to search for strings that contain 'SA_' in the JOB_ID column. Which SQL statement do you use?（）
    A

    SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA/_%' ESCAPE '/';

    B

    SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA_';

    C

    SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA_' ESCAPE /;

    D

    SELECT employee_id, last_name, job_id FROM employees WHERE job_id = '%SA_';


    正确答案： B
    解析： 暂无解析

  • 第4题：

    多选题
    Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER NOT NULL, Primary Key EMP_NAME VARCHAR2(30) JOB_ID NUMBER/ SAL NUMBER MGR_ID NUMBER References EMPLOYEE_ID column DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID column of the DEPARTMENTS table You created a sequence called EMP_ID_SEQ in orderto populate sequential values for the EMPLOYEE_ID column of the EMPLOYEES table. Which two statements regarding the EMP_ID_SEQ sequence are true? （）
    A

    You cannot use the EMP_ID_SEQ sequence to populate the JOB_ID column.

    B

    The EMP_ID_SEQ sequence is invalidated when you modify the EMPLOYEE_ID column.

    C

    The EMP_ID_SEQ sequence is not affected by modifications to the EMPLOYEES table.

    D

    Any other column of NUMBER data type in your schema can use the EMP_ID_SEQ sequence.

    E

    The EMP_ID_SEQ sequence is dropped automatically when you drop the EMPLOYEES table.

    F

    The EMP_ID_SEQ sequence is dropped automatically when you drop the EMPLOYEE_ID column.


    正确答案： F,A
    解析： 暂无解析

  • 第5题：

    单选题
    Examine the structure of the EMPLOYEES table: Column name Data type Remarks EMPLOYEE_ID NUMBER NOT NULL, Primary Key EMP_NAME VARCHAR2(30) JOB_ID VARCHAR2(20) NOT NULL SAL NUMBER MGR_ID NUMBER References EMPLOYEE_ID column DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID column of the DEPARTMENTS table You need to create a view called EMP_VU that allows the users to insert rows through the view. Which SQL statement, when used to create the EMP_VU view, allows the users to insert rows?（）
    A

    CREATE VIEW emp_vu AS SELECT employee_id, emp_name, department_id FROM employees WHERE mgr_id IN (102, 120);

    B

    CREATE VIEW emp_vu AS SELECT employee_id, emp_name, job_id, department_id FROM employees WHERE mgr_id IN (102, 120);

    C

    CREATE VIEW emp_vu AS SELECT department_id, SUM(sal) TOTALSAL FROM employees WHERE mgr_id IN (102, 120) GROUP BY department_id;

    D

    CREATE VIEW emp_vu AS SELECT employee_id, emp_name, job_id, DISTINCT department_id FROM employees;


    正确答案： D
    解析： 暂无解析

  • 第6题：

    单选题
    Which SQL statement defines the FOREIGN KEY constraint on the DEPTNO column of the EMP table?（）
    A

    CREATE TABLE EMP (empno NUMBER(4), ename VARCNAR2(35), deptno NUMBER(7,2) NOT NULL CONSTRAINT emp_deptno_fk FOREIGN KEY deptno REFERENCES dept deptno);

    B

    CREATE TABLE EMP (empno NUMBER(4), ename VARCNAR2(35), deptno NUMBER(7,2) CONSTRAINT emp_deptno_fk REFERENCES dept (deptno));

    C

    CREATE TABLE EMP (empno NUMBER(4) ename VARCHAR2(35), deptno NUMBER(7,2) NOT NULL, CONSTRAINT emp_deptno_fk REFERENCES dept (deptno) FOREIGN KEY (deptno));

    D

    CREATE TABLE EMP (empno NUMBER(4), ename VARCNAR2(35), deptno NUMBER(7,2) FOREIGN KEY CONSTRAINT emp deptno fk REFERENCES dept (deptno));


    正确答案： C
    解析： 暂无解析

  • 第7题：

    多选题
    Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER NOT NULL, Primary Key EMP_NAME VARCHAR2(30) JOB_ID NUMBER SAL NUMBER MGR_ID NUMBER References EMPLOYEE_ID column DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID column of the DEPARTMENTS table You created a sequence called EMP_ID_SEQ in order to populate sequential values for the EMPLOYEE_ID column of the EMPLOYEES table. Which two statements regarding the EMP_ID_SEQ sequence are true? （）
    A

    You cannot use the EMP_ID_SEQ sequence to populate the JOB_ID column.

    B

    The EMP_ID_SEQ sequence is invalidated when you modify the EMPLOYEE_ID column.

    C

    The EMP_ID_SEQ sequence is not affected by modifications to the EMPLOYEES table.

    D

    Any other column of NUMBER data type in your schema can use the EMP_ID_SEQ sequence.

    E

    The EMP_ID_SEQ sequence is dropped automatically when you drop the EMPLOYEES table.

    F

    The EMP_ID_SEQ sequence is dropped automatically when you drop the EMPLOYEE_ID column.


    正确答案： B,E
    解析： 暂无解析

  • 第8题：

    单选题
    You created a view called EMP_DEPT_VU that contains three columns from the EMPLOYEES and DEPARTMENTS tables: EMPLOYEE_ID, EMPLOYEE_NAME AND DEPARTMENT_NAME. The DEPARTMENT_ID column of the EMPLOYEES table is the foreign key to the primary key DEPARTMENT_ID column of the DEPARTMENTS table. You want to modify the view by adding a fourth column, MANAGER_ID of NUMBER data type from the EMPLOYEES tables. How can you accomplish this task?（）
    A

    ALTER VIEW EMP_dept_vu (ADD manger_id NUMBER);

    B

    MODIFY VIEW EMP_dept_vu (ADD manger_id NUMBER);

    C

    ALTER VIEW emp_dept_vu AS SELECT employee_id, employee_name, department_name, manager_id FROM employee e, departments d WHERE e.department _ id = d.department_id;

    D

    MODIFY VIEW emp_dept_vu AS SELECT employee_id, employee_name, department_name, manager_id FROM employees e, departments d WHERE e.department _ id = d.department_id;

    E

    CREATE OR REPLACE VIEW emp_dept_vu AS SELECT employee_id, employee_name, department_name, manager_id FROM employees e, departments d WHERE e.department _ id = d.department_id;

    F

    You must remove the existing view first, and then run the CREATE VIEW command with a new column list to modify a view.


    正确答案： F
    解析： 暂无解析

  • 第9题：

    多选题
    Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER NOT NULL, Primary Key EMP_NAME VARCHAR2(30) JOB_ID NUMBER SAL NUMBER MGR_ID NUMBER References EMPLOYEE_ID column DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID column of the DEPARTMENTS table You created a sequence called EMP_ID_SEQ in order to populate sequential values for the EMPLOYEE_ID column of the EMPLOYEES table. Which two statements regarding the EMP_ID_SEQ sequence are true? （）
    A

    You cannot use the EMP_ID_SEQ sequence to populate the JOB_ID column.

    B

    The EMP_ID_SEQ sequence is invalidated when you modify the EMPLOYEE_ID column.

    C

    The EMP_ID_SEQ sequence is not affected by modifications to the EMPLOYEES table.

    D

    Any other column of NUMBER data type in your schema can use the EMP_ID_SEQ sequence.

    E

    The EMP_ID_SEQ sequence is dropped automatically when you drop the EMPLOYEES table.

    F

    The EMP_ID_SEQ sequence is dropped automatically when you drop the EMPLOYEE_ID column.


    正确答案： C,B
    解析： 暂无解析

  • 第10题：

    单选题
    Which is a valid CREATE TABLE statement?（）
    A

    CREATE TABLE EMP9$# AS (empid number(2));

    B

    CREATE TABLE EMP*123 AS (empid number(2));

    C

    CREATE TABLE PACKAGE AS (packid number(2));

    D

    CREATE TABLE 1EMP_TEST AS (empid number(2));


    正确答案： D
    解析： 暂无解析

  • 第11题：

    单选题
    Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE You 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.


    正确答案： D
    解析： 暂无解析

  • 第12题：

    单选题
    Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE You 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.


    正确答案： C
    解析： 暂无解析

  • 第13题：

    单选题
    Management has asked you to calculate the value 12*salary* commission_pct for all the employees in the EMP table. The EMP table contains these columns: LAST NAME VARCNAR2(35) NOT NULL SALARY NUMBER(9,2) NOT NULL COMMISION_PCT NUMBER(4,2) Which statement ensures that a value is displayed in the calculated columns for all employees?（）
    A

    SELECT last_name, 12*salary* commission_pct FROM emp;

    B

    SELECT last_name, 12*salary* (commission_pct,0) FROM emp;

    C

    SELECT last_name, 12*salary*(nvl(commission_pct,0)) FROM emp;

    D

    SELECT last_name, 12*salary*(decode(commission_pct,0)) FROM emp;


    正确答案： B
    解析： 暂无解析

相关内容