Natural 2006 Practice Exam - Database Concepts
-
What is software ag's database called
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.
Quiz Preview
- 2.
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:
- 3.
What letter denotes a floating point datatype in adabas
-
A
-
G
-
B
-
P
-
U
Correct Answer
A. GExplanation
A is alphanumeric, G is floating pt, B is binary, P is packed, U is Unpacked, and W is unicodeRate this question:
-
- 4.
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.
Correct Answer
descriptorExplanation
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:
- 5.
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 numbersExplanation
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#fisanchor0Rate this question:
-
- 6.
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. FindExplanation
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:
-
- 7.
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(s)
STORE RECORD IN WORK-VIEWExplanation
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:
- 8.
What type of database protocol holds off on locking until the record is modified
-
Pessimistic
-
Optimistic
-
Record holding
-
Transaction processing
Correct Answer
A. OptimisticExplanation
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:
-
- 9.
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:
-
- 10.
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 transactionExplanation
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:
-
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, 2023Quiz Edited by
ProProfs Editorial Team -
Aug 30, 2008Quiz Created by
Nimba
Back to top