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. Limits the output of the established groups into the derived result table






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






3. Most valuable asset of a database system.






4. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________






5. Ensures data is correct casings






6. Changes the values in one or more selected rows of a table






7. Meaningful info related to database






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






9. Data remains unchanged in database






10. Tally of how many rows meet criteria specified






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






12. Data in database interacts & corresponds with other data






13. Definition of commands it can do






14. Describe information in a tree styled format






15. Ensures functions are done efficiently






16. Identifies columns to appear in the result






17. SELECT statment containing the nested query






18. Meaningful info related to database






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






20. Attribute in quotes






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






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






23. Columns containing numbers only






24. Used to combine one query to another






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






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






27. Ensures functions are done efficiently






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






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






30. Basic Component of SQL






31. = - < - > - <= - >= - <> - !






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






33. Defines a new column






34. Interact and manipulates the data in the database






35. SQL finds and retrieves date






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






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. Limits the rows that appear in the result mathcing a specified condition






39. The Web is ___________






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






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






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






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






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






45. Writes programs that use or allow acces to databse with specific purpose






46. Finds the lowest ACII value in column






47. Describe information in a tree styled format






48. SQL finds and retrieves date






49. Order in which WHERE clause is evaluated and combined






50. Command based way to ask the database a question