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. Data in database interacts & corresponds with other data
single value
Inner SELECT query
Integrated
IN
2. Used in a SELECT clause in place of a column
Aggregate Functions
Data Definition
Comparison Operators
Application Programmers
3. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
ALL
ORDER BY
Dynamic
SELECT
4. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
Calculated Column
Query
single value
Data Elements
5. Computer programs allowing website visitors to submit and retrieve data to/from a database over the Internet using their preferred web browser
Interactive SQL
Web Applications
Report
Tables
6. Browser requests page - code is delivered - executed and done with
Application Programers
Inner SELECT query
Dynamic
Central control of data
7. Three Basic Operations of SP - SR - SB: Publish - Find - ____
Tables
Inner SELECT query
FROM
Bind
8. Executes commands one at a time - results being displayed immediately
SUM
ALL
Interactive SQL
Comparison Operators
9. Change order of rows in result table
Database
MAX
ORDER BY
Report
10. Attribute in quotes
Data Manipulation
End Users
Property
Word
11. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
Joins
Web server
Views
DISTINCT
12. Allows data recovery in case of corruption or loss
Hierarchial
Users
Application Programmers
Data Recovery & Concurrance
13. Allow useres to retrieve data and interact with content located on web pages within website
Web Applications
Subqueries
Data Dictionary
Web Browser
14. Table displayed in ascending order
Opening tag
INSERT INTO
Hardware
ASC
15. Ongoing record of data reflecting the info defining the database
Opening tag
MIN
Central control of data
Data Dictionary
16. Ensures functions are done efficiently
Outer SELECT query
COUNT
Calculated Column
Performance
17. Command based way to ask the database a question
accident
Query
MIN
Data Recovery & Concurrance
18. Basic Component of SQL
LIKE
Service-Oriented Architecture (SOA)
Tables
ESC
19. One huge database to hold all data; Access to data - and use of system to add - update & print records
Aggregate Functions
Database Management Systems (DBMS)
HAVING
SELECT
20. Finds the lowest constant value in a column
MAX
WHERE
Element Content
Shared
21. = - < - > - <= - >= - <> - !
ORDER BY
Comparison Operators
Query
Primary Keys
22. Finds the lowest ACII value in column
Hardware
SUM
Empty Elements
MIN
23. Everything in enviroment becomes an object - expands on Priniples of relational databases
ORDER BY
Inner SELECT query
Relational
Object-Oriented Relational (OOR)
24. Join a table to a copy of itself
End Users
Scripting
Dynamic
Self Join
25. One of the tools that SQL uses to find and retrieve data.
Application Programers
Functions
Indexes
Opening tag
26. Responsible for technical implementation & maintenance of database on a design & physical level
Empty Elements
Query
Report
Database Administrator (DBA)
27. Looks like opening tag - but with a forward slash
Information
Bind
Closing tag
Cookie
28. Data in database interacts & corresponds with other data
Integrated
Web Applications
SUM
Data Dictionary
29. Tally of how many rows meet criteria specified
Cookie
Data
COUNT
End Users
30. = - < - > - <= - >= - <> - !
Bind
Fields
ORDER BY
Comparison Operators
31. Cookies are more secure than______ - allowing travel on a website without loss of info
COUNT
American Standard Code for Information Interchange (ASCII)
to update
hidden fields
32. Using product as intended for its audience
Report
Structured Query Language (SQL)
Structured Query Language (SQL)
End Users
33. Tally of how many rows meet criteria specified
Inner SELECT query
Performance
accident
COUNT
34. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
Shared
single value
accident
Outer SELECT query
35. Network node that discovers and invokes other software services to provide a buisness solution
Tags
Report
ASC
Service Requestor
36. Used in a SELECT clause in place of a column
Embedded SQL
single value
Aggregate Functions
Service-Oriented Architecture (SOA)
37. Selects from specific values in list
COUNT
BETWEEN
IN
UPDATE
38. Meaningful info related to database
Data Definition
Comparison Operators
Data
Database
39. Columns containing numbers only
Hardware
Persistent
SUM
Service-Oriented Architecture (SOA)
40. Some form of output - usually - printed - containing information
Negation Operator
Aliases
Hypertext Markup Language (HTML)
Report
41. Characterizes operation of a relational database
Joins
Data Administrator (DAd)
MIN
Equals Operator
42. Data in database has ability to be accessed and manipulated by several users
Hypertext Markup Language (HTML)
Shared
Flat File
Data Elements
43. Command used to show the attributes that define a table.
Data Elements
sp_help
ALL
Self Join
44. Combination of attributes that can be uniquely used to identify a database record and is generally the pool from which the primary key is chosen.
MIN
Candidate Keys
Web Service
Views
45. 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.
Primary Keys
NOT
Aggregate Functions
Views
46. Essentially a collection of services that communicate with eachother
Database
UPDATE
Data Recovery & Concurrance
Service-Oriented Architecture (SOA)
47. Table displayed in descending order
IN
ESC
SUM
American Standard Code for Information Interchange (ASCII)
48. Characterizes operation of a relational database
UPDATE
ALL
Joins
Structured Query Language (SQL)
49. Data stored by DAd
Service-Oriented Architecture (SOA)
Data Elements
Aggregate Functions
Object-Oriented Relational (OOR)
50. Used with another comparison operator - values become inverted
Integrated
SUM
Aliases
Negation Operator