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. Allow useres to retrieve data and interact with content located on web pages within website
Data Manipulation
COUNT
Web Browser
Report
2. Data stored by DAd
accident
Data Elements
single value
Hardware
3. Uses two values as limits - selecting any values between the two of them
Aliases
FROM
BETWEEN
Session
4. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
SELECT
Aliases
ESC
Outer SELECT query
5. Changes the values in one or more selected rows of a table
Session
Attributes
Aliases
UPDATE
6. Used in a SELECT clause in place of a column
Subqueries
Aggregate Functions
DISTINCT
Application Programers
7. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
Web server
hidden fields
Information
Shared
8. Supplies value for the search condition of the SELECT statement containing it
Element Content
*
Inner SELECT query
COUNT
9. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
Comparison Operators
Hardware
accident
single value
10. Responsible for technical implementation & maintenance of database on a design & physical level
Performance
American Standard Code for Information Interchange (ASCII)
Database Administrator (DBA)
Web Browser
11. 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
Session
Central Control of data
single value
Self Join
12. Straight implementation of raw data formatted into rows and columns
Indexes
Flat File
Users
Hardware
13. Used with another comparison operator - values become inverted
Views
Negation Operator
Persistent
COUNT
14. Browser requests page - code is delivered - executed and done with
Dynamic
ESC
Data Dictionary
Precedence of Logical Operators
15. Grant acces and control to only specific information
IN
Web Service
Views
Tags
16. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
Web server
Cookie
Application Programmers
Data Dictionary
17. Text markups that form an element" sort of a "box" to hold things like text and other elements
Element Content
Tags
SUM
Query
18. SQL Commands - Two Things Specify data interested in - Indicate the ________
accident
Application Programmers
ORDER BY
Structured Query Language (SQL)
19. Computer equipment -Fixed Storage Media - Removeable Storage Media - System Memory - and the Processor
Database
DELETE
Bind
Hardware
20. Looks like opening tag - but with a forward slash
Closing tag
Subqueries
Tables
Data Elements
21. Uniquely identify each record in the table and are chosen at the time of table creation. It is recommended that you use a variable such as a Social Security for this.
hidden fields
Primary Keys
Users
Empty Elements
22. Everything between the start and end tag
Inner SELECT query
Element Content
HAVING
Session
23. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG
Object-Oriented Relational (OOR)
Web Browser
Hardware
SUM
24. SQL Commands - Two Things Specify data interested in - Indicate the ________
Scripting
Query
Dynamic
accident
25. Some form of output - usually - printed - containing information
Negation Operator
AVG
Users
Report
26. Allow useres to retrieve data and interact with content located on web pages within website
HAVING
Foreign Keys
Web Browser
Scripting
27. Flat File Examples: Excel Spreadsheets - _____
INSERT INTO
Word
Public Key Infrastructure (PKI)
End Users
28. Finds the lowest ACII value in column
Cookie
Session
MIN
hidden fields
29. Begins an element
Web server
BETWEEN
Opening tag
Hierarchial
30. Large structured set of persistent data
Fields
accident
Database
Persistent
31. Fields in a relational table that match the primary key from one column to the primary key of another table.
Fields
Web Service
ALL
Foreign Keys
32. Changes the values in one or more selected rows of a table
UPDATE
GROUP BY
Element Content
MIN
33. Defines a new column
Data Dictionary
Data Recovery & Concurrance
Calculated Column
Database Administrator (DBA)
34. Used to combine one query with another.
COUNT
Data Definition
Subquery
Shared
35. File stored on a user's machine that contains infor about application
Central control of data
Query
Cookie
Subquery
36. Meaningful info related to database
COUNT
Database Administrator (DBA)
Session
Data
37. Used to remove duplicates from result table
ALL
DISTINCT
NOT
Application Programers
38. Data that has been processed into a format that is understandable by its audience
Views
Database
ASC
Information
39. Supplies value for the search condition of the SELECT statement containing it
Inner SELECT query
UPDATE
Web Service
Persistent
40. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
Users
Service Broker
FROM
Subqueries
41. All Columns indicated and selected
*
Database Management Systems (DBMS)
Service Requestor
Integrated
42. Uses relationships between independent entities
BETWEEN
Relational
MIN
Joins
43. Uses two values as limits - selecting any values between the two of them
Primary Keys
Data Definition
Service Broker
BETWEEN
44. Specifies the tables or views from which rows and columns are retrieved
Precedence of Logical Operators
Performance
Element Content
FROM
45. Used to combine one query to another
Precedence of Logical Operators
Performance
Flat File
Subqueries
46. Selects from specific values in list
Candidate Keys
IN
Data Recovery & Concurrance
DELETE
47. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
Service Broker
ASC
MAX
Data Recovery & Concurrance
48. SQL finds and retrieves date
Indexes
Data Recovery & Concurrance
HAVING
Data Dictionary
49. Uses relationships between independent entities
accident
Relational
Service-Oriented Architecture (SOA)
MIN
50. Computer programs allowing website visitors to submit and retrieve data to/from a database over the Internet using their preferred web browser
Element Content
Flat File
Session
Web Applications