SUBJECTS
|
BROWSE
|
CAREER CENTER
|
POPULAR
|
JOIN
|
LOGIN
Business Skills
|
Soft Skills
|
Basic Literacy
|
Certifications
About
|
Help
|
Privacy
|
Terms
|
Email
Search
Test your basic knowledge |
Database Management Fundamentals
Start Test
Study First
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. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
Hypertext Markup Language (HTML)
Session
Database Management Systems (DBMS)
Web server
2. Compares value of the column in the specified condition with the value specified
GROUP BY
Empty Elements
ORDER BY
Equals Operator
3. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
Data Manipulation
Closing tag
SUM
Structured Query Language (SQL)
4. Software system designed to support interoperable machine - to - machine interaction over a network
Web Service
Application Programmers
Object-Oriented Relational (OOR)
IN
5. Has the highest precedence - followed by the AND - OR
GROUP BY
NOT
Foreign Keys
Data Manipulation
6. Straight implementation of raw data formatted into rows and columns
Flat File
Word
Data Elements
Joins
7. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
Service Broker
Central control of data
Data Manipulation
Data Recovery & Concurrance
8. SQL Commands: Define tables - views - _____ - delete or insert info
Joins
Stateless
Object-Oriented Relational (OOR)
to update
9. Allow useres to retrieve data and interact with content located on web pages within website
Stateless
NOT
Flat File
Web Browser
10. Change order of rows in result table
ORDER BY
Primary Keys
Relational
Data Recovery & Concurrance
11. Identifies columns to appear in the result
Functions
Data Elements
Bind
SELECT
12. Allow useres to retrieve data and interact with content located on web pages within website
Hardware
Equals Operator
Web Browser
Database Administrator (DBA)
13. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance
Integrated
Database Administrator (DBA)
hidden fields
Functions
14. Uses two values as limits - selecting any values between the two of them
Database Management Systems (DBMS)
LIKE
BETWEEN
Data Elements
15. Software system designed to support interoperable machine - to - machine interaction over a network
Application Programers
Bind
ESC
Web Service
16. Averages the numeric values
AVG
Aggregate Functions
Service Broker
Hypertext Markup Language (HTML)
17. Computer programs allowing website visitors to submit and retrieve data to/from a database over the Internet using their preferred web browser
GROUP BY
Web Browser
ASC
Web Applications
18. One huge database to hold all data; Access to data - and use of system to add - update & print records
INSERT INTO
Database Management Systems (DBMS)
Object-Oriented Relational (OOR)
Data Definition
19. Command based way to ask the database a question
Query
SUM
to update
Session
20. Compares value of the column in the specified condition with the value specified
MAX
accident
Word
Equals Operator
21. Table displayed in descending order
AVG
ESC
INSERT INTO
Fields
22. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG
Views
Interactive SQL
COUNT
SUM
23. Flat File Examples: Excel Spreadsheets - _____
single value
Word
Element Content
Embedded SQL
24. Limits the rows that appear in the result mathcing a specified condition
WHERE
Report
Forward Slash
Tags
25. File stored on a user's machine that contains infor about application
Database
WHERE
Cookie
Attributes
26. Using product as intended for its audience
MIN
Equals Operator
Query
End Users
27. Executes commands one at a time - results being displayed immediately
Interactive SQL
Forward Slash
Web Applications
Calculated Column
28. Used to combine one query with another.
Subquery
single value
Precedence of Logical Operators
COUNT
29. Limits the output of the established groups into the derived result table
Users
HAVING
BETWEEN
Data Manipulation
30. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
Aliases
Data Administrator (DAd)
Data
Data Elements
31. Basic Component of SQL
Report
Service Broker
Data
Tables
32. Software system designed to support interface for a software asset that manages a specific set of tasks
Web server
Service Provider
Calculated Column
Tables
33. Cookies are more secure than______ - allowing travel on a website without loss of info
SUM
End Users
Data
hidden fields
34. One of the tools that SQL uses to find and retrieve data.
Interactive SQL
SELECT
Service-Oriented Architecture (SOA)
Indexes
35. Command based way to ask the database a question
Query
Public Key Infrastructure (PKI)
INSERT INTO
Data
36. Tally of how many rows meet criteria specified
ESC
Web server
COUNT
Relational
37. Used with another comparison operator - values become inverted
Performance
Comparison Operators
Opening tag
Negation Operator
38. Table displayed in ascending order
ASC
SUM
Database Administrator (DBA)
ALL
39. Data in database interacts & corresponds with other data
WHERE
Aliases
Element Content
Integrated
40. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance
Aliases
Application Programers
Functions
DISTINCT
41. Basic Component of SQL
Tables
Self Join
Structured Query Language (SQL)
to update
42. Ensures data is correct casings
Data Recovery & Concurrance
American Standard Code for Information Interchange (ASCII)
Foreign Keys
NOT
43. Large structured set of persistent data
Database
Report
FROM
Service Broker
44. Interact and manipulates the data in the database
Indexes
Data Manipulation
Data
INSERT INTO
45. Data stored by DAd
Information
Data Elements
INSERT INTO
hidden fields
46. Interact and manipulates the data in the database
GROUP BY
ALL
Web server
Data Manipulation
47. Copies multiple records at the same time using a SELECT statement
Interactive SQL
INSERT INTO
Precedence of Logical Operators
COUNT
48. Definition of commands it can do
INSERT INTO
Data Dictionary
Data Definition
Word
49. Finds the lowest ACII value in column
Property
Integrated
Application Programmers
MIN
50. The Web is ___________
Stateless
NOT
Dynamic
Hypertext Markup Language (HTML)