IBM C2090-730 Prüfungsthemen:
| Abschnitt | Ziele |
|---|---|
| Grundlagen von Datenbanken | - Konzepte relationaler Datenbanken
|
| Architektur und Komponenten von DB2 | - Speicher- und Prozessmodell
|
| Datenbankvorgänge und Hilfsprogramme | - Überwachung und Wartung
|
| Grundlagen der Datenbankverwaltung | - Sicherheitsgrundlagen
|
IBM DB2 9 Family Fundamentals C2090-730 Prüfungsfragen mit Lösungen
Frage #1
Given the following query:
SELECT last_name, first_name, age, hire_date
FROM employee WHERE age > 40 Which of the following clauses must be added to return the rows sorted by AGE, oldest first, and by LAST_NAME, from A to Z?
A. ORDER BY age DESC,last_name
B. ORDER BY age ASC,last_name
C. SORT BY age DESC,last_name
D. SORT BY age ASC,last_name
Frage #2
57 Given table T1 has column I1 containing the following data: I1
1
2
3
4
If the following sequence of SQL statements is applied within a single unit of work:
UPDATE t1 SET i1 = 3 WHERE i1 = 2; S
AVEPOINT s1 ON ROLLBACK RETAIN CURSORS;
UPDATE t1 SET i1 = 5 WHERE i1 = 3;
SAVEPOINT s2 ON ROLLBACK RETAIN CURSORS;
INSERT INTO t1 (i1) VALUES (6);
ROLLBACK TO SAVEPOINT s1;
UPDATE t1 SET i1 = 2 WHERE i1 = 4;
COMMIT;
What is the expected sequence of values returned from?
SELECT i1 FROM t1 ORDER BY i1
A. 1, 2, 3, 3, 6
B. 1, 2, 2, 4
C. 1, 2, 2, 5, 6
D. 1, 2, 3, 3
Frage #3
Which of the following would NOT provide access to data stored in table TABLE1 using the name T1?
A. An alias named T1 that references table TABLE1
B. An alias named T1 that references a view named V1 that references table TABLE1
C. A schema named T1 that references table TABLE1
D. A view named T1 that references table TABLE1
Frage #4
Which of the following is NOT a difference between a unique index and a primary key?
A. Unique indexes can be defined over one or more columns that allow null values; primary keys cannot contain null values.
B. A table can have many unique indexes but only one primary key.
C. A primary key is a special form of a unique constraint; both use a unique index.
D. Unique indexes can be defined over one or more columns; primary keys can only be defined on a single column.
Frage #5
If the following statement is executed:
CREATE TABLE tab1 (col1 INTEGER NOT NULL,
col2 INTEGER,
CONSTRAINT const1 FOREIGN KEY (col2)
REFERENCES tab1(col1));
How many unique indexes are defined for table TAB1?
A. 3
B. 2
C. 1
D. 0
Fragen und Antworten:
| Frage #1 Antwort: A | Frage #2 Antwort: D | Frage #3 Antwort: C | Frage #4 Antwort: D | Frage #5 Antwort: D |
1901 Kundenbewertungen
