1. If you need to create a table and store the index data and other data in the table separately, you should
A. Set up two SMS table spaces to store index data and other data separately
B. Set up two DMS table spaces to store index data and other data separately
C, establish a DMS table space to store index data, and then set up an SMS table space to store other data
D. Create an SMS table space to store the index data, and then set up a DMS table space to store other data
2. Create a DMS type tablespace, which of the following two file system objects can be used as containers?
A, Directory
B. Documents
C, DEVICE
3. If the user does not specify a schema for the database object in the SQL statement, its default schema is:
A, SYSIBM
B, SYSCAT
C, SYSSTAT
D, the user name used when the user connects to the database
E, the above are not
4. When exporting data from a table using export, which of the following three file formats can be used?
A, ASC
B, DEL
C, WSF
D, IXF
5, if you want to create a table in the process of data import, you should
A. Load using the IXF file format
B. Load using the WSF file format
C. Import using the IXF file format
D. Import using the WSF file format
6, if the use of circular logging, auxiliary log files when assigned?
A, when the database was established
B, when the database server starts
C, when needed
D, the above are not
7. The default database log file type is:
A, Circular Log
B, Archival Log
C, Primary Log
D, secondary log
8, the following kind of isolation level for read-only operation is not locked on the data line?
A, RR
B, RS
C, CS
D, UR
9. Which of the following tools can add records to a table and change the statistics for a database?
A, Import
B, insert
C, Load
D, update
10. Which of the following two tools can update the statistical information of a system?
A, REORG
B, RUNSTATS
C, REORGCHK
D, IMPORT
|
