Tag: databases

Questions Related to databases

Within the application MY_APP the following PREVIOUS VALUE expression references the sequence MY_SEQ: PREVIOUS VALUE FOR my_seq After which of the following events will the most recently generated value of MY_SEQ persist so that it can be returned to the active MY_APP application?
technology databases

  1. After a ROLLBACK is issued

  2. .After the sequence is altered

  3. After the sequence is dropped

  4. After the current session ends

Show answer
Correct Option: A

Which of the following describes the objects of a DB2 database and their relationships?

technology databases

  1. Instance

  2. Table space

  3. System catalog

  4. Schema repository

Show answer
Correct Option: C
Explanation:

To solve this question, the user needs to know about the components of a DB2 database and their functions.

A. Instance: This refers to the environment in which DB2 runs. An instance includes system memory, a set of processes, and a set of configuration files. It is responsible for managing the overall operation of the database.

B. Table space: This is where the actual data is stored in a DB2 database. A table space consists of one or more containers that hold the actual data. Each container can be a file or a set of files.

C. System catalog: This is a set of tables that hold metadata about the database objects, such as tables, indexes, views, etc. It is used by DB2 to manage the database and its objects.

D. Schema repository: This is a collection of schemas, which are logical containers for database objects such as tables, views, indexes, etc.

Among the given options, C is the correct answer as the system catalog is responsible for storing metadata about the database objects and their relationships. It provides information about tables, indexes, views, permissions, etc. and is used by the DB2 system to manage the database and its objects. Therefore, the correct answer is:

The Answer is: C

Which of the following database objects is considered executable using SQL?
technology databases

  1. View

  2. Table

  3. Routine

  4. Package

Show answer
Correct Option: C

A user utilizing an alias to update a subset of columns in a table must have UPDATE privileges on which of the following DB2 objects?
technology databases

  1. Table

  2. Columns

  3. Table and Alias

  4. Columns and Alias

Show answer
Correct Option: A

In which of the following scenarios would a stored procedure be beneficial?
technology databases

  1. An application running on a remote client needs to be able to convert degrees Celsius to degrees Fahrenheit and vice versa

  2. An application running on a remote client needs to collect three input values, perform a calculation using the values provided, and store the input data, along with the results of the calculation in two different base tables

  3. An application running on a remote client needs to track every modification made to a table that contains sensitive data

  4. An application running on a remote client needs to ensure that every new employee that joins the company is assigned a unique, sequential employee number

Show answer
Correct Option: B

A programmer wants to generate values for a numeric ID column in their EXPENSE table. The ID column values need to be incremented by 1000 for each new expense report added to the EXPENSE table. Which DB2 object can be referenced by an INSERT statement to meet thisrequirement?
technology databases

  1. Sequence

  2. Table Function

  3. Identity Column

  4. INSTEAD OF Trigger

Show answer
Correct Option: A

Given the following DDL for the PARTS table: CREATE TABLE parts (part_no INT(9) NOT NULL, part_name VARCHAR(24), part_remain INT(9)); All part numbers entered will be different and all rows should be displayed in order of increasing part numbers whenever the table is queried. Which of the following create index statements will meet this criteria and require the least amount of storage for the index object?
technology databases

  1. CREATE UNIQUE INDEX idx_partno ON parts(part_no)

  2. CREATE UNIQUE INDEX idx_partno ON parts(part_name ASC)

  3. CREATE UNIQUE INDEX idx_partno ON parts(part_name, part_no ASC)

  4. CREATE UNIQUE INDEX idx_partno ON parts(part_no, part_name ASC)

Show answer
Correct Option: A

What type of constraint can be used to ensure that, in any given row in a table, the value of one column never exceeds the value of another column?
technology databases

  1. Check

  2. Range

  3. Referential

  4. Informational

Show answer
Correct Option: A

Which of the following will DELETE all of the rows from table T03?
technology databases

  1. DELETE * FROM TABLE T03

  2. DELETE ALL FROM T03

  3. DELETE * FROM T03

  4. DELETE FROM T03

Show answer
Correct Option: D

Which of the following can NOT be done using the ALTER TABLE statement?
technology databases

  1. Add a new column

  2. Drop a check constraint

  3. Change a column's name

  4. Change the length of a VARCHAR column

Show answer
Correct Option: C