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. Supplies value for the search condition of the SELECT statement containing it






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






3. Characterizes operation of a relational database






4. Describe information in a tree styled format






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






6. Definition of commands it can do






7. All Columns indicated and selected






8. Ensures data is correct casings






9. Computer programs allowing website visitors to submit and retrieve data to/from a database over the Internet using their preferred web browser






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






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






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






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






14. Used to remove duplicates from result table






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






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






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






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






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






20. Join a table to a copy of itself






21. Deletes selected rows






22. Defines a new column






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






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






25. Table displayed in ascending order






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






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






28. Join a table to a copy of itself






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






30. Definition of commands it can do






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






32. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands






33. Uses relationships between independent entities






34. Data remains unchanged in database






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






36. SELECT statment containing the nested query






37. Allows data recovery in case of corruption or loss






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






39. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____






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






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






42. SELECT statment containing the nested query






43. Give the browser more specific information about that tag






44. Order in which WHERE clause is evaluated and combined






45. Describe information in a tree styled format






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






47. Large structured set of persistent data






48. Used to combine one query to another






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






50. Meaningful info related to database