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
Below is a Relational Database Trivia Quiz! It is designed to help you understand how databases holding the same information are structured and maintained. Do you think that you have what it takes to tackle it based on what you...
Questions: 9 | Attempts: 8211 | Last updated: Apr 2, 2021
-
Sample QuestionWhich of the following makes it possible for entities toshare a relationship?
Ever wondered how much you know about DBMS, or the Database Management System? For this quiz, you should know what is responsible for authorizing access to the databases and obtaining software and hardware services, what is a...
Questions: 31 | Attempts: 5841 | Last updated: May 6, 2021
-
Sample Question-------------------------------responsible for authorizing access to the database, for coordinating and monitoring its use, acquiring software, and hardware resources, controlling its use, andmonitoring efficiency of operations.
Questions: 22 | Attempts: 5851 | Last updated: Jan 28, 2013
-
Sample QuestionWhat are the basic components of a linked list?
What Dog Breed Does Your Personality Match With Quiz
What Dog Breed Does Your Personality Match With Quiz
Hunter x Hunter Nen Test: What is Your Nen Personality?
Hunter x Hunter Nen Test: What is Your Nen Personality?
Back to top