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 - _____
Functions
Word
Data Dictionary
Database Administrator (DBA)
2. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
Hypertext Markup Language (HTML)
SUM
Service Requestor
Outer SELECT query
3. Copies multiple records at the same time using a SELECT statement
Hypertext Markup Language (HTML)
ORDER BY
INSERT INTO
Service Provider
4. Finds the lowest ACII value in column
American Standard Code for Information Interchange (ASCII)
MIN
DISTINCT
Fields
5. Meaningful info related to database
WHERE
Scripting
Data
Database Management Systems (DBMS)
6. Limits the rows that appear in the result mathcing a specified condition
Central Control of data
Users
Shared
WHERE
7. Data stored by DAd
Data Elements
Joins
Embedded SQL
accident
8. Everything between the start and end tag
Bind
Element Content
Forward Slash
WHERE
9. File stored on a user's machine that contains infor about application
Indexes
Functions
Cookie
Web server
10. Used to combine one query to another
Subqueries
Object-Oriented Relational (OOR)
Word
Equals Operator
11. Allows use of single or multiple character wildcards with the underscore or percent symbol
SUM
LIKE
to update
Database
12. Create program files that include SQ after each command
Hierarchial
Hierarchial
to update
Embedded SQL
13. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
Service Provider
SUM
Bind
Application Programmers
14. Interact and manipulates the data in the database
Hardware
Data Manipulation
Data Elements
IN
15. Allows use of single or multiple character wildcards with the underscore or percent symbol
to update
LIKE
Bind
Object-Oriented Relational (OOR)
16. Fields in a relational table that match the primary key from one column to the primary key of another table.
Foreign Keys
to update
WHERE
Hardware
17. Join a table to a copy of itself
LIKE
Inner SELECT query
Indexes
Self Join
18. Data stored by DAd
Comparison Operators
Stateless
Data Elements
Database Administrator (DBA)
19. Finds the lowest constant value in a column
Query
Aliases
Session
MAX
20. Supplies value for the search condition of the SELECT statement containing it
Negation Operator
Data Administrator (DAd)
Inner SELECT query
Tags
21. Uses relationships between independent entities
Service Provider
Integrated
Property
Relational
22. Characterizes operation of a relational database
Joins
Scripting
Candidate Keys
Calculated Column
23. One of the tools that SQL uses to find and retrieve data.
SELECT
Indexes
Scripting
WHERE
24. Practice of writing code into a webpage that is not directly visible to the user
COUNT
Scripting
Object-Oriented Relational (OOR)
Embedded SQL
25. Begins an element
Cookie
Dynamic
Opening tag
Functions
26. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
Calculated Column
ALL
Aliases
Hierarchial
27. Limits the output of the established groups into the derived result table
Indexes
WHERE
Web Service
HAVING
28. Tally of how many rows meet criteria specified
ORDER BY
Aggregate Functions
Stateless
COUNT
29. SELECT statment containing the nested query
Outer SELECT query
Element Content
Web server
Web Browser
30. System that is composed of a Certificate Authority - certificates - software - services and other cryptographic components to enable authenticity and validation of data and/or entities
INSERT INTO
Equals Operator
Public Key Infrastructure (PKI)
Hypertext Markup Language (HTML)
31. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
Persistent
Web Browser
Data Administrator (DAd)
Structured Query Language (SQL)
32. 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.
Primary Keys
HAVING
Fields
Candidate Keys
33. Selects from specific values in list
IN
DELETE
SELECT
Joins
34. Individuals that use - manipulate or maintain aspects of database
Users
Stateless
SELECT
Tables
35. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
Data Definition
Query
Web server
Empty Elements
36. Network node that discovers and invokes other software services to provide a buisness solution
Service Requestor
Web Browser
Embedded SQL
Information
37. Uses two values as limits - selecting any values between the two of them
BETWEEN
Primary Keys
Tags
Application Programers
38. Table displayed in descending order
ASC
Web Service
ESC
DISTINCT
39. Command used to show the attributes that define a table.
Negation Operator
sp_help
Outer SELECT query
Hardware
40. Interact and manipulates the data in the database
Data Manipulation
NOT
Service-Oriented Architecture (SOA)
Hierarchial
41. Computer programs allowing website visitors to submit and retrieve data to/from a database over the Internet using their preferred web browser
Web Applications
Data Recovery & Concurrance
Functions
Shared
42. Writes programs that use or allow acces to databse with specific purpose
Application Programers
hidden fields
Data Manipulation
INSERT INTO
43. Ensures data is correct casings
Database Management Systems (DBMS)
American Standard Code for Information Interchange (ASCII)
SUM
Data Administrator (DAd)
44. Table displayed in descending order
Opening tag
Candidate Keys
Web Service
ESC
45. Basic Component of SQL
Service Provider
to update
Tables
hidden fields
46. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
Aliases
*
Web server
Property
47. Responsible for technical implementation & maintenance of database on a design & physical level
ALL
Bind
Negation Operator
Database Administrator (DBA)
48. Everything between the start and end tag
COUNT
Element Content
Word
MAX
49. Writes programs that use or allow acces to databse with specific purpose
Application Programers
DISTINCT
Data
Performance
50. Closed in the start tag by adding a slash to the start tag
Cookie
Empty Elements
Data Dictionary
Stateless