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. Allow useres to retrieve data and interact with content located on web pages within website
Equals Operator
Hardware
Functions
Web Browser
2. Used to remove duplicates from result table
to update
DISTINCT
Session
Forward Slash
3. Used with another comparison operator - values become inverted
Negation Operator
Equals Operator
Persistent
Tables
4. Ongoing record of data reflecting the info defining the database
*
Data Dictionary
Data Administrator (DAd)
Views
5. Data in database has ability to be accessed and manipulated by several users
Empty Elements
IN
Database Administrator (DBA)
Shared
6. Characterizes operation of a relational database
Joins
accident
ASC
Flat File
7. Ensures data is correct casings
Outer SELECT query
American Standard Code for Information Interchange (ASCII)
Tags
INSERT INTO
8. Grant acces and control to only specific information
ORDER BY
Data Manipulation
Views
Aggregate Functions
9. Copies multiple records at the same time using a SELECT statement
INSERT INTO
Tags
WHERE
Negation Operator
10. Decides what data is stored in the databse and the manner it is stored
Service-Oriented Architecture (SOA)
INSERT INTO
Data Administrator (DAd)
Indexes
11. One huge database to hold all data; Access to data - and use of system to add - update & print records
Database Management Systems (DBMS)
Web Applications
INSERT INTO
hidden fields
12. Using product as intended for its audience
End Users
Service Provider
Service Provider
Data Manipulation
13. Text markups that form an element" sort of a "box" to hold things like text and other elements
Tags
Data
Precedence of Logical Operators
COUNT
14. Practice of writing code into a webpage that is not directly visible to the user
Scripting
COUNT
Candidate Keys
Data
15. Changes the values in one or more selected rows of a table
ORDER BY
Persistent
Report
UPDATE
16. SQL finds and retrieves date
Indexes
AVG
ESC
Persistent
17. Network node that discovers and invokes other software services to provide a buisness solution
Comparison Operators
Service Requestor
Aggregate Functions
Subquery
18. File stored on a user's machine that contains infor about application
Shared
Embedded SQL
SUM
Cookie
19. Ensures functions are done efficiently
to update
Opening tag
Web Browser
Performance
20. Supplies value for the search condition of the SELECT statement containing it
End Users
Inner SELECT query
Integrated
BETWEEN
21. SELECT statment containing the nested query
Outer SELECT query
COUNT
Structured Query Language (SQL)
FROM
22. = - < - > - <= - >= - <> - !
Negation Operator
Shared
Data Manipulation
Comparison Operators
23. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
Web server
Service-Oriented Architecture (SOA)
Flat File
Fields
24. Has the highest precedence - followed by the AND - OR
Persistent
UPDATE
NOT
HAVING
25. Software system designed to support interoperable machine - to - machine interaction over a network
Information
Web Service
Structured Query Language (SQL)
accident
26. SQL finds and retrieves date
SUM
Persistent
Web Service
Indexes
27. Basic Component of SQL
single value
Opening tag
ALL
Tables
28. Concatenated in SQL Server Database software using the addition symbol
Public Key Infrastructure (PKI)
Joins
Fields
ASC
29. Table displayed in ascending order
INSERT INTO
Embedded SQL
MAX
ASC
30. Deletes selected rows
End Users
DELETE
Data Administrator (DAd)
Database Administrator (DBA)
31. Defines a new column
Subqueries
Outer SELECT query
AVG
Calculated Column
32. Used to combine one query with another.
Web Service
Inner SELECT query
Tags
Subquery
33. Responsible for technical implementation & maintenance of database on a design & physical level
Application Programers
Database Administrator (DBA)
Scripting
Central Control of data
34. Compares value of the column in the specified condition with the value specified
Equals Operator
Data Definition
Data Dictionary
Service Requestor
35. Browser requests page - code is delivered - executed and done with
Data Recovery & Concurrance
Dynamic
Inner SELECT query
Web server
36. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance
Central Control of data
Functions
Structured Query Language (SQL)
MAX
37. Software system designed to support interoperable machine - to - machine interaction over a network
Web Service
Interactive SQL
Users
WHERE
38. Uniquely identify each record in the table and are chosen at the time of table creation. It is recommended that you use a variable such as a Social Security for this.
Primary Keys
Hardware
ASC
Hardware
39. Table displayed in ascending order
Relational
ASC
Closing tag
Hypertext Markup Language (HTML)
40. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
SELECT
Bind
single value
IN
41. Order in which WHERE clause is evaluated and combined
Database Administrator (DBA)
Web Service
Precedence of Logical Operators
Element Content
42. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
Users
Structured Query Language (SQL)
ASC
Web server
43. Allows use of single or multiple character wildcards with the underscore or percent symbol
Word
Database
LIKE
Interactive SQL
44. Cookies are more secure than______ - allowing travel on a website without loss of info
Self Join
hidden fields
Closing tag
COUNT
45. Three Basic Operations of SP - SR - SB: Publish - Find - ____
Structured Query Language (SQL)
ALL
Web Applications
Bind
46. Characterizes operation of a relational database
Calculated Column
Joins
Session
single value
47. Has the highest precedence - followed by the AND - OR
ALL
Aggregate Functions
NOT
Calculated Column
48. Used to combine one query to another
Subqueries
Element Content
Database Administrator (DBA)
Comparison Operators
49. Limits the rows that appear in the result mathcing a specified condition
Report
Precedence of Logical Operators
Web Applications
WHERE
50. 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
Hierarchial
Subquery
COUNT