71.
The DB2 instance "db2inst1" has been created in the /home/db2inst1 directory. fi the DFTDBPATH database manager
confiuration parameter contains no value and the following command is executed. CREATE DATABASE newdb where will the NODE0000 subdirectory of the database NEWDB reside?
- A.in the /home/dbinst1 subdirectory
- B.in the /home/db2inst1/newdb subdirectory
- C.in the /home/db2inst1/db2inst1 subdirectory
- D.in the /home/db2inst1/db2inst1/newdb subdirectory
- Answer
- Report
Answer : [C]
72.
If a large amount of data is being loaded into table MKT_value, what does the following DB2 command do?
LOAD QUERY TABLE mkt_value
LOAD QUERY TABLE mkt_value
- A.Displays the status of the load
- B.Allows users to query the data being loaded
- C.Prevents any querying of the table MKT_VALUE during the load
- D.Specifies a query is to be run immediately after the load operation
- Answer
- Report
Answer : [A]
73.
Which of the following identifies which users have SYSCTRL authority?
- A.DB2 registry
- B.System catalog
- C.Database configuration
- D.Database manager configuration
- Answer
- Report
Answer : [D]
74.
Which of the following statements about SCHEMA objects is true?
- A.A schema must always be associated with a user.
- B.Triggers and sequences do not have schemas associated with them.
- C.After creating a new database, all users who successfully authenticate with the database have the ability to create a new schema.
- D.If a schema is not explicitly specified in a SQL statement, the PUBLIC schema is assumed.
- Answer
- Report
Answer : [C]
75.
Given the following server information, which of the following commands will catalog this node?
Instance name: db2inst1
Port number: 60000
Service name: db2c_db2inst1
Host TCP/IP address: 10.205.15.100
Hostname: tcphost
Protocol : TCP/IP
Instance name: db2inst1
Port number: 60000
Service name: db2c_db2inst1
Host TCP/IP address: 10.205.15.100
Hostname: tcphost
Protocol : TCP/IP
- A.CATALOG TCPIP NODE db2tcp REMOTE 10.205.15.100
- B.CATALOG TCPIP NODE db2tcp REMOTE tcphost SERVER 60000
- C.CATALOG TCPIP NODE db2tcp REMOTE tcphost SERVER db2inst1
- D.CATALOG TCPIP NODE db2tcp REMOTE tcphost INSTANCE db2inst1
- Answer
- Report
Answer : [B]
|
|
||||||||||||||||||||||||||||
