Tag: databases

Questions Related to databases

We can declare DB2 host variables in a COBOL copybook
technology databases

  1. True

  2. False

Show answer
Correct Option: B

Given the following table: TEMP_DATA TEMP DATE _____________ 45    12/25/2006 51    12/26/2006 67    12/27/2006 72    12/28/2006 34    12/29/2006 42    12/30/2006 And the following SQL statement: TE FUNCTION degf_to_c (temp INTEGER) RETURNS INTEGER LANGUAGE SQL CONTAINS SQL NO EXTERNAL ACTION DETERMINISTIC BEGIN ATOMIC DECLARE newtemp INTEGER; SET newtemp = temp - 32; SET newtemp = newtemp * 5; RETURN newtemp / 9; END Which two of the following SQL statements illustrate the proper way to invoke the calar function DEGF_TO_C?
technology databases

  1. VALUES degf_to_c(32)

  2. SELECT date, degf_to_c(temp) AS temp_c FROM temp_data

  3. CALL degf_to_c(32)

  4. Both a and b

Show answer
Correct Option: D

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

AI Explanation

To answer this question, you need to understand the basic structure of a database.

A database is divided into:

A. records - This option is correct. In a database, a record is a collection of related data items that are grouped together. Each record represents a single entity or object, such as a customer, product, or employee.

B. fields - This option is also correct. A field is a specific piece of information within a record. It represents a single attribute or characteristic of the entity being stored in the database. For example, in a customer record, the fields may include the customer's name, address, and phone number.

C. articles - This option is incorrect. Articles are not typically used to divide a database. Articles are a more general term used for written content or publications.

D. names - This option is incorrect. Names are not used to divide a database. Names are used to identify individual entities or objects within a database, such as the name of a customer or a product.

The correct answer is A) records. This option is correct because records are the primary division of a database, representing individual entities or objects.

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

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.

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