Natural 2006 Practice Exam - Database Concepts

10 Questions | Total Attempts: 150

SettingsSettingsSettings
Please wait...
Database Quizzes & Trivia

Practice for the Software AG test


Related Topics
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