IBM 000-730 echte frage : DB2 9 Family Fundamentals

Eine Wiederholungsprüfung kostet nicht nur Zeit, sondern auch erneut die volle Prüfungsgebühr. Die 303 aktuellen Übungsfragen zur 000-730 Prüfung von EchteFrage helfen Ihnen, die IBM DB2 9 Family Fundamentals beim ersten Anlauf zu bestehen.

IBM 000-730 Prüfungsübersicht:

Zertifizierungsanbieter:	IBM
Prüfungsname:	Prüfung: DB2 9 Family Grundlagen
Prüfungsnummer:	A2090-730
Prüfungsformat:	Multiple-Choice-Fragen
Verwandte Zertifizierungen:	IBM Certified Database Associate - DB2 9 Family Fundamentals
Verfügbare Sprachen:	Englisch
Prüfungsdauer:	90 Minuten
Beispielfragen:
Prüfungsmethode:	Online oder in einem Prüfungszentrum (je nach Anbieter und Region unterschiedlich)
Voraussetzungen:	Es gibt keine formalen Teilnahmevoraussetzungen, jedoch werden grundlegende Datenbankkenntnisse empfohlen.
Offizielle Syllabus-URL:	https://www.ibm.com/certify

IBM 000-730 Prüfungsthemen:

Häufig gestellte Fragen rund um die 000-730 Zertifizierungsprüfung

IBM DB2 9 Family Fundamentals 000-730 Prüfungsfragen mit Lösungen

Frage #1

Given the following set of statements:
CREATE TABLE tab1 (col1 INTEGER, col2 CHAR(20));
COMMIT;
INSERT INTO tab1 VALUES (123, 'Red');
INSERT INTO tab1 VALUES (456, 'Yellow');
SAVEPOINT s1 ON ROLLBACK RETAIN CURSORS;
DELETE FROM tab1 WHERE col1 = 123;
INSERT INTO tab1 VALUES (789, 'Blue');
ROLLBACK TO SAVEPOINT s1;
INSERT INTO tab1 VALUES (789, 'Green');
UPDATE tab1 SET col2 = NULL WHERE col1 = 789; COMMIT;
Which of the following records would be returned by the following statement?
SELECT * FROM tab1

A. COL1 COL2
456 Yellow 1 record(s) selected.
B. COL1 COL2
123 Red 456 Yellow 789 3 record(s) selected.
C. COL1 COL2
123 Red 456 Yellow 2 record(s) selected.
D. COL1 COL2
123 Red 456 Yellow 789 Green 3 record(s) selected.

Frage #2

Two applications have created a deadlock cycle in the locking subsystem. If lock timeout is set to 30 and both applications were started at the same time, what action will the deadlock detector take when it "wakes up" and discovers the deadlock?

A. Itwill rollback the current transactions of both applications
B. It will go back to sleep for 30 seconds, then if the deadlock still exists, it will randomly pick an application and rollback its current transaction
C. It will wait 30 seconds, then rollback the current transactions of both applications if the deadlock has not been resolved
D. It will randomly pick an application and rollback its current transaction

Frage #3

Given the following table definition:
SALES
SALES_DATE DATE
SALES_PERSON CHAR(20)
REGION CHAR(20)
SALES INTEGER
Which of the following SQL statements will remove all rows that had a SALES_DATE in the year
1995?

A. DROP FROM sales WHEREYEAR(sales_date) = 1995
B. DELETE FROM sales WHEREYEAR(sales_date) = 1995
C. DROP * FROM sales WHEREYEAR(sales_date) = 1995
D. DELETE * FROM sales WHEREYEAR(sales_date) = 1995

Frage #4

When a client using the SERVER_ENCRYPT authentication type connects to a server using the SERVER authentication type, what happens?

A. User IDs and passwords are encrypted before they are passed to the server.
B. User IDs and passwords are passed to the server unencrypted.
C. Data passed between the client and the server is encrypted.
D. An error will occur.

Frage #5

Which of the following DB2 UDB isolation levels will only lock rows during read processing if another transaction tries to drop the table the rows are being read from?

A. Repeatable Read
B. Cursor Stability
C. Uncommitted Read
D. Read Stability

Fragen und Antworten: