최신 On Demand Business C2090-556 무료샘플문제:
1. Which statement combines the actions of the PREPARE, EXECUTE, and FREE statements into a single operation to process most SQL statements?
A) EXECUTE NOW
B) EXEC SQL
C) EXECUTE DYNAMIC
D) EXECUTE IMMEDIATE
2. The definition of the table "tab1" is:
create table tab1 (colA boolean, colB boolean);
Which INSERT statement for the table is correct?
A) insert into tab1 (colA, colB) values ('F','0');
B) insert into tab1 (colA, colB) values (1,0);
C) insert into tab1 (colA, colB) values ('t', NULL);
D) insert into tab1 (colA, colB) values (t,f);
3. What does the TRACE PROCEDURE statement do when debugging stored procedures?
A) Traces the routine calls and return values, and every parsed statement in the stored procedure.
B) Traces the routine calls and return values, but not the body of the stored procedure.
C) Traces the routine calls and return values, automatically setting the debug file to the name of the stored procedure.
D) Activates the TRACE statements embedded in the stored procedure.
4. Which of the following data types can be directly cast to a DATE type?
A) DECIMAL
B) SMALLFLOAT
C) DATETIME
D) SMALLINT
5. Which built-in function is supported by Informix Server?
A) FORMAT_UNITS()
B) IFNULL()
C) LASTDAY()
D) TOCHAR()
질문과 대답:
질문 # 1 정답: D | 질문 # 2 정답: C | 질문 # 3 정답: B | 질문 # 4 정답: D | 질문 # 5 정답: A |