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. 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.
Web Browser
ESC
Web Service
Candidate Keys
2. Used to combine one query to another
*
Element Content
Subqueries
Public Key Infrastructure (PKI)
3. Responsible for technical implementation & maintenance of database on a design & physical level
COUNT
Query
Database Administrator (DBA)
Subqueries
4. Characterizes operation of a relational database
Relational
ASC
Joins
Embedded SQL
5. Software system designed to support interface for a software asset that manages a specific set of tasks
Service Provider
Information
Data Manipulation
Session
6. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance
Functions
Central Control of data
Negation Operator
Equals Operator
7. Responsible for technical implementation & maintenance of database on a design & physical level
Database Management Systems (DBMS)
Object-Oriented Relational (OOR)
SUM
Database Administrator (DBA)
8. Used with another comparison operator - values become inverted
Negation Operator
Query
Equals Operator
DISTINCT
9. Table displayed in ascending order
Bind
MAX
Performance
ASC
10. = - < - > - <= - >= - <> - !
Comparison Operators
HAVING
Service Broker
Scripting
11. Writes programs that use or allow acces to databse with specific purpose
Data Dictionary
Persistent
single value
Application Programers
12. Computer programs allowing website visitors to submit and retrieve data to/from a database over the Internet using their preferred web browser
Web Applications
Web server
MAX
Subquery
13. Large structured set of persistent data
LIKE
Scripting
Database
Negation Operator
14. Browser requests page - code is delivered - executed and done with
Dynamic
Indexes
COUNT
IN
15. Supplies value for the search condition of the SELECT statement containing it
Property
Inner SELECT query
Web Browser
Database Management Systems (DBMS)
16. Using product as intended for its audience
Tables
Data Dictionary
End Users
Application Programmers
17. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG
sp_help
SUM
Performance
Web server
18. Three Basic Operations of SP - SR - SB: Publish - Find - ____
Information
Database Administrator (DBA)
SUM
Bind
19. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
Structured Query Language (SQL)
Flat File
ALL
Indexes
20. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
Embedded SQL
WHERE
SUM
Hypertext Markup Language (HTML)
21. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
Object-Oriented Relational (OOR)
Application Programmers
ASC
UPDATE
22. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
Closing tag
Users
Service Broker
Opening tag
23. Limits the output of the established groups into the derived result table
Public Key Infrastructure (PKI)
ASC
Embedded SQL
HAVING
24. SQL Commands: Define tables - views - _____ - delete or insert info
hidden fields
Scripting
to update
Primary Keys
25. Looks like opening tag - but with a forward slash
Closing tag
Data
DELETE
Opening tag
26. SQL finds and retrieves date
Flat File
Bind
ALL
Indexes
27. Concatenated in SQL Server Database software using the addition symbol
Hypertext Markup Language (HTML)
Session
BETWEEN
Fields
28. Uses two values as limits - selecting any values between the two of them
COUNT
Indexes
BETWEEN
ASC
29. SQL Commands - Two Things Specify data interested in - Indicate the ________
*
Structured Query Language (SQL)
Inner SELECT query
accident
30. Specifies the tables or views from which rows and columns are retrieved
FROM
Views
hidden fields
Hardware
31. Uses relationships between independent entities
Relational
Web Applications
ORDER BY
Database Management Systems (DBMS)
32. Concatenated in SQL Server Database software using the addition symbol
Calculated Column
Fields
Application Programmers
SELECT
33. Definition of commands it can do
Dynamic
Empty Elements
HAVING
Data Definition
34. Text markups that form an element" sort of a "box" to hold things like text and other elements
Subquery
hidden fields
Tags
single value
35. Everything in enviroment becomes an object - expands on Priniples of relational databases
Flat File
Object-Oriented Relational (OOR)
Hierarchial
Opening tag
36. Command used to show the attributes that define a table.
Flat File
hidden fields
IN
sp_help
37. Limits the rows that appear in the result mathcing a specified condition
WHERE
Functions
Hierarchial
Service-Oriented Architecture (SOA)
38. Compares value of the column in the specified condition with the value specified
Views
Empty Elements
Equals Operator
Aggregate Functions
39. Combines rows from a SELECT statements result table into a group
GROUP BY
Database Management Systems (DBMS)
Hypertext Markup Language (HTML)
Inner SELECT query
40. Data in database interacts & corresponds with other data
End Users
Integrated
Application Programmers
Service Provider
41. Changes the values in one or more selected rows of a table
Data Recovery & Concurrance
single value
Hardware
UPDATE
42. SQL Commands - Two Things Specify data interested in - Indicate the ________
Application Programmers
ORDER BY
accident
NOT
43. Closed in the start tag by adding a slash to the start tag
Empty Elements
Opening tag
accident
hidden fields
44. Essentially a collection of services that communicate with eachother
Dynamic
Service-Oriented Architecture (SOA)
Structured Query Language (SQL)
Data Recovery & Concurrance
45. Meaningful info related to database
Data
Joins
Negation Operator
Service Provider
46. Grant acces and control to only specific information
Performance
Views
SUM
Data Administrator (DAd)
47. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________
DISTINCT
Central Control of data
MIN
AVG
48. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
Scripting
Aliases
ALL
UPDATE
49. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
Web server
Primary Keys
Data Recovery & Concurrance
Application Programmers
50. Table displayed in descending order
Web server
Database Management Systems (DBMS)
End Users
ESC