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. Data in database has ability to be accessed and manipulated by several users






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






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






4. Individuals that use - manipulate or maintain aspects of database






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






6. Allows data recovery in case of corruption or loss






7. Deletes selected rows






8. Everything between the start and end tag






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






10. Finds the lowest constant value in a column






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






12. Ensures functions are done efficiently






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






14. Deletes selected rows






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






16. Combines rows from a SELECT statements result table into a group






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






18. One of the tools that SQL uses to find and retrieve data.






19. Ensures functions are done efficiently






20. Attribute in quotes






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






22. Begins an element






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






24. Identifies columns to appear in the result






25. Identifies columns to appear in the result






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






27. Allows data recovery in case of corruption or loss






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






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






30. Characterizes operation of a relational database






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






32. Data stored by DAd






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






34. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause






35. Large structured set of persistent data






36. Join a table to a copy of itself






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






38. Considered the time that a user first accesses a page until a set of amount time - on the server - after their last activity or until the session is explicitly closed






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






40. Straight implementation of raw data formatted into rows and columns






41. SELECT statment containing the nested query






42. Grant acces and control to only specific information






43. Averages the numeric values






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






45. Table displayed in descending order






46. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause






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






48. Used with another comparison operator - values become inverted






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






50. Selects from specific values in list







Sorry!:) No result found.

Can you answer 50 questions in 15 minutes?


Let me suggest you:

Browse all subjects

Browse all tests

Most popular tests



Major Subjects

Tests & Exams


AP
CLEP
DSST
GRE
SAT
GMAT

Browse all subjects

Browse all tests

Most popular tests