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. Using product as intended for its audience
ASC
Subquery
End Users
INSERT INTO
2. Used to combine one query to another
Subqueries
Central Control of data
SUM
Database Management Systems (DBMS)
3. Looks like opening tag - but with a forward slash
Closing tag
Tags
Negation Operator
Relational
4. Flat File Examples: Excel Spreadsheets - _____
Negation Operator
Word
Comparison Operators
Aliases
5. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
DISTINCT
hidden fields
Query
Aliases
6. Create program files that include SQ after each command
Database Administrator (DBA)
Embedded SQL
Empty Elements
Flat File
7. Change order of rows in result table
Data Dictionary
Service-Oriented Architecture (SOA)
Indexes
ORDER BY
8. Finds the lowest ACII value in column
Integrated
Persistent
Fields
MIN
9. Limits the rows that appear in the result mathcing a specified condition
WHERE
Web server
Outer SELECT query
GROUP BY
10. Limits the rows that appear in the result mathcing a specified condition
WHERE
Data Elements
Object-Oriented Relational (OOR)
Joins
11. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
Stateless
UPDATE
Aggregate Functions
Aliases
12. Compares value of the column in the specified condition with the value specified
Attributes
Equals Operator
Comparison Operators
Subqueries
13. Defines a new column
Attributes
Calculated Column
hidden fields
Forward Slash
14. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG
Embedded SQL
DELETE
SUM
Flat File
15. SQL finds and retrieves date
Views
Indexes
to update
FROM
16. Copies multiple records at the same time using a SELECT statement
Subqueries
Precedence of Logical Operators
Web Service
INSERT INTO
17. Concatenated in SQL Server Database software using the addition symbol
Fields
WHERE
Precedence of Logical Operators
Object-Oriented Relational (OOR)
18. Fields in a relational table that match the primary key from one column to the primary key of another table.
Structured Query Language (SQL)
Foreign Keys
Web Service
Tags
19. Describe information in a tree styled format
Query
Relational
Users
Hierarchial
20. Uses two values as limits - selecting any values between the two of them
End Users
DISTINCT
FROM
BETWEEN
21. Practice of writing code into a webpage that is not directly visible to the user
Performance
Scripting
Web Service
Service-Oriented Architecture (SOA)
22. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
INSERT INTO
Service-Oriented Architecture (SOA)
Tables
Web server
23. Executes commands one at a time - results being displayed immediately
Element Content
AVG
Interactive SQL
Joins
24. Data stored by DAd
Outer SELECT query
Hypertext Markup Language (HTML)
Scripting
Data Elements
25. 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
Functions
Self Join
Application Programers
Public Key Infrastructure (PKI)
26. Straight implementation of raw data formatted into rows and columns
Flat File
Integrated
Service-Oriented Architecture (SOA)
Forward Slash
27. Software system designed to support interoperable machine - to - machine interaction over a network
Web Browser
Negation Operator
Application Programers
Web Service
28. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________
WHERE
DELETE
Central Control of data
Scripting
29. Begins an element
Web Browser
Indexes
Opening tag
Aggregate Functions
30. Data that has been processed into a format that is understandable by its audience
ALL
Hardware
Hardware
Information
31. Selects from specific values in list
Views
Element Content
Application Programmers
IN
32. Ensures functions are done efficiently
single value
Performance
Session
Forward Slash
33. Allows data recovery in case of corruption or loss
Data Recovery & Concurrance
WHERE
Calculated Column
INSERT INTO
34. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
Data Recovery & Concurrance
Web server
Equals Operator
Bind
35. Everything in enviroment becomes an object - expands on Priniples of relational databases
Object-Oriented Relational (OOR)
hidden fields
Web Service
Integrated
36. Software system designed to support interface for a software asset that manages a specific set of tasks
Element Content
Application Programmers
Service Provider
Calculated Column
37. Used to combine one query with another.
Web Browser
to update
Subquery
MAX
38. Cookies are more secure than______ - allowing travel on a website without loss of info
End Users
Empty Elements
hidden fields
Application Programers
39. Specifies the tables or views from which rows and columns are retrieved
Outer SELECT query
Subquery
Dynamic
FROM
40. Columns containing numbers only
Attributes
NOT
SUM
Primary Keys
41. Give the browser more specific information about that tag
SUM
Negation Operator
Attributes
*
42. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
Primary Keys
single value
Negation Operator
Database
43. Executes commands one at a time - results being displayed immediately
Inner SELECT query
Interactive SQL
BETWEEN
MAX
44. Basic Component of SQL
UPDATE
Tables
Interactive SQL
Data Manipulation
45. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
Data Definition
Hierarchial
Service Broker
DISTINCT
46. Used in a SELECT clause in place of a column
Aggregate Functions
Joins
Web server
Element Content
47. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________
Public Key Infrastructure (PKI)
Query
Central Control of data
hidden fields
48. Selects from specific values in list
INSERT INTO
HAVING
Element Content
IN
49. Individuals that use - manipulate or maintain aspects of database
WHERE
Equals Operator
Functions
Users
50. Everything in enviroment becomes an object - expands on Priniples of relational databases
Object-Oriented Relational (OOR)
Opening tag
Word
American Standard Code for Information Interchange (ASCII)