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. Selects from specific values in list
MIN
Negation Operator
AVG
IN
2. Data in database has ability to be accessed and manipulated by several users
Joins
SELECT
Shared
Word
3. Cookies are more secure than______ - allowing travel on a website without loss of info
accident
hidden fields
Users
ASC
4. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
ASC
Tags
Persistent
Application Programmers
5. Essentially a collection of services that communicate with eachother
Service-Oriented Architecture (SOA)
Report
LIKE
Database
6. Basic Component of SQL
to update
Tables
Inner SELECT query
Precedence of Logical Operators
7. Selects from specific values in list
Relational
IN
Application Programers
Views
8. = - < - > - <= - >= - <> - !
Hardware
Comparison Operators
Indexes
Tables
9. Allows data recovery in case of corruption or loss
MIN
INSERT INTO
Tags
Data Recovery & Concurrance
10. Used in a SELECT clause in place of a column
Word
Aggregate Functions
Inner SELECT query
hidden fields
11. Has the highest precedence - followed by the AND - OR
Subqueries
Views
Closing tag
NOT
12. Used to remove duplicates from result table
Performance
DISTINCT
Data Elements
ALL
13. Used to combine one query to another
Subqueries
Indexes
SUM
single value
14. Decides what data is stored in the databse and the manner it is stored
UPDATE
Data Administrator (DAd)
Web server
Comparison Operators
15. Uses relationships between independent entities
DELETE
GROUP BY
Empty Elements
Relational
16. Executes commands one at a time - results being displayed immediately
Interactive SQL
Data Manipulation
Negation Operator
Functions
17. Copies multiple records at the same time using a SELECT statement
Database
Hypertext Markup Language (HTML)
INSERT INTO
Attributes
18. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
Bind
Service Broker
Data Dictionary
Hypertext Markup Language (HTML)
19. Computer equipment -Fixed Storage Media - Removeable Storage Media - System Memory - and the Processor
Integrated
Users
INSERT INTO
Hardware
20. Specifies the tables or views from which rows and columns are retrieved
MAX
FROM
Subquery
Users
21. Join a table to a copy of itself
Forward Slash
Application Programers
Self Join
Tags
22. Looks like opening tag - but with a forward slash
Joins
Closing tag
Information
Tags
23. Browser requests page - code is delivered - executed and done with
Dynamic
Joins
SELECT
to update
24. Practice of writing code into a webpage that is not directly visible to the user
MIN
Equals Operator
WHERE
Scripting
25. Responsible for technical implementation & maintenance of database on a design & physical level
LIKE
Users
Database Administrator (DBA)
Self Join
26. Finds the lowest ACII value in column
FROM
SELECT
MIN
Structured Query Language (SQL)
27. Software system designed to support interface for a software asset that manages a specific set of tasks
Flat File
Service Provider
Web server
Functions
28. Limits the output of the established groups into the derived result table
BETWEEN
HAVING
GROUP BY
Fields
29. Describe information in a tree styled format
Embedded SQL
Comparison Operators
Hierarchial
Bind
30. Text markups that form an element" sort of a "box" to hold things like text and other elements
Dynamic
Tags
FROM
Negation Operator
31. File stored on a user's machine that contains infor about application
Cookie
Indexes
ESC
Data Definition
32. Everything between the start and end tag
Element Content
DELETE
Precedence of Logical Operators
Users
33. Closed in the start tag by adding a slash to the start tag
Foreign Keys
Property
Empty Elements
Service Provider
34. Concatenated in SQL Server Database software using the addition symbol
Scripting
Closing tag
Fields
Database Administrator (DBA)
35. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance
Subqueries
Functions
COUNT
Report
36. Table displayed in descending order
NOT
ESC
BETWEEN
Performance
37. Data in database interacts & corresponds with other data
Equals Operator
COUNT
Integrated
Empty Elements
38. Allows use of single or multiple character wildcards with the underscore or percent symbol
LIKE
Property
Self Join
Negation Operator
39. Large structured set of persistent data
ALL
Hypertext Markup Language (HTML)
Database
Opening tag
40. The Web is ___________
Scripting
Stateless
Performance
Hypertext Markup Language (HTML)
41. Deletes selected rows
Flat File
Scripting
Persistent
DELETE
42. Data in database has ability to be accessed and manipulated by several users
Subquery
Shared
Relational
Joins
43. Table displayed in ascending order
Inner SELECT query
Central Control of data
Data Definition
ASC
44. Supplies value for the search condition of the SELECT statement containing it
Inner SELECT query
Hardware
BETWEEN
MAX
45. 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
FROM
INSERT INTO
Public Key Infrastructure (PKI)
Candidate Keys
46. Specifies the tables or views from which rows and columns are retrieved
Flat File
Service Provider
to update
FROM
47. Meaningful info related to database
Empty Elements
Data
Data Manipulation
Application Programmers
48. Limits the rows that appear in the result mathcing a specified condition
WHERE
Element Content
Tables
Persistent
49. Begins an element
Data Recovery & Concurrance
Opening tag
Users
Web Service
50. Considered the time that a user first accesses a page until a set of amount time - on the server - after their last activity or until the session is explicitly closed
Subqueries
Property
ASC
Session