최신IBM Informix 11.50 Application Developer - 000-556무료샘플문제
문제1
A user opens a transaction. In that transaction, a cursor is opened to fetch multiple rows for read access. Another transaction is opened and that connection attempts to modify some rows that the first transaction is examining. Which isolation level will ensure that the rows the first transaction examines remain the same?
A user opens a transaction. In that transaction, a cursor is opened to fetch multiple rows for read access. Another transaction is opened and that connection attempts to modify some rows that the first transaction is examining. Which isolation level will ensure that the rows the first transaction examines remain the same?
정답: C
문제2
What result will be returned for User B in the attached exhibit?
What result will be returned for User B in the attached exhibit?
정답: A
문제3
What is a view?
What is a view?
정답: A
문제4
To register a new user-defined access method called my_tree for a virtual index, which of the following SQL statements must be used?
To register a new user-defined access method called my_tree for a virtual index, which of the following SQL statements must be used?
정답: D
문제5
William needs to create a table with a BYTE column which must be populated. Which of the following CREATE TABLE clauses can be used to ensure that the BYTE column contains a value?
William needs to create a table with a BYTE column which must be populated. Which of the following CREATE TABLE clauses can be used to ensure that the BYTE column contains a value?
정답: C
문제6
When user "ABC" attempts to use a view, the database server tests for which of the following privileges?
When user "ABC" attempts to use a view, the database server tests for which of the following privileges?
정답: A