สถิติ ExactPapers Oracle 1Z0-001 2005.01...
คำถาม
39
กระดาษคำตอบ
14
สุ่มคำถาม
1400
ตอบถูก
0
ประเมินผล
0%
ผู้เยี่ยมชม
0%
ทำข้อสอบออนไลน์
G-Code
รหัสสำหรับทำข้อสอบออนไลน์ ยืนยันตัวตนด้วยการเสียบบัตรประชาชนบนเครื่องอ่านสมาร์ทการ์ด
QR-Code...
คำถาม ExactPapers Oracle 1Z0-001 2005.01...
39 รายการ | หน้าที่ 2 | 11-20
| A DBA has updated Smiths account by adding the privileges. Create any table and create procedure. Which task can Smith successfully perform. |
| Which data dictionary view contains the definition of a view. |
| Employee Table exhibit: ***MISSING*** Click on the exhibit button and examine the employee table. You create a view with this command: CREATE VIEW dept_salary_vu AS SELECT dept_no, salary, last_name FROM employee WHERE salary>45000. WITH CHECK OPTION; For which employee can you update the dept_no column using this view |
| You need to retrieve the employee names and salaries from emp tables assorted by the salary in descending order. If two names match for a salary then two names must be displayed in alphabetical order. Which statement produces the required results. |
| The employee table has ten columns. Since you often query the table with condition based on four or more columns, you created an index on all the columns in the table. Which result will occur |
| Examine the table instance chart for the employee table. Column name ID_NO NAME SALARY DEPT_NO HIRE_DATE Key type PK FK Nulls/unique NN, UU NN FK table DEPARMENT FK column DEPT_NO Data type NUM VARCHAR2 NUM NUM DATE Length 9 25 8,2 3 You want to display employee hire date from the earliest to latest. Which SQL statement would you use. |
| Examine the table instance chart for the patient table. Column name Id_number Last_name first_name birth_date doctor_id Key type PK Nulls/Unique NN, UU NN NN FK table DOCTOR FK column ID_NUMBER Data type NUM VARCHAR2 VARCHAR2 DATE NUM Length 10 25 25 10 You created the patient_vu view based on the id_number and last_name columns from the patient table. What is the best way to modify the view to contain only those patients born in 1997. |
| Exhibit button and examine the employee table. ID NO LAST_NAME FIRST_NAME SALARY DEPT_NO 7 Brown Terry 30000 255 6 Wargner Julie 233 4 southall david 25000 102 3 chiazza mike 50000 2 limber john 32000 145 5 goldberg Kelvin 233 1 lomberg susan 55000 8 oliver tracey 145 You attempt to query the database with this command: SELECT dept_no,last_name,SUM(salary) FROM employee WHERE salary<50000 GROUP BY dept_no ORDER BY last_name; Which clause causes an error. |
| You attempt to create the salary table with this command: 1. CREATE TABLE SALARY. 2. (employee_id NUMBER(9) 3. CONSTRAINT salary_pk PRIMARY KEY, 4. 1995_salary NUMBER(8,2), 5. NUMBER_manager_name VARCHAR2(25) 6. CONSTRAINT mgr_name_nn NOT NULL, 7. $_salary_96 NUMBER(8,2)); Which two lines of the statement will return errors. (Choose two) |
| Which select statement displays the order id product id and quantity of items in the item table that matches both the product id and quantity of an item order(605). Do not display the details of the order 605. |