สถิติ ExactPapers Oracle 1Z0-001 2005.01...
คำถาม
39
กระดาษคำตอบ
14
สุ่มคำถาม
1400
ตอบถูก
0
ประเมินผล
0%
ผู้เยี่ยมชม
0%
ทำข้อสอบออนไลน์
G-Code
รหัสสำหรับทำข้อสอบออนไลน์ ยืนยันตัวตนด้วยการเสียบบัตรประชาชนบนเครื่องอ่านสมาร์ทการ์ด
QR-Code...
คำถาม ExactPapers Oracle 1Z0-001 2005.01...
39 รายการ | หน้าที่ 4 | 31-40
| Examine the table instance chart for the sales table. Column name PURCHASE_NO CUSTOMER_ID CAR_ID SALES_ID Key type PK FK FK FK Nulls/Unique NN, U NN NN NN FK table CUSTOMER CAR EMPLOY EE FK column ID ID ID Data type NUM NUM NUM NUM Length 9 9 9 9 You attempt to change the data base with this command: INSERT INTO sales(purchase_no, customer_id,car_id) VALUES(1234,345,6); If this statement fails which condition would explain the failure. |
| Examine the structure of the BOOK_TITLE, COPY and CHECK_OUT tables. BOOK TITLE Id.PK title Author COPY Id PK Title_id PK available CHECK_OUT 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 results. 1. Include the title of each book. 2. Include the availability of each book. 3. Order the results 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 |
| The employee table contains two columns: BONUS NUMBER(7,2) DEPT_ID NUMBER(9) There are three departments and each department has at least one employee. Bonus values are greater than 500;not all employee receive a bonus. Evaluate this PL/SQL block: DECLARE v_bonus employee.bonus%TYPE:=300; BEGIN UPDATE employee SET bonus=bonus+v_bonus WHERE dept_id IN (10,20,30); COMMIT; END; What will be the result. |
| 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. |
| You need to perform a major update on the employee table. You have decided to disable the primary key constraint on the empid column and the check constraint on the job column. What happens when you try to enable the constraint after the update is completed. |
| Which table name is valid. |
| You want to display the average salary for the departments 20 and 50 but only if those departments have an average salary of at least 2000. Which statement will produce the required res |
| As a DBA you have just created a user account for employee Smith by using the create user command. Smith should be able to create tables and packages in his schema. Which command will the DBA need to execute next so that Smith can perform his task successfully. |
| You want to retrieve the employee details from the emp table and process them in PL/SQL block. Which type of variable do you create in the PL/SQL block to retrieve all the rows and columns using a single select statement from the emp table |