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. Flat File Examples: Excel Spreadsheets - _____






2. Table displayed in descending order






3. SELECT statment containing the nested query






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






5. Columns containing numbers only






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






7. Used to remove duplicates from result table






8. Interact and manipulates the data in the database






9. Finds the lowest constant value in a column






10. Create program files that include SQ after each command






11. Table displayed in descending order






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






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






14. Defines a new column






15. Identifies columns to appear in the result






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






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






18. Basic Component of SQL






19. SQL finds and retrieves date






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






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






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






23. All Columns indicated and selected






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






25. Data in database interacts & corresponds with other data






26. Allows data recovery in case of corruption or loss






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






28. Averages the numeric values






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






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






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






32. SQL finds and retrieves date






33. Interact and manipulates the data in the database






34. Begins an element






35. Practice of writing code into a webpage that is not directly visible to the user






36. Used to remove duplicates from result table






37. Essentially a collection of services that communicate with eachother






38. Deletes selected rows






39. Order in which WHERE clause is evaluated and combined






40. Grant acces and control to only specific information






41. Used to close a tag properly






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






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






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






45. Ensures data is correct casings






46. Data stored by DAd






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






48. Used with another comparison operator - values become inverted






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






50. = - < - > - <= - >= - <> - !