สถิติ ExactPapers Oracle 1Z0-001 2005.01...
คำถาม
39
กระดาษคำตอบ
14
สุ่มคำถาม
1400
ตอบถูก
0
ประเมินผล
0%
ผู้เยี่ยมชม
0%
ทำข้อสอบออนไลน์
G-Code
รหัสสำหรับทำข้อสอบออนไลน์ ยืนยันตัวตนด้วยการเสียบบัตรประชาชนบนเครื่องอ่านสมาร์ทการ์ด
QR-Code...
คำถาม ExactPapers Oracle 1Z0-001 2005.01...
39 รายการ | หน้าที่ 3 | 21-30
| Which select statement displays all the employees who do not have any subordinate. |
| Given the cursor statement: DECLARE CURSOR query_cursor(v_salary)IS SELECT last_name,salary,dept_no FROM employee WHERE SALARY>v_salary; Why does this statement cause an error |
| Examine the structure: EMP TABLE NAME NULL. TYPE EMP NUMBER NOT NULL NUMBER(4) VARCHER2 NUMBER(10) JOB VARCHAR2 NUMBER(2,9) MGR NUMBER(4) HARIDATE DATE SALARY NUMBER(7,2) COMM NUMBER(7,2) DEPT NO NOT NULL NUMBER(2) TAX TABLE NAME NULL. TYPE TAX GRADE NUMBER LOWSAL NUMBER HIGHSAL NUMBER You want to create a report that displays the employee details along with the tax category of each employee. The tax category is determined by comparing the salary of the employee from the emp table to the lower and the upper salary values in the tax table. Which select statement produces the required result |
| Examine the structure of the product and the part tables. There points a line from id PK to product_id PRODUCT id PK Name PART id PK Name Product_id Cost You issue this SQL statement: SELECT pr.name FROM part pt, product pr WHERE pt.product_id(+)=pr.id; What is the result |
| Which statement describes the use of a group function |
| Examine the structure of the department and employee table. There points a line from id PK to dept_id DEPARTMENT id PK Name EMPLOYEE id PK Last_ name First_name Dept_id Evaluate this SQL statement: CREATE INDEX emp_dept_id_idx ON employee(dept_id); Which result will this statement provide. |
| You issue this command: CREATE SYNONYM emp FOR ed.employee; Which task has been accomplished. |
| Examine this code : SELECT employee.ename FROM employee WHERE employee.empno NOT IN (SELECT manager.mgr FROM emp manager); What is not an operator equivalent to the above query. |
| You want to create a report that gives per department the number of employees and total salary as a percentage of all the departments. Examine the results from the report: DEPARTMENT %EMPLOYEES %SALARY 10 21. 4 30. 15 20 35. 71 37. 47 30 42. 86 32. 39 Which select statement produces the report |
| Evaluate these two SQL Commands 1 SELECT distinct object_type FROM user_objects; 2 SELECT object_type FROM all_objects; How will the results differ. |