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. Looks like opening tag - but with a forward slash
ASC
MAX
Web server
Closing tag
2. Text markups that form an element" sort of a "box" to hold things like text and other elements
IN
MIN
SUM
Tags
3. SQL Commands: Define tables - views - _____ - delete or insert info
to update
Dynamic
Performance
Query
4. Software system designed to support interface for a software asset that manages a specific set of tasks
Session
Web Service
Primary Keys
Service Provider
5. Has the highest precedence - followed by the AND - OR
Comparison Operators
NOT
to update
IN
6. Network node that discovers and invokes other software services to provide a buisness solution
Precedence of Logical Operators
ALL
Service Requestor
FROM
7. Ensures data is correct casings
IN
Service Provider
Service Provider
American Standard Code for Information Interchange (ASCII)
8. Used to remove duplicates from result table
Public Key Infrastructure (PKI)
DISTINCT
Integrated
Relational
9. Browser requests page - code is delivered - executed and done with
Dynamic
LIKE
Web Service
Self Join
10. Attribute in quotes
Joins
single value
Property
Shared
11. Data remains unchanged in database
Persistent
Public Key Infrastructure (PKI)
hidden fields
ESC
12. Used in a SELECT clause in place of a column
Web Applications
Central Control of data
Outer SELECT query
Aggregate Functions
13. Straight implementation of raw data formatted into rows and columns
Flat File
Database
Web server
ESC
14. Uses two values as limits - selecting any values between the two of them
Shared
ALL
Embedded SQL
BETWEEN
15. Writes programs that use or allow acces to databse with specific purpose
Service Provider
Application Programers
Service-Oriented Architecture (SOA)
Closing tag
16. Cookies are more secure than______ - allowing travel on a website without loss of info
ASC
Scripting
hidden fields
Equals Operator
17. 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
Query
Session
Report
Public Key Infrastructure (PKI)
18. Essentially a collection of services that communicate with eachother
Application Programers
Service-Oriented Architecture (SOA)
Functions
Comparison Operators
19. Data in database has ability to be accessed and manipulated by several users
Cookie
Database
Service Requestor
Shared
20. Executes commands one at a time - results being displayed immediately
Central Control of data
hidden fields
Cookie
Interactive SQL
21. Practice of writing code into a webpage that is not directly visible to the user
Data Elements
Scripting
SELECT
Application Programmers
22. Computer equipment -Fixed Storage Media - Removeable Storage Media - System Memory - and the Processor
hidden fields
Hardware
accident
ALL
23. Uses relationships between independent entities
Attributes
Comparison Operators
SUM
Relational
24. Data that has been processed into a format that is understandable by its audience
Element Content
Information
to update
FROM
25. SQL Commands - Two Things Specify data interested in - Indicate the ________
accident
AVG
MAX
LIKE
26. Ensures data is correct casings
Aggregate Functions
American Standard Code for Information Interchange (ASCII)
HAVING
Report
27. Columns containing numbers only
Database
Performance
MAX
SUM
28. Text markups that form an element" sort of a "box" to hold things like text and other elements
Tags
Data
ESC
Functions
29. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________
Self Join
SUM
Central Control of data
Web Applications
30. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
Opening tag
Aliases
ORDER BY
FROM
31. Meaningful info related to database
Attributes
Calculated Column
Persistent
Data
32. Averages the numeric values
AVG
MIN
Interactive SQL
Equals Operator
33. Three Basic Operations of SP - SR - SB: Publish - Find - ____
Embedded SQL
Data Recovery & Concurrance
Bind
Web Browser
34. Identifies columns to appear in the result
SELECT
Subquery
Aliases
Bind
35. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance
Cookie
Property
Service Broker
Functions
36. Copies multiple records at the same time using a SELECT statement
BETWEEN
INSERT INTO
Hierarchial
Scripting
37. Finds the lowest constant value in a column
MAX
MIN
ASC
MIN
38. Flat File Examples: Excel Spreadsheets - _____
Service Provider
Word
Aggregate Functions
Web Service
39. Grant acces and control to only specific information
Data Elements
Relational
Flat File
Views
40. Deletes selected rows
DELETE
SELECT
Calculated Column
*
41. Closed in the start tag by adding a slash to the start tag
Information
accident
Candidate Keys
Empty Elements
42. Table displayed in ascending order
ASC
NOT
Data Dictionary
Central Control of data
43. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
Element Content
SELECT
Hypertext Markup Language (HTML)
ORDER BY
44. File stored on a user's machine that contains infor about application
Embedded SQL
Application Programers
Web Browser
Cookie
45. Ensures functions are done efficiently
Performance
HAVING
Data Definition
Property
46. Fields in a relational table that match the primary key from one column to the primary key of another table.
Foreign Keys
Tags
Hardware
HAVING
47. Writes programs that use or allow acces to databse with specific purpose
Database Administrator (DBA)
Application Programers
Information
Application Programmers
48. Basic Component of SQL
Foreign Keys
Scripting
Indexes
Tables
49. Changes the values in one or more selected rows of a table
Element Content
Attributes
UPDATE
Service Provider
50. Limits the rows that appear in the result mathcing a specified condition
Self Join
Service Requestor
WHERE
accident