최신IBM DB2 10.1 Fundamentals - 000-610무료샘플문제
문제1
Which product replaced the Control Center used in versions prior to DB2 v10?
Which product replaced the Control Center used in versions prior to DB2 v10?
정답: B
문제2
After creating several new indexes and executing RUNSTATS, user USER1 wants to re-create a package that is stored in the database so it will take advantage of the new indexes. Which authority/privilege must user USER1 be granted in order to re-create the package?
After creating several new indexes and executing RUNSTATS, user USER1 wants to re-create a package that is stored in the database so it will take advantage of the new indexes. Which authority/privilege must user USER1 be granted in order to re-create the package?
정답: C
문제3
Which function can be used to obtain values from XML documents that are to be inserted into one or more tables?
Which function can be used to obtain values from XML documents that are to be inserted into one or more tables?
정답: C
문제4
Which statement about a deadlock is true?
Which statement about a deadlock is true?
정답: A
문제5
A column mask that is to be used for row and column access control (RCAC) was created with the DISABLE option specified. What must be done if this mask is to be used to restrict access to data stored in a table named EMPLOYEE?
A column mask that is to be used for row and column access control (RCAC) was created with the DISABLE option specified. What must be done if this mask is to be used to restrict access to data stored in a table named EMPLOYEE?
정답: D
문제6
A table named SALES contains a record for every sales transaction a company processes. A user wishes to see the number of transactions that are made by each salesman. Which SQL statement will produce the desired results?
A table named SALES contains a record for every sales transaction a company processes. A user wishes to see the number of transactions that are made by each salesman. Which SQL statement will produce the desired results?
정답: A
문제7
Which object can be enabled for compression?
Which object can be enabled for compression?
정답: B