IBM DB2 11.1 Fundamentals for LUW - C2090-616무료 덤프문제 풀어보기
Which constraint can be used to ensure that identical values are never stored in a set of columns in a table?
정답: D
Which of the following is designed for continuous availability, increased throughput of many concurrent short queries, and easy scalability?
정답: C
Below are the SQL statements a DBA is planning to execute on a database:
CREATE TABLE t1 (name VARCHAR (1));
INSERT INTO t1 VALUES ('A'), ('B'), ('C'), ('D');
ALTER TABLE t1 ALTER COLUMN name SET DATA TYPE INT;
What will be the outcome of the last statement?
CREATE TABLE t1 (name VARCHAR (1));
INSERT INTO t1 VALUES ('A'), ('B'), ('C'), ('D');
ALTER TABLE t1 ALTER COLUMN name SET DATA TYPE INT;
What will be the outcome of the last statement?
정답: C
Given the following statement:
DECLARE GLOBAL TEMPORARY TABLE TEMP1 (
ID INTEGER NOT NULL,
ITEM CHAR(30),
AMOUNT DECIMAL (10,2)
ON COMMIT DELETE ROWS NOT LOGGED;
Which of the following statements are TRUE? (Choose two.)
DECLARE GLOBAL TEMPORARY TABLE TEMP1 (
ID INTEGER NOT NULL,
ITEM CHAR(30),
AMOUNT DECIMAL (10,2)
ON COMMIT DELETE ROWS NOT LOGGED;
Which of the following statements are TRUE? (Choose two.)
정답: B,C
Which of the following editions of DB2 include support for Federation with Oracle database?
정답: C
Which of the following SQL statements will update columns C1 to DB2 and C2 to 11 if C3 is 2016?
정답: B
Which edition of DB2 LUW has been discontinued in v11.1?
정답: B