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. Cookies are more secure than______ - allowing travel on a website without loss of info
Web Service
Closing tag
hidden fields
Interactive SQL
2. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG
Service-Oriented Architecture (SOA)
GROUP BY
Report
SUM
3. Defines a new column
Report
Tables
Calculated Column
Joins
4. Flat File Examples: Excel Spreadsheets - _____
SUM
Central Control of data
Word
Aliases
5. Uses relationships between independent entities
Aliases
ASC
Interactive SQL
Relational
6. Looks like opening tag - but with a forward slash
sp_help
Closing tag
WHERE
Users
7. Software system designed to support interoperable machine - to - machine interaction over a network
Persistent
Primary Keys
Web Service
Bind
8. Characterizes operation of a relational database
FROM
Database
Joins
ORDER BY
9. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
Persistent
Web Applications
Structured Query Language (SQL)
ASC
10. Data that has been processed into a format that is understandable by its audience
BETWEEN
Subquery
Hierarchial
Information
11. SELECT statment containing the nested query
ALL
Property
Outer SELECT query
Database Management Systems (DBMS)
12. Straight implementation of raw data formatted into rows and columns
Flat File
SUM
IN
Element Content
13. Practice of writing code into a webpage that is not directly visible to the user
Scripting
Indexes
Comparison Operators
Web server
14. Finds the lowest ACII value in column
Candidate Keys
MIN
SELECT
Property
15. SQL Commands - Two Things Specify data interested in - Indicate the ________
Views
Web Browser
Forward Slash
accident
16. Everything in enviroment becomes an object - expands on Priniples of relational databases
Report
Object-Oriented Relational (OOR)
hidden fields
NOT
17. Allows data recovery in case of corruption or loss
Performance
Joins
Bind
Data Recovery & Concurrance
18. The Web is ___________
WHERE
LIKE
INSERT INTO
Stateless
19. Ongoing record of data reflecting the info defining the database
Session
Query
Bind
Data Dictionary
20. Grant acces and control to only specific information
American Standard Code for Information Interchange (ASCII)
HAVING
ESC
Views
21. Ensures data is correct casings
INSERT INTO
American Standard Code for Information Interchange (ASCII)
Application Programers
Scripting
22. Decides what data is stored in the databse and the manner it is stored
Joins
HAVING
to update
Data Administrator (DAd)
23. File stored on a user's machine that contains infor about application
Object-Oriented Relational (OOR)
DISTINCT
GROUP BY
Cookie
24. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG
SUM
Precedence of Logical Operators
Relational
Web Applications
25. Fields in a relational table that match the primary key from one column to the primary key of another table.
COUNT
Central Control of data
Inner SELECT query
Foreign Keys
26. Definition of commands it can do
Data Definition
Embedded SQL
ASC
Negation Operator
27. Identifies columns to appear in the result
Aliases
SELECT
Information
DELETE
28. All Columns indicated and selected
*
Inner SELECT query
Information
Aliases
29. Finds the lowest constant value in a column
ORDER BY
Negation Operator
MAX
Comparison Operators
30. Data that has been processed into a format that is understandable by its audience
American Standard Code for Information Interchange (ASCII)
Information
SUM
Aliases
31. Changes the values in one or more selected rows of a table
Data Elements
SUM
Report
UPDATE
32. Data in database interacts & corresponds with other data
*
INSERT INTO
Integrated
Data
33. Data in database has ability to be accessed and manipulated by several users
Aliases
hidden fields
Shared
Report
34. Begins an element
ORDER BY
ALL
Service Requestor
Opening tag
35. Describe information in a tree styled format
GROUP BY
Hierarchial
Data
Service Provider
36. Allows data recovery in case of corruption or loss
Data Definition
Data Recovery & Concurrance
Data Dictionary
Aliases
37. Limits the output of the established groups into the derived result table
Outer SELECT query
COUNT
HAVING
Element Content
38. Data remains unchanged in database
Indexes
ESC
DELETE
Persistent
39. Concatenated in SQL Server Database software using the addition symbol
BETWEEN
Fields
Service-Oriented Architecture (SOA)
Service-Oriented Architecture (SOA)
40. Create program files that include SQ after each command
Service Requestor
Embedded SQL
Integrated
Application Programmers
41. Data remains unchanged in database
DELETE
Persistent
Data Dictionary
Service Provider
42. Computer equipment -Fixed Storage Media - Removeable Storage Media - System Memory - and the Processor
IN
Hardware
Element Content
Performance
43. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
Service Broker
Hypertext Markup Language (HTML)
Property
BETWEEN
44. SQL Commands: Define tables - views - _____ - delete or insert info
to update
HAVING
DELETE
Integrated
45. Grant acces and control to only specific information
Tables
Views
Web Service
hidden fields
46. Basic Component of SQL
Data Recovery & Concurrance
Database
Equals Operator
Tables
47. Writes programs that use or allow acces to databse with specific purpose
Functions
Application Programers
Primary Keys
Object-Oriented Relational (OOR)
48. Practice of writing code into a webpage that is not directly visible to the user
Scripting
ASC
Flat File
Shared
49. Closed in the start tag by adding a slash to the start tag
Application Programers
*
Empty Elements
HAVING
50. Ensures functions are done efficiently
MAX
Performance
INSERT INTO
Element Content