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. SQL Commands: Define tables - views - _____ - delete or insert info






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






3. Command based way to ask the database a question






4. Used with another comparison operator - values become inverted






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






6. The Web is ___________






7. Characterizes operation of a relational database






8. Table displayed in ascending order






9. Ensures data is correct casings






10. Command based way to ask the database a question






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






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






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






14. Give the browser more specific information about that tag






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






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






17. Most valuable asset of a database system.






18. Attribute in quotes






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






20. Used to combine one query to another






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






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






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






24. Describe information in a tree styled format






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






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






27. Using product as intended for its audience






28. Used to combine one query to another






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






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






31. Data remains unchanged in database






32. Finds the lowest ACII value in column






33. Data in database interacts & corresponds with other data






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






35. Table displayed in descending order






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






37. Meaningful info related to database






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






39. Defines a new column






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






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






42. Attribute in quotes






43. Finds the lowest constant value in a column






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






45. Everything between the start and end tag






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






47. Selects from specific values in list






48. Combination of attributes that can be uniquely used to identify a database record and is generally the pool from which the primary key is chosen.






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






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