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. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values






2. Order in which WHERE clause is evaluated and combined






3. Table displayed in descending order






4. Finds the lowest constant value in a column






5. Everything between the start and end tag






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






7. Large structured set of persistent data






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






9. Data in database interacts & corresponds with other data






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






11. Create program files that include SQ after each command






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






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






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






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






16. Deletes selected rows






17. Table displayed in descending order






18. Basic Component of SQL






19. Data stored by DAd






20. Ensures data is correct casings






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






22. Used to remove duplicates from result table






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






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






25. Deletes selected rows






26. Allows data recovery in case of corruption or loss






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






28. Attribute in quotes






29. Table displayed in ascending order






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






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






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






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






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






35. Averages the numeric values






36. Ensures functions are done efficiently






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






38. Large structured set of persistent data






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






40. Create program files that include SQ after each command






41. Grant acces and control to only specific information






42. Data in database interacts & corresponds with other data






43. All Columns indicated and selected






44. Change order of rows in result table






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






46. Order in which WHERE clause is evaluated and combined






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






48. Change order of rows in result table






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






50. Give the browser more specific information about that tag






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