สถิติ ExactPapers Oracle 1Z0-001 2005.01...
คำถาม
39
กระดาษคำตอบ
14
สุ่มคำถาม
1400
ตอบถูก
0
ประเมินผล
0%
ผู้เยี่ยมชม
0%
ทำข้อสอบออนไลน์
G-Code
รหัสสำหรับทำข้อสอบออนไลน์ ยืนยันตัวตนด้วยการเสียบบัตรประชาชนบนเครื่องอ่านสมาร์ทการ์ด
QR-Code...
คำถาม ExactPapers Oracle 1Z0-001 2005.01...
39 รายการ | หน้าที่ 1 | 1-10
| You are a user of PROD database which contains over 1000 tables and you need to determine the number of tables you can access. Which data dictionary view could you query to display this information. |
| You query the database with this command. SELECT last_name, first_name FROM employee WHERE SALARY IN SELECT salary FROM employee WHERE dept_no=3 OR dept_no=5); Which values are displayed. |
| Which operator is not appropriate in the joined condition of none equijoin select statement. |
| What should you do after each fetch statement in the PL/SQL block |
| You issue this command: CREATE PUBLIC SYNONYM emp FOR ed.employee; Which task has been accomplished. |
| Which data type should you use for interest rates with varying and unpredictable decimal places such as 1.234, 3.4, 5 and 1.23. |
| For which three tasks would you use the where clause. (Choose three) |
| Which SELECT statement would you use in a PL/SQL block to query the employee table and retrieve the last name and salary of the employee whose ID is 3. |
| Under which situation it is necessary to use an explicit cursor. |
| Using SQL Plus you created a user with this command: CREATE USER Jennifer IDENTIFIED BY jbw122 What should you do to allow users database access. |