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. Compares value of the column in the specified condition with the value specified
Equals Operator
Calculated Column
Hypertext Markup Language (HTML)
Shared
2. Looks like opening tag - but with a forward slash
Closing tag
SELECT
Precedence of Logical Operators
Application Programers
3. Flat File Examples: Excel Spreadsheets - _____
Word
Data Elements
sp_help
Application Programmers
4. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
Central Control of data
Embedded SQL
Relational
Hypertext Markup Language (HTML)
5. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG
IN
Data Administrator (DAd)
Data Dictionary
SUM
6. Responsible for technical implementation & maintenance of database on a design & physical level
Database Administrator (DBA)
Scripting
Dynamic
Equals Operator
7. The Web is ___________
Query
Interactive SQL
Foreign Keys
Stateless
8. Software system designed to support interface for a software asset that manages a specific set of tasks
BETWEEN
Web Applications
ORDER BY
Service Provider
9. Copies multiple records at the same time using a SELECT statement
SELECT
COUNT
INSERT INTO
Performance
10. SQL Commands: Define tables - views - _____ - delete or insert info
to update
COUNT
Web Service
Integrated
11. Characterizes operation of a relational database
Joins
SUM
ORDER BY
accident
12. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
NOT
Data
ALL
single value
13. Create program files that include SQ after each command
Embedded SQL
FROM
ASC
Structured Query Language (SQL)
14. Used to remove duplicates from result table
*
DISTINCT
Session
Indexes
15. Using product as intended for its audience
Data Administrator (DAd)
Web Service
GROUP BY
End Users
16. 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
Fields
Subquery
Indexes
Session
17. One huge database to hold all data; Access to data - and use of system to add - update & print records
ESC
Data Administrator (DAd)
Data Manipulation
Database Management Systems (DBMS)
18. Table displayed in ascending order
ASC
HAVING
Session
Opening tag
19. Closed in the start tag by adding a slash to the start tag
Equals Operator
Web Browser
Database Management Systems (DBMS)
Empty Elements
20. Basic Component of SQL
Closing tag
to update
Tables
Self Join
21. Practice of writing code into a webpage that is not directly visible to the user
Dynamic
Scripting
accident
Application Programmers
22. Essentially a collection of services that communicate with eachother
Calculated Column
ESC
Comparison Operators
Service-Oriented Architecture (SOA)
23. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
Property
Aliases
Information
Views
24. Order in which WHERE clause is evaluated and combined
Precedence of Logical Operators
Negation Operator
DISTINCT
Cookie
25. Concatenated in SQL Server Database software using the addition symbol
Interactive SQL
Data Dictionary
Structured Query Language (SQL)
Fields
26. Finds the lowest constant value in a column
MAX
Tags
Calculated Column
Tables
27. Large structured set of persistent data
*
Precedence of Logical Operators
Scripting
Database
28. = - < - > - <= - >= - <> - !
WHERE
Users
Comparison Operators
Tables
29. Ongoing record of data reflecting the info defining the database
Data Dictionary
WHERE
Data Administrator (DAd)
Aliases
30. Essentially a collection of services that communicate with eachother
Aliases
Service-Oriented Architecture (SOA)
Equals Operator
Structured Query Language (SQL)
31. Ensures functions are done efficiently
DELETE
Performance
Subquery
ASC
32. Used to combine one query with another.
to update
Subquery
Application Programers
Report
33. SELECT statment containing the nested query
Information
ESC
Outer SELECT query
Database Administrator (DBA)
34. Data in database interacts & corresponds with other data
HAVING
hidden fields
Web Service
Integrated
35. Attribute in quotes
ORDER BY
BETWEEN
Property
Data
36. Everything in enviroment becomes an object - expands on Priniples of relational databases
UPDATE
Object-Oriented Relational (OOR)
Closing tag
Data Manipulation
37. Definition of commands it can do
Data Definition
Hypertext Markup Language (HTML)
UPDATE
Empty Elements
38. Interact and manipulates the data in the database
Indexes
Data Manipulation
Flat File
Web Service
39. Most valuable asset of a database system.
Central control of data
Session
Integrated
Comparison Operators
40. Software system designed to support interface for a software asset that manages a specific set of tasks
Service Provider
Service-Oriented Architecture (SOA)
Opening tag
Users
41. = - < - > - <= - >= - <> - !
COUNT
Comparison Operators
ALL
sp_help
42. Used to close a tag properly
Scripting
Self Join
Forward Slash
Hypertext Markup Language (HTML)
43. 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.
UPDATE
Users
Candidate Keys
Web Browser
44. Change order of rows in result table
Database
ORDER BY
Performance
Web Applications
45. Changes the values in one or more selected rows of a table
Aggregate Functions
Application Programmers
UPDATE
End Users
46. Limits the output of the established groups into the derived result table
HAVING
Stateless
Property
Indexes
47. Data that has been processed into a format that is understandable by its audience
Subqueries
IN
Central control of data
Information
48. Command based way to ask the database a question
Hypertext Markup Language (HTML)
Query
Joins
Structured Query Language (SQL)
49. Some form of output - usually - printed - containing information
Report
Data Elements
to update
Data
50. Individuals that use - manipulate or maintain aspects of database
Closing tag
Query
Aggregate Functions
Users