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. Data in database interacts & corresponds with other data
Functions
accident
Integrated
Views
2. Data stored by DAd
Information
Relational
Database
Data Elements
3. Ongoing record of data reflecting the info defining the database
ASC
Data Dictionary
Performance
Performance
4. Closed in the start tag by adding a slash to the start tag
Object-Oriented Relational (OOR)
Persistent
Empty Elements
Word
5. Characterizes operation of a relational database
Joins
FROM
Shared
Session
6. Supplies value for the search condition of the SELECT statement containing it
Cookie
single value
Inner SELECT query
Web Service
7. Used with another comparison operator - values become inverted
Embedded SQL
Negation Operator
Dynamic
ALL
8. Change order of rows in result table
ORDER BY
MAX
ESC
End Users
9. Flat File Examples: Excel Spreadsheets - _____
Word
Property
Inner SELECT query
Web Browser
10. Responsible for technical implementation & maintenance of database on a design & physical level
Database Administrator (DBA)
Query
Attributes
DISTINCT
11. Defines a new column
Structured Query Language (SQL)
Calculated Column
Report
Embedded SQL
12. Specifies the tables or views from which rows and columns are retrieved
Session
MIN
FROM
accident
13. Compares value of the column in the specified condition with the value specified
GROUP BY
Equals Operator
Aliases
Calculated Column
14. Allows use of single or multiple character wildcards with the underscore or percent symbol
Web Applications
Database Management Systems (DBMS)
LIKE
ASC
15. Software system designed to support interoperable machine - to - machine interaction over a network
HAVING
End Users
AVG
Web Service
16. Used with another comparison operator - values become inverted
Hardware
Candidate Keys
Negation Operator
MAX
17. Definition of commands it can do
Inner SELECT query
Attributes
Data Definition
Flat File
18. Ensures data is correct casings
Subqueries
American Standard Code for Information Interchange (ASCII)
Forward Slash
Bind
19. Selects from specific values in list
Equals Operator
IN
Integrated
Central control of data
20. Straight implementation of raw data formatted into rows and columns
Flat File
Candidate Keys
Outer SELECT query
Shared
21. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG
Data Elements
sp_help
SUM
Database
22. SQL finds and retrieves date
Precedence of Logical Operators
Attributes
Indexes
FROM
23. Text markups that form an element" sort of a "box" to hold things like text and other elements
Self Join
Tags
Subqueries
ALL
24. Give the browser more specific information about that tag
LIKE
Calculated Column
Attributes
Cookie
25. Cookies are more secure than______ - allowing travel on a website without loss of info
Database Administrator (DBA)
hidden fields
Data Definition
Flat File
26. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
SUM
ALL
Data Elements
Web server
27. Definition of commands it can do
Opening tag
Data Administrator (DAd)
Hypertext Markup Language (HTML)
Data Definition
28. Browser requests page - code is delivered - executed and done with
Word
WHERE
Dynamic
Aggregate Functions
29. Computer programs allowing website visitors to submit and retrieve data to/from a database over the Internet using their preferred web browser
Candidate Keys
Web Service
Web Applications
Subqueries
30. Data that has been processed into a format that is understandable by its audience
Information
Data
Closing tag
Object-Oriented Relational (OOR)
31. Allow useres to retrieve data and interact with content located on web pages within website
Web Browser
Query
Session
Forward Slash
32. Large structured set of persistent data
Web Applications
Web Browser
GROUP BY
Database
33. Uses two values as limits - selecting any values between the two of them
Functions
Precedence of Logical Operators
Hardware
BETWEEN
34. All Columns indicated and selected
Integrated
*
WHERE
Users
35. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance
DISTINCT
WHERE
Functions
Attributes
36. Characterizes operation of a relational database
Tables
LIKE
Tags
Joins
37. Concatenated in SQL Server Database software using the addition symbol
Persistent
Hardware
hidden fields
Fields
38. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
Data Dictionary
Structured Query Language (SQL)
Empty Elements
single value
39. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
Bind
Web server
INSERT INTO
Service Broker
40. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
Web Applications
Aliases
Service Broker
Indexes
41. Software system designed to support interface for a software asset that manages a specific set of tasks
Service Provider
Dynamic
ALL
Data Administrator (DAd)
42. Finds the lowest ACII value in column
ORDER BY
Scripting
MAX
MIN
43. 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.
End Users
Candidate Keys
Empty Elements
hidden fields
44. Practice of writing code into a webpage that is not directly visible to the user
Scripting
NOT
Hardware
AVG
45. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
Hypertext Markup Language (HTML)
LIKE
Query
Opening tag
46. Allows use of single or multiple character wildcards with the underscore or percent symbol
LIKE
HAVING
Self Join
Dynamic
47. Selects from specific values in list
IN
Subqueries
Indexes
hidden fields
48. Attribute in quotes
Relational
Data Elements
Negation Operator
Property
49. Averages the numeric values
Service-Oriented Architecture (SOA)
Stateless
Self Join
AVG
50. Changes the values in one or more selected rows of a table
ALL
Web Browser
UPDATE
Empty Elements