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. Table displayed in descending order
Hardware
Data Administrator (DAd)
ESC
accident
2. Identifies columns to appear in the result
Data Definition
SELECT
FROM
Equals Operator
3. Columns containing numbers only
accident
SUM
AVG
Negation Operator
4. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance
Functions
ESC
Stateless
Flat File
5. Practice of writing code into a webpage that is not directly visible to the user
Functions
AVG
IN
Scripting
6. Ensures functions are done efficiently
Users
Embedded SQL
Aggregate Functions
Performance
7. Used to remove duplicates from result table
DISTINCT
FROM
Application Programers
Service-Oriented Architecture (SOA)
8. Executes commands one at a time - results being displayed immediately
Data Dictionary
UPDATE
Tables
Interactive SQL
9. Software system designed to support interface for a software asset that manages a specific set of tasks
Database Management Systems (DBMS)
Information
Aliases
Service Provider
10. Individuals that use - manipulate or maintain aspects of database
SUM
Views
Data Recovery & Concurrance
Users
11. Begins an element
Opening tag
Central control of data
Structured Query Language (SQL)
Information
12. 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
Closing tag
Web Service
Shared
Session
13. Command based way to ask the database a question
DISTINCT
accident
Word
Query
14. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
Functions
Scripting
Public Key Infrastructure (PKI)
Aliases
15. Everything in enviroment becomes an object - expands on Priniples of relational databases
Session
Object-Oriented Relational (OOR)
Fields
MIN
16. Computer programs allowing website visitors to submit and retrieve data to/from a database over the Internet using their preferred web browser
Database
Report
Web Applications
ORDER BY
17. Copies multiple records at the same time using a SELECT statement
Flat File
Persistent
INSERT INTO
Database Management Systems (DBMS)
18. Ongoing record of data reflecting the info defining the database
INSERT INTO
Inner SELECT query
Cookie
Data Dictionary
19. Everything in enviroment becomes an object - expands on Priniples of relational databases
Joins
Object-Oriented Relational (OOR)
Closing tag
Database Management Systems (DBMS)
20. File stored on a user's machine that contains infor about application
Cookie
Tags
Self Join
Service Requestor
21. Command used to show the attributes that define a table.
Web Applications
Stateless
Hardware
sp_help
22. Straight implementation of raw data formatted into rows and columns
hidden fields
Foreign Keys
HAVING
Flat File
23. Columns containing numbers only
Database Management Systems (DBMS)
UPDATE
Subquery
SUM
24. Flat File Examples: Excel Spreadsheets - _____
Comparison Operators
Attributes
Word
ORDER BY
25. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
COUNT
Database Management Systems (DBMS)
Shared
Service Broker
26. Basic Component of SQL
Tables
Fields
Hierarchial
COUNT
27. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
Web server
Fields
Central Control of data
INSERT INTO
28. Some form of output - usually - printed - containing information
WHERE
Performance
Report
Structured Query Language (SQL)
29. Basic Component of SQL
HAVING
Tables
Information
American Standard Code for Information Interchange (ASCII)
30. Limits the output of the established groups into the derived result table
HAVING
ALL
AVG
hidden fields
31. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
Hypertext Markup Language (HTML)
DISTINCT
sp_help
HAVING
32. Text markups that form an element" sort of a "box" to hold things like text and other elements
Tags
Relational
DELETE
Functions
33. Table displayed in ascending order
Subqueries
Session
ASC
SUM
34. Computer equipment -Fixed Storage Media - Removeable Storage Media - System Memory - and the Processor
Data Definition
Hardware
HAVING
Aggregate Functions
35. SELECT statment containing the nested query
Bind
Negation Operator
Hierarchial
Outer SELECT query
36. SELECT statment containing the nested query
Forward Slash
Report
INSERT INTO
Outer SELECT query
37. Writes programs that use or allow acces to databse with specific purpose
Aggregate Functions
Central Control of data
accident
Application Programers
38. Decides what data is stored in the databse and the manner it is stored
Closing tag
Data Administrator (DAd)
ESC
COUNT
39. Join a table to a copy of itself
to update
Self Join
Persistent
Service Provider
40. All Columns indicated and selected
ALL
Public Key Infrastructure (PKI)
*
MIN
41. Finds the lowest ACII value in column
Web Browser
MIN
*
FROM
42. Definition of commands it can do
*
Data Definition
SUM
Comparison Operators
43. Describe information in a tree styled format
Data Recovery & Concurrance
hidden fields
Hierarchial
Structured Query Language (SQL)
44. Interact and manipulates the data in the database
Tags
Data Manipulation
Service Broker
Hierarchial
45. Give the browser more specific information about that tag
Persistent
Data Recovery & Concurrance
INSERT INTO
Attributes
46. Finds the lowest ACII value in column
Performance
Equals Operator
Users
MIN
47. Network node that discovers and invokes other software services to provide a buisness solution
Persistent
WHERE
Service Requestor
Word
48. Selects from specific values in list
Database Administrator (DBA)
Dynamic
Closing tag
IN
49. Uses two values as limits - selecting any values between the two of them
Database Management Systems (DBMS)
BETWEEN
Web Service
SELECT
50. Allows data recovery in case of corruption or loss
Data Manipulation
Performance
Calculated Column
Data Recovery & Concurrance