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. Begins an element
Data Dictionary
COUNT
Performance
Opening tag
2. Practice of writing code into a webpage that is not directly visible to the user
hidden fields
Public Key Infrastructure (PKI)
Outer SELECT query
Scripting
3. Data stored by DAd
Data Elements
Data Dictionary
Central control of data
Calculated Column
4. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
Negation Operator
IN
Equals Operator
Application Programmers
5. Cookies are more secure than______ - allowing travel on a website without loss of info
Web Browser
hidden fields
Web Applications
Performance
6. Used to combine one query to another
Subqueries
Negation Operator
INSERT INTO
Data Dictionary
7. SQL Commands - Two Things Specify data interested in - Indicate the ________
Database
accident
hidden fields
Inner SELECT query
8. Defines a new column
Calculated Column
Information
accident
Subqueries
9. Data that has been processed into a format that is understandable by its audience
Element Content
Information
Embedded SQL
FROM
10. Looks like opening tag - but with a forward slash
Indexes
American Standard Code for Information Interchange (ASCII)
Closing tag
Cookie
11. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
LIKE
Object-Oriented Relational (OOR)
Relational
ALL
12. Uses relationships between independent entities
Relational
Service-Oriented Architecture (SOA)
BETWEEN
SUM
13. Used with another comparison operator - values become inverted
Database Administrator (DBA)
Persistent
Joins
Negation Operator
14. Allow useres to retrieve data and interact with content located on web pages within website
Outer SELECT query
Web Browser
Interactive SQL
Hardware
15. Attribute in quotes
Property
Data Definition
GROUP BY
Data Manipulation
16. Text markups that form an element" sort of a "box" to hold things like text and other elements
Aggregate Functions
MIN
DELETE
Tags
17. Fields in a relational table that match the primary key from one column to the primary key of another table.
Joins
Indexes
Foreign Keys
FROM
18. Executes commands one at a time - results being displayed immediately
Hierarchial
Closing tag
ALL
Interactive SQL
19. Most valuable asset of a database system.
Database Management Systems (DBMS)
Central control of data
Joins
Interactive SQL
20. Data remains unchanged in database
Persistent
Shared
Information
WHERE
21. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG
SUM
HAVING
COUNT
Hypertext Markup Language (HTML)
22. Allows use of single or multiple character wildcards with the underscore or percent symbol
Web Browser
COUNT
Object-Oriented Relational (OOR)
LIKE
23. Straight implementation of raw data formatted into rows and columns
Flat File
Word
Web Service
Comparison Operators
24. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
Service Broker
Views
*
DELETE
25. One huge database to hold all data; Access to data - and use of system to add - update & print records
Negation Operator
Database Management Systems (DBMS)
BETWEEN
NOT
26. Command based way to ask the database a question
Database Management Systems (DBMS)
Web Service
Outer SELECT query
Query
27. Limits the rows that appear in the result mathcing a specified condition
WHERE
Service-Oriented Architecture (SOA)
Hierarchial
Service Provider
28. Software system designed to support interoperable machine - to - machine interaction over a network
Negation Operator
Calculated Column
Structured Query Language (SQL)
Web Service
29. Order in which WHERE clause is evaluated and combined
ORDER BY
Aliases
Tables
Precedence of Logical Operators
30. Large structured set of persistent data
Fields
Database
*
Service-Oriented Architecture (SOA)
31. Combines rows from a SELECT statements result table into a group
Data Dictionary
GROUP BY
DISTINCT
ASC
32. Using product as intended for its audience
GROUP BY
SUM
End Users
Central Control of data
33. Ongoing record of data reflecting the info defining the database
Tags
Data Dictionary
Dynamic
SUM
34. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
DELETE
Aliases
Property
FROM
35. Copies multiple records at the same time using a SELECT statement
UPDATE
Cookie
INSERT INTO
to update
36. SELECT statment containing the nested query
Outer SELECT query
Hierarchial
Precedence of Logical Operators
to update
37. Decides what data is stored in the databse and the manner it is stored
hidden fields
ALL
Data Administrator (DAd)
Aliases
38. Meaningful info related to database
INSERT INTO
Report
End Users
Data
39. Deletes selected rows
DELETE
Data Administrator (DAd)
Persistent
Opening tag
40. Create program files that include SQ after each command
Application Programmers
Embedded SQL
Closing tag
Performance
41. Ensures functions are done efficiently
Calculated Column
GROUP BY
Performance
Opening tag
42. 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
Data Recovery & Concurrance
ALL
Session
Data Administrator (DAd)
43. All Columns indicated and selected
Opening tag
*
hidden fields
SUM
44. Used to combine one query to another
Indexes
MIN
Subqueries
Forward Slash
45. Create program files that include SQ after each command
Embedded SQL
Database Administrator (DBA)
Data Manipulation
Primary Keys
46. Basic Component of SQL
Tables
Forward Slash
SUM
LIKE
47. Definition of commands it can do
MIN
Data Definition
single value
Service Requestor
48. Columns containing numbers only
SELECT
Fields
Data Elements
SUM
49. Table displayed in ascending order
Query
SUM
ASC
Data Manipulation
50. Compares value of the column in the specified condition with the value specified
Equals Operator
*
Negation Operator
to update