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
Outer SELECT query
Web Service
Relational
Service Provider
2. Characterizes operation of a relational database
Web Service
Closing tag
Joins
Word
3. Practice of writing code into a webpage that is not directly visible to the user
Web server
COUNT
Scripting
Outer SELECT query
4. Basic Component of SQL
HAVING
Hardware
Tables
Service Broker
5. Data in database interacts & corresponds with other data
Indexes
Integrated
Object-Oriented Relational (OOR)
Structured Query Language (SQL)
6. Cookies are more secure than______ - allowing travel on a website without loss of info
Property
End Users
Inner SELECT query
hidden fields
7. Order in which WHERE clause is evaluated and combined
Precedence of Logical Operators
Calculated Column
Dynamic
BETWEEN
8. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________
Central Control of data
Service Broker
HAVING
INSERT INTO
9. Selects from specific values in list
IN
Negation Operator
single value
Flat File
10. Deletes selected rows
Integrated
*
ALL
DELETE
11. SQL Commands: Define tables - views - _____ - delete or insert info
Empty Elements
Comparison Operators
Database
to update
12. Limits the rows that appear in the result mathcing a specified condition
Tables
Database Administrator (DBA)
Data Administrator (DAd)
WHERE
13. Uses two values as limits - selecting any values between the two of them
MAX
Persistent
Service Provider
BETWEEN
14. Join a table to a copy of itself
Comparison Operators
Self Join
BETWEEN
Scripting
15. Using product as intended for its audience
Session
Tags
Subqueries
End Users
16. SQL Commands - Two Things Specify data interested in - Indicate the ________
Application Programers
accident
Element Content
Flat File
17. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
Embedded SQL
Hypertext Markup Language (HTML)
Candidate Keys
Aliases
18. Averages the numeric values
AVG
Report
Dynamic
Data Dictionary
19. Data that has been processed into a format that is understandable by its audience
Shared
sp_help
Hypertext Markup Language (HTML)
Information
20. All Columns indicated and selected
*
Database Management Systems (DBMS)
Scripting
MIN
21. Computer equipment -Fixed Storage Media - Removeable Storage Media - System Memory - and the Processor
Flat File
Embedded SQL
Subquery
Hardware
22. Definition of commands it can do
Data Definition
hidden fields
Bind
Database Management Systems (DBMS)
23. Data stored by DAd
Central control of data
Dynamic
Data Elements
Scripting
24. Responsible for technical implementation & maintenance of database on a design & physical level
Calculated Column
Database Administrator (DBA)
Bind
Negation Operator
25. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance
Candidate Keys
MIN
Functions
Aggregate Functions
26. Grant acces and control to only specific information
FROM
Performance
HAVING
Views
27. Used to close a tag properly
Forward Slash
Scripting
GROUP BY
Data Recovery & Concurrance
28. Data remains unchanged in database
Persistent
ESC
Closing tag
Subqueries
29. Table displayed in descending order
ESC
to update
MAX
Aliases
30. Finds the lowest constant value in a column
Aliases
MAX
Service-Oriented Architecture (SOA)
Tables
31. Used in a SELECT clause in place of a column
Aggregate Functions
WHERE
FROM
hidden fields
32. Essentially a collection of services that communicate with eachother
Service-Oriented Architecture (SOA)
Joins
Session
Indexes
33. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG
Scripting
SUM
IN
Element Content
34. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance
Hypertext Markup Language (HTML)
Scripting
Functions
Application Programmers
35. Writes programs that use or allow acces to databse with specific purpose
Bind
ESC
Application Programers
*
36. Change order of rows in result table
SUM
Application Programers
ORDER BY
Database
37. Software system designed to support interface for a software asset that manages a specific set of tasks
Hypertext Markup Language (HTML)
AVG
Hypertext Markup Language (HTML)
Service Provider
38. All Columns indicated and selected
*
Hypertext Markup Language (HTML)
Service Broker
ASC
39. Table displayed in ascending order
Data Definition
ASC
Primary Keys
SELECT
40. Ensures functions are done efficiently
Data Dictionary
Hierarchial
Views
Performance
41. Looks like opening tag - but with a forward slash
Opening tag
Closing tag
WHERE
Information
42. Computer programs allowing website visitors to submit and retrieve data to/from a database over the Internet using their preferred web browser
MAX
Web Applications
Web server
SELECT
43. Has the highest precedence - followed by the AND - OR
Service Requestor
Attributes
Shared
NOT
44. Ensures data is correct casings
Comparison Operators
ASC
Views
American Standard Code for Information Interchange (ASCII)
45. Looks like opening tag - but with a forward slash
Views
Closing tag
NOT
Service-Oriented Architecture (SOA)
46. Everything in enviroment becomes an object - expands on Priniples of relational databases
Word
Flat File
Object-Oriented Relational (OOR)
Tables
47. Copies multiple records at the same time using a SELECT statement
Flat File
INSERT INTO
Hypertext Markup Language (HTML)
Forward Slash
48. Writes programs that use or allow acces to databse with specific purpose
ESC
AVG
Dynamic
Application Programers
49. Decides what data is stored in the databse and the manner it is stored
Relational
Cookie
Data Administrator (DAd)
Precedence of Logical Operators
50. Characterizes operation of a relational database
ASC
Empty Elements
Joins
Comparison Operators