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. Uses relationships between independent entities
Database
Relational
ORDER BY
UPDATE
2. Identifies columns to appear in the result
SELECT
Session
Interactive SQL
Indexes
3. Combines rows from a SELECT statements result table into a group
Hierarchial
GROUP BY
Element Content
Database
4. Used to remove duplicates from result table
Web Service
Aliases
Central Control of data
DISTINCT
5. Allows use of single or multiple character wildcards with the underscore or percent symbol
Empty Elements
Flat File
Hypertext Markup Language (HTML)
LIKE
6. Used to combine one query to another
Element Content
Subqueries
Subquery
ESC
7. = - < - > - <= - >= - <> - !
accident
Persistent
Comparison Operators
Query
8. Some form of output - usually - printed - containing information
Aggregate Functions
Report
FROM
Opening tag
9. Flat File Examples: Excel Spreadsheets - _____
Word
Users
Database Management Systems (DBMS)
Views
10. Essentially a collection of services that communicate with eachother
Inner SELECT query
Central control of data
Information
Service-Oriented Architecture (SOA)
11. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
FROM
Inner SELECT query
Structured Query Language (SQL)
Hypertext Markup Language (HTML)
12. Deletes selected rows
sp_help
DISTINCT
Bind
DELETE
13. Used to remove duplicates from result table
Inner SELECT query
DISTINCT
Service Provider
Hierarchial
14. Ensures data is correct casings
MIN
Web Browser
American Standard Code for Information Interchange (ASCII)
Equals Operator
15. Selects from specific values in list
Data
Session
Web Applications
IN
16. Individuals that use - manipulate or maintain aspects of database
Users
Hypertext Markup Language (HTML)
NOT
Data Definition
17. Closed in the start tag by adding a slash to the start tag
Data Recovery & Concurrance
Calculated Column
Empty Elements
Shared
18. SQL Commands - Two Things Specify data interested in - Indicate the ________
Application Programers
Word
Information
accident
19. Ensures functions are done efficiently
Precedence of Logical Operators
Service Requestor
Performance
HAVING
20. Characterizes operation of a relational database
Information
UPDATE
Joins
Integrated
21. = - < - > - <= - >= - <> - !
Relational
Comparison Operators
Relational
Indexes
22. 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
Data Administrator (DAd)
American Standard Code for Information Interchange (ASCII)
Session
Web Browser
23. Selects from specific values in list
single value
Persistent
Data Elements
IN
24. Writes programs that use or allow acces to databse with specific purpose
Subqueries
Calculated Column
Application Programers
Data Administrator (DAd)
25. Practice of writing code into a webpage that is not directly visible to the user
Hardware
single value
LIKE
Scripting
26. 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
Service Provider
Data Definition
Closing tag
27. Changes the values in one or more selected rows of a table
Foreign Keys
ORDER BY
UPDATE
Persistent
28. Command based way to ask the database a question
Data Recovery & Concurrance
Inner SELECT query
INSERT INTO
Query
29. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
ALL
single value
Public Key Infrastructure (PKI)
Data Dictionary
30. Concatenated in SQL Server Database software using the addition symbol
Fields
Web Browser
accident
GROUP BY
31. Used in a SELECT clause in place of a column
COUNT
AVG
single value
Aggregate Functions
32. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
End Users
NOT
SELECT
Aliases
33. Ensures functions are done efficiently
Aliases
DISTINCT
Performance
ESC
34. Data in database has ability to be accessed and manipulated by several users
Empty Elements
GROUP BY
Query
Shared
35. Table displayed in ascending order
ASC
Word
Object-Oriented Relational (OOR)
Cookie
36. Computer programs allowing website visitors to submit and retrieve data to/from a database over the Internet using their preferred web browser
Subqueries
Service Provider
Outer SELECT query
Web Applications
37. Finds the lowest ACII value in column
MIN
Web server
Service-Oriented Architecture (SOA)
Views
38. Data remains unchanged in database
Persistent
ALL
Comparison Operators
Shared
39. Begins an element
Subqueries
Performance
ALL
Opening tag
40. Some form of output - usually - printed - containing information
ASC
Self Join
Report
accident
41. Cookies are more secure than______ - allowing travel on a website without loss of info
Closing tag
hidden fields
to update
NOT
42. Copies multiple records at the same time using a SELECT statement
INSERT INTO
accident
Data Definition
Object-Oriented Relational (OOR)
43. Compares value of the column in the specified condition with the value specified
Structured Query Language (SQL)
Equals Operator
Attributes
INSERT INTO
44. Order in which WHERE clause is evaluated and combined
ESC
Stateless
Inner SELECT query
Precedence of Logical Operators
45. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
Web Applications
Hierarchial
Service-Oriented Architecture (SOA)
ALL
46. Grant acces and control to only specific information
IN
Views
Comparison Operators
Joins
47. File stored on a user's machine that contains infor about application
Interactive SQL
Tags
Embedded SQL
Cookie
48. Grant acces and control to only specific information
Structured Query Language (SQL)
Views
SUM
Session
49. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
Application Programmers
ORDER BY
Comparison Operators
Hierarchial
50. Finds the lowest constant value in a column
Service Requestor
COUNT
MAX
Equals Operator