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. Looks like opening tag - but with a forward slash






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






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






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






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






6. Network node that discovers and invokes other software services to provide a buisness solution






7. Ensures data is correct casings






8. Used to remove duplicates from result table






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






10. Attribute in quotes






11. Data remains unchanged in database






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






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






14. Uses two values as limits - selecting any values between the two of them






15. Writes programs that use or allow acces to databse with specific purpose






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






17. System that is composed of a Certificate Authority - certificates - software - services and other cryptographic components to enable authenticity and validation of data and/or entities






18. Essentially a collection of services that communicate with eachother






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






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






21. Practice of writing code into a webpage that is not directly visible to the user






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






23. Uses relationships between independent entities






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






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






26. Ensures data is correct casings






27. Columns containing numbers only






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






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






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






31. Meaningful info related to database






32. Averages the numeric values






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






34. Identifies columns to appear in the result






35. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance






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






37. Finds the lowest constant value in a column






38. Flat File Examples: Excel Spreadsheets - _____






39. Grant acces and control to only specific information






40. Deletes selected rows






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






42. Table displayed in ascending order






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






44. File stored on a user's machine that contains infor about application






45. Ensures functions are done efficiently






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






47. Writes programs that use or allow acces to databse with specific purpose






48. Basic Component of SQL






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






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