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. Begins an element
Relational
Calculated Column
Opening tag
Precedence of Logical Operators
2. Uses relationships between independent entities
Data Administrator (DAd)
Relational
Outer SELECT query
Equals Operator
3. Specifies the tables or views from which rows and columns are retrieved
Word
American Standard Code for Information Interchange (ASCII)
FROM
Data Elements
4. Join a table to a copy of itself
single value
Indexes
DELETE
Self Join
5. Give the browser more specific information about that tag
Functions
Attributes
Data
COUNT
6. Has the highest precedence - followed by the AND - OR
Application Programmers
NOT
Relational
Bind
7. Begins an element
Forward Slash
Tables
Opening tag
Attributes
8. Table displayed in descending order
Data Dictionary
ESC
LIKE
UPDATE
9. Cookies are more secure than______ - allowing travel on a website without loss of info
hidden fields
Cookie
Central control of data
MIN
10. Everything between the start and end tag
Web Applications
Element Content
Closing tag
Persistent
11. Tally of how many rows meet criteria specified
Service Provider
Database Administrator (DBA)
COUNT
Equals Operator
12. Software system designed to support interoperable machine - to - machine interaction over a network
Hardware
Web Service
Information
COUNT
13. Ongoing record of data reflecting the info defining the database
Calculated Column
Element Content
Data Dictionary
Object-Oriented Relational (OOR)
14. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance
Flat File
Object-Oriented Relational (OOR)
Comparison Operators
Functions
15. Software system designed to support interface for a software asset that manages a specific set of tasks
Structured Query Language (SQL)
Central control of data
Interactive SQL
Service Provider
16. Has the highest precedence - followed by the AND - OR
Fields
Precedence of Logical Operators
Outer SELECT query
NOT
17. Three Basic Operations of SP - SR - SB: Publish - Find - ____
Persistent
UPDATE
Relational
Bind
18. Data remains unchanged in database
Shared
MIN
Persistent
GROUP BY
19. Finds the lowest ACII value in column
Data Dictionary
*
MIN
SUM
20. Practice of writing code into a webpage that is not directly visible to the user
Self Join
Fields
Relational
Scripting
21. Supplies value for the search condition of the SELECT statement containing it
Inner SELECT query
Data Recovery & Concurrance
GROUP BY
AVG
22. SELECT statment containing the nested query
Structured Query Language (SQL)
Outer SELECT query
single value
Stateless
23. Finds the lowest constant value in a column
MAX
Inner SELECT query
Web server
BETWEEN
24. Basic Component of SQL
American Standard Code for Information Interchange (ASCII)
Outer SELECT query
Performance
Tables
25. One of the tools that SQL uses to find and retrieve data.
FROM
Empty Elements
Indexes
MAX
26. Table displayed in ascending order
Subquery
Persistent
Equals Operator
ASC
27. Executes commands one at a time - results being displayed immediately
single value
Aliases
UPDATE
Interactive SQL
28. Looks like opening tag - but with a forward slash
NOT
Database
Scripting
Closing tag
29. Tally of how many rows meet criteria specified
COUNT
Element Content
Query
ESC
30. 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.
Candidate Keys
Central Control of data
Session
AVG
31. Everything between the start and end tag
Indexes
Element Content
BETWEEN
Users
32. Combines rows from a SELECT statements result table into a group
Data Dictionary
GROUP BY
Cookie
Tags
33. Columns containing numbers only
DISTINCT
Inner SELECT query
INSERT INTO
SUM
34. Table displayed in ascending order
Aliases
ASC
Embedded SQL
Flat File
35. Selects from specific values in list
Inner SELECT query
Scripting
IN
Joins
36. Used in a SELECT clause in place of a column
Outer SELECT query
Attributes
Aggregate Functions
Performance
37. Command used to show the attributes that define a table.
American Standard Code for Information Interchange (ASCII)
Database
sp_help
hidden fields
38. Uses two values as limits - selecting any values between the two of them
WHERE
BETWEEN
Inner SELECT query
Service-Oriented Architecture (SOA)
39. Table displayed in descending order
Web Browser
ESC
Interactive SQL
Persistent
40. Supplies value for the search condition of the SELECT statement containing it
*
Web server
Inner SELECT query
accident
41. Describe information in a tree styled format
AVG
SUM
Web server
Hierarchial
42. Concatenated in SQL Server Database software using the addition symbol
HAVING
Fields
Structured Query Language (SQL)
Element Content
43. Limits the output of the established groups into the derived result table
Precedence of Logical Operators
to update
HAVING
Flat File
44. Meaningful info related to database
Data
DISTINCT
Application Programmers
Object-Oriented Relational (OOR)
45. Concatenated in SQL Server Database software using the addition symbol
Joins
Fields
GROUP BY
Closing tag
46. Definition of commands it can do
Outer SELECT query
Persistent
Relational
Data Definition
47. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance
Functions
Scripting
Comparison Operators
BETWEEN
48. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
Word
hidden fields
Structured Query Language (SQL)
Subqueries
49. Grant acces and control to only specific information
Views
Data Elements
Database Administrator (DBA)
Aggregate Functions
50. Compares value of the column in the specified condition with the value specified
Closing tag
Information
Equals Operator
Embedded SQL