THE DATA DETECTIVE - QuickBooks Database Quiz

by

QuickBooks Database Quiz

I thought it might be fun to write an article as a Quiz over the QuickBooks database.  I guess we will consider this an ‘open book’ Quiz since you can always research the various articles I have written to come up with the answers. 

So if you think of yourself as a QuickBooks Master, then take this little quiz and see how much you know?  I will be writing an article to give you the answers for ‘grading purposes’ in a few days. 

  1. Since 2006, Intuit has used Sybase as the ‘database’ for QuickBooks; what database was used previously?
  2. QuickBooks provides two versions of the Sybase database server; the personal database server is installed when QuickBooks has been set-up as a stand-alone application. What windows process is shown in Task Manager when this server is running?
  3. The Sybase network database server supports client/server communications across a network in order to provide multi-user capabilities.  What ‘windows user account’ does the Network Server operate under for 2014?
  4. What file records all of the database server’s activities (reads, writes, inserts, deletes, etc.) in machine language? (Hint: This file can sometimes be 'played back' by data recovery experts to restore missing data.)
  5. The QBWin.log file commonly refers to a source transaction as the “__________” record?
  6. “_________” are pointers used to provide rapid, random access to data within the database?
  7. In QuickBooks, the targetID and transactionID make up the “__________” key?
  8. These store data in a defined schema depending on their type, in QuickBooks each of them contain 4096 bytes, what are they?
  9. A “__________” always reflect a specific point in time when all the data in the database is held in the database file?
  10. What is the most common type of data corruption?
  11. Name the four most common causes of data corruption?
  12. What is the first step you should take whenever you realize that you have a data problem in QuickBooks?

                 A. Contact Intuit Technical Support Data Services

                 B. Run the Verify Data Utility and then examine the QBWin.log file.

                 C. Make a Windows copy of the entire directory containing your QuickBooks file

                 D. Restore your last fully verified backup

                 E. All of the above (A thru D) in that order

If you are game, bring your quiz by the Intuitive Accountant Booth at Scaling New Heights for a special award.....I look forward to meeting you.