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. Data in database has ability to be accessed and manipulated by several users






2. Ensures data is correct casings






3. Most valuable asset of a database system.






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






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






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






7. Deletes selected rows






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






9. Used in a SELECT clause in place of a column






10. Used with another comparison operator - values become inverted






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






12. Defines a new column






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






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






15. Used to combine one query with another.






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






17. Describe information in a tree styled format






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






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






20. Allow useres to retrieve data and interact with content located on web pages within website






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






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






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






24. Table displayed in ascending order






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






26. Everything between the start and end tag






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






28. Finds the lowest constant value in a column






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






30. Give the browser more specific information about that tag






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






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






33. Large structured set of persistent data






34. Used to remove duplicates from result table






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






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






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






38. Essentially a collection of services that communicate with eachother






39. Columns containing numbers only






40. Averages the numeric values






41. Columns containing numbers only






42. SELECT statment containing the nested query






43. Data remains unchanged in database






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






45. Identifies columns to appear in the result






46. Grant acces and control to only specific information






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






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






49. Interact and manipulates the data in the database






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