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. Flat File Examples: Excel Spreadsheets - _____
ASC
Service Broker
MAX
Word
2. Ensures functions are done efficiently
Performance
Application Programmers
Service Provider
WHERE
3. Data in database has ability to be accessed and manipulated by several users
Shared
Outer SELECT query
IN
Element Content
4. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
Application Programmers
HAVING
ALL
Service Broker
5. Has the highest precedence - followed by the AND - OR
BETWEEN
NOT
INSERT INTO
UPDATE
6. Cookies are more secure than______ - allowing travel on a website without loss of info
Session
hidden fields
IN
INSERT INTO
7. Tally of how many rows meet criteria specified
Query
ASC
COUNT
Data Administrator (DAd)
8. Computer programs allowing website visitors to submit and retrieve data to/from a database over the Internet using their preferred web browser
Service Broker
Web Applications
WHERE
FROM
9. Order in which WHERE clause is evaluated and combined
Query
Tags
Service Provider
Precedence of Logical Operators
10. Compares value of the column in the specified condition with the value specified
Equals Operator
Joins
Attributes
Web Service
11. Text markups that form an element" sort of a "box" to hold things like text and other elements
Application Programmers
Opening tag
Users
Tags
12. Large structured set of persistent data
Database
single value
HAVING
Object-Oriented Relational (OOR)
13. Used to combine one query to another
Precedence of Logical Operators
Scripting
FROM
Subqueries
14. One of the tools that SQL uses to find and retrieve data.
WHERE
GROUP BY
Service Broker
Indexes
15. Data that has been processed into a format that is understandable by its audience
Data
Information
Hierarchial
Application Programers
16. File stored on a user's machine that contains infor about application
Hierarchial
Cookie
Indexes
Negation Operator
17. Computer equipment -Fixed Storage Media - Removeable Storage Media - System Memory - and the Processor
Data
Hardware
Subqueries
Tags
18. Allows data recovery in case of corruption or loss
Web Browser
Service Requestor
Stateless
Data Recovery & Concurrance
19. Create program files that include SQ after each command
Data Definition
Embedded SQL
Hardware
FROM
20. Finds the lowest ACII value in column
Tags
Tables
Data Recovery & Concurrance
MIN
21. Allow useres to retrieve data and interact with content located on web pages within website
Persistent
to update
Web Browser
Empty Elements
22. Uses relationships between independent entities
Relational
Users
Users
Data
23. 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.
Subqueries
Word
Opening tag
Primary Keys
24. Closed in the start tag by adding a slash to the start tag
Dynamic
ALL
Data Elements
Empty Elements
25. Everything between the start and end tag
Subqueries
Calculated Column
Element Content
Users
26. Definition of commands it can do
Web Service
Data Definition
Users
Tags
27. Uses two values as limits - selecting any values between the two of them
UPDATE
Shared
ORDER BY
BETWEEN
28. Used to close a tag properly
Attributes
Forward Slash
Tags
Comparison Operators
29. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
Bind
Precedence of Logical Operators
Structured Query Language (SQL)
ESC
30. SQL finds and retrieves date
Equals Operator
Opening tag
Indexes
American Standard Code for Information Interchange (ASCII)
31. Columns containing numbers only
Service Requestor
SUM
DISTINCT
Structured Query Language (SQL)
32. Writes programs that use or allow acces to databse with specific purpose
Relational
Application Programers
Comparison Operators
Empty Elements
33. Basic Component of SQL
Tables
Word
Web server
SUM
34. Copies multiple records at the same time using a SELECT statement
NOT
single value
Tables
INSERT INTO
35. Join a table to a copy of itself
Service Requestor
COUNT
Object-Oriented Relational (OOR)
Self Join
36. Data in database interacts & corresponds with other data
to update
Bind
Users
Integrated
37. Create program files that include SQ after each command
Embedded SQL
Self Join
Service-Oriented Architecture (SOA)
ORDER BY
38. Selects from specific values in list
single value
IN
Object-Oriented Relational (OOR)
Indexes
39. Finds the lowest ACII value in column
Shared
Stateless
MIN
Precedence of Logical Operators
40. Software system designed to support interoperable machine - to - machine interaction over a network
Central control of data
hidden fields
Tables
Web Service
41. Defines a new column
FROM
Data Administrator (DAd)
accident
Calculated Column
42. Software system designed to support interoperable machine - to - machine interaction over a network
Tables
Aliases
Users
Web Service
43. Uses relationships between independent entities
Service-Oriented Architecture (SOA)
Relational
Flat File
Hardware
44. Essentially a collection of services that communicate with eachother
MIN
NOT
Subqueries
Service-Oriented Architecture (SOA)
45. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
ALL
Shared
Information
Database Administrator (DBA)
46. Decides what data is stored in the databse and the manner it is stored
Central Control of data
Data Administrator (DAd)
Hypertext Markup Language (HTML)
GROUP BY
47. SQL Commands - Two Things Specify data interested in - Indicate the ________
Indexes
End Users
accident
Central Control of data
48. Responsible for technical implementation & maintenance of database on a design & physical level
Tables
Database Administrator (DBA)
BETWEEN
Empty Elements
49. One huge database to hold all data; Access to data - and use of system to add - update & print records
DISTINCT
Database Management Systems (DBMS)
Information
ALL
50. Limits the rows that appear in the result mathcing a specified condition
Database Management Systems (DBMS)
Empty Elements
Central control of data
WHERE