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. Used to remove duplicates from result table
DISTINCT
Joins
Subquery
Data Dictionary
2. Used to combine one query to another
Subqueries
Dynamic
MAX
NOT
3. Practice of writing code into a webpage that is not directly visible to the user
SUM
Negation Operator
Interactive SQL
Scripting
4. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
HAVING
Aliases
Service Requestor
Equals Operator
5. Interact and manipulates the data in the database
Data Manipulation
Data Dictionary
hidden fields
Functions
6. Ensures data is correct casings
NOT
American Standard Code for Information Interchange (ASCII)
SELECT
BETWEEN
7. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
Aliases
Attributes
Precedence of Logical Operators
WHERE
8. Software system designed to support interoperable machine - to - machine interaction over a network
Integrated
Web Service
Fields
Database Administrator (DBA)
9. Straight implementation of raw data formatted into rows and columns
LIKE
Interactive SQL
Data Dictionary
Flat File
10. Table displayed in descending order
Foreign Keys
ESC
hidden fields
IN
11. Defines a new column
Calculated Column
INSERT INTO
FROM
MIN
12. Selects from specific values in list
IN
MAX
Joins
Shared
13. Cookies are more secure than______ - allowing travel on a website without loss of info
Hierarchial
Database Management Systems (DBMS)
hidden fields
Performance
14. All Columns indicated and selected
Flat File
American Standard Code for Information Interchange (ASCII)
Data Recovery & Concurrance
*
15. Uses two values as limits - selecting any values between the two of them
Negation Operator
HAVING
BETWEEN
Information
16. Three Basic Operations of SP - SR - SB: Publish - Find - ____
Bind
Scripting
Indexes
SUM
17. Limits the output of the established groups into the derived result table
UPDATE
SELECT
HAVING
Tags
18. Identifies columns to appear in the result
SELECT
Data Dictionary
MAX
Tags
19. Some form of output - usually - printed - containing information
Precedence of Logical Operators
Subqueries
Report
Views
20. Change order of rows in result table
ORDER BY
Web Browser
Equals Operator
Element Content
21. Tally of how many rows meet criteria specified
Tags
Equals Operator
COUNT
Service-Oriented Architecture (SOA)
22. Allows data recovery in case of corruption or loss
Data Recovery & Concurrance
to update
Outer SELECT query
Interactive SQL
23. Columns containing numbers only
Data Elements
SUM
Service Requestor
GROUP BY
24. Uses relationships between independent entities
Relational
WHERE
Web Service
Flat File
25. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
Service Broker
Application Programmers
hidden fields
ESC
26. Using product as intended for its audience
DISTINCT
Views
End Users
Tags
27. = - < - > - <= - >= - <> - !
Equals Operator
Users
Comparison Operators
Service Provider
28. Describe information in a tree styled format
MIN
Hierarchial
ESC
IN
29. SQL Commands: Define tables - views - _____ - delete or insert info
DISTINCT
to update
Hierarchial
Relational
30. Computer equipment -Fixed Storage Media - Removeable Storage Media - System Memory - and the Processor
Hardware
UPDATE
WHERE
Public Key Infrastructure (PKI)
31. Used in a SELECT clause in place of a column
Outer SELECT query
Opening tag
Relational
Aggregate Functions
32. Create program files that include SQ after each command
DISTINCT
Database Administrator (DBA)
GROUP BY
Embedded SQL
33. Finds the lowest constant value in a column
End Users
MAX
SELECT
Hierarchial
34. Data in database interacts & corresponds with other data
End Users
Database Administrator (DBA)
Central Control of data
Integrated
35. Attribute in quotes
Indexes
ALL
Property
Application Programmers
36. Browser requests page - code is delivered - executed and done with
hidden fields
Dynamic
HAVING
Scripting
37. One huge database to hold all data; Access to data - and use of system to add - update & print records
Database Management Systems (DBMS)
Outer SELECT query
Application Programmers
FROM
38. Averages the numeric values
Database Administrator (DBA)
Negation Operator
Fields
AVG
39. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
Candidate Keys
Hypertext Markup Language (HTML)
Subqueries
SELECT
40. Supplies value for the search condition of the SELECT statement containing it
Inner SELECT query
Report
Query
ALL
41. SQL finds and retrieves date
Data Administrator (DAd)
Indexes
Outer SELECT query
Dynamic
42. Basic Component of SQL
ASC
Tables
INSERT INTO
Database Management Systems (DBMS)
43. Table displayed in ascending order
WHERE
ASC
BETWEEN
Opening tag
44. Give the browser more specific information about that tag
Data
Persistent
Interactive SQL
Attributes
45. Essentially a collection of services that communicate with eachother
Service-Oriented Architecture (SOA)
DISTINCT
single value
to update
46. Ensures data is correct casings
UPDATE
American Standard Code for Information Interchange (ASCII)
Foreign Keys
Element Content
47. Grant acces and control to only specific information
Web Applications
Service Provider
Views
Hierarchial
48. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
to update
Query
ALL
Tables
49. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
Attributes
Application Programmers
Integrated
Central Control of data
50. Meaningful info related to database
End Users
SUM
Indexes
Data