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. Using product as intended for its audience






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






3. Create program files that include SQ after each command






4. Used with another comparison operator - values become inverted






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






6. Command based way to ask the database a question






7. Used to combine one query to another






8. Flat File Examples: Excel Spreadsheets - _____






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






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






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






12. Join a table to a copy of itself






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






14. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____






15. Allows data recovery in case of corruption or loss






16. Decides what data is stored in the databse and the manner it is stored






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






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






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






20. Tally of how many rows meet criteria specified






21. Ensures functions are done efficiently






22. Flat File Examples: Excel Spreadsheets - _____






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






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






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






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






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






28. Order in which WHERE clause is evaluated and combined






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






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






31. Change order of rows in result table






32. Deletes selected rows






33. Ensures functions are done efficiently






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






35. Definition of commands it can do






36. Identifies columns to appear in the result






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






38. Tally of how many rows meet criteria specified






39. Attribute in quotes






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






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






42. Fields in a relational table that match the primary key from one column to the primary key of another table.






43. Finds the lowest constant value in a column






44. Finds the lowest ACII value in column






45. Selects from specific values in list






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






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






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






49. Ensures data is correct casings






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







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