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. One huge database to hold all data; Access to data - and use of system to add - update & print records






2. Definition of commands it can do






3. Grant acces and control to only specific information






4. Data in database interacts & corresponds with other data






5. Essentially a collection of services that communicate with eachother






6. All Columns indicated and selected






7. Defines a new column






8. Identifies columns to appear in the result






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






10. Give the browser more specific information about that tag






11. Columns containing numbers only






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






13. Large structured set of persistent data






14. Everything between the start and end tag






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






16. Command based way to ask the database a question






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






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






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






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






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






22. Allows data recovery in case of corruption or loss






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






25. Used to combine one query with another.






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






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






28. Join a table to a copy of itself






29. Averages the numeric values






30. Change order of rows in result table






31. Interact and manipulates the data in the database






32. Grant acces and control to only specific information






33. Looks like opening tag - but with a forward slash






34. Begins an element






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






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






37. Table displayed in ascending order






38. Used with another comparison operator - values become inverted






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






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






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






42. Identifies columns to appear in the result






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






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






45. Essentially a collection of services that communicate with eachother






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






47. Attribute in quotes






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






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






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







Sorry!:) No result found.

Can you answer 50 questions in 15 minutes?


Let me suggest you:



Major Subjects



Tests & Exams


AP
CLEP
DSST
GRE
SAT
GMAT

Most popular tests