IBM 000-544 Prüfungsthemen:
| Abschnitt | Ziele |
|---|---|
| Thema 1: Architektur und Konfiguration des fortgeschrittenen DB2 9.7-DBA | - Fortgeschrittene Funktionen und Erweiterungen von DB2 9.7 - Instanz- und Datenbankkonfigurationsparameter |
| Thema 2: Sicherung, Wiederherstellung und Hochverfügbarkeit | - Hochverfügbarkeits- und Notfallwiederherstellung (HADR) - Sicherungs- und Wiederherstellungstechniken |
| Thema 3: Fortgeschrittene DBA-Tools und -Dienstprogramme | - Partitionierung und Datenbankverteilung - DB2-Dienstprogramme und -Befehle |
| Thema 4: Sicherheit und Berechtigungsverwaltung | - Authentifizierung und Rechteverwaltung - Rollen- und Berechtigungssteuerung |
| Thema 5: Leistungsüberwachung und -optimierung | - Pufferpools und Speicherverwaltung - Index-, Tabellen- und Abfrageoptimierung |
IBM DB2 9.7 Advanced DBA for LUW 000-544 Prüfungsfragen mit Lösungen
Frage #1
Which action can be performed by the ALTER TABLESPACE statement?
A. Change the EXTENTSIZE setting for a table space on a database partition that currently has no containers.
B. Add a container to an SMS table space on a database partition that currently has no containers.
C. Change the size of a container in an SMS table space.
D. Change an SMS table space to a DMS table space on any database partition.
Frage #2
A database and a table space were created using the following commands:
Afterwards, two tables were created in table space TBSP1 and both tables were populated with 100,000 rows. If a DBA decides that database MYDB should use automatic storage, which command(s) are needed to convert the database?
A. ALTER DATABASE mydb ADD STORAGE ON ?mnt/path_1? ?mnt/path_2? ALTER TABLESPACE tbsp1 MANAGED BY AUTOMATIC STORAGE;
B. ALTER DATABASE mydb AUTOMATIC STORAGE YES ON ?mnt/path_1? ?mnt/path_2? ALTER TABLESPACE tbsp1 MANAGED BY AUTOMATIC STORAGE;
C. ALTER DATABASE mydb ADD STORAGE ON ?mnt/path_1? ?mnt/path_2?
D. ALTER DATABASE mydb AUTOMATIC STORAGE YES ON ?mnt/path_1? ?mnt/path_2?
Frage #3
If you know that the table space containers for your database reside on RAID-5 3+p arrays, which registry variable should be assigned the value *:3 to help improve performance?
A. DB2_RESOURCE_POLICY
B. DB2_PARALLEL_IO
C. DB2_EXTENDED_IO_FEATURES
D. DB2_APM_PERFORMANCE
Frage #4
A DBA has configured an Oracle data source in a federated database (that references a table named ORA1). How do you update the statistics for table ORA1 at the federated server?
A. Perform RUNSTATS on the ORA1 nickname at the federated server.
B. Perform the equivalent of RUNSTATS on ORA1 in Oracle; then drop and re-create the ORA1 nickname.
C. Perform the equivalent of RUNSTATS on ORA1 in Oracle; then perform RUNSTATS on the ORA1 nickname.
D. Perform the equivalent of RUNSTATS on ORA1 in Oracle.
Frage #5
A user with Security Administrator (SECADM) authority executes the following statements:
If user USER2 queries the table S.TAB1, how many rows will be returned?
A. 3
B. 2
C. 1
D. 0
Fragen und Antworten:
| Frage #1 Antwort: B | Frage #2 Antwort: C | Frage #3 Antwort: B | Frage #4 Antwort: B | Frage #5 Antwort: B |
0 Kundenbewertungen
