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. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
Session
Property
Structured Query Language (SQL)
MAX
2. Individuals that use - manipulate or maintain aspects of database
Data
Opening tag
ORDER BY
Users
3. Data that has been processed into a format that is understandable by its audience
Data Elements
Information
Interactive SQL
ESC
4. Limits the rows that appear in the result mathcing a specified condition
Forward Slash
Data
WHERE
Aggregate Functions
5. Software system designed to support interoperable machine - to - machine interaction over a network
Tags
Web Service
Public Key Infrastructure (PKI)
Database Management Systems (DBMS)
6. Allows data recovery in case of corruption or loss
FROM
Data Recovery & Concurrance
Application Programers
Database Administrator (DBA)
7. Practice of writing code into a webpage that is not directly visible to the user
Scripting
LIKE
Tables
Data Recovery & Concurrance
8. Computer equipment -Fixed Storage Media - Removeable Storage Media - System Memory - and the Processor
Hardware
hidden fields
Session
ALL
9. Table displayed in descending order
Data Recovery & Concurrance
UPDATE
Self Join
ESC
10. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
Application Programers
Service Broker
Property
Structured Query Language (SQL)
11. Three Basic Operations of SP - SR - SB: Publish - Find - ____
Service Provider
COUNT
Bind
Subqueries
12. Identifies columns to appear in the result
SELECT
Service Requestor
Data Definition
End Users
13. The Web is ___________
Opening tag
Stateless
Indexes
Hierarchial
14. Considered the time that a user first accesses a page until a set of amount time - on the server - after their last activity or until the session is explicitly closed
INSERT INTO
Opening tag
Negation Operator
Session
15. Fields in a relational table that match the primary key from one column to the primary key of another table.
Views
Structured Query Language (SQL)
Foreign Keys
Negation Operator
16. Executes commands one at a time - results being displayed immediately
Tags
accident
Interactive SQL
GROUP BY
17. Interact and manipulates the data in the database
Word
Data Manipulation
Indexes
Negation Operator
18. Characterizes operation of a relational database
Joins
Foreign Keys
Closing tag
Service-Oriented Architecture (SOA)
19. Flat File Examples: Excel Spreadsheets - _____
hidden fields
Database
ESC
Word
20. Ensures functions are done efficiently
Performance
ESC
Data Elements
Web server
21. Everything between the start and end tag
Empty Elements
LIKE
IN
Element Content
22. Describe information in a tree styled format
Data Definition
Web Applications
Hierarchial
Subqueries
23. Allow useres to retrieve data and interact with content located on web pages within website
Web Browser
Tags
End Users
Report
24. Computer programs allowing website visitors to submit and retrieve data to/from a database over the Internet using their preferred web browser
Web Applications
Central control of data
Embedded SQL
Attributes
25. SELECT statment containing the nested query
Cookie
Outer SELECT query
SELECT
to update
26. Limits the rows that appear in the result mathcing a specified condition
Cookie
Interactive SQL
WHERE
Scripting
27. Finds the lowest ACII value in column
MIN
Element Content
LIKE
Application Programmers
28. Uses two values as limits - selecting any values between the two of them
Data Dictionary
BETWEEN
Comparison Operators
ASC
29. Responsible for technical implementation & maintenance of database on a design & physical level
Closing tag
to update
Database Administrator (DBA)
HAVING
30. One huge database to hold all data; Access to data - and use of system to add - update & print records
ASC
*
single value
Database Management Systems (DBMS)
31. SQL Commands: Define tables - views - _____ - delete or insert info
Cookie
Report
AVG
to update
32. Text markups that form an element" sort of a "box" to hold things like text and other elements
FROM
Word
Performance
Tags
33. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance
Foreign Keys
Users
Property
Functions
34. Columns containing numbers only
DISTINCT
Indexes
Closing tag
SUM
35. Network node that discovers and invokes other software services to provide a buisness solution
Information
single value
Shared
Service Requestor
36. Writes programs that use or allow acces to databse with specific purpose
Fields
Application Programers
Persistent
Service Requestor
37. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
Data Recovery & Concurrance
ALL
SUM
Tags
38. Has the highest precedence - followed by the AND - OR
DISTINCT
NOT
Web Service
Inner SELECT query
39. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
*
*
accident
ALL
40. Selects from specific values in list
Bind
IN
Service-Oriented Architecture (SOA)
Central control of data
41. Averages the numeric values
Comparison Operators
AVG
Element Content
WHERE
42. Data in database interacts & corresponds with other data
Users
Integrated
Database Administrator (DBA)
COUNT
43. Individuals that use - manipulate or maintain aspects of database
DISTINCT
SUM
Users
Forward Slash
44. Change order of rows in result table
DISTINCT
Shared
ORDER BY
Public Key Infrastructure (PKI)
45. Used to close a tag properly
GROUP BY
Forward Slash
Report
Integrated
46. Finds the lowest ACII value in column
to update
MIN
GROUP BY
Database Management Systems (DBMS)
47. Attribute in quotes
Integrated
single value
SUM
Property
48. Writes programs that use or allow acces to databse with specific purpose
Application Programers
Report
Empty Elements
Service Requestor
49. Specifies the tables or views from which rows and columns are retrieved
Data Dictionary
Database Administrator (DBA)
FROM
single value
50. Everything between the start and end tag
ESC
Shared
Cookie
Element Content