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. Has the highest precedence - followed by the AND - OR
AVG
NOT
Self Join
Service Requestor
2. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
ALL
Information
*
AVG
3. Command based way to ask the database a question
Flat File
Query
FROM
single value
4. Compares value of the column in the specified condition with the value specified
Equals Operator
Service-Oriented Architecture (SOA)
Tags
ASC
5. Defines a new column
Users
Calculated Column
*
Views
6. Looks like opening tag - but with a forward slash
ORDER BY
IN
Data
Closing tag
7. Writes programs that use or allow acces to databse with specific purpose
Application Programers
Comparison Operators
Scripting
Fields
8. Table displayed in ascending order
DISTINCT
ASC
Query
GROUP BY
9. Cookies are more secure than______ - allowing travel on a website without loss of info
UPDATE
hidden fields
Primary Keys
Inner SELECT query
10. Ensures data is correct casings
Data Recovery & Concurrance
American Standard Code for Information Interchange (ASCII)
Performance
Empty Elements
11. Concatenated in SQL Server Database software using the addition symbol
Scripting
Fields
Cookie
Tables
12. One of the tools that SQL uses to find and retrieve data.
Property
Indexes
ASC
Shared
13. Uses relationships between independent entities
Self Join
Data Administrator (DAd)
Relational
ORDER BY
14. Everything between the start and end tag
AVG
Element Content
Central Control of data
Data Administrator (DAd)
15. Essentially a collection of services that communicate with eachother
Data Dictionary
Element Content
Service Requestor
Service-Oriented Architecture (SOA)
16. Finds the lowest constant value in a column
MAX
Tags
Word
Equals Operator
17. One huge database to hold all data; Access to data - and use of system to add - update & print records
Equals Operator
Database Management Systems (DBMS)
Database Administrator (DBA)
ALL
18. SELECT statment containing the nested query
DELETE
Outer SELECT query
Web server
Tables
19. Limits the rows that appear in the result mathcing a specified condition
WHERE
Property
Precedence of Logical Operators
Candidate Keys
20. 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
to update
Dynamic
WHERE
21. Data in database has ability to be accessed and manipulated by several users
HAVING
Shared
single value
Data Elements
22. Uses two values as limits - selecting any values between the two of them
Attributes
BETWEEN
Fields
Hardware
23. Ongoing record of data reflecting the info defining the database
Data Elements
Word
Data Dictionary
Database Management Systems (DBMS)
24. Writes programs that use or allow acces to databse with specific purpose
Element Content
Aliases
Application Programers
Precedence of Logical Operators
25. Ongoing record of data reflecting the info defining the database
Data Dictionary
Aliases
Aggregate Functions
Hypertext Markup Language (HTML)
26. Describe information in a tree styled format
Word
Outer SELECT query
Hierarchial
Fields
27. Describe information in a tree styled format
Data Elements
Hierarchial
ORDER BY
HAVING
28. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
Integrated
DISTINCT
Word
Service Broker
29. Compares value of the column in the specified condition with the value specified
Equals Operator
GROUP BY
COUNT
Data Definition
30. Attribute in quotes
Database
sp_help
Property
Application Programmers
31. Finds the lowest constant value in a column
Word
Data Definition
MAX
BETWEEN
32. SELECT statment containing the nested query
Service-Oriented Architecture (SOA)
UPDATE
Outer SELECT query
Shared
33. Three Basic Operations of SP - SR - SB: Publish - Find - ____
Closing tag
Database
Bind
NOT
34. Used in a SELECT clause in place of a column
Aggregate Functions
Hypertext Markup Language (HTML)
Empty Elements
FROM
35. Software system designed to support interface for a software asset that manages a specific set of tasks
Database Management Systems (DBMS)
Interactive SQL
Service Provider
BETWEEN
36. Text markups that form an element" sort of a "box" to hold things like text and other elements
Hardware
Tags
HAVING
Query
37. Decides what data is stored in the databse and the manner it is stored
Data Administrator (DAd)
AVG
Service-Oriented Architecture (SOA)
Hierarchial
38. Data stored by DAd
Data Elements
Indexes
Equals Operator
Database Management Systems (DBMS)
39. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
DISTINCT
single value
Hardware
Service Requestor
40. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
Element Content
Application Programmers
Hardware
DISTINCT
41. Used to remove duplicates from result table
MIN
Hierarchial
SUM
DISTINCT
42. Columns containing numbers only
SUM
AVG
Users
INSERT INTO
43. Everything between the start and end tag
Hardware
Application Programmers
Element Content
DELETE
44. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
Object-Oriented Relational (OOR)
Hypertext Markup Language (HTML)
Service-Oriented Architecture (SOA)
Data Administrator (DAd)
45. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
Aliases
DELETE
Word
SUM
46. Join a table to a copy of itself
Self Join
Foreign Keys
Integrated
End Users
47. Ensures functions are done efficiently
Shared
Session
Relational
Performance
48. Interact and manipulates the data in the database
Hierarchial
Functions
Data Manipulation
Application Programers
49. SQL finds and retrieves date
Indexes
UPDATE
Web server
Views
50. Browser requests page - code is delivered - executed and done with
FROM
Dynamic
Scripting
hidden fields