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. Deletes selected rows
DELETE
End Users
Aggregate Functions
SELECT
2. Data stored by DAd
Embedded SQL
ALL
Comparison Operators
Data Elements
3. Everything in enviroment becomes an object - expands on Priniples of relational databases
Object-Oriented Relational (OOR)
Bind
Interactive SQL
Hardware
4. Change order of rows in result table
GROUP BY
ORDER BY
DELETE
Property
5. Definition of commands it can do
Cookie
Data Definition
HAVING
Persistent
6. Writes programs that use or allow acces to databse with specific purpose
NOT
ASC
Web Browser
Application Programers
7. Interact and manipulates the data in the database
Integrated
WHERE
Calculated Column
Data Manipulation
8. Averages the numeric values
single value
Embedded SQL
Inner SELECT query
AVG
9. Data in database interacts & corresponds with other data
Foreign Keys
Shared
Service-Oriented Architecture (SOA)
Integrated
10. Used to remove duplicates from result table
DISTINCT
End Users
BETWEEN
FROM
11. Responsible for technical implementation & maintenance of database on a design & physical level
Dynamic
Database Administrator (DBA)
Shared
Tables
12. Large structured set of persistent data
Outer SELECT query
Comparison Operators
Database
Session
13. Copies multiple records at the same time using a SELECT statement
Functions
Data
INSERT INTO
ALL
14. Responsible for technical implementation & maintenance of database on a design & physical level
Embedded SQL
Central Control of data
Database Administrator (DBA)
Persistent
15. Grant acces and control to only specific information
DELETE
Web Browser
Views
Structured Query Language (SQL)
16. Selects from specific values in list
Data
IN
Users
Relational
17. Three Basic Operations of SP - SR - SB: Publish - Find - ____
Bind
Service Provider
Negation Operator
Shared
18. Data that has been processed into a format that is understandable by its audience
MAX
Application Programers
Data Elements
Information
19. Supplies value for the search condition of the SELECT statement containing it
Empty Elements
Inner SELECT query
Cookie
Hierarchial
20. Table displayed in descending order
WHERE
ORDER BY
ESC
Closing tag
21. = - < - > - <= - >= - <> - !
Flat File
Outer SELECT query
Comparison Operators
Integrated
22. File stored on a user's machine that contains infor about application
ASC
ORDER BY
ESC
Cookie
23. Command based way to ask the database a question
Query
to update
Application Programmers
Tags
24. Concatenated in SQL Server Database software using the addition symbol
UPDATE
WHERE
Stateless
Fields
25. Network node that discovers and invokes other software services to provide a buisness solution
COUNT
Central Control of data
Service Requestor
IN
26. Data in database has ability to be accessed and manipulated by several users
Shared
Property
Persistent
COUNT
27. Cookies are more secure than______ - allowing travel on a website without loss of info
Central Control of data
Indexes
hidden fields
Equals Operator
28. 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.
Hypertext Markup Language (HTML)
Primary Keys
End Users
Interactive SQL
29. Describe information in a tree styled format
IN
SUM
Hierarchial
Persistent
30. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
single value
Service Provider
Cookie
INSERT INTO
31. Limits the rows that appear in the result mathcing a specified condition
American Standard Code for Information Interchange (ASCII)
Relational
SELECT
WHERE
32. Allow useres to retrieve data and interact with content located on web pages within website
Hierarchial
ESC
Web Browser
Data
33. Ensures data is correct casings
American Standard Code for Information Interchange (ASCII)
Attributes
Subqueries
Fields
34. Attribute in quotes
Database Management Systems (DBMS)
Data Administrator (DAd)
Property
BETWEEN
35. Join a table to a copy of itself
Self Join
Dynamic
Inner SELECT query
Functions
36. Everything between the start and end tag
Element Content
American Standard Code for Information Interchange (ASCII)
End Users
Service-Oriented Architecture (SOA)
37. Table displayed in descending order
ESC
DISTINCT
Data Definition
Property
38. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
Persistent
Relational
Web server
Indexes
39. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
Closing tag
accident
Hypertext Markup Language (HTML)
Data Manipulation
40. Ensures functions are done efficiently
Performance
Word
Central Control of data
Flat File
41. Identifies columns to appear in the result
Forward Slash
Persistent
SELECT
Data Manipulation
42. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
LIKE
Web server
Tables
Service Broker
43. SQL Commands - Two Things Specify data interested in - Indicate the ________
Hypertext Markup Language (HTML)
accident
Information
Word
44. Table displayed in ascending order
ASC
Hardware
Aliases
American Standard Code for Information Interchange (ASCII)
45. Changes the values in one or more selected rows of a table
Flat File
UPDATE
Attributes
Shared
46. SQL Commands: Define tables - views - _____ - delete or insert info
Opening tag
Outer SELECT query
to update
End Users
47. Used to combine one query with another.
Negation Operator
Subquery
Information
Embedded SQL
48. Begins an element
Web Service
Aliases
Empty Elements
Opening tag
49. Has the highest precedence - followed by the AND - OR
NOT
Scripting
Empty Elements
Hierarchial
50. Data that has been processed into a format that is understandable by its audience
Central control of data
Information
AVG
Web Browser