Natural 2006 Practice Exam - Database Concepts

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Nimba
N
Nimba
Community Contributor
Quizzes Created: 2 | Total Attempts: 255
| Attempts: 194
SettingsSettings
Please wait...
  • 1/10 Questions

    What is software ag's database called

Please wait...
About This Quiz

The 'Natural 2006 Practice Exam - Database Concepts' focuses on Adabas, a database system by Software AG. It assesses knowledge of database structures, data types, and command usage essential for managing and retrieving data effectively. This quiz is pivotal for learners aiming to master Adabas database management.

Database Systems Quizzes & Trivia

Quiz Preview

  • 2. 

    What is used as an inverted list to get records from a file? Note that the inverted list stores these; they are also known as keys.

    Explanation
    A descriptor is used as an inverted list to get records from a file. In this context, the descriptor serves as a key that helps retrieve specific records from the file. The inverted list, which is essentially a collection of these descriptors or keys, allows for efficient searching and retrieval of records based on specific criteria.

    Rate this question:

  • 3. 

    What describes the datatypes, lengths, and attributes of a file for a database (acronym)

    Explanation
    The acronym "fdt" stands for File Definition Table, which describes the datatypes, lengths, and attributes of a file for a database. The File Definition Table is used to define the structure and characteristics of a file, including the types of data it can store, the length of each field, and any additional attributes or constraints that apply to the file. This information is crucial for organizing and managing data within a database system.

    Rate this question:

  • 4. 

    What should you place in an error handling block for a program that edits an important database?

    • Backout transaction

    • End transaction

    • Terminate

    • Stop

    • Retry

    Correct Answer
    A. Backout transaction
    Explanation
    If this application fails it should abort the transaction by doing backout transaction. This undos whatever modifications were done since the last end transaction.

    terminate stops the current program. stop exits the natural environment. retry goes back to the code that caused the error.

    Rate this question:

  • 5. 

    You have to update only a few records in the database, but you have to read a lot of records. Which method would reduce the number of records held?DEFINE DATA LOCAL 1 WORK-VIEW VIEW OF WORK2 ID-NO2 NAME2 DEPT2 LOCATIONEND-DEFINERD. READ WORK-VIEW BY ID-NOIF DEPT = "HR" OR DEPT = "ACCOUNTING" * YOUR CODE HERELOCATION := "CA"UPDATE END TRANSACTIONEND-IFEND-READ

    • What's above is fine

    • Use the store record in work-view command first

    • Get work-view *isn (rd.)

    • Get work-view *isn

    Correct Answer
    A. Get work-view *isn (rd.)
    Explanation
    The store command is for adding new records. The problem with the above code is that it will lock every record read. Whenever a update command shows up, the record retrieved before it will be held. The get command is redundant since we are doing another adabas access. However, only the records retrieved with get will be locked. (rd.) refers to the label by the read command. This is so Natural knows where the ISN (internal sequence number) comes from.

    Rate this question:

  • 6. 

    Which of the following below is the default form of compression in Adabas?

    • No blank compression (NB)

    • Null suppression (NU)

    • Not Null (NN)

    • Fixed fields

    • Trailing blanks are removed for strings and leading zeros are removed and data is packed for numbers

    Correct Answer
    A. Trailing blanks are removed for strings and leading zeros are removed and data is packed for numbers
    Explanation
    NB does means that fields are stored without stripping blanks. NU means that the database only stores one byte for null values. NN requires that the field has a value.

    Here is some info on field compression types:
    http://documentation.softwareag.com/adabas/ada614unw/admin/fdtrec.htm#fisanchor0

    Rate this question:

  • 7. 

    Mark which Natural commands can be used to retrieve records for the update command

    • Get

    • Read

    • Find

    • Histogram

    Correct Answer(s)
    A. Get
    A. Read
    A. Find
    Explanation
    The Natural 6.2.3 help only lists get, read, and find as commands to get records for update. Histogram only retrieves values from the inverted list.

    Rate this question:

  • 8. 

    What letter denotes a floating point datatype in adabas

    • A

    • G

    • B

    • P

    • U

    Correct Answer
    A. G
    Explanation
    A is alphanumeric, G is floating pt, B is binary, P is packed, U is Unpacked, and W is unicode

    Rate this question:

  • 9. 

    What type of database protocol holds off on locking until the record is modified

    • Pessimistic

    • Optimistic

    • Record holding

    • Transaction processing

    Correct Answer
    A. Optimistic
    Explanation
    Pessimistic locks the record as soon as it's accessed. Record holding is the act of locking a piece of the database, so it cannot be accessed or changed by other users.

    Rate this question:

  • 10. 

    DEFINE DATA LOCAL 1 WORK-VIEW VIEW OF WORK 2 ID-NO (N6) 2 NAME (A20) END-DEFINE ID := 1 NAME := "JOHN DOE" * What is the command to add this to the database?

    Correct Answer
    STORE RECORD IN WORK-VIEW
    Explanation
    The command "STORE RECORD IN WORK-VIEW" is used to add the data, with the ID value of 1 and the NAME value of "JOHN DOE", to the WORK-VIEW database.

    Rate this question:

Quiz Review Timeline (Updated): Mar 20, 2023 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Mar 20, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Aug 30, 2008
    Quiz Created by
    Nimba
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.