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. Begins an element






2. Everything between the start and end tag






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






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






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






6. Ongoing record of data reflecting the info defining the database






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






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






9. SELECT statment containing the nested query






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






11. Used to remove duplicates from result table






12. Characterizes operation of a relational database






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






14. Deletes selected rows






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






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






17. Flat File Examples: Excel Spreadsheets - _____






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






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






20. Grant acces and control to only specific information






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






22. Table displayed in ascending order






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






24. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns






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






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






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






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






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






30. Begins an element






31. Interact and manipulates the data in the database






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






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






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






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






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






37. Ensures functions are done efficiently






38. Everything between the start and end tag






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






40. Table displayed in descending order






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






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






43. Used with another comparison operator - values become inverted






44. SQL finds and retrieves date






45. Join a table to a copy of itself






46. Attribute in quotes






47. Selects from specific values in list






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






49. The Web is ___________






50. Defines a new column







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