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. SQL Commands - Two Things Specify data interested in - Indicate the ________
Self Join
*
accident
HAVING
2. Combines rows from a SELECT statements result table into a group
Performance
DELETE
Service Broker
GROUP BY
3. Software system designed to support interoperable machine - to - machine interaction over a network
Joins
Web Service
Bind
Relational
4. Order in which WHERE clause is evaluated and combined
Service Broker
Negation Operator
Application Programers
Precedence of Logical Operators
5. Data that has been processed into a format that is understandable by its audience
Database Administrator (DBA)
Relational
Information
Functions
6. Computer equipment -Fixed Storage Media - Removeable Storage Media - System Memory - and the Processor
Hardware
Property
Functions
Relational
7. = - < - > - <= - >= - <> - !
Data Elements
Closing tag
Comparison Operators
Outer SELECT query
8. Create program files that include SQ after each command
Embedded SQL
Data Recovery & Concurrance
Users
ASC
9. Tally of how many rows meet criteria specified
Integrated
COUNT
Data Manipulation
Structured Query Language (SQL)
10. Defines a new column
ASC
MAX
Calculated Column
Closing tag
11. SQL finds and retrieves date
Indexes
Query
Data Recovery & Concurrance
Joins
12. Changes the values in one or more selected rows of a table
GROUP BY
UPDATE
Service Broker
Service Broker
13. Everything between the start and end tag
NOT
Structured Query Language (SQL)
Element Content
Session
14. Flat File Examples: Excel Spreadsheets - _____
Word
Dynamic
COUNT
sp_help
15. Basic Component of SQL
COUNT
Tables
NOT
Tags
16. Everything in enviroment becomes an object - expands on Priniples of relational databases
AVG
Cookie
GROUP BY
Object-Oriented Relational (OOR)
17. Used in a SELECT clause in place of a column
Aggregate Functions
SUM
Central control of data
Database Administrator (DBA)
18. Limits the output of the established groups into the derived result table
SUM
HAVING
single value
Data Administrator (DAd)
19. Limits the rows that appear in the result mathcing a specified condition
ASC
GROUP BY
WHERE
DISTINCT
20. Network node that discovers and invokes other software services to provide a buisness solution
WHERE
Service Requestor
Inner SELECT query
Closing tag
21. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
Precedence of Logical Operators
ESC
FROM
Application Programmers
22. Grant acces and control to only specific information
Views
IN
Closing tag
Precedence of Logical Operators
23. One huge database to hold all data; Access to data - and use of system to add - update & print records
American Standard Code for Information Interchange (ASCII)
Integrated
SELECT
Database Management Systems (DBMS)
24. Writes programs that use or allow acces to databse with specific purpose
BETWEEN
Scripting
ESC
Application Programers
25. Defines a new column
Calculated Column
single value
Element Content
Web Browser
26. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
AVG
single value
Application Programmers
NOT
27. Data remains unchanged in database
Subqueries
Joins
Persistent
Service-Oriented Architecture (SOA)
28. Interact and manipulates the data in the database
BETWEEN
Comparison Operators
Service-Oriented Architecture (SOA)
Data Manipulation
29. Computer programs allowing website visitors to submit and retrieve data to/from a database over the Internet using their preferred web browser
single value
Application Programmers
Performance
Web Applications
30. Identifies columns to appear in the result
End Users
Data Dictionary
SELECT
Embedded SQL
31. Uses two values as limits - selecting any values between the two of them
Bind
Embedded SQL
BETWEEN
Element Content
32. Table displayed in ascending order
ASC
Data Administrator (DAd)
Query
Data Dictionary
33. Data in database has ability to be accessed and manipulated by several users
*
End Users
Shared
Service Provider
34. Executes commands one at a time - results being displayed immediately
Interactive SQL
DELETE
INSERT INTO
Embedded SQL
35. File stored on a user's machine that contains infor about application
sp_help
Cookie
Word
Data Manipulation
36. Cookies are more secure than______ - allowing travel on a website without loss of info
DELETE
Cookie
hidden fields
Data
37. = - < - > - <= - >= - <> - !
Database Administrator (DBA)
Comparison Operators
hidden fields
UPDATE
38. Used to close a tag properly
hidden fields
Forward Slash
Report
INSERT INTO
39. Selects from specific values in list
Information
Hierarchial
HAVING
IN
40. Browser requests page - code is delivered - executed and done with
*
Interactive SQL
Dynamic
Web Service
41. Attribute in quotes
Closing tag
Functions
Tables
Property
42. Used to remove duplicates from result table
AVG
Foreign Keys
DISTINCT
Flat File
43. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
Subqueries
Hypertext Markup Language (HTML)
Query
ORDER BY
44. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
FROM
hidden fields
BETWEEN
ALL
45. Ongoing record of data reflecting the info defining the database
Joins
Scripting
Calculated Column
Data Dictionary
46. Software system designed to support interoperable machine - to - machine interaction over a network
Web Service
Shared
Application Programmers
FROM
47. Data in database interacts & corresponds with other data
INSERT INTO
Web Browser
Integrated
Flat File
48. Table displayed in descending order
ESC
Application Programers
Database
Web Applications
49. Ensures functions are done efficiently
Tags
End Users
Inner SELECT query
Performance
50. 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
Application Programmers
Session
Views
Embedded SQL