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. Uses relationships between independent entities






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






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






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






5. Using product as intended for its audience






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






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






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






9. = - < - > - <= - >= - <> - !






10. Give the browser more specific information about that tag






11. Data in database interacts & corresponds with other data






12. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG






13. Executes commands one at a time - results being displayed immediately






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






15. Data remains unchanged in database






16. Text markups that form an element" sort of a "box" to hold things like text and other elements






17. Text markups that form an element" sort of a "box" to hold things like text and other elements






18. Basic Component of SQL






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






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






21. Ensures data is correct casings






22. Data stored by DAd






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






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






25. Interact and manipulates the data in the database






26. Used to remove duplicates from result table






27. Definition of commands it can do






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






29. Tally of how many rows meet criteria specified






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






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






32. Describe information in a tree styled format






33. Averages the numeric values






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






35. Finds the lowest constant value in a column






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






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






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






39. Identifies columns to appear in the result






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






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






42. Table displayed in ascending order






43. Basic Component of SQL






44. Used to combine one query to another






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






46. SQL finds and retrieves date






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






48. Used to close a tag properly






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






50. Identifies columns to appear in the result






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