DBA_SCHEDULER_JOB_RUN_DETAILS
DBA_SCHEDULER_RUNNING_JOBS
DBA_SCHEDULER_JOBS
DBA_SCHEDULER_JOB_LOG
第1题:
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 keyDEPARTMENT_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.
第2题:
第3题:
What are you recommended to answer the question tell me about yourself, if you are seeking for your first job?
A.Speak much about how that job appeals to you and caused you to apply for it.
B.Speak much about how your enthusiasm about an area has driven you to want that job.
C.Speak much about how a book you’ve read or a person you’ve known motivated you to get that job.
D.Speak much about how your past experiences made you decide to compete for that job.
第4题:
Which version of a view would you use if you just want a quick, easy view within your XPage?()
第5题:
You want to purge job entries older than 5 days from the job log. You do not want to purge window log entries. Which command will you use to accomplish this task?()
第6题:
Why do you want a new job ______you've got such a good one already?
A. that
B. where
C. which
D. when
17.答案为D。为什么你已经有个好工作,还要找新工作?分析整句结构,从句做状语,只有 D为正确选项。
第7题:
第8题:
Before sending your resume to prospective employers
or scheduling any interviews , you need to analyze the job market. Analyzing the job market involves determining actual job
openings and gathering information about organizations for which you want to work.
第9题:
In which three cases would you use the USING clause?()
第10题:
Which view will you use to view information regarding the jobs that are currently running in a database?()