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. Used to combine one query to another






2. Defines a new column






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






4. Begins an element






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






6. Columns containing numbers only






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






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






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






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






11. Grant acces and control to only specific information






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






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






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






15. Definition of commands it can do






16. Meaningful info related to database






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






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






19. Essentially a collection of services that communicate with eachother






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






21. Characterizes operation of a relational database






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






23. Create program files that include SQ after each command






24. Tally of how many rows meet criteria specified






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






26. Using product as intended for its audience






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






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






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






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






31. Used to close a tag properly






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






33. Ensures functions are done efficiently






34. Give the browser more specific information about that tag






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






36. Finds the lowest constant value in a column






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






38. Describe information in a tree styled format






39. Used with another comparison operator - values become inverted






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






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






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






43. One of the tools that SQL uses to find and retrieve data.






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






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






46. Using product as intended for its audience






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






48. Table displayed in descending order






49. Interact and manipulates the data in the database






50. Data remains unchanged in database