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. Computer programs allowing website visitors to submit and retrieve data to/from a database over the Internet using their preferred web browser
Subqueries
MAX
Persistent
Web Applications

2. Has the highest precedence - followed by the AND - OR
Object-Oriented Relational (OOR)
Data Recovery & Concurrance
DISTINCT
NOT

3. Data in database interacts & corresponds with other data
Tags
Self Join
Web server
Integrated

4. Give the browser more specific information about that tag
Users
Service Requestor
Data Elements
Attributes

5. Decides what data is stored in the databse and the manner it is stored
Data Dictionary
WHERE
Tables
Data Administrator (DAd)

6. Three Basic Operations of SP - SR - SB: Publish - Find - ____
FROM
Tables
to update
Bind

7. Cookies are more secure than______ - allowing travel on a website without loss of info
Database
Interactive SQL
hidden fields
Element Content

8. Columns containing numbers only
Bind
SUM
ALL
LIKE

9. Network node that discovers and invokes other software services to provide a buisness solution
Service Requestor
SUM
Users
Foreign Keys

10. Ongoing record of data reflecting the info defining the database
Object-Oriented Relational (OOR)
Primary Keys
Data Dictionary
LIKE

11. Deletes selected rows
DISTINCT
DELETE
Web Service
IN

12. Finds the lowest ACII value in column
Shared
FROM
Relational
MIN

13. Data stored by DAd
MAX
Indexes
Data Elements
Data Dictionary

14. Individuals that use - manipulate or maintain aspects of database
End Users
Element Content
Opening tag
Users

15. SQL Commands - Two Things Specify data interested in - Indicate the ________
Hypertext Markup Language (HTML)
Data
ASC
accident

16. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
Self Join
Aliases
single value
End Users

17. Used to close a tag properly
Structured Query Language (SQL)
Data Definition
sp_help
Forward Slash

18. Specifies the tables or views from which rows and columns are retrieved
BETWEEN
Bind
Inner SELECT query
FROM

19. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG
Subqueries
Comparison Operators
Hardware
SUM

20. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
Integrated
Shared
Dynamic
ALL

21. Software system designed to support interoperable machine - to - machine interaction over a network
Closing tag
Property
Service-Oriented Architecture (SOA)
Web Service

22. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
Aliases
DISTINCT
Dynamic
Application Programers

23. Allows use of single or multiple character wildcards with the underscore or percent symbol
Database
LIKE
Data
MIN

24. Responsible for technical implementation & maintenance of database on a design & physical level
Web Service
Integrated
Data Elements
Database Administrator (DBA)

25. Selects from specific values in list
Equals Operator
IN
Indexes
Joins

26. One of the tools that SQL uses to find and retrieve data.
Indexes
Data
Data Administrator (DAd)
Shared

27. Join a table to a copy of itself
Attributes
Self Join
Primary Keys
Word

28. Allows data recovery in case of corruption or loss
Integrated
Data
Views
Data Recovery & Concurrance

29. Command based way to ask the database a question
Flat File
Property
Query
Dynamic

30. Flat File Examples: Excel Spreadsheets - _____
Candidate Keys
Bind
Word
IN

31. Table displayed in ascending order
Indexes
Hardware
Foreign Keys
ASC

32. Ensures functions are done efficiently
Empty Elements
FROM
Data Definition
Performance

33. Data in database interacts & corresponds with other data
Fields
Integrated
SUM
Indexes

34. Software system designed to support interoperable machine - to - machine interaction over a network
Precedence of Logical Operators
MAX
Service Provider
Web Service

35. Using product as intended for its audience
Hardware
IN
End Users
ESC

36. Data in database has ability to be accessed and manipulated by several users
Functions
Users
Shared
Structured Query Language (SQL)

37. Definition of commands it can do
Tags
Data Administrator (DAd)
Data Definition
Database Administrator (DBA)

38. Used with another comparison operator - values become inverted
FROM
Negation Operator
Outer SELECT query
Data

39. Finds the lowest constant value in a column
Database
Service Broker
MAX
Data Recovery & Concurrance

40. Command based way to ask the database a question
Web Browser
Query
LIKE
Service-Oriented Architecture (SOA)

41. Data remains unchanged in database
FROM
Persistent
UPDATE
Data

42. Table displayed in descending order
Data
Candidate Keys
ESC
Web Browser

43. Executes commands one at a time - results being displayed immediately
Service Requestor
Negation Operator
Performance
Interactive SQL

44. Join a table to a copy of itself
DISTINCT
Self Join
Negation Operator
ORDER BY

45. Changes the values in one or more selected rows of a table
UPDATE
Functions
INSERT INTO
ORDER BY

46. Closed in the start tag by adding a slash to the start tag
SUM
Relational
Empty Elements
Attributes

47. Used to combine one query to another
Information
Interactive SQL
Subqueries
Embedded SQL

48. Begins an element
Dynamic
Views
Opening tag
Data Dictionary

49. Limits the output of the established groups into the derived result table
Web Browser
Stateless
INSERT INTO
HAVING

50. Grant acces and control to only specific information
Aliases
Performance
ALL
Views