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. Ensures functions are done efficiently






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






3. All Columns indicated and selected






4. Selects from specific values in list






5. Used with another comparison operator - values become inverted






6. Finds the lowest ACII value in column






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






8. Order in which WHERE clause is evaluated and combined






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






10. Begins an element






11. Characterizes operation of a relational database






12. Finds the lowest constant value in a column






13. SQL finds and retrieves date






14. Used to combine one query to another






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






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






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






18. Using product as intended for its audience






19. Tally of how many rows meet criteria specified






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






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






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






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






24. Flat File Examples: Excel Spreadsheets - _____






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






26. Allows data recovery in case of corruption or loss






27. Used to combine one query to another






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






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






30. Allows use of single or multiple character wildcards with the underscore or percent symbol






31. Allows data recovery in case of corruption or loss






32. Table displayed in descending order






33. Defines a new column






34. Averages the numeric values






35. Interact and manipulates the data in the database






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






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






38. Allows use of single or multiple character wildcards with the underscore or percent symbol






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






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






41. Using product as intended for its audience






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






43. SELECT statment containing the nested query






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






45. Flat File Examples: Excel Spreadsheets - _____






46. Meaningful info related to database






47. Create program files that include SQ after each command






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






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






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