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. Grant acces and control to only specific information






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






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






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






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






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






7. = - < - > - <= - >= - <> - !






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






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






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






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






12. Table displayed in descending order






13. Finds the lowest constant value in a column






14. Allows data recovery in case of corruption or loss






15. Using product as intended for its audience






16. Most valuable asset of a database system.






17. Essentially a collection of services that communicate with eachother






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






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






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






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






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






23. Compares value of the column in the specified condition with the value specified






24. Flat File Examples: Excel Spreadsheets - _____






25. Tally of how many rows meet criteria specified






26. Data stored by DAd






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






28. Data stored by DAd






29. Characterizes operation of a relational database






30. Command used to show the attributes that define a table.






31. One huge database to hold all data; Access to data - and use of system to add - update & print records






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






33. Tally of how many rows meet criteria specified






34. Table displayed in ascending order






35. Characterizes operation of a relational database






36. SQL finds and retrieves date






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






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






39. SELECT statment containing the nested query






40. Basic Component of SQL






41. Give the browser more specific information about that tag






42. Data remains unchanged in database






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






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






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






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






47. Command based way to ask the database a question






48. All Columns indicated and selected






49. One huge database to hold all data; Access to data - and use of system to add - update & print records






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