• databases Online Quiz - 196
Back
0

databases Online Quiz - 196

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

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

technology databases

  1. True

  2. False

Show answer
Correct Option: A

can we have a nested transaction
technology databases

  1. True

  2. False

Show answer
Correct Option: A

t-sql variables case sensitive?
technology databases

  1. True

  2. False

Show answer
Correct Option: B

A database is divided into:
technology databases

  1. records

  2. fields

  3. articles

  4. names

Show answer
Correct Option: A

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

technology databases

  1. one magazine, journal or newspaper

  2. one author

  3. one article from a magazine, journal or newspaper

  4. all of the above

Show answer
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:
technology databases

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

  2. one author

  3. one subject

  4. all of the above

Show answer
Correct Option: A

You are searching an electronic article index that contains citations to journal articles. What part of each article does the database contain?
technology databases

  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

Show answer
Correct Option: D

You are making your own database so you can organize information about your ‘Top 100' movies. You want to include information like Title, Actor(s), Director, Year, Genre, etc. Each record in your database will represent:
technology databases

  1. an actor

  2. a director

  3. a year

  4. a movie

Show answer
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?

technology databases

  1. DB2 Everyplace

  2. DB2 Express Edition

  3. DB2 Workgroup Server Edition

  4. DB2 Enterprise Server Edition

Show answer
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.

On which two of the following database objects may the SELECT privilege be controlled?
technology databases

  1. Index

  2. Sequence

  3. Nickname

  4. View

Show answer
Correct Option: C,D

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

technology databases

  1. Identity column

  2. Table function

  3. Sequence

  4. Trigger

Show answer
Correct Option: C

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

technology databases

  1. A select operation

  2. An update operation

  3. An insert operation

  4. A delete operation

Show answer
Correct Option: A

Which of the following DB2 data types does NOT have a fixed length?
technology databases

  1. INT

  2. XML

  3. CHAR

  4. DOUBLE

Show answer
Correct Option: B

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

technology databases

  1. SMALLINT

  2. NUMERIC

  3. INTEGER

  4. DOUBLE

Show answer
Correct Option: D

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

technology databases

  1. Default constraint

  2. Column data type

  3. Column name

  4. Table name

Show answer
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?

technology databases

  1. Index

  2. Check constraint

  3. Default constraint

  4. Referential constraint

Show answer
Correct Option: C

When does a view get populated?

technology databases

  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

Show answer
Correct Option: C

To which of the following resources can a lock NOT be applied?
technology databases

  1. Tablespaces

  2. Buffer pools

  3. Tables

  4. Rows

Show answer
Correct Option: B

In NPS the minimum NPS row overhead is how many bytes

technology databases

  1. 24

  2. 26

  3. 28

  4. 22

Show answer
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

technology databases

  1. True

  2. False

Show answer
Correct Option: B
- Hide questions
ADVERTISEMENT

Find more quizzes from top tags

general knowledge
3615 Quizzes
119858 Questions
 technology
307 Quizzes
36705 Questions
 sports
961 Quizzes
19148 Questions
 history
1187 Quizzes
13475 Questions
 physics
550 Quizzes
11687 Questions
 biology
1078 Quizzes
11791 Questions
 science & technology
551 Quizzes
11015 Questions
 chemistry
462 Quizzes
9309 Questions
 maths
457 Quizzes
8210 Questions
 softskills
0 Quizzes
7131 Questions