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. Finds the lowest ACII value in column
MIN
SUM
Element Content
Web Applications
2. Closed in the start tag by adding a slash to the start tag
Indexes
Object-Oriented Relational (OOR)
Application Programers
Empty Elements
3. SQL Commands - Two Things Specify data interested in - Indicate the ________
accident
Functions
ESC
Report
4. Table displayed in descending order
Data Administrator (DAd)
ESC
Indexes
Inner SELECT query
5. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
Self Join
Aliases
Subqueries
Service Requestor
6. The Web is ___________
Data Manipulation
hidden fields
*
Stateless
7. Uses two values as limits - selecting any values between the two of them
accident
Flat File
Report
BETWEEN
8. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
Hierarchial
Application Programmers
Database
Shared
9. 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
DELETE
Outer SELECT query
Data Dictionary
10. Large structured set of persistent data
FROM
DELETE
Database
Attributes
11. Defines a new column
Tables
HAVING
Calculated Column
NOT
12. File stored on a user's machine that contains infor about application
Cookie
Object-Oriented Relational (OOR)
Indexes
Relational
13. Tally of how many rows meet criteria specified
Views
Forward Slash
COUNT
Query
14. Software system designed to support interface for a software asset that manages a specific set of tasks
Application Programmers
Service Provider
Dynamic
Data Dictionary
15. Ensures data is correct casings
Application Programmers
American Standard Code for Information Interchange (ASCII)
Integrated
Central Control of data
16. Allows use of single or multiple character wildcards with the underscore or percent symbol
Structured Query Language (SQL)
UPDATE
LIKE
Web server
17. Changes the values in one or more selected rows of a table
Cookie
Persistent
UPDATE
DISTINCT
18. Grant acces and control to only specific information
Users
ORDER BY
Views
Data Manipulation
19. One huge database to hold all data; Access to data - and use of system to add - update & print records
FROM
Opening tag
Database Management Systems (DBMS)
Web Service
20. Data that has been processed into a format that is understandable by its audience
Precedence of Logical Operators
Information
Flat File
Structured Query Language (SQL)
21. Meaningful info related to database
SUM
Closing tag
Data
Service Provider
22. Used to combine one query to another
Attributes
Subqueries
SELECT
HAVING
23. Straight implementation of raw data formatted into rows and columns
WHERE
Shared
Self Join
Flat File
24. Individuals that use - manipulate or maintain aspects of database
Users
Tags
Persistent
SUM
25. Basic Component of SQL
AVG
SUM
Tables
Service Broker
26. Characterizes operation of a relational database
DELETE
Joins
Indexes
Opening tag
27. Uses two values as limits - selecting any values between the two of them
BETWEEN
ESC
Scripting
Performance
28. Table displayed in ascending order
ASC
Data
DELETE
Relational
29. Practice of writing code into a webpage that is not directly visible to the user
Property
sp_help
Calculated Column
Scripting
30. = - < - > - <= - >= - <> - !
Service Provider
Comparison Operators
Aliases
FROM
31. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
COUNT
Service Provider
Structured Query Language (SQL)
DELETE
32. Executes commands one at a time - results being displayed immediately
Indexes
Flat File
Aliases
Interactive SQL
33. All Columns indicated and selected
*
Functions
Views
Subquery
34. Responsible for technical implementation & maintenance of database on a design & physical level
Database Administrator (DBA)
Embedded SQL
Indexes
ALL
35. Data stored by DAd
Data Elements
Element Content
Dynamic
Service Broker
36. Combines rows from a SELECT statements result table into a group
GROUP BY
Database Administrator (DBA)
End Users
Application Programers
37. Used to combine one query to another
Subqueries
Application Programers
Web Browser
Session
38. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
Structured Query Language (SQL)
Equals Operator
BETWEEN
Scripting
39. Used to remove duplicates from result table
Hardware
DISTINCT
American Standard Code for Information Interchange (ASCII)
Database Management Systems (DBMS)
40. Copies multiple records at the same time using a SELECT statement
Data Administrator (DAd)
IN
Users
INSERT INTO
41. Selects from specific values in list
Session
IN
Indexes
LIKE
42. Some form of output - usually - printed - containing information
Hardware
ESC
Fields
Report
43. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
Database Administrator (DBA)
DISTINCT
ESC
Hypertext Markup Language (HTML)
44. Averages the numeric values
Scripting
Data Recovery & Concurrance
AVG
Indexes
45. Browser requests page - code is delivered - executed and done with
WHERE
Dynamic
IN
Persistent
46. Allows data recovery in case of corruption or loss
Hierarchial
Views
GROUP BY
Data Recovery & Concurrance
47. Compares value of the column in the specified condition with the value specified
MIN
Word
SUM
Equals Operator
48. SQL finds and retrieves date
IN
Indexes
Data
Negation Operator
49. Everything in enviroment becomes an object - expands on Priniples of relational databases
DELETE
Object-Oriented Relational (OOR)
Hierarchial
Aliases
50. Interact and manipulates the data in the database
Data Manipulation
Interactive SQL
Information
Forward Slash