Tag: databases

Questions Related to databases

If a new object is created , DB2 automatically starts using it (True or False)
technology databases

  1. True

  2. False

Show answer
Correct Option: B
Explanation:

To solve this question, the user needs to know how DB2 handles new objects.

The option A is incorrect because it's false. DB2 does not automatically start using a new object immediately after creation. The object must be activated before it can be used.

The option B is correct because DB2 does not automatically start using a new object. The object must be activated using the ACTIVATE DATABASE command or the ACTIVATE OBJECT command before it can be used.

Therefore, the correct answer is:

The Answer is: B

Which utility is used to retrieve data from a Image copy
technology databases

  1. LOAD

  2. UNLOAD

  3. REORG

  4. RUNSTATS

Show answer
Correct Option: B
Explanation:

To answer this question, the user needs to have an understanding of database management and utilities used to manipulate data in a database.

The utility used to retrieve data from an Image copy is the UNLOAD utility. This utility is used to extract data from a table or set of tables and write it to an output data set. The output data set can then be used to restore the data to a database using the LOAD utility.

Option A, LOAD, is incorrect because it is used to load data into a database from an input data set. It is the opposite of the UNLOAD utility.

Option C, REORG, is incorrect because it is used to reorganize a table or set of tables in a database, not to retrieve data from an Image copy.

Option D, RUNSTATS, is incorrect because it is used to collect statistics about the data in a table or set of tables. It is not used to retrieve data from an Image copy.

Therefore, the correct answer is:

The Answer is: B. UNLOAD

Which one is not the output of the LOAD utility
technology databases

  1. Loaded table or partition

  2. Discard file of rejected records

  3. Summary report of errors encountered

  4. Updated system catalog table stats

Show answer
Correct Option: D
Explanation:

To answer this question, the user needs to be familiar with the LOAD utility in database systems.

The LOAD utility is used to load data from external files into database tables. It is commonly used for bulk inserts of large amounts of data.

Now, let's go through each option to determine which one is not an output of the LOAD utility:

A. Loaded table or partition: This is a valid output of the LOAD utility. When the LOAD utility is successful, it loads data from external files into database tables or partitions.

B. Discard file of rejected records: This is a valid output of the LOAD utility. When the LOAD utility encounters records that cannot be loaded into the target table or partition, it writes those records to a discard file.

C. Summary report of errors encountered: This is a valid output of the LOAD utility. When the LOAD utility encounters errors while loading data, it generates a summary report of those errors.

D. Updated system catalog table stats: This is not an output of the LOAD utility. The LOAD utility is used for inserting data into tables, not updating system catalog table stats. The job of updating system catalog statistics falls under the responsibility of the database management system.

Therefore, the answer is:

The Answer is: D

Which utility is used to insert bulk amount of data in to a table.
technology databases

  1. LOAD

  2. UNLOAD

  3. INSERT

  4. RUNSTATS

Show answer
Correct Option: A

Which utility is used to reclaim fragmented space

technology databases

  1. LOAD

  2. UNLOAD

  3. REORG

  4. RUNSTATS

Show answer
Correct Option: C

AI Explanation

To answer this question, you need to understand the concept of fragmented space and the utility used to reclaim it.

Fragmented space refers to the scattered or unused space within a database or storage system. This can occur when records or data are deleted or modified, leaving gaps or unused space. Reclaiming fragmented space involves consolidating or rearranging the data to optimize the storage.

The utility used to reclaim fragmented space is the REORG utility.

Option A) LOAD - The LOAD utility is used to load data into a database. It does not specifically address the reclamation of fragmented space.

Option B) UNLOAD - The UNLOAD utility is used to extract data from a database. It does not address the reclamation of fragmented space.

Option C) REORG - The REORG utility is used to reorganize data in a database, including the reclamation of fragmented space. This utility helps to improve performance and optimize storage.

Option D) RUNSTATS - The RUNSTATS utility is used to collect statistics about the data in a database. It does not specifically address the reclamation of fragmented space.

The correct answer is C) REORG. This option is correct because the REORG utility is used to reclaim fragmented space by reorganizing and optimizing the data in a database.

Which utility is used to update the data related to tablespaces & indexes in system catalog tables

technology databases

  1. LOAD

  2. UNLOAD

  3. REORG

  4. RUNSTATS

Show answer
Correct Option: D

AI Explanation

To answer this question, you need to understand the utilities used to update data related to tablespaces and indexes in system catalog tables.

Option A) LOAD - The LOAD utility is used to load data into a table from an input file, but it does not update data related to tablespaces and indexes in system catalog tables.

Option B) UNLOAD - The UNLOAD utility is used to unload data from a table into an output file, but it does not update data related to tablespaces and indexes in system catalog tables.

Option C) REORG - The REORG utility is used to reorganize the data and indexes of a table to improve performance, but it does not update data related to tablespaces and indexes in system catalog tables.

Option D) RUNSTATS - The correct answer is D. The RUNSTATS utility is used to update the statistics of tables and indexes in system catalog tables. These statistics are used by the query optimizer to generate efficient access plans for SQL queries.

Therefore, the correct answer is D) RUNSTATS.

Which one is the correct option for taking unload from the table EMPTAB

technology databases

  1. UNLOAD TABLE DSN1DB04.EMPTABSP

  2. UNLOAD TABLESPACE DSN1DB04.EMPTABSP

  3. UNLOAD DATABASE DSN1DB04.EMPTABSP

  4. UNLOAD DATABASE DSN1DB04 EMPTABSP

Show answer
Correct Option: B

AI Explanation

To answer this question, let's go through each option to understand why it is correct or incorrect:

Option A) UNLOAD TABLE DSN1DB04.EMPTABSP - This option is incorrect because the syntax "UNLOAD TABLE" is not valid. The correct syntax is "UNLOAD TABLESPACE" to specify unloading a tablespace.

Option B) UNLOAD TABLESPACE DSN1DB04.EMPTABSP - This option is correct because it uses the correct syntax "UNLOAD TABLESPACE" to specify unloading a tablespace.

Option C) UNLOAD DATABASE DSN1DB04.EMPTABSP - This option is incorrect because the syntax "UNLOAD DATABASE" is not valid for unloading a specific table or tablespace. It is used for unloading the entire database.

Option D) UNLOAD DATABASE DSN1DB04 EMPTABSP - This option is incorrect because it does not specify the tablespace properly. The correct syntax for specifying a tablespace is "DSN1DB04.EMPTABSP" instead of "DSN1DB04 EMPTABSP".

The correct answer is Option B) UNLOAD TABLESPACE DSN1DB04.EMPTABSP. This option is correct because it uses the correct syntax for unloading a specific tablespace.

) While doing loading, data is sorted and then loaded into table (True or False)

technology databases

  1. True

  2. False

Show answer
Correct Option: B

AI Explanation

To answer this question, you need to understand the process of loading data into a table.

Option A) True - This option is incorrect. When loading data into a table, it is not necessary to sort the data before loading it. The data can be loaded into the table in any order, and the sorting can be done later if needed.

Option B) False - This option is correct. While loading data into a table, there is no requirement to sort the data before loading it. The data can be loaded into the table in any order.

Therefore, the correct answer is B) False.

While doing loading , indexes are built automatically(True or False)

technology databases

  1. True

  2. False

Show answer
Correct Option: A
Explanation:

The correct answer is A) True.

When data is loaded into a database, indexes can be automatically built on the specified columns. Indexes help improve query performance by allowing the database engine to quickly locate the rows that satisfy the search criteria. By automatically building indexes during the loading process, the database system can optimize the performance of queries executed on the loaded data.

Therefore, the statement that indexes are built automatically during loading is true.

No need to use RUNSTATS when
technology databases

  1. a table is unloaded

  2. a table is loaded

  3. an index is created

  4. a table is reorganized

Show answer
Correct Option: A
Explanation:

To answer this question, let's go through each option to understand why it is correct or incorrect:

Option A) A table is unloaded - This option is correct. When a table is unloaded, there is no need to use RUNSTATS. Unloading a table means that the data is being removed from the table, and therefore, there is no data to collect statistics on.

Option B) A table is loaded - This option is incorrect. When a table is loaded, it is recommended to use RUNSTATS to collect statistics on the newly loaded data. This helps the database optimizer make better decisions when generating query plans.

Option C) An index is created - This option is incorrect. When an index is created, it is recommended to use RUNSTATS to collect statistics on the indexed columns. This helps the database optimizer make better decisions when using the index in query plans.

Option D) A table is reorganized - This option is incorrect. When a table is reorganized, it is recommended to use RUNSTATS to collect statistics on the reorganized table. This helps the database optimizer make better decisions when generating query plans for the reorganized table.

The correct answer is A) a table is unloaded. This option is correct because there is no need to use RUNSTATS when a table is unloaded, as there is no data to collect statistics on.

Therefore, the correct answer is option A.