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. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)






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






3. Browser requests page - code is delivered - executed and done with






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






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






6. Large structured set of persistent data






7. Large structured set of persistent data






8. = - < - > - <= - >= - <> - !






9. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values






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






11. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause






12. Everything between the start and end tag






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






14. Grant acces and control to only specific information






15. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands






16. Essentially a collection of services that communicate with eachother






17. Flat File Examples: Excel Spreadsheets - _____






18. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands






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






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






21. SQL Commands - Two Things Specify data interested in - Indicate the ________






22. Give the browser more specific information about that tag






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






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






25. Changes the values in one or more selected rows of a table






26. Selects from specific values in list






27. Practice of writing code into a webpage that is not directly visible to the user






28. The Web is ___________






29. SQL Commands: Define tables - views - _____ - delete or insert info






30. Interact and manipulates the data in the database






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






32. SQL finds and retrieves date






33. Give the browser more specific information about that tag






34. Definition of commands it can do






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






36. SQL Commands - Two Things Specify data interested in - Indicate the ________






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






38. Identifies columns to appear in the result






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






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






41. Basic Component of SQL






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






43. Interact and manipulates the data in the database






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






45. Create program files that include SQ after each command






46. Practice of writing code into a webpage that is not directly visible to the user






47. Begins an element






48. Data stored by DAd






49. Used to remove duplicates from result table






50. Command based way to ask the database a question