Test your basic knowledge |

Database Management Fundamentals

Subject : it-skills
Instructions:
  • Answer 50 questions in 15 minutes.
  • If you are not ready to take this test, you can study here.
  • Match each statement with the correct term.
  • Don't refresh. All questions and answers are randomly picked and ordered every time you load a test.

This is a study tool. The 3 wrong answers for each question are randomly chosen from answers to other questions. So, you might find at times the answers obvious, but you will see it re-enforces your understanding as you take the test each time.
1. Used to combine one query to another






2. Identifies columns to appear in the result






3. Attribute in quotes






4. Order in which WHERE clause is evaluated and combined






5. Some form of output - usually - printed - containing information






6. Table displayed in ascending order






7. Definition of commands it can do






8. Essentially a collection of services that communicate with eachother






9. Uses relationships between independent entities






10. The Web is ___________






11. Change order of rows in result table






12. Text markups that form an element" sort of a "box" to hold things like text and other elements






13. SELECT statment containing the nested query






14. Some form of output - usually - printed - containing information






15. One huge database to hold all data; Access to data - and use of system to add - update & print records






16. Data in database has ability to be accessed and manipulated by several users






17. Selects from specific values in list






18. Command based way to ask the database a question






19. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____






20. Looks like opening tag - but with a forward slash






21. Executes commands one at a time - results being displayed immediately






22. Defines a new column






23. Ensures functions are done efficiently






24. Software system designed to support interface for a software asset that manages a specific set of tasks






25. Writes programs that use or allow acces to databse with specific purpose






26. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____






27. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage






28. Allows use of single or multiple character wildcards with the underscore or percent symbol






29. Uses two values as limits - selecting any values between the two of them






30. One huge database to hold all data; Access to data - and use of system to add - update & print records






31. All Columns indicated and selected






32. Most valuable asset of a database system.






33. Computer equipment -Fixed Storage Media - Removeable Storage Media - System Memory - and the Processor






34. Data that has been processed into a format that is understandable by its audience






35. Network node that discovers and invokes other software services to provide a buisness solution






36. Flat File Examples: Excel Spreadsheets - _____






37. Has the highest precedence - followed by the AND - OR






38. Ongoing record of data reflecting the info defining the database






39. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________






40. Tally of how many rows meet criteria specified






41. Straight implementation of raw data formatted into rows and columns






42. Fields in a relational table that match the primary key from one column to the primary key of another table.






43. Allow useres to retrieve data and interact with content located on web pages within website






44. Uniquely identify each record in the table and are chosen at the time of table creation. It is recommended that you use a variable such as a Social Security for this.






45. Copies multiple records at the same time using a SELECT statement






46. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)






47. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance






48. Has the highest precedence - followed by the AND - OR






49. Ongoing record of data reflecting the info defining the database






50. Used to combine one query to another