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. Deletes selected rows
Data Recovery & Concurrance
Hypertext Markup Language (HTML)
Data Definition
DELETE
2. Ensures data is correct casings
accident
Joins
Information
American Standard Code for Information Interchange (ASCII)
3. All Columns indicated and selected
Data Manipulation
Query
Property
*
4. Three Basic Operations of SP - SR - SB: Publish - Find - ____
Flat File
Performance
Bind
Empty Elements
5. Give the browser more specific information about that tag
Tags
GROUP BY
Dynamic
Attributes
6. Attribute in quotes
Service Requestor
ALL
Data Administrator (DAd)
Property
7. Identifies columns to appear in the result
Database Management Systems (DBMS)
Central control of data
SELECT
Service Requestor
8. Everything in enviroment becomes an object - expands on Priniples of relational databases
Subquery
SUM
Object-Oriented Relational (OOR)
HAVING
9. Fields in a relational table that match the primary key from one column to the primary key of another table.
Foreign Keys
Tables
*
DISTINCT
10. Command used to show the attributes that define a table.
Indexes
End Users
Joins
sp_help
11. Used in a SELECT clause in place of a column
Aggregate Functions
Functions
Empty Elements
Empty Elements
12. Combines rows from a SELECT statements result table into a group
GROUP BY
Shared
Data
Web Browser
13. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance
Functions
Web Applications
Precedence of Logical Operators
Service-Oriented Architecture (SOA)
14. Uses two values as limits - selecting any values between the two of them
BETWEEN
AVG
End Users
Cookie
15. Everything between the start and end tag
Element Content
Property
MIN
Calculated Column
16. Practice of writing code into a webpage that is not directly visible to the user
Dynamic
Scripting
Central Control of data
SUM
17. Network node that discovers and invokes other software services to provide a buisness solution
Service Requestor
Database Management Systems (DBMS)
Web server
BETWEEN
18. Used with another comparison operator - values become inverted
DELETE
Aliases
Negation Operator
Database Management Systems (DBMS)
19. Create program files that include SQ after each command
Tags
Element Content
Embedded SQL
Stateless
20. Data stored by DAd
Negation Operator
Data Definition
MAX
Data Elements
21. Tally of how many rows meet criteria specified
COUNT
Service Broker
Session
Report
22. Identifies columns to appear in the result
Element Content
Primary Keys
SELECT
Service Broker
23. Browser requests page - code is delivered - executed and done with
Dynamic
AVG
Data
Database
24. Large structured set of persistent data
Database
Interactive SQL
HAVING
*
25. SQL Commands - Two Things Specify data interested in - Indicate the ________
Stateless
accident
Cookie
Data Elements
26. Limits the rows that appear in the result mathcing a specified condition
BETWEEN
Tags
Performance
WHERE
27. Computer programs allowing website visitors to submit and retrieve data to/from a database over the Internet using their preferred web browser
Web Applications
DELETE
Central control of data
Performance
28. Definition of commands it can do
Property
hidden fields
Data Definition
Interactive SQL
29. Three Basic Operations of SP - SR - SB: Publish - Find - ____
Views
Bind
Data Elements
Stateless
30. Text markups that form an element" sort of a "box" to hold things like text and other elements
Central control of data
Service Requestor
BETWEEN
Tags
31. Cookies are more secure than______ - allowing travel on a website without loss of info
Bind
Equals Operator
hidden fields
Opening tag
32. SELECT statment containing the nested query
Flat File
Outer SELECT query
UPDATE
Functions
33. One huge database to hold all data; Access to data - and use of system to add - update & print records
Joins
Integrated
Database Management Systems (DBMS)
Outer SELECT query
34. SQL Commands: Define tables - views - _____ - delete or insert info
to update
Scripting
Equals Operator
Database Management Systems (DBMS)
35. Software system designed to support interface for a software asset that manages a specific set of tasks
Service Provider
Subqueries
INSERT INTO
Calculated Column
36. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG
American Standard Code for Information Interchange (ASCII)
SUM
Report
DISTINCT
37. Averages the numeric values
Integrated
AVG
Word
Data Definition
38. Ensures data is correct casings
COUNT
ASC
Calculated Column
American Standard Code for Information Interchange (ASCII)
39. Allows data recovery in case of corruption or loss
Cookie
Data Recovery & Concurrance
SUM
Fields
40. Responsible for technical implementation & maintenance of database on a design & physical level
HAVING
Property
Database Administrator (DBA)
Word
41. Supplies value for the search condition of the SELECT statement containing it
Central control of data
Fields
FROM
Inner SELECT query
42. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
UPDATE
Database
Web server
American Standard Code for Information Interchange (ASCII)
43. Definition of commands it can do
Interactive SQL
Subqueries
Data Definition
hidden fields
44. Used to combine one query to another
DELETE
American Standard Code for Information Interchange (ASCII)
Web Browser
Subqueries
45. Data in database interacts & corresponds with other data
Stateless
Tables
DISTINCT
Integrated
46. Defines a new column
single value
Calculated Column
Embedded SQL
UPDATE
47. The Web is ___________
Data Dictionary
Stateless
Foreign Keys
DISTINCT
48. Table displayed in descending order
American Standard Code for Information Interchange (ASCII)
Calculated Column
ESC
Negation Operator
49. Columns containing numbers only
Tables
ESC
UPDATE
SUM
50. Copies multiple records at the same time using a SELECT statement
single value
Report
INSERT INTO
Closing tag