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. Deletes selected rows






2. Data stored by DAd






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






4. Change order of rows in result table






5. Definition of commands it can do






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






7. Interact and manipulates the data in the database






8. Averages the numeric values






9. Data in database interacts & corresponds with other data






10. Used to remove duplicates from result table






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






12. Large structured set of persistent data






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






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






15. Grant acces and control to only specific information






16. Selects from specific values in list






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






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






19. Supplies value for the search condition of the SELECT statement containing it






20. Table displayed in descending order






21. = - < - > - <= - >= - <> - !






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






23. Command based way to ask the database a question






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






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






26. Data in database has ability to be accessed and manipulated by several users






27. Cookies are more secure than______ - allowing travel on a website without loss of info






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






29. Describe information in a tree styled format






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






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






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






33. Ensures data is correct casings






34. Attribute in quotes






35. Join a table to a copy of itself






36. Everything between the start and end tag






37. Table displayed in descending order






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






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






40. Ensures functions are done efficiently






41. Identifies columns to appear in the result






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






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






44. Table displayed in ascending order






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






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






47. Used to combine one query with another.






48. Begins an element






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






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