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. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
Shared
Web server
Functions
Data Dictionary
2. Fields in a relational table that match the primary key from one column to the primary key of another table.
LIKE
ALL
Precedence of Logical Operators
Foreign Keys
3. Individuals that use - manipulate or maintain aspects of database
Attributes
Users
Web Browser
Indexes
4. Text markups that form an element" sort of a "box" to hold things like text and other elements
Shared
Functions
Primary Keys
Tags
5. Finds the lowest ACII value in column
Precedence of Logical Operators
Scripting
Inner SELECT query
MIN
6. Most valuable asset of a database system.
Persistent
Precedence of Logical Operators
Central control of data
ESC
7. Everything in enviroment becomes an object - expands on Priniples of relational databases
Closing tag
ESC
Public Key Infrastructure (PKI)
Object-Oriented Relational (OOR)
8. Describe information in a tree styled format
Hierarchial
Report
Subquery
ESC
9. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
Equals Operator
Application Programers
Structured Query Language (SQL)
Property
10. Create program files that include SQ after each command
Embedded SQL
AVG
DISTINCT
Comparison Operators
11. Large structured set of persistent data
Comparison Operators
Dynamic
Database
Views
12. Definition of commands it can do
Report
Application Programers
Data Definition
sp_help
13. Concatenated in SQL Server Database software using the addition symbol
Opening tag
Flat File
Closing tag
Fields
14. Used to combine one query with another.
ALL
LIKE
Views
Subquery
15. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
Web Applications
accident
Indexes
Aliases
16. Has the highest precedence - followed by the AND - OR
NOT
Data Administrator (DAd)
Opening tag
accident
17. Large structured set of persistent data
Database
MIN
Tables
Tags
18. Attribute in quotes
Property
DISTINCT
Dynamic
FROM
19. Tally of how many rows meet criteria specified
Integrated
Query
Database
COUNT
20. Join a table to a copy of itself
Users
Flat File
Self Join
HAVING
21. Three Basic Operations of SP - SR - SB: Publish - Find - ____
IN
Hypertext Markup Language (HTML)
Bind
Central control of data
22. SQL Commands: Define tables - views - _____ - delete or insert info
Attributes
to update
Database Management Systems (DBMS)
Flat File
23. Defines a new column
Object-Oriented Relational (OOR)
Web Service
Calculated Column
Flat File
24. Change order of rows in result table
BETWEEN
Session
Interactive SQL
ORDER BY
25. Used in a SELECT clause in place of a column
GROUP BY
Aggregate Functions
Database Management Systems (DBMS)
NOT
26. Interact and manipulates the data in the database
Indexes
Data Dictionary
Data Manipulation
Integrated
27. Software system designed to support interoperable machine - to - machine interaction over a network
Joins
Inner SELECT query
Views
Web Service
28. Data that has been processed into a format that is understandable by its audience
Information
End Users
DELETE
NOT
29. Copies multiple records at the same time using a SELECT statement
INSERT INTO
Data Administrator (DAd)
Indexes
Interactive SQL
30. 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 Definition
Database
Central control of data
Session
31. Data in database has ability to be accessed and manipulated by several users
Views
Flat File
Service Provider
Shared
32. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance
ASC
Session
Application Programers
Functions
33. SELECT statment containing the nested query
Attributes
Data Dictionary
Outer SELECT query
Central control of data
34. One huge database to hold all data; Access to data - and use of system to add - update & print records
*
American Standard Code for Information Interchange (ASCII)
Database Management Systems (DBMS)
Indexes
35. Used with another comparison operator - values become inverted
NOT
Database
Negation Operator
Service-Oriented Architecture (SOA)
36. Allow useres to retrieve data and interact with content located on web pages within website
Word
Web Browser
Tags
Application Programmers
37. One of the tools that SQL uses to find and retrieve data.
Service Broker
Aggregate Functions
COUNT
Indexes
38. Command based way to ask the database a question
Data Definition
Query
Hardware
SUM
39. Change order of rows in result table
Bind
ORDER BY
End Users
Central Control of data
40. Using product as intended for its audience
End Users
Users
Service Provider
Application Programmers
41. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
Data Recovery & Concurrance
Service-Oriented Architecture (SOA)
Data Definition
Hypertext Markup Language (HTML)
42. Give the browser more specific information about that tag
accident
Attributes
Self Join
ORDER BY
43. Attribute in quotes
DELETE
Application Programers
Aliases
Property
44. Command based way to ask the database a question
Query
Database
Flat File
Data Elements
45. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
SUM
single value
Web Service
Aliases
46. Data in database has ability to be accessed and manipulated by several users
Structured Query Language (SQL)
Query
Shared
Relational
47. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
Service Broker
Inner SELECT query
Empty Elements
accident
48. Identifies columns to appear in the result
SELECT
Tables
Tags
Data Dictionary
49. Data stored by DAd
Data Elements
Fields
Cookie
Views
50. Columns containing numbers only
sp_help
Object-Oriented Relational (OOR)
SUM
Performance