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. Data in database has ability to be accessed and manipulated by several users
Shared
LIKE
Subqueries
ORDER BY
2. Cookies are more secure than______ - allowing travel on a website without loss of info
hidden fields
SELECT
Central control of data
Data
3. Decides what data is stored in the databse and the manner it is stored
AVG
single value
Data Administrator (DAd)
NOT
4. 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.
Hierarchial
Candidate Keys
Data Elements
Hypertext Markup Language (HTML)
5. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
Web Service
Negation Operator
Persistent
Application Programmers
6. SQL Commands - Two Things Specify data interested in - Indicate the ________
Aliases
Data Dictionary
Data Dictionary
accident
7. Command used to show the attributes that define a table.
sp_help
MAX
Application Programmers
Precedence of Logical Operators
8. Computer equipment -Fixed Storage Media - Removeable Storage Media - System Memory - and the Processor
accident
Hardware
ORDER BY
sp_help
9. All Columns indicated and selected
COUNT
*
COUNT
LIKE
10. Used to combine one query to another
Database
Views
Scripting
Subqueries
11. Everything between the start and end tag
*
Element Content
Inner SELECT query
Application Programers
12. Data remains unchanged in database
HAVING
Self Join
Persistent
COUNT
13. File stored on a user's machine that contains infor about application
Joins
Element Content
Indexes
Cookie
14. Ensures functions are done efficiently
ORDER BY
Data Recovery & Concurrance
Performance
Integrated
15. = - < - > - <= - >= - <> - !
Relational
Report
Comparison Operators
SELECT
16. Finds the lowest constant value in a column
Application Programers
MAX
Flat File
DISTINCT
17. Data remains unchanged in database
SELECT
Persistent
Forward Slash
Calculated Column
18. Limits the rows that appear in the result mathcing a specified condition
Indexes
Attributes
WHERE
Attributes
19. Create program files that include SQ after each command
Service Broker
Data Recovery & Concurrance
Embedded SQL
accident
20. Supplies value for the search condition of the SELECT statement containing it
GROUP BY
GROUP BY
Inner SELECT query
Interactive SQL
21. Allows data recovery in case of corruption or loss
Web Service
Aliases
Session
Data Recovery & Concurrance
22. Straight implementation of raw data formatted into rows and columns
Dynamic
Flat File
Scripting
FROM
23. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG
SUM
AVG
MIN
GROUP BY
24. Everything between the start and end tag
Data
Element Content
Service Provider
Word
25. Computer programs allowing website visitors to submit and retrieve data to/from a database over the Internet using their preferred web browser
Web server
INSERT INTO
Web Applications
Aliases
26. Join a table to a copy of itself
Application Programers
FROM
Self Join
Report
27. Columns containing numbers only
Equals Operator
SUM
Data Manipulation
Stateless
28. Allow useres to retrieve data and interact with content located on web pages within website
Service Requestor
Structured Query Language (SQL)
Database
Web Browser
29. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG
SUM
Data Administrator (DAd)
Stateless
Indexes
30. Definition of commands it can do
Aggregate Functions
Data Definition
WHERE
Embedded SQL
31. Responsible for technical implementation & maintenance of database on a design & physical level
Data Elements
Structured Query Language (SQL)
Database Administrator (DBA)
Hypertext Markup Language (HTML)
32. Network node that discovers and invokes other software services to provide a buisness solution
hidden fields
SUM
Service Requestor
Performance
33. Uses relationships between independent entities
Central Control of data
DELETE
Relational
Negation Operator
34. Uses two values as limits - selecting any values between the two of them
MAX
Interactive SQL
BETWEEN
Precedence of Logical Operators
35. Looks like opening tag - but with a forward slash
AVG
IN
Closing tag
*
36. SQL Commands: Define tables - views - _____ - delete or insert info
Closing tag
to update
WHERE
American Standard Code for Information Interchange (ASCII)
37. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
DELETE
Web server
Application Programmers
ALL
38. Flat File Examples: Excel Spreadsheets - _____
Service Provider
Word
single value
hidden fields
39. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
Service Broker
Service-Oriented Architecture (SOA)
Cookie
UPDATE
40. Uses two values as limits - selecting any values between the two of them
Fields
Opening tag
BETWEEN
Attributes
41. Tally of how many rows meet criteria specified
Tables
Integrated
Candidate Keys
COUNT
42. Used in a SELECT clause in place of a column
Aggregate Functions
Tables
DELETE
Scripting
43. Individuals that use - manipulate or maintain aspects of database
ASC
Data Dictionary
Hypertext Markup Language (HTML)
Users
44. Executes commands one at a time - results being displayed immediately
*
Interactive SQL
Dynamic
hidden fields
45. Compares value of the column in the specified condition with the value specified
Database Management Systems (DBMS)
Candidate Keys
Equals Operator
Self Join
46. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
LIKE
WHERE
to update
Hypertext Markup Language (HTML)
47. Flat File Examples: Excel Spreadsheets - _____
Data
Subqueries
Word
Session
48. Uses relationships between independent entities
Inner SELECT query
Stateless
Relational
Tags
49. Data in database has ability to be accessed and manipulated by several users
Shared
Information
Database
MAX
50. Meaningful info related to database
Session
Data
Embedded SQL
Data Dictionary