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. Used to remove duplicates from result table
Web Service
Application Programers
Web Applications
DISTINCT
2. Give the browser more specific information about that tag
NOT
Attributes
Tables
Empty Elements
3. 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
Cookie
Session
IN
Cookie
4. Three Basic Operations of SP - SR - SB: Publish - Find - ____
Bind
Relational
MIN
Application Programers
5. Change order of rows in result table
End Users
Application Programers
Foreign Keys
ORDER BY
6. Supplies value for the search condition of the SELECT statement containing it
Users
GROUP BY
Inner SELECT query
single value
7. Order in which WHERE clause is evaluated and combined
Precedence of Logical Operators
Relational
Service Provider
Flat File
8. Specifies the tables or views from which rows and columns are retrieved
Interactive SQL
Tables
Equals Operator
FROM
9. Deletes selected rows
DELETE
Fields
to update
Data Dictionary
10. Limits the rows that appear in the result mathcing a specified condition
Tables
WHERE
Flat File
Tags
11. Ongoing record of data reflecting the info defining the database
Service Requestor
Data Dictionary
Hardware
SUM
12. Interact and manipulates the data in the database
Tags
Outer SELECT query
Data Manipulation
UPDATE
13. 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
SUM
Session
Shared
Empty Elements
14. Large structured set of persistent data
Database
WHERE
DELETE
End Users
15. Computer programs allowing website visitors to submit and retrieve data to/from a database over the Internet using their preferred web browser
Web Applications
Application Programers
Web Browser
Property
16. Everything between the start and end tag
MAX
Word
Empty Elements
Element Content
17. Basic Component of SQL
Database Management Systems (DBMS)
Subqueries
Tables
Session
18. SQL Commands: Define tables - views - _____ - delete or insert info
Hierarchial
DELETE
Service Provider
to update
19. Everything in enviroment becomes an object - expands on Priniples of relational databases
Service Requestor
Object-Oriented Relational (OOR)
Element Content
Database
20. Most valuable asset of a database system.
Central control of data
HAVING
COUNT
Structured Query Language (SQL)
21. 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
Functions
Tables
Web server
22. Data remains unchanged in database
MAX
Data Elements
Database Administrator (DBA)
Persistent
23. Changes the values in one or more selected rows of a table
Bind
Data Administrator (DAd)
UPDATE
ALL
24. Large structured set of persistent data
Closing tag
Database
Database Management Systems (DBMS)
Data Definition
25. SQL finds and retrieves date
ESC
LIKE
Indexes
Database Management Systems (DBMS)
26. Grant acces and control to only specific information
Forward Slash
BETWEEN
Attributes
Views
27. Essentially a collection of services that communicate with eachother
Self Join
Database Management Systems (DBMS)
Service-Oriented Architecture (SOA)
ALL
28. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________
MAX
Web server
Central Control of data
UPDATE
29. Finds the lowest constant value in a column
Hypertext Markup Language (HTML)
End Users
MAX
Structured Query Language (SQL)
30. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
Closing tag
Precedence of Logical Operators
Data Manipulation
ALL
31. Attribute in quotes
Property
SUM
Outer SELECT query
Data Manipulation
32. Concatenated in SQL Server Database software using the addition symbol
Fields
Persistent
Application Programmers
Performance
33. Join a table to a copy of itself
Self Join
ASC
MAX
Scripting
34. Give the browser more specific information about that tag
Web server
SUM
Foreign Keys
Attributes
35. Looks like opening tag - but with a forward slash
Subquery
MAX
Closing tag
Aggregate Functions
36. Allows use of single or multiple character wildcards with the underscore or percent symbol
LIKE
ASC
ORDER BY
Database
37. Ensures data is correct casings
American Standard Code for Information Interchange (ASCII)
Structured Query Language (SQL)
Web server
Closing tag
38. Defines a new column
Hierarchial
LIKE
Calculated Column
Flat File
39. Data stored by DAd
Data Elements
BETWEEN
Equals Operator
Database Administrator (DBA)
40. Responsible for technical implementation & maintenance of database on a design & physical level
Database Administrator (DBA)
SUM
accident
Aliases
41. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
Web server
Public Key Infrastructure (PKI)
Bind
Integrated
42. Data that has been processed into a format that is understandable by its audience
Information
accident
Inner SELECT query
SELECT
43. Some form of output - usually - printed - containing information
Report
Information
Joins
Database Administrator (DBA)
44. Identifies columns to appear in the result
SELECT
Dynamic
UPDATE
Service-Oriented Architecture (SOA)
45. Uses two values as limits - selecting any values between the two of them
BETWEEN
ESC
Session
WHERE
46. Practice of writing code into a webpage that is not directly visible to the user
Application Programmers
ESC
accident
Scripting
47. File stored on a user's machine that contains infor about application
Report
Inner SELECT query
Cookie
Session
48. 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
ORDER BY
sp_help
Persistent
Public Key Infrastructure (PKI)
49. Order in which WHERE clause is evaluated and combined
COUNT
Forward Slash
Tables
Precedence of Logical Operators
50. Averages the numeric values
AVG
Joins
Service Broker
Equals Operator