lspath
sdd query adapter
pcmpath query adapter
datapath query device
第1题:
what device sends IGMP Query messages?
第2题:
Which three statements are true regarding subqueries?()
第3题:
Attaching to a SCSI storage system through redundant paths will provide which of the following?()
第4题:
A company runs very large database applications on multiple HP-UX servers. They recently upgraded the device drivers for their fibre channel HBAs and have suffered numerous crashes on several systems. Which feature of Power Systems running AIX would help eliminate this problem during pre-release testing of a new device driver?()
第5题:
A general purpose MySQL instance is configured with the following options: —log-slow-queries —long-query-time=,0001 —log-slow-admin-queries —general-log —log-bin —binlog-format=STATEMENT —innodb-flush-log-at-trx-commit=1 Which three statements are true()。
第6题:
In which cases is reference partitioning effective in enhancing performance?()
第7题:
It is effective only in partition pruning.
It is effective only in partitionwise joins provided that the query predicates are different from the partitioning key.
It is effective in both partition pruning as well as partitionwise joins provided that the query predicates are identical to the partitioning key.
It is effective in both partition pruning as well as partitionwise joins irrespective of whether the query predicates are different from or identical to the partitioning key.
第8题:
A main query can have more than one subquery.
A subquery can have more than one main query.
The subquery and main query must retrieve data from the same table.
The subquery and main query can retrieve data from different tables.
Only one column or expression can be compared between the subquery and main query.
Multiple columns or expression can be compared between the subquery and main query.
第9题:
The inner query always sorts the results of the outer query.
The outer query always sorts the results of the inner query.
The outer query must return a value to the inner query.
The inner query returns a value to the outer query.
The inner query must always return a value or the outer query will give an error.
第10题:
High availability and failover
File sharing on the storage system
Better bandwidth through NIC Teaming on attached servers
Greater number of LUNS available on the same storage system
第11题:
The nested query executes after the outer query returns the row.
The nested query executes first and then the outer query executes.
The outer query executes only once for the result returned by the inner query.
Each row returned by the outer query is evaluated for the results returned by the inner query.
第12题:
Subqueries can contain GROUP BY and ORDER BY clauses
Main query and subquery can get data from different tables
Main query and subquery must get data from the same tables
Subqueries can contain ORDER BY but not the GROUP BY clause
Only one column or expression can be compared between the main query and subquery
Multiple columns or expressions can be compared between the main query and subquery
第13题:
LPAR1 is configured to have the same 2 LUNs virtualized by a redundant pair of VIO servers. Which command will validate thatboth storage paths are available?()
第14题:
Attaching to a NAS storage system through redundant NICs will provide which of the following?()
第15题:
LPAR1 is configured to have the same 2 LUNs virtualized by a redundant pair of VIO servers. Which command will validate that both storage paths are available?()
第16题:
Which command will enable the administrator to query the current network adapter configuration?()
第17题:
Which three statements about subqueries are true? ()
第18题:
Which MySQL utility program should you to process and sort the slow Query log based on query time or average query time?()
第19题:
lspath
sdd query adapter
pcmpath query adapter
datapath query device
第20题:
Mysqlaccess
Mysqldump
Mysqlshow
Mysqlslow
Mysqldumpslow
第21题:
The ability to interleave writes to the array
High Availability and failover
LUN sharing via Target Mode SCSI on the storage system
A greater number of LUNS available on the same storage system
第22题:
Exhibit A
Exhibit B
The query returns no rows
The query fails because the outer query is retrieving more than one column
The query fails because both the inner and outer queries are retrieving data from the same table.
第23题:
netstat -v
entstat -d
lsattr -El
lsdev -C -attr
第24题:
lspath
sdd query adapter
pcmpath query adapter
datapath query device