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. Some form of output - usually - printed - containing information






2. Command based way to ask the database a question






3. Order in which WHERE clause is evaluated and combined






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






5. Table displayed in descending order






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






7. = - < - > - <= - >= - <> - !






8. Definition of commands it can do






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






10. Averages the numeric values






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






12. Deletes selected rows






13. Columns containing numbers only






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






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






16. Ensures data is correct casings






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






18. SELECT statment containing the nested query






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






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






21. Used to combine one query to another






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






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






24. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance






25. Finds the lowest ACII value in column






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






27. Used with another comparison operator - values become inverted






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






29. Data remains unchanged in database






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






31. Deletes selected rows






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






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






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






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






36. Finds the lowest constant value in a column






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






38. Grant acces and control to only specific information






39. SQL finds and retrieves date






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






41. SQL finds and retrieves date






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






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






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






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






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






47. Used to combine one query to another






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






49. Ensures functions are done efficiently






50. Uses relationships between independent entities