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. Allow useres to retrieve data and interact with content located on web pages within website






2. Used to remove duplicates from result table






3. Used with another comparison operator - values become inverted






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






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






6. Characterizes operation of a relational database






7. Ensures data is correct casings






8. Grant acces and control to only specific information






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






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






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






12. Using product as intended for its audience






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






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






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






16. SQL finds and retrieves date






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






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






19. Ensures functions are done efficiently






20. Supplies value for the search condition of the SELECT statement containing it






21. SELECT statment containing the nested query






22. = - < - > - <= - >= - <> - !






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






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






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






26. SQL finds and retrieves date






27. Basic Component of SQL






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






29. Table displayed in ascending order






30. Deletes selected rows






31. Defines a new column






32. Used to combine one query with another.






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






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






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






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






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






38. Uniquely identify each record in the table and are chosen at the time of table creation. It is recommended that you use a variable such as a Social Security for this.






39. Table displayed in ascending order






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






41. Order in which WHERE clause is evaluated and combined






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






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






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






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






46. Characterizes operation of a relational database






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






48. Used to combine one query to another






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






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