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. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG






2. Begins an element






3. All Columns indicated and selected






4. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG






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






6. Identifies columns to appear in the result






7. Meaningful info related to database






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






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






10. Identifies columns to appear in the result






11. Attribute in quotes






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






13. Used with another comparison operator - values become inverted






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






15. Columns containing numbers only






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






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






18. Used to combine one query with another.






19. = - < - > - <= - >= - <> - !






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






21. Tally of how many rows meet criteria specified






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






23. Combination of attributes that can be uniquely used to identify a database record and is generally the pool from which the primary key is chosen.






24. Considered the time that a user first accesses a page until a set of amount time - on the server - after their last activity or until the session is explicitly closed






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






26. Characterizes operation of a relational database






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






28. Table displayed in ascending order






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






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






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






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






33. Large structured set of persistent data






34. Data remains unchanged in database






35. Specifies the tables or views from which rows and columns are retrieved






36. Ensures data is correct casings






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






38. Essentially a collection of services that communicate with eachother






39. Create program files that include SQ after each command






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






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






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






43. Using product as intended for its audience






44. Supplies value for the search condition of the SELECT statement containing it






45. Table displayed in descending order






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






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






48. Uses relationships between independent entities






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






50. Flat File Examples: Excel Spreadsheets - _____