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. Limits the output of the established groups into the derived result table






2. Software system designed to support interface for a software asset that manages a specific set of tasks






3. Specifies the tables or views from which rows and columns are retrieved






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






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






6. Defines a new column






7. Characterizes operation of a relational database






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






9. Averages the numeric values






10. The Web is ___________






11. Change order of rows in result table






12. Deletes selected rows






13. Describe information in a tree styled format






14. Flat File Examples: Excel Spreadsheets - _____






15. Join a table to a copy of itself






16. Basic Component of SQL






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






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






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






20. Tally of how many rows meet criteria specified






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






22. Grant acces and control to only specific information






23. Uniquely identify each record in the table and are chosen at the time of table creation. It is recommended that you use a variable such as a Social Security for this.






24. Finds the lowest constant value in a column






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






26. Used to combine one query to another






27. Used to close a tag properly






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






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






30. Some form of output - usually - printed - containing information






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






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






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






34. Used with another comparison operator - values become inverted






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






36. Deletes selected rows






37. Ensures data is correct casings






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






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






40. Change order of rows in result table






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






42. Data stored by DAd






43. Ensures data is correct casings






44. Selects from specific values in list






45. Characterizes operation of a relational database






46. System that is composed of a Certificate Authority - certificates - software - services and other cryptographic components to enable authenticity and validation of data and/or entities






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






48. = - < - > - <= - >= - <> - !






49. Large structured set of persistent data






50. Used to remove duplicates from result table