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. Writes programs that use or allow acces to databse with specific purpose






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






3. Large structured set of persistent data






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






5. Give the browser more specific information about that tag






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






7. Table displayed in descending order






8. Interact and manipulates the data in the database






9. 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.






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






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






12. Describe information in a tree styled format






13. Flat File Examples: Excel Spreadsheets - _____






14. Using product as intended for its audience






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






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






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






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






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






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






21. Give the browser more specific information about that tag






22. Basic Component of SQL






23. Data stored by DAd






24. Attribute in quotes






25. Table displayed in ascending order






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






27. Grant acces and control to only specific information






28. Attribute in quotes






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






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






31. Concatenated in SQL Server Database software using the addition symbol






32. Uses relationships between independent entities






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






34. Ensures data is correct casings






35. SELECT statment containing the nested query






36. Finds the lowest constant value in a column






37. 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.






38. Averages the numeric values






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






40. Essentially a collection of services that communicate with eachother






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






42. Most valuable asset of a database system.






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






44. = - < - > - <= - >= - <> - !






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






46. Selects from specific values in list






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






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






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






50. Definition of commands it can do