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. Join a table to a copy of itself
ASC
Scripting
Hierarchial
Self Join
2. Finds the lowest constant value in a column
Outer SELECT query
accident
MAX
Query
3. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
Tags
Subqueries
Application Programmers
Web Applications
4. Used with another comparison operator - values become inverted
Application Programers
Interactive SQL
Database Management Systems (DBMS)
Negation Operator
5. Straight implementation of raw data formatted into rows and columns
Views
Query
Flat File
Data Manipulation
6. Browser requests page - code is delivered - executed and done with
Fields
Dynamic
Views
Data Administrator (DAd)
7. Responsible for technical implementation & maintenance of database on a design & physical level
Database Administrator (DBA)
Indexes
Application Programers
Users
8. Create program files that include SQ after each command
Relational
Embedded SQL
Database
to update
9. Finds the lowest constant value in a column
MAX
SELECT
SUM
MIN
10. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG
Application Programmers
Data Recovery & Concurrance
Integrated
SUM
11. Attribute in quotes
Word
Data
DELETE
Property
12. Everything between the start and end tag
SUM
Attributes
Hierarchial
Element Content
13. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
Central control of data
Service Broker
SELECT
Information
14. System that is composed of a Certificate Authority - certificates - software - services and other cryptographic components to enable authenticity and validation of data and/or entities
AVG
Public Key Infrastructure (PKI)
Interactive SQL
Structured Query Language (SQL)
15. Uses relationships between independent entities
Relational
Dynamic
Subqueries
Flat File
16. Practice of writing code into a webpage that is not directly visible to the user
Scripting
to update
End Users
Relational
17. Compares value of the column in the specified condition with the value specified
Hypertext Markup Language (HTML)
SELECT
Equals Operator
DELETE
18. Ensures data is correct casings
American Standard Code for Information Interchange (ASCII)
Precedence of Logical Operators
Web server
Outer SELECT query
19. Create program files that include SQ after each command
Embedded SQL
Closing tag
Hierarchial
Joins
20. Data remains unchanged in database
Persistent
INSERT INTO
Bind
SELECT
21. Finds the lowest ACII value in column
accident
Integrated
MIN
Data Recovery & Concurrance
22. SQL Commands - Two Things Specify data interested in - Indicate the ________
Structured Query Language (SQL)
accident
Dynamic
Central Control of data
23. Selects from specific values in list
IN
Structured Query Language (SQL)
Word
American Standard Code for Information Interchange (ASCII)
24. Averages the numeric values
Stateless
HAVING
AVG
MIN
25. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
Service Provider
Data Recovery & Concurrance
Integrated
single value
26. Ensures data is correct casings
American Standard Code for Information Interchange (ASCII)
Primary Keys
End Users
accident
27. Attribute in quotes
Report
ESC
Property
Session
28. Cookies are more secure than______ - allowing travel on a website without loss of info
Central control of data
hidden fields
Cookie
Dynamic
29. Begins an element
Word
UPDATE
HAVING
Opening tag
30. Describe information in a tree styled format
HAVING
ESC
Hierarchial
AVG
31. Essentially a collection of services that communicate with eachother
Users
Service-Oriented Architecture (SOA)
Precedence of Logical Operators
WHERE
32. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
Hierarchial
Web server
Precedence of Logical Operators
ORDER BY
33. Used to combine one query to another
Subqueries
ALL
INSERT INTO
HAVING
34. Some form of output - usually - printed - containing information
Inner SELECT query
Query
Integrated
Report
35. Uses relationships between independent entities
Joins
MAX
Candidate Keys
Relational
36. SELECT statment containing the nested query
Outer SELECT query
Joins
IN
Relational
37. Network node that discovers and invokes other software services to provide a buisness solution
Hypertext Markup Language (HTML)
Views
Service Requestor
Tables
38. Software system designed to support interface for a software asset that manages a specific set of tasks
Database Administrator (DBA)
Service Provider
GROUP BY
Joins
39. Cookies are more secure than______ - allowing travel on a website without loss of info
FROM
Dynamic
Data Elements
hidden fields
40. Basic Component of SQL
Closing tag
Empty Elements
DISTINCT
Tables
41. Data remains unchanged in database
Database Management Systems (DBMS)
Joins
Precedence of Logical Operators
Persistent
42. All Columns indicated and selected
MAX
accident
Data Administrator (DAd)
*
43. Definition of commands it can do
Negation Operator
Data Definition
Flat File
Query
44. Executes commands one at a time - results being displayed immediately
Performance
Aggregate Functions
Interactive SQL
Closing tag
45. Grant acces and control to only specific information
Web server
Views
Subqueries
Hypertext Markup Language (HTML)
46. Table displayed in descending order
Data Definition
Opening tag
Users
ESC
47. Used to remove duplicates from result table
DISTINCT
End Users
Hierarchial
Service Provider
48. Uses two values as limits - selecting any values between the two of them
Application Programmers
Opening tag
BETWEEN
Cookie
49. Specifies the tables or views from which rows and columns are retrieved
Data Manipulation
FROM
Data Definition
Bind
50. Averages the numeric values
Service Provider
Structured Query Language (SQL)
Information
AVG