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. Closed in the start tag by adding a slash to the start tag
Interactive SQL
Empty Elements
SUM
Central control of data
2. Interact and manipulates the data in the database
Data Manipulation
Flat File
Data Definition
Session
3. Table displayed in ascending order
ASC
Session
IN
INSERT INTO
4. Allows data recovery in case of corruption or loss
Service Provider
ASC
Object-Oriented Relational (OOR)
Data Recovery & Concurrance
5. Used to combine one query to another
NOT
Subqueries
Database
Database Administrator (DBA)
6. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
Application Programers
WHERE
Hypertext Markup Language (HTML)
Scripting
7. Ongoing record of data reflecting the info defining the database
MAX
BETWEEN
Database Management Systems (DBMS)
Data Dictionary
8. Responsible for technical implementation & maintenance of database on a design & physical level
Service Requestor
DELETE
Database Administrator (DBA)
Service Provider
9. Most valuable asset of a database system.
Central control of data
UPDATE
Subqueries
Aggregate Functions
10. Limits the rows that appear in the result mathcing a specified condition
Application Programmers
Data Administrator (DAd)
WHERE
UPDATE
11. Large structured set of persistent data
HAVING
Database
Service Provider
Comparison Operators
12. Everything in enviroment becomes an object - expands on Priniples of relational databases
Tables
Object-Oriented Relational (OOR)
SUM
Service Broker
13. Straight implementation of raw data formatted into rows and columns
ALL
Self Join
Flat File
accident
14. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
Opening tag
LIKE
ESC
Web server
15. Finds the lowest ACII value in column
*
MIN
ORDER BY
Negation Operator
16. Essentially a collection of services that communicate with eachother
Functions
Service-Oriented Architecture (SOA)
Database Management Systems (DBMS)
Database
17. Defines a new column
Calculated Column
Performance
GROUP BY
LIKE
18. Columns containing numbers only
SUM
Query
Hierarchial
to update
19. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
LIKE
accident
accident
Web server
20. Software system designed to support interface for a software asset that manages a specific set of tasks
Service Provider
Data Definition
Hypertext Markup Language (HTML)
Service Requestor
21. Text markups that form an element" sort of a "box" to hold things like text and other elements
ORDER BY
Data Administrator (DAd)
Tags
American Standard Code for Information Interchange (ASCII)
22. Concatenated in SQL Server Database software using the addition symbol
Central Control of data
End Users
Relational
Fields
23. Columns containing numbers only
HAVING
Flat File
SUM
SELECT
24. Compares value of the column in the specified condition with the value specified
Equals Operator
Aliases
Closing tag
Cookie
25. Ensures functions are done efficiently
Word
Performance
hidden fields
American Standard Code for Information Interchange (ASCII)
26. Data in database interacts & corresponds with other data
Opening tag
Application Programmers
ASC
Integrated
27. Everything between the start and end tag
AVG
Object-Oriented Relational (OOR)
Element Content
Stateless
28. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
Indexes
Forward Slash
Structured Query Language (SQL)
Joins
29. Text markups that form an element" sort of a "box" to hold things like text and other elements
Tables
Persistent
Tags
ASC
30. Data stored by DAd
DISTINCT
COUNT
Session
Data Elements
31. Describe information in a tree styled format
Hardware
Hierarchial
Comparison Operators
NOT
32. Limits the output of the established groups into the derived result table
HAVING
WHERE
Property
FROM
33. Averages the numeric values
AVG
*
Bind
Interactive SQL
34. Meaningful info related to database
Performance
Self Join
ESC
Data
35. Specifies the tables or views from which rows and columns are retrieved
LIKE
Empty Elements
Bind
FROM
36. Supplies value for the search condition of the SELECT statement containing it
Inner SELECT query
single value
Word
Web Applications
37. Looks like opening tag - but with a forward slash
Opening tag
Service Requestor
ORDER BY
Closing tag
38. Data that has been processed into a format that is understandable by its audience
Application Programers
Information
Precedence of Logical Operators
BETWEEN
39. Command based way to ask the database a question
Query
hidden fields
Data Elements
Embedded SQL
40. Compares value of the column in the specified condition with the value specified
Subqueries
Equals Operator
Query
Aliases
41. Browser requests page - code is delivered - executed and done with
Aggregate Functions
Dynamic
Data Definition
UPDATE
42. Software system designed to support interoperable machine - to - machine interaction over a network
Data Manipulation
Web Service
Database Management Systems (DBMS)
Comparison Operators
43. Computer programs allowing website visitors to submit and retrieve data to/from a database over the Internet using their preferred web browser
Web Applications
Word
Service Broker
AVG
44. Used to close a tag properly
Joins
Data Dictionary
Database
Forward Slash
45. SQL Commands: Define tables - views - _____ - delete or insert info
Scripting
hidden fields
to update
Central control of data
46. Flat File Examples: Excel Spreadsheets - _____
Word
Tables
Aggregate Functions
HAVING
47. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
BETWEEN
Service-Oriented Architecture (SOA)
accident
Aliases
48. Characterizes operation of a relational database
Functions
Closing tag
Joins
INSERT INTO
49. Everything in enviroment becomes an object - expands on Priniples of relational databases
Subqueries
Object-Oriented Relational (OOR)
Equals Operator
Joins
50. Meaningful info related to database
Flat File
Outer SELECT query
Application Programmers
Data