sybase iq 12.6模拟题第二部分

11. Identify the IQ Temporary Store in the following CREATE DATABASE script. CREATE DATABASE ‘d:\\SybaseIQ\\megaphone\\megaphone.db’ LOG ON ‘d:\\SybaseIQ\\megaphone\\megaphone.log’ IQ PATH ‘d:\\SybaseIQ\\megaphone\\megaphone.iq’ IQ SIZE 40 IQ PAGE SIZE 65536 MESSAGE PATH ‘d:\\SybaseIQ\\megaphone\\megaphone.iqmsg’ TEMPORARY PATH ‘d:\\SybaseIQ\\megaphone\\megaphone.iqtmp’ TEMPORARY SIZE 20
megaphone.db
megaphone.log
megaphone.iq
megaphone.iqmsg
megaphone.iqtmp

12. The IQ Database Devices are called ____________.
Table Spaces
dbspaces
Index Spaces
Partitions

13. Identify the IQ Message Log in the following CREATE DATABASE script. CREATE DATABASE ‘d:\\SybaseIQ\\megaphone\\megaphone.db’ LOG ON ‘d:\\SybaseIQ\\megaphone\\megaphone.log’ IQ PATH ‘d:\\SybaseIQ\\megaphone\\megaphone.iq’ IQ SIZE 40 IQ PAGE SIZE 65536 MESSAGE PATH ‘d:\\SybaseIQ\\megaphone\\megaphone.iqmsg’ TEMPORARY PATH ‘d:\\SybaseIQ\\megaphone\\megaphone.iqtmp’ TEMPORARY SIZE 20
megaphone.db
megaphone.log
megaphone.iq
megaphone.iqmsg
megaphone.iqtmp

14. Identify the Catalog Store in the following CREATE DATABASE script. CREATE DATABASE ‘d:\\SybaseIQ\\megaphone\\megaphone.db’ LOG ON ‘d:\\SybaseIQ\\megaphone\\megaphone.log’ IQ PATH ‘d:\\SybaseIQ\\megaphone\\megaphone.iq’ IQ SIZE 40 IQ PAGE SIZE 65536 MESSAGE PATH ‘d:\\SybaseIQ\\megaphone\\megaphone.iqmsg’ TEMPORARY PATH ‘d:\\SybaseIQ\\megaphone\\megaphone.iqtmp’ TEMPORARY SIZE 20
megaphone.db
megaphone.log
megaphone.iq
megaphone.iqmsg
megaphone.iqtmp

15. Given the command: CREATE DBSPACE mydbspace AS ‘/dev/mdbspace.iq’ IQ STORE SIZE 2048 Which of the following is true?
It creates a database named ‘mydbspace’.
It increases the IQ Store by 2048MB.
The page size is 2048.
The physical device name is ‘mydbspace’.

16. Which of the following are true of local temporary tables? (Choose 2)
The table exists until it is explicitly removed
The table exists until the connection ends
The table is accessible only to the connection that creates it
The table exists in the IQ Store

17. Which one of the following index types can be declared Unique?
LF
CMP
WD
TIME

18. Which indexes can be created on a column defined as varchar(500)? (Choose 3)
FP
LF
HG
CMP
WD
HNG

19. Every column named in the WHERE and GROUP BY clause of a select statement should contain which of the following?
HG or LF index
HNG or LF index
HNG or HG index
LF or DATE index

20. Which of the following are used to determine index type selections for a column? (Choose 2)
How the column is used (e.g. Joins, GROUP BY, aggregation)
Number of rows in the table
Cardinality of the data type of the column
Number of columns in the table

回复 coolmax

我的答案：
    11. Identify the IQ Temporary Store in the following CREATE DATABASE script.
CREATE DATABASE ‘d:\\SybaseIQ\\megaphone\\megaphone.db’ LOG ON ‘d:\\SybaseIQ\\megaphone\\megaphone.log’
IQ PATH ‘d:\\SybaseIQ\\megaphone\\megaphone.iq’ IQ SIZE 40 IQ PAGE SIZE 65536 MESSAGE PATH ‘d:\\SybaseIQ\\megaphone\\megaphone.iqmsg’
TEMPORARY PATH ‘d:\\SybaseIQ\\megaphone\\megaphone.iqtmp’ TEMPORARY SIZE 20

megaphone.iqtmp

12. The IQ Database Devices are called ____________.
dbspaces

13. Identify the IQ Message Log in the following CREATE DATABASE script.
megaphone.iqmsg

14. Identify the Catalog Store in the following CREATE DATABASE script.
megaphone.db

15. Given the command: CREATE DBSPACE mydbspace AS ‘/dev/mdbspace.iq’ IQ STORE SIZE 2048 Which of the following is true?
It increases the IQ Store by 2048MB.

16. Which of the following are true of local temporary tables?
The table exists until the connection ends
The table is accessible only to the connection that creates it

17. Which one of the following index types can be declared Unique?
LF

18. Which indexes can be created on a column defined as varchar(500)?
WD, FP, HG

19. Every column named in the WHERE and GROUP BY clause of a select statement should contain which of the following?
HG or LF index

20. Which of the following are used to determine index type selections for a column?
How the column is used (e.g. Joins, GROUP BY, aggregation) & Cardinality of the data type of the column