Oracle9i dba new features for Oracle7.3 and Oracle9 ocps 1Z0-035 Prüfungsfragen mit Lösungen:
1. In which tablespace are temporary LOBs stored?
A) in the SYSTEM tablespace
B) any tablespace depending on the temporary LOBs' definition
C) in the user's temporary tablespace
D) in the user's default tablespace
2. What does fine-grained access enable you to do?
A) select which user's privilege map is used during execution
B) associate policies with tables and views
C) choose the schema in which a stored PL/SQL block will execute in
D) select how external object references are resolved in queries
3. Oracle Enterprise Manage (OEM) can generate database reports. Which statement about this feature is true?
A) Report generation is scheduled in the job system.
B) The report is placed in a table for suitable selects.
C) The reports are in HTML format for viewing in a browser.
D) Generating reports requires a repository.
4. Examine this statement, which creates a Cartesian product of the COUNTRIES and REGION tables:
SQL> SELECT c.country_name, 2> r.region_name 3> FROM countries c, region r;
Oracle9i SQL:1999 syntax supports the same functionality with which join type?
A) Natural join
B) Cross join
C) Equijoin
D) Merge join
5. User defined events in Oracle Enterprise Manager return status, and possibly values, to the Oracle Enterprise Manager Event Monitor. What are user defined events?
A) user written PL/SQL programs in the database, which the OEM console can execute and display the results
B) database based scripts (PL/SQL, Java) run by the Agent
C) Database Event Triggers, which issue Alerts to the Agent
D) scripts run by the Agent in any language on the host server
Fragen und Antworten:
| 1. Frage Antwort: C | 2. Frage Antwort: B | 3. Frage Antwort: C | 4. Frage Antwort: B | 5. Frage Antwort: D |






834 Kundenbewertungen

