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
您可能感兴趣的试卷
你可能感兴趣的试题
Examine the SQL statement that creates ORDERS table:
CREATE TABLE orders
(SER_NO NUMBER UNIQUE,
ORDER_ID NUMBER,
ORDER_DATE DATE NOT NULL,
STATUS VARCHAR2(10)
CHECK (status IN ('CREDIT', 'CASH')),
PROD_ID NUMBER
REFERENCES PRODUCTS(PRODUCT_ID),
ORD_TOTAL NUMBER,
PRIMARY KEY (order_id, order_date));
For which columns would an index be automatically created when you execute the above SQL statement? ()
A.SER_NO
B.ORDER_ID
C.STATUS
D.PROD_ID
E.ORD_TOTAL
F.composite index on ORDER_ID and ORDER_DATE
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;
Evaluate the set of SQL statements:
CREATE TABLE dept
(deptno NUMBER(2),
dname VARCHAR2(14),
loc VARCHAR2(13));
ROLLBACK;
DESCRIBE DEPT
What is true about the set?()
A.The DESCRIBE DEPT statement displays the structure of the DEPT table.
B.The ROLLBACK statement frees the storage space occupied by the DEPT table.
C.The DESCRIBE DEPT statement returns an error ORA-04043: object DEPT does not exist.
D.The DESCRIBE DEPT statement displays the structure of the DEPT table only if there is a COMMIT statement introduced before the ROLLBACK statement.
A.COMMIT
B.MERGE
C.UPDATE
D.DELETE
E.CREATE
F.DROP...
A. 46 and 45
B. 46 and 45.93
C. 50 and 45.93
D. 50 and 45.9
E. 45 and 45.93
F. 45.95 and 45.93
Examine the structure of the EMPLOYEES table:
EMPLOYEE_ID NUMBER Primary Key
FIRST_NAME VARCHAR2(25)
LAST_NAME VARCHAR2(25)
Which three statements insert a row into the table? ()
A.INSERT INTO employees VALUES ( NULL, 'John', 'Smith');
B.INSERT INTO employees( first_name, last_name) VALUES( 'John', 'Smith');
C.INSERT INTO employees VALUES ( '1000', 'John', NULL);
D.INSERT INTO employees (first_name, last_name, employee_id) VALUES ( 1000, 'John', 'Smith');
E.INSERT INTO employees (employee_id) VALUES (1000);
F.INSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, 'John', ' ');
最新试题
Which one is a system privilege? ()
The user Alice wants to grant all users query privileges on her DEPT table. Which SQL statement accomplishes this? ()
Evaluate these two SQL statements: SELECT last_name, salary, hire_dateFROM EMPLOYEES ORDRE BY salary DESC; SELECT last_name, salary, hire_dateFROM EMPOLYEES ORDER BY 2 DESC; What is true about them? ()
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary KeyFIRST_NAME VARCHAR2(25)LAST_NAME VARCHAR2(25)HIRE_DATE DATEWhich INSERT statement is valid? ()
Evaluate this SQL statement:SELECT e.emp_name, d.dept_nameFROM employees eJOIN departments dUSING (department_id)WHERE d.department_id NOT IN (10,40)ORSER BY dept_name;The statement fails when executed. Which change fixes the error? ()
Examine the structure of the STUDENTS table:STUDENT_ID NUMBER NOT NULL, Primary KeySTUDENT_NAME VARCHAR2(30)COURSE_ID VARCHAR2(10) NOT NULLMARKS NUMBERSTART_DATE DATEFINISH_DATE DATEYou need to create a report of the 10 students who achieved the highest ranking in the course INT SQL and who completed the course in the year 1999.Which SQL statement accomplishes this task? ()
You need to perform these tasks:1. Create and assign a MANAGER role to Blake and Clark2. Grant CREATE TABLE and CREATE VIEW privileges to Blake and ClarkWhich set of SQL statements achieves the desired results? ()
Evaluate the SQL statement: TRUNCATE TABLE DEPT; Which three are true about the SQL statement? ()
Which statement correctly describes SQL and /SQL*Plus? ()
Examine these statements:CREATE ROLE registrarGRANT UPDATE ON dtudent_grades TO registrar;GRANT registrar to user1, user2, user3;What does this set of SQL statements do? ()