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. SELECT statment containing the nested query






2. Used to combine one query to another






3. Flat File Examples: Excel Spreadsheets - _____






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






5. Used to combine one query to another






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






7. Uses two values as limits - selecting any values between the two of them






8. Change order of rows in result table






9. Grant acces and control to only specific information






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






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






12. Create program files that include SQ after each command






13. Averages the numeric values






14. Ensures functions are done efficiently






15. Data stored by DAd






16. Definition of commands it can do






17. Basic Component of SQL






18. Characterizes operation of a relational database






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






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






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






22. The Web is ___________






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






24. Finds the lowest ACII value in column






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






26. Essentially a collection of services that communicate with eachother






27. Using product as intended for its audience






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






29. Allow useres to retrieve data and interact with content located on web pages within website






30. Closed in the start tag by adding a slash to the start tag






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






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






33. Large structured set of persistent data






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






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






36. Everything between the start and end tag






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






38. Describe information in a tree styled format






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






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






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






42. Uses relationships between independent entities






43. Table displayed in descending order






44. All Columns indicated and selected






45. SQL finds and retrieves date






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






47. Flat File Examples: Excel Spreadsheets - _____






48. Meaningful info related to database






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






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