READ Free Dumps For Oracle- 1z0-001
| Question ID 8130 | 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?
|
| Option A | USER_OBJECTS.
|
| Option B | ALL_OBJECTS.
|
| Option C | DBA_SEGMENTS.
|
| Option D | DBA_TABLES.
|
| Correct Answer | B |
Explanation Explanation: Answer B is correct because view ALL_OBJECTS shows all objects user can access, not only user's objects. Using clause WHERE OBJECT_NAME = 'TABLE' user will be able to determine the number of tables he or she can access. Incorrect Answers: A: View USER_OBJECTS shows only user owned objects. C: View DBA_SEGMENTS shows all objects, not only those objects which user can access. DBA_SEGMENTS contains information not only about tables, but about other objects, like INDEX segments, too. D: View DBA_TABLES shows all tables, not only those tables which user can access. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 116-117 Chapter 3: Creating Oracle Database Objects
| Question ID 8131 | You query the database with this command.SELECT last_name, first_nameFROM employeeWHERE SALARY
IN
SELECT salary
FROM employee WHERE dept_no=3 OR dept_no=5);
Which values are displayed?
|
| Option A | Last name and the first name of only the employees in the department number 3 and 5.
|
| Option B | Last name and first name of all the employees except those working in the department 3and 5.
|
| Option C | Last name and first name of all the employees with the same salary as employee in the department 3 and 5.
|
| Option D | Last name and first name of only the employees whose salary falls in the range of salary from department 3 or 5.
|
| Correct Answer | C |
Explanation Explanation/Reference: Explanation: Answer C is correct because sub query returns all possible salaries for employees in the department 3 and 5 and main query will show all employees who have the same salaries. Incorrect Answers: A: Command will return information not only about employees in the departments 3 and 5, but other departments also. B: Command will return information about employees in the departments 3 and 5 also. D: Command will return information about employees who have exactly the same salary as employees in the department 3 and 5, not range of salaries. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 64- 66 Chapter 2: Advanced Data Selection in Oracle