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. Data remains unchanged in database






2. Software system designed to support interoperable machine - to - machine interaction over a network






3. Tally of how many rows meet criteria specified






4. Essentially a collection of services that communicate with eachother






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






6. Three Basic Operations of SP - SR - SB: Publish - Find - ____






7. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers






8. Join a table to a copy of itself






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






10. Decides what data is stored in the databse and the manner it is stored






11. Used to remove duplicates from result table






12. SQL finds and retrieves date






13. = - < - > - <= - >= - <> - !






14. Most valuable asset of a database system.






15. Table displayed in descending order






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






17. Characterizes operation of a relational database






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






19. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns






20. Used with another comparison operator - values become inverted






21. SELECT statment containing the nested query






22. File stored on a user's machine that contains infor about application






23. Allows data recovery in case of corruption or loss






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






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






26. Defines a new column






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






28. The Web is ___________






29. Meaningful info related to database






30. Describe information in a tree styled format






31. Large structured set of persistent data






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






33. Command used to show the attributes that define a table.






34. Attribute in quotes






35. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers






36. Grant acces and control to only specific information






37. Definition of commands it can do






38. Characterizes operation of a relational database






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






40. Give the browser more specific information about that tag






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






42. Cookies are more secure than______ - allowing travel on a website without loss of info






43. Everything in enviroment becomes an object - expands on Priniples of relational databases






44. Change order of rows in result table






45. Data remains unchanged in database






46. Order in which WHERE clause is evaluated and combined






47. Limits the output of the established groups into the derived result table






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






49. File stored on a user's machine that contains infor about application






50. Interact and manipulates the data in the database