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. Everything in enviroment becomes an object - expands on Priniples of relational databases
Object-Oriented Relational (OOR)
Service-Oriented Architecture (SOA)
to update
Calculated Column
2. Attribute in quotes
Data Dictionary
Property
Web Browser
Users
3. Used to remove duplicates from result table
Tags
DISTINCT
Calculated Column
Joins
4. Large structured set of persistent data
Database
Service Broker
Stateless
Calculated Column
5. Combines rows from a SELECT statements result table into a group
Joins
Database
GROUP BY
Precedence of Logical Operators
6. Concatenated in SQL Server Database software using the addition symbol
Tags
Fields
Hypertext Markup Language (HTML)
Element Content
7. Allow useres to retrieve data and interact with content located on web pages within website
Web Browser
Structured Query Language (SQL)
ASC
Word
8. Used to combine one query to another
Subqueries
Tags
Data Dictionary
Web server
9. Decides what data is stored in the databse and the manner it is stored
Integrated
HAVING
Data Administrator (DAd)
Calculated Column
10. Ensures functions are done efficiently
Performance
SELECT
End Users
Database Administrator (DBA)
11. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
Web Service
Flat File
Performance
Service Broker
12. Create program files that include SQ after each command
Web Browser
Property
Closing tag
Embedded SQL
13. Using product as intended for its audience
Inner SELECT query
End Users
IN
hidden fields
14. Finds the lowest ACII value in column
MIN
Database
Service Requestor
ESC
15. Everything between the start and end tag
Data Elements
Calculated Column
Element Content
ORDER BY
16. Allow useres to retrieve data and interact with content located on web pages within website
Database
Closing tag
Web Browser
Empty Elements
17. Large structured set of persistent data
COUNT
Database
BETWEEN
Tags
18. Has the highest precedence - followed by the AND - OR
NOT
Tags
Web server
Persistent
19. SQL finds and retrieves date
Indexes
Shared
Application Programmers
Flat File
20. Practice of writing code into a webpage that is not directly visible to the user
Data
Object-Oriented Relational (OOR)
Hypertext Markup Language (HTML)
Scripting
21. Data that has been processed into a format that is understandable by its audience
Property
Web Browser
Information
Database Management Systems (DBMS)
22. Change order of rows in result table
single value
Dynamic
Foreign Keys
ORDER BY
23. Identifies columns to appear in the result
Joins
Database
INSERT INTO
SELECT
24. Ongoing record of data reflecting the info defining the database
SUM
Data Dictionary
Tables
Embedded SQL
25. SQL Commands: Define tables - views - _____ - delete or insert info
Precedence of Logical Operators
Embedded SQL
to update
Application Programers
26. Looks like opening tag - but with a forward slash
Tables
Equals Operator
Closing tag
Structured Query Language (SQL)
27. SQL finds and retrieves date
ESC
NOT
Indexes
Report
28. Practice of writing code into a webpage that is not directly visible to the user
Integrated
Scripting
Database Management Systems (DBMS)
Service Requestor
29. Three Basic Operations of SP - SR - SB: Publish - Find - ____
Bind
Data Administrator (DAd)
Users
Empty Elements
30. Limits the output of the established groups into the derived result table
to update
Object-Oriented Relational (OOR)
Cookie
HAVING
31. Used with another comparison operator - values become inverted
Negation Operator
LIKE
Data
Element Content
32. Columns containing numbers only
Data Recovery & Concurrance
Database
SUM
Dynamic
33. Meaningful info related to database
Data
Information
Flat File
*
34. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
Foreign Keys
Hardware
ESC
Structured Query Language (SQL)
35. SQL Commands - Two Things Specify data interested in - Indicate the ________
IN
Information
Data Definition
accident
36. Limits the output of the established groups into the derived result table
Database
HAVING
Stateless
End Users
37. Tally of how many rows meet criteria specified
single value
COUNT
Service-Oriented Architecture (SOA)
Service Provider
38. Software system designed to support interface for a software asset that manages a specific set of tasks
IN
Joins
Service Provider
SUM
39. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
Data Elements
Data Definition
Aliases
Empty Elements
40. Join a table to a copy of itself
Data Elements
Self Join
Attributes
Service Requestor
41. Data in database has ability to be accessed and manipulated by several users
Data Definition
Inner SELECT query
Shared
ASC
42. Describe information in a tree styled format
Application Programmers
hidden fields
Hierarchial
DISTINCT
43. 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
Integrated
Public Key Infrastructure (PKI)
Calculated Column
GROUP BY
44. Definition of commands it can do
Data Definition
Word
ESC
INSERT INTO
45. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
ALL
Data
WHERE
Stateless
46. Text markups that form an element" sort of a "box" to hold things like text and other elements
Tags
Service-Oriented Architecture (SOA)
Web Browser
IN
47. SQL Commands: Define tables - views - _____ - delete or insert info
Users
Dynamic
single value
to update
48. Flat File Examples: Excel Spreadsheets - _____
Word
*
ORDER BY
IN
49. Closed in the start tag by adding a slash to the start tag
Subquery
Dynamic
Service-Oriented Architecture (SOA)
Empty Elements
50. Ensures functions are done efficiently
Opening tag
Foreign Keys
Performance
Element Content