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. Cookies are more secure than______ - allowing travel on a website without loss of info
hidden fields
Tables
Hypertext Markup Language (HTML)
*
2. Limits the output of the established groups into the derived result table
HAVING
Aggregate Functions
Tags
UPDATE
3. Data remains unchanged in database
Calculated Column
Empty Elements
Persistent
COUNT
4. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
American Standard Code for Information Interchange (ASCII)
Application Programmers
AVG
Data Elements
5. Ensures functions are done efficiently
Data Definition
Data
Performance
Application Programers
6. Changes the values in one or more selected rows of a table
Tables
Hardware
Data Recovery & Concurrance
UPDATE
7. Closed in the start tag by adding a slash to the start tag
Subqueries
*
Empty Elements
Calculated Column
8. Create program files that include SQ after each command
hidden fields
End Users
Structured Query Language (SQL)
Embedded SQL
9. Text markups that form an element" sort of a "box" to hold things like text and other elements
Central Control of data
Tags
Data Definition
DELETE
10. Responsible for technical implementation & maintenance of database on a design & physical level
Service Broker
SUM
Database Administrator (DBA)
Comparison Operators
11. Concatenated in SQL Server Database software using the addition symbol
Comparison Operators
ORDER BY
Fields
HAVING
12. Everything in enviroment becomes an object - expands on Priniples of relational databases
Joins
MIN
Object-Oriented Relational (OOR)
Negation Operator
13. Finds the lowest ACII value in column
Interactive SQL
Functions
MIN
hidden fields
14. SELECT statment containing the nested query
Views
Outer SELECT query
Attributes
Data Elements
15. File stored on a user's machine that contains infor about application
Fields
Cookie
DISTINCT
Primary Keys
16. Executes commands one at a time - results being displayed immediately
Dynamic
Interactive SQL
UPDATE
Primary Keys
17. Used with another comparison operator - values become inverted
IN
Tables
Opening tag
Negation Operator
18. Responsible for technical implementation & maintenance of database on a design & physical level
MIN
Shared
accident
Database Administrator (DBA)
19. SQL Commands: Define tables - views - _____ - delete or insert info
ESC
to update
SELECT
Equals Operator
20. Definition of commands it can do
hidden fields
Data Definition
Aggregate Functions
Report
21. Join a table to a copy of itself
Self Join
Equals Operator
Aliases
Session
22. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance
Self Join
Functions
Database Management Systems (DBMS)
Tags
23. Most valuable asset of a database system.
Fields
Application Programmers
Central control of data
SUM
24. Limits the output of the established groups into the derived result table
HAVING
ALL
Web Applications
Scripting
25. Averages the numeric values
Calculated Column
AVG
Property
Web server
26. Large structured set of persistent data
MIN
Database
Service Requestor
Tables
27. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
Service Broker
Self Join
Web server
Scripting
28. Software system designed to support interface for a software asset that manages a specific set of tasks
GROUP BY
ESC
Service Provider
Calculated Column
29. Interact and manipulates the data in the database
Data Manipulation
Application Programmers
ORDER BY
HAVING
30. Network node that discovers and invokes other software services to provide a buisness solution
Web server
Service Requestor
Query
Subqueries
31. Data in database interacts & corresponds with other data
Structured Query Language (SQL)
Integrated
Joins
Central Control of data
32. Copies multiple records at the same time using a SELECT statement
ALL
INSERT INTO
Closing tag
FROM
33. Meaningful info related to database
Data
Structured Query Language (SQL)
DELETE
SELECT
34. Three Basic Operations of SP - SR - SB: Publish - Find - ____
Bind
hidden fields
SUM
Integrated
35. Using product as intended for its audience
Attributes
End Users
Application Programers
COUNT
36. Computer equipment -Fixed Storage Media - Removeable Storage Media - System Memory - and the Processor
Hardware
Joins
to update
Tables
37. Uses relationships between independent entities
Relational
Empty Elements
Structured Query Language (SQL)
Web Browser
38. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
ALL
Word
DELETE
Aliases
39. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
Data Elements
Application Programers
Service Broker
Central Control of data
40. Closed in the start tag by adding a slash to the start tag
Empty Elements
SUM
Embedded SQL
ASC
41. Cookies are more secure than______ - allowing travel on a website without loss of info
Structured Query Language (SQL)
SUM
INSERT INTO
hidden fields
42. 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
IN
Self Join
IN
Public Key Infrastructure (PKI)
43. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
Data
Database
Hypertext Markup Language (HTML)
ALL
44. Practice of writing code into a webpage that is not directly visible to the user
Scripting
Flat File
End Users
Subquery
45. Begins an element
Opening tag
Database Administrator (DBA)
Public Key Infrastructure (PKI)
Self Join
46. Straight implementation of raw data formatted into rows and columns
Flat File
Hierarchial
Tags
Word
47. Join a table to a copy of itself
IN
Self Join
Closing tag
Empty Elements
48. Allow useres to retrieve data and interact with content located on web pages within website
*
Web Browser
Scripting
Inner SELECT query
49. SELECT statment containing the nested query
Indexes
Data
Data Definition
Outer SELECT query
50. Some form of output - usually - printed - containing information
Fields
Query
HAVING
Report