sybase iq 12.6模拟题，请高手有空的时候给给标准答案-部分1

本帖最后由 coolmax 于 2010-08-23 16:56 编辑

1. For what applications is Sybase IQ ideally suited? (Choose 3)
Decision Support System
Online Transaction Processing
Distributed Data Mart
Data Warehouse
Real-time Update Applications

2. The benefits of Sybase IQ are: (Choose 4)
Fully flexible schema support
Reduces ongoing tuning of databases
Increases the need of DBA resources after initial install
Supports multi-server configuration
Increases I/Os with less CPU and memory usage

3. For which of the following systems should you NOT use Sybase IQ?
Data Warehouse
Decision Support System
Distributed Data Mart
Online Transaction Processing

4. Which dbspace contains the system tables and stored procedures necessary to manage an IQ database?
Catalog Store
IQ Store
IQ Temporary Store
IQ Message Log
IQ Server Log

5. What is the default port for Sybase IQ?
1521
2638
4500
5000

6. Identify the true statements about client access to Sybase IQ. (Choose 3)
ODBC supports all Sybase IQ data types
JDBC supports all Sybase IQ data types
Open Client supports all Sybase IQ data types
IQ Component Integration Services can map to tables on other database servers
IQ Component Integration Services is ideal for joining IQ tables to non-IQ proxy tables

7. Which IQ component can be built on a raw device? (Choose 2)
IQ Store
Catalog Store
IQ Temporary Store
IQ Message Log
Catalog Store Transaction Log
IQ Server Logs

8. Identify the default port number for both ASA and Sybase IQ:
1000
2638
3600
4000
4836

9. What is the default port for the utility server/database?
2368
2836
2638
5000

10. Which of the following would be true about the database created with the following command? CREATE DATABASE ‘/sybasedb/production.db’ IQ PATH ‘/dev/md/rdsk/iq’ IQ SIZE 500 IQ PAGE SIZE 65536
The size of the database would be 64K.
The size of the database would be 500 MB.
The size of the database would be 500 K.
The size of the database would be 500 GB.

回复 coolmax


    1. For what applications is Sybase IQ ideally suited?
Decision Support System & Distributed Data Mart & Data Warehouse

2. The benefits of Sybase IQ are:
除了Increases the need of DBA resources after initial install都选

3. For which of the following systems should you NOT use Sybase IQ?
Online Transaction Processing

4. Which dbspace contains the system tables and stored procedures necessary to manage an IQ database?
Catalog Store

5. What is the default port for Sybase IQ?
2638

6. Identify the true statements about client access to Sybase IQ.
IQ Component Integration Services can map to tables on other database servers
Open Client supports all Sybase IQ data types
JDBC supports all Sybase IQ data types

7. Which IQ component can be built on a raw device?
IQ Store
IQ Temporary Store

8. Identify the default port number for both ASA and Sybase IQ:
2638

9. What is the default port for the utility server/database?
2638

10. Which of the following would be true about the database created with the following command?
CREATE DATABASE ‘/sybasedb/production.db’ IQ PATH ‘/dev/md/rdsk/iq’ IQ SIZE 500 IQ PAGE SIZE 65536
The size of the database would be 500 MB.