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. = - < - > - <= - >= - <> - !






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






3. Join a table to a copy of itself






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






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






6. Text markups that form an element" sort of a "box" to hold things like text and other elements






7. Flat File Examples: Excel Spreadsheets - _____






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






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






10. Uses relationships between independent entities






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






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






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






14. Computer equipment -Fixed Storage Media - Removeable Storage Media - System Memory - and the Processor






15. Most valuable asset of a database system.






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






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






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






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






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






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






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






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






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






25. Data stored by DAd






26. Averages the numeric values






27. Ensures data is correct casings






28. Order in which WHERE clause is evaluated and combined






29. Definition of commands it can do






30. Table displayed in ascending order






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






32. Used to combine one query to another






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






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






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






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






37. Data stored by DAd






38. Used with another comparison operator - values become inverted






39. Used in a SELECT clause in place of a column






40. Table displayed in descending order






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






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






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






44. Command based way to ask the database a question






45. Text markups that form an element" sort of a "box" to hold things like text and other elements






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






47. Join a table to a copy of itself






48. Change order of rows in result table






49. Describe information in a tree styled format






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