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. Large structured set of persistent data






2. Everything in enviroment becomes an object - expands on Priniples of relational databases






3. Attribute in quotes






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






5. Interact and manipulates the data in the database






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






7. Identifies columns to appear in the result






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






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






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






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






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






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






14. Used with another comparison operator - values become inverted






15. Ensures functions are done efficiently






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






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






18. Meaningful info related to database






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






20. Finds the lowest ACII value in column






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






22. Used to remove duplicates from result table






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






24. All Columns indicated and selected






25. Essentially a collection of services that communicate with eachother






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






27. Meaningful info related to database






28. Join a table to a copy of itself






29. Uses relationships between independent entities






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






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






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






33. Computer programs allowing website visitors to submit and retrieve data to/from a database over the Internet using their preferred web browser






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






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






36. Create program files that include SQ after each command






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






38. Columns containing numbers only






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






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






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






42. Finds the lowest constant value in a column






43. Change order of rows in result table






44. Used to combine one query to another






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






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






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






48. Defines a new column






49. Finds the lowest ACII value in column






50. Tally of how many rows meet criteria specified






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