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. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns






2. SELECT statment containing the nested query






3. Columns containing numbers only






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






5. Used to close a tag properly






6. Basic Component of SQL






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






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






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






10. Essentially a collection of services that communicate with eachother






11. Deletes selected rows






12. Flat File Examples: Excel Spreadsheets - _____






13. Everything between the start and end tag






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






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






16. Join a table to a copy of itself






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. SQL finds and retrieves date






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






20. Most valuable asset of a database system.






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






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






23. Identifies columns to appear in the result






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






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






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






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






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






29. Definition of commands it can do






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






31. Finds the lowest constant value in a column






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






33. Attribute in quotes






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






35. Allows data recovery in case of corruption or loss






36. Deletes selected rows






37. Averages the numeric values






38. All Columns indicated and selected






39. Identifies columns to appear in the result






40. Table displayed in ascending order






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






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






43. Using product as intended for its audience






44. Data remains unchanged in database






45. Large structured set of persistent data






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






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






48. Selects from specific values in list






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






50. Create program files that include SQ after each command






Can you answer 50 questions in 15 minutes?



Let me suggest you:



Major Subjects



Tests & Exams


AP
CLEP
DSST
GRE
SAT
GMAT

Most popular tests