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. Limits the output of the established groups into the derived result table
Tables
GROUP BY
Scripting
HAVING
2. Software system designed to support interface for a software asset that manages a specific set of tasks
Service Provider
Negation Operator
SELECT
Users
3. Specifies the tables or views from which rows and columns are retrieved
ESC
Information
Word
FROM
4. Limits the output of the established groups into the derived result table
Query
Candidate Keys
LIKE
HAVING
5. Combines rows from a SELECT statements result table into a group
GROUP BY
Foreign Keys
SELECT
Outer SELECT query
6. Defines a new column
Calculated Column
Web Applications
Inner SELECT query
Dynamic
7. Characterizes operation of a relational database
Empty Elements
Joins
Service Provider
accident
8. Computer programs allowing website visitors to submit and retrieve data to/from a database over the Internet using their preferred web browser
Performance
FROM
ORDER BY
Web Applications
9. Averages the numeric values
AVG
Performance
Persistent
DELETE
10. The Web is ___________
Calculated Column
Performance
Data Manipulation
Stateless
11. Change order of rows in result table
Tables
ORDER BY
Database Administrator (DBA)
Views
12. Deletes selected rows
American Standard Code for Information Interchange (ASCII)
DELETE
Calculated Column
Data Definition
13. Describe information in a tree styled format
End Users
Hierarchial
BETWEEN
SELECT
14. Flat File Examples: Excel Spreadsheets - _____
Word
Public Key Infrastructure (PKI)
DELETE
*
15. Join a table to a copy of itself
SUM
Indexes
Web server
Self Join
16. Basic Component of SQL
Object-Oriented Relational (OOR)
Tables
Shared
SELECT
17. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
SUM
Indexes
Closing tag
single value
18. Limits the rows that appear in the result mathcing a specified condition
Empty Elements
WHERE
Candidate Keys
Embedded SQL
19. Browser requests page - code is delivered - executed and done with
American Standard Code for Information Interchange (ASCII)
LIKE
Dynamic
Opening tag
20. Tally of how many rows meet criteria specified
COUNT
Web Service
ALL
Opening tag
21. Three Basic Operations of SP - SR - SB: Publish - Find - ____
DELETE
End Users
Bind
Flat File
22. Grant acces and control to only specific information
Persistent
Joins
LIKE
Views
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.
Primary Keys
ASC
Subqueries
Attributes
24. Finds the lowest constant value in a column
Report
Aliases
MAX
Tags
25. Writes programs that use or allow acces to databse with specific purpose
Functions
ORDER BY
Application Programers
ASC
26. Used to combine one query to another
SUM
Subqueries
INSERT INTO
LIKE
27. Used to close a tag properly
MAX
Hierarchial
Database
Forward Slash
28. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance
Bind
Closing tag
Session
Functions
29. Everything in enviroment becomes an object - expands on Priniples of relational databases
Property
Object-Oriented Relational (OOR)
INSERT INTO
Application Programers
30. Some form of output - usually - printed - containing information
Report
Outer SELECT query
SUM
Word
31. Used in a SELECT clause in place of a column
Self Join
Self Join
Aggregate Functions
Comparison Operators
32. Computer equipment -Fixed Storage Media - Removeable Storage Media - System Memory - and the Processor
Data Recovery & Concurrance
Application Programmers
Data Elements
Hardware
33. Considered the time that a user first accesses a page until a set of amount time - on the server - after their last activity or until the session is explicitly closed
Session
SUM
Web Service
NOT
34. Used with another comparison operator - values become inverted
SELECT
Negation Operator
DELETE
Central Control of data
35. Allows use of single or multiple character wildcards with the underscore or percent symbol
UPDATE
WHERE
Negation Operator
LIKE
36. Deletes selected rows
Embedded SQL
DELETE
Subqueries
FROM
37. Ensures data is correct casings
American Standard Code for Information Interchange (ASCII)
*
Views
NOT
38. Everything in enviroment becomes an object - expands on Priniples of relational databases
Web Browser
Forward Slash
Object-Oriented Relational (OOR)
Interactive SQL
39. Decides what data is stored in the databse and the manner it is stored
*
Inner SELECT query
Data Dictionary
Data Administrator (DAd)
40. Change order of rows in result table
ORDER BY
single value
Empty Elements
Web Browser
41. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
Data Recovery & Concurrance
American Standard Code for Information Interchange (ASCII)
Shared
ALL
42. Data stored by DAd
SUM
Application Programmers
Dynamic
Data Elements
43. Ensures data is correct casings
American Standard Code for Information Interchange (ASCII)
Hardware
Hypertext Markup Language (HTML)
Flat File
44. Selects from specific values in list
BETWEEN
Attributes
Hierarchial
IN
45. Characterizes operation of a relational database
Users
Joins
Bind
Self Join
46. 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
ESC
Attributes
Element Content
Public Key Infrastructure (PKI)
47. Considered the time that a user first accesses a page until a set of amount time - on the server - after their last activity or until the session is explicitly closed
Views
Aliases
Session
Indexes
48. = - < - > - <= - >= - <> - !
DELETE
Opening tag
Comparison Operators
SUM
49. Large structured set of persistent data
Central Control of data
Database
Dynamic
Embedded SQL
50. Used to remove duplicates from result table
Subqueries
Element Content
DISTINCT
Hierarchial