Natural 2006 Practice Exam - Database Concepts
10 Questions
| Total Attempts: 151
Practice for the Software AG test
Questions and Answers
- 1.What is software ag's database called
- 2.What describes the datatypes, lengths, and attributes of a file for a database (acronym)
- 3.What letter denotes a floating point datatype in adabas
- A.
A
- B.
G
- C.
B
- D.
P
- E.
U
- 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.
- 5.Which of the following below is the default form of compression in Adabas?
- A.
No blank compression (NB)
- B.
Null suppression (NU)
- C.
Not Null (NN)
- D.
Fixed fields
- E.
Trailing blanks are removed for strings and leading zeros are removed and data is packed for numbers
- 6.Mark which Natural commands can be used to retrieve records for the update command
- A.
Get
- B.
Read
- C.
Find
- D.
Histogram
- 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?
- 8.What type of database protocol holds off on locking until the record is modified
- A.
Pessimistic
- B.
Optimistic
- C.
Record holding
- D.
Transaction processing
- 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
- A.
What's above is fine
- B.
Use the store record in work-view command first
- C.
Get work-view *isn (rd.)
- D.
Get work-view *isn
- 10.What should you place in an error handling block for a program that edits an important database?
- A.
Backout transaction
- B.
End transaction
- C.
Terminate
- D.
Stop
- E.
Retry
Back to top