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

t-sql variables case sensitive?

  1. True

  2. False


Correct Option: B
  1. records

  2. fields

  3. articles

  4. names


Correct Option: A
  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.

In a library catalogue database, each record represents:

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

  2. one author

  3. one subject

  4. all of the above


Correct Option: A

AI Explanation

To answer this question, you need to understand the purpose and structure of a library catalogue database.

A library catalogue database is used to organize and provide access to the items in a library's collection. Each record in the database represents one item in the collection, such as a book, journal, video, CD, etc. Therefore, the correct answer is A) one book, journal, video, CD, etc.

Option B) one author is incorrect because the database may contain multiple records for different books written by the same author.

Option C) one subject is incorrect because the database may contain multiple records for different items on the same subject.

Option D) all of the above is incorrect because the database focuses on individual items rather than grouping them by authors or subjects.

Therefore, the correct answer is A) one book, journal, video, CD, etc.

  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
  1. DB2 Everyplace

  2. DB2 Express Edition

  3. DB2 Workgroup Server Edition

  4. DB2 Enterprise Server Edition


Correct Option: B

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
  1. A select operation

  2. An update operation

  3. An insert operation

  4. A delete operation


Correct Option: A

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