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. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________






2. Characterizes operation of a relational database






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






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






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






6. Using product as intended for its audience






7. Grant acces and control to only specific information






8. The Web is ___________






9. Tally of how many rows meet criteria specified






10. Table displayed in descending order






11. Finds the lowest constant value in a column






12. Create program files that include SQ after each command






13. Command based way to ask the database a question






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






15. Considered the time that a user first accesses a page until a set of amount time - on the server - after their last activity or until the session is explicitly closed






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






17. Order in which WHERE clause is evaluated and combined






18. Ensures data is correct casings






19. Used to remove duplicates from result table






20. Allows data recovery in case of corruption or loss






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






22. SQL finds and retrieves date






23. Fields in a relational table that match the primary key from one column to the primary key of another table.






24. = - < - > - <= - >= - <> - !






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






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






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






28. All Columns indicated and selected






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






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






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






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






33. All Columns indicated and selected






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






35. Data stored by DAd






36. Defines a new column






37. Give the browser more specific information about that tag






38. Command based way to ask the database a question






39. Table displayed in descending order






40. Uses relationships between independent entities






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






42. Uses relationships between independent entities






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






44. Averages the numeric values






45. Using product as intended for its audience






46. Data stored by DAd






47. Selects from specific values in list






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






49. Everything between the start and end tag






50. Table displayed in ascending order