최신IBM PureData System for Transactions Technical Mastery Test v1 - P2090-047무료샘플문제
문제1
When unloading data via an external table, where can the SQL be submitted?
When unloading data via an external table, where can the SQL be submitted?
정답: D
문제2
In order to set a runaway query event to trigger when a query runs longer than two minutes, which two items must be configured? (Choose two.)
In order to set a runaway query event to trigger when a query runs longer than two minutes, which two items must be configured? (Choose two.)
정답: B,C
문제3
Where are the database log files located?
Where are the database log files located?
정답: C
문제4
What must the Linux administrator ensure when creating a Linux user on the host?
What must the Linux administrator ensure when creating a Linux user on the host?
정답: B
문제5
Which two characteristics describe materialized views. (Choose two.)
Which two characteristics describe materialized views. (Choose two.)
정답: C,E
문제6
In a UNIX 64bit environment, a 64bit application requires which software to execute SQL statements via ODBC? (Choose two.)
In a UNIX 64bit environment, a 64bit application requires which software to execute SQL statements via ODBC? (Choose two.)
정답: C,D
문제7
A SELECT statement spends all its time returning 1 billion rows. What can be done to make this faster?
A SELECT statement spends all its time returning 1 billion rows. What can be done to make this faster?
정답: C
문제8
The simplest query execution plan file must have the following minimum nodes?
The simplest query execution plan file must have the following minimum nodes?
정답: A
문제9
What will prevent a GROOM TABLE command from running on a table named TableA?
What will prevent a GROOM TABLE command from running on a table named TableA?
정답: B