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. Supplies value for the search condition of the SELECT statement containing it






2. Data remains unchanged in database






3. Grant acces and control to only specific information






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






5. Used to combine one query to another






6. = - < - > - <= - >= - <> - !






7. Allows data recovery in case of corruption or loss






8. Characterizes operation of a relational database






9. Using product as intended for its audience






10. Network node that discovers and invokes other software services to provide a buisness solution






11. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage






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






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






14. Finds the lowest constant value in a column






15. Ensures functions are done efficiently






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






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






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






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






20. Flat File Examples: Excel Spreadsheets - _____






21. Large structured set of persistent data






22. Data stored by DAd






23. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause






24. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause






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






26. Table displayed in ascending order






27. Network node that discovers and invokes other software services to provide a buisness solution






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






29. Table displayed in ascending order






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






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






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






33. Data in database interacts & corresponds with other data






34. Table displayed in descending order






35. SELECT statment containing the nested query






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






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






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






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






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






41. SELECT statment containing the nested query






42. Basic Component of SQL






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






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






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






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






47. All Columns indicated and selected






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






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






50. Used to close a tag properly