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. Command used to show the attributes that define a table.






2. Attribute in quotes






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






4. Using product as intended for its audience






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






6. Begins an element






7. Interact and manipulates the data in the database






8. Individuals that use - manipulate or maintain aspects of database






9. Everything between the start and end tag






10. Flat File Examples: Excel Spreadsheets - _____






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






12. Basic Component of SQL






13. Used with another comparison operator - values become inverted






14. Order in which WHERE clause is evaluated and combined






15. All Columns indicated and selected






16. Closed in the start tag by adding a slash to the start tag






17. Responsible for technical implementation & maintenance of database on a design & physical level






18. Definition of commands it can do






19. Describe information in a tree styled format






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






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






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






23. Describe information in a tree styled format






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






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






26. Selects from specific values in list






27. = - < - > - <= - >= - <> - !






28. Meaningful info related to database






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






30. Essentially a collection of services that communicate with eachother






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






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






33. Computer programs allowing website visitors to submit and retrieve data to/from a database over the Internet using their preferred web browser






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






35. Closed in the start tag by adding a slash to the start tag






36. Combines rows from a SELECT statements result table into a group






37. Ensures functions are done efficiently






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






39. Limits the rows that appear in the result mathcing a specified condition






40. Used with another comparison operator - values become inverted






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






42. Using product as intended for its audience






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






44. Compares value of the column in the specified condition with the value specified






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






46. Flat File Examples: Excel Spreadsheets - _____






47. Interact and manipulates the data in the database






48. Responsible for technical implementation & maintenance of database on a design & physical level






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






50. Command based way to ask the database a question