0

databases Online Quiz - 196

Description: databases Online Quiz - 196
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

Each time you fetch a row from the cursor, it results in a network roundtrip

  1. True

  2. False


Correct Option: A
  1. records

  2. fields

  3. articles

  4. names


Correct Option: A

In a database of newspaper, journal or magazine articles, each record represents:

  1. one magazine, journal or newspaper

  2. one author

  3. one article from a magazine, journal or newspaper

  4. all of the above


Correct Option: C
Explanation:

To solve this question, the user needs to have a basic understanding of database management systems and the structure of a database.

The correct answer is:

C. one article from a magazine, journal or newspaper

Each record in a database of newspaper, journal or magazine articles represents a single article, not an entire publication or the author of the article. Therefore, option C is the correct answer.

Option A is incorrect because it suggests that each record represents a single magazine, journal or newspaper, which is not true.

Option B is also incorrect because it suggests that each record represents a single author, which is not true either.

Option D is incorrect because it includes options A and B, which are both incorrect.

  1. one book, journal, video, CD, etc.

  2. one author

  3. one subject

  4. all of the above


Correct Option: A
  1. the whole article

  2. a summary of the article

  3. the title of the article

  4. the author, title and source of the article


Correct Option: D

Which of the following is the lowest cost DB2 product that can be legally installed on a Windows server that has 2 CPUs?

  1. DB2 Everyplace

  2. DB2 Express Edition

  3. DB2 Workgroup Server Edition

  4. DB2 Enterprise Server Edition


Correct Option: B

AI Explanation

To answer this question, you need to understand the different editions of DB2 and their pricing.

Let's go through each option to understand why it is correct or incorrect:

Option A) DB2 Everyplace - This option is incorrect because DB2 Everyplace is designed for mobile devices and is not intended for installation on a Windows server.

Option B) DB2 Express Edition - This option is correct because DB2 Express Edition is the lowest cost DB2 product that can be legally installed on a Windows server with 2 CPUs. It is designed for small to medium-sized businesses and has a lower price point compared to other editions.

Option C) DB2 Workgroup Server Edition - This option is incorrect because DB2 Workgroup Server Edition is a more advanced edition compared to DB2 Express Edition. It is designed for larger workgroups and has a higher price point.

Option D) DB2 Enterprise Server Edition - This option is incorrect because DB2 Enterprise Server Edition is the most advanced edition of DB2 and is designed for enterprise-level applications. It has a higher price point compared to the other editions.

The correct answer is B) DB2 Express Edition. This option is correct because it is the lowest cost DB2 product that can be legally installed on a Windows server with 2 CPUs.

Which of the following DB2 objects can be referenced by an INSERT statement to generate values for a column?

  1. Identity column

  2. Table function

  3. Sequence

  4. Trigger


Correct Option: C

Which of the following events will NOT cause a trigger to be activated?

  1. A select operation

  2. An update operation

  3. An insert operation

  4. A delete operation


Correct Option: A

Which of the following DB2 data types can NOT be used to create an identity column?

  1. SMALLINT

  2. NUMERIC

  3. INTEGER

  4. DOUBLE


Correct Option: D

Which of the following are optional and do not have to be specified when creating a table?

  1. Default constraint

  2. Column data type

  3. Column name

  4. Table name


Correct Option: A

AI Explanation

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

Option A) Default constraint - This option is correct because a default constraint is not mandatory when creating a table. A default constraint specifies a default value for a column when no value is explicitly provided during an insert operation. However, it is not necessary to specify a default constraint when creating a table.

Option B) Column data type - This option is incorrect. When creating a table, it is mandatory to specify the data type for each column. The data type determines the type of data that can be stored in the column, such as integer, string, date, etc.

Option C) Column name - This option is incorrect. When creating a table, it is mandatory to specify the name of each column. The column name is used to identify and reference the specific column within the table.

Option D) Table name - This option is incorrect. When creating a table, it is mandatory to specify the name of the table. The table name is used to identify and reference the table itself.

The correct answer is A) Default constraint. This option is correct because a default constraint is optional and does not have to be specified when creating a table.

Which of the following can NOT be used to restrict specific values from being inserted into a column in a particular table?

  1. Index

  2. Check constraint

  3. Default constraint

  4. Referential constraint


Correct Option: C

When does a view get populated?

  1. When it is created

  2. When it is referenced in an INSERT statement

  3. Any time an executable SQL statement references it

  4. The first time any executable SQL statement references it


Correct Option: C

In NPS the minimum NPS row overhead is how many bytes

  1. 24

  2. 26

  3. 28

  4. 22


Correct Option: C

In NPS, it's a best practice to use 'rowid' as a primary key in a database table to guarantee quick access

  1. True

  2. False


Correct Option: B
- Hide questions