Sandy’socp1z0-001Exam
添加时间: 2008-4-27 0:45:58 作者: Oracle指导 阅读次数:14 来源: http://www.d9soft.com
85. IN WHICH SITUATION WOULD YOU USE AN OUTER QUERY?
THE EMPLOYEE TABLE COLUMN CORRESPONDING TO THE REGIN TABLE
CONTAIN NULL VALUES FOR ROWS THAT NEED TO BE DISPLAYED
86. YOU ATTEMPT TO QUERY THE DATABASE WITH THIS COMMAND
SELECT NAME, SALARY FROM EMPLOYEE
WHERE SALARY = (SELECT SALARY FROM EMPLOYEE WHERE
LAST_NAME = AGNER?OR DEPT_NO = 233)
WHY COULD THIS STATEMENT CAUSE AN ERROR
ANS: A MULTIPLE ROW SUBQUERY IS USED WITH A SINGLE ROW COMPARISON OPERATOR
87. WHICH STATEMENT SHOWS THE VIEW DEFINATION OF THE VIEW EMP_VIEW THAT IS CREATED BASED ON THE EMP TABLE
ANS SELECT TEXT FROM USER_VIEWS WHERE VIEW_NAME = MP_VIEW?
88. EXAMINE THE STRUCTURE OF THE BOOK_TITLE, COPY AND CHECK_OUT TABLES
BOOK_TITLE
ID PK TITLE AUTHOR
COPY
ID PK TITLE IDPK AVAILABLE
CHECKOUT
ID PK COPY_ID TITLE_ID CHECK_OUT_DATE
- EXPECTED_RETURN_DATE CUSTOMER_ID
YOU NEED TO CREATE THE BOOKS_AVAILABLE VIEW THESE ARE THE DESIRED RESULT
1. INCLUDE THE TITLE OF THE EACH BOOK
2. INCUDE THE AVAILABILITY OF EACH BOOK
3. ORDER THE RESULT BY THE AUTHOR EVALUATE THIS SQL STATEMENT
CREATE VIEW BOOKS_AVAILABLE AS
SELECT B.TITLE, C.AVAILABLE FROM BOOK_TITLE B, COPY C
WHERE B.ID = C.TITLE_ID ORDER BY B.AUTHOR
WHAT DOES THIS STATEMENT PROVIDE
ANS A SYNTEX ERROR
89. THE EMPLOYEE TABLE CONTAINS THREE COLUMNS, 2 OF WHICH ARE
BONUS NUMBER (7,2)
DEPT_ID NUMBER (9)
THERE ARE THREE DEPARTMENT AND EACH DEPARTMENT HAS AT LEAST ONE EMPLOYEE BONUS VALUE BONUS VALUES ARE GREATE THAN 500 AND NOT ALL EMPLOYEES RECEIVE A BONUS EVALUATE THIS PL/SQL BLOCK
DECLARE
V_BONUS EMPLOYEES.BONUS%TYPE := 300;
BEGIN
UPDATE EMPLOYEE
SET BONS = BONUS + V_BONUS
WHERE DEPT_ID IN (10,20,30) ;
COMMIT;
END;
WHAT WILL BE THE RESULT
ANS: A SUBSET OF EMPLOYEES WILL BE GIVEN A $300 INCREASE IN BONUS
90. YOU HAVE BEEN GRANTED UPDATE PRIVILEGES ON THE LAST_NAME COLUMN OF THE EMPLOYEE TABLE WHICH DATA DICTIONARY VIEW WOULD YOU QUERY TO DISPLAY THE COLUMN THE PRIVILEGES WAS GRANTED ON THE SCHEMA THAT OWNS THE EMPLOYEE TABLE
ANS ALL_COL_PRIVS_RECD.
91. WHICH ALTER COMMAND WOULD YOU USE TO REINSTATE A DISABLE PRIMARY RE-CONSTRAINT.
ANS ALTER TABLE CARS ENABLE CONSTRAINT CARS_ID_PK
Sandy’socp1z0-001Exam(5) 第 [1] [2] [3] [4] [5] 下一页
上下文章:
上一篇文章: 深入了解Oracle10g中新型层次查询选项 下一篇文章: 案例学习Oracle错误：ORA-00904
相关文章:
相关软件: