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. Combines rows from a SELECT statements result table into a group
COUNT
GROUP BY
Data Elements
Element Content
2. Software system designed to support interoperable machine - to - machine interaction over a network
WHERE
Database Management Systems (DBMS)
Web Service
Flat File
3. Data remains unchanged in database
Persistent
Forward Slash
Data Elements
Dynamic
4. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance
FROM
Bind
Outer SELECT query
Functions
5. Copies multiple records at the same time using a SELECT statement
INSERT INTO
WHERE
Data Elements
End Users
6. Defines a new column
Hierarchial
Application Programmers
accident
Calculated Column
7. Allow useres to retrieve data and interact with content located on web pages within website
Web Browser
Integrated
Data Recovery & Concurrance
Shared
8. SELECT statment containing the nested query
Outer SELECT query
Service Broker
*
Data Elements
9. Finds the lowest ACII value in column
Performance
MIN
Negation Operator
Service Requestor
10. Large structured set of persistent data
SUM
Database
Flat File
MAX
11. Network node that discovers and invokes other software services to provide a buisness solution
Joins
COUNT
Cookie
Service Requestor
12. Grant acces and control to only specific information
Web server
Views
Integrated
SUM
13. 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.
Forward Slash
MIN
Flat File
Primary Keys
14. Order in which WHERE clause is evaluated and combined
Precedence of Logical Operators
Report
Inner SELECT query
MIN
15. The Web is ___________
ASC
Stateless
Functions
single value
16. One of the tools that SQL uses to find and retrieve data.
ESC
Property
Word
Indexes
17. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
Flat File
Application Programmers
accident
BETWEEN
18. Identifies columns to appear in the result
American Standard Code for Information Interchange (ASCII)
MAX
Application Programers
SELECT
19. Definition of commands it can do
Data Definition
AVG
ASC
Primary Keys
20. Computer programs allowing website visitors to submit and retrieve data to/from a database over the Internet using their preferred web browser
Web Applications
Element Content
WHERE
Application Programmers
21. Supplies value for the search condition of the SELECT statement containing it
accident
Query
Inner SELECT query
Web server
22. Software system designed to support interface for a software asset that manages a specific set of tasks
Relational
Interactive SQL
Word
Service Provider
23. Looks like opening tag - but with a forward slash
Closing tag
WHERE
Integrated
Information
24. 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.
ESC
Users
Tables
Candidate Keys
25. Decides what data is stored in the databse and the manner it is stored
Data Dictionary
Service Provider
Views
Data Administrator (DAd)
26. Defines a new column
Calculated Column
Shared
Information
WHERE
27. Three Basic Operations of SP - SR - SB: Publish - Find - ____
Bind
hidden fields
UPDATE
Information
28. Looks like opening tag - but with a forward slash
AVG
Closing tag
Performance
Central Control of data
29. Table displayed in descending order
AVG
ESC
American Standard Code for Information Interchange (ASCII)
Tables
30. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
Structured Query Language (SQL)
Views
Interactive SQL
INSERT INTO
31. Data in database interacts & corresponds with other data
ALL
Integrated
End Users
Application Programmers
32. Averages the numeric values
Public Key Infrastructure (PKI)
AVG
Empty Elements
Indexes
33. Uses relationships between independent entities
Relational
Object-Oriented Relational (OOR)
Service Requestor
Application Programmers
34. Uses two values as limits - selecting any values between the two of them
BETWEEN
COUNT
Performance
single value
35. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
HAVING
ALL
Opening tag
Negation Operator
36. Writes programs that use or allow acces to databse with specific purpose
HAVING
Object-Oriented Relational (OOR)
ESC
Application Programers
37. Create program files that include SQ after each command
Users
Embedded SQL
Data Elements
Data Definition
38. Practice of writing code into a webpage that is not directly visible to the user
Flat File
Information
Scripting
*
39. Browser requests page - code is delivered - executed and done with
Word
Dynamic
BETWEEN
ASC
40. Everything between the start and end tag
BETWEEN
Property
NOT
Element Content
41. Executes commands one at a time - results being displayed immediately
Interactive SQL
Users
Relational
Calculated Column
42. Give the browser more specific information about that tag
Central Control of data
Embedded SQL
Attributes
Shared
43. Limits the rows that appear in the result mathcing a specified condition
WHERE
Self Join
Indexes
Database Administrator (DBA)
44. Supplies value for the search condition of the SELECT statement containing it
Web Service
Inner SELECT query
Relational
Session
45. Interact and manipulates the data in the database
INSERT INTO
Users
ESC
Data Manipulation
46. Join a table to a copy of itself
SELECT
Information
Joins
Self Join
47. All Columns indicated and selected
Data Recovery & Concurrance
*
Indexes
SELECT
48. Table displayed in ascending order
ASC
Data
Data Elements
Relational
49. Averages the numeric values
AVG
accident
accident
ORDER BY
50. = - < - > - <= - >= - <> - !
Comparison Operators
sp_help
Database
Element Content