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. SQL Commands - Two Things Specify data interested in - Indicate the ________
Database Management Systems (DBMS)
Service Provider
accident
Object-Oriented Relational (OOR)
2. SQL finds and retrieves date
Scripting
NOT
Outer SELECT query
Indexes
3. Combines rows from a SELECT statements result table into a group
Report
Fields
GROUP BY
Query
4. Table displayed in ascending order
Data Definition
ASC
Data Administrator (DAd)
Tables
5. Using product as intended for its audience
End Users
GROUP BY
COUNT
SELECT
6. Used to combine one query to another
Data Manipulation
LIKE
Precedence of Logical Operators
Subqueries
7. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
Data Manipulation
Tags
Embedded SQL
Structured Query Language (SQL)
8. Supplies value for the search condition of the SELECT statement containing it
Inner SELECT query
MIN
Embedded SQL
Cookie
9. Some form of output - usually - printed - containing information
Report
Outer SELECT query
Interactive SQL
Stateless
10. = - < - > - <= - >= - <> - !
Subquery
Hardware
Comparison Operators
Bind
11. Software system designed to support interoperable machine - to - machine interaction over a network
Web Service
Bind
MIN
Database Management Systems (DBMS)
12. Ensures functions are done efficiently
SUM
Word
Embedded SQL
Performance
13. Large structured set of persistent data
Database
Stateless
Application Programers
to update
14. Concatenated in SQL Server Database software using the addition symbol
Attributes
Query
Aggregate Functions
Fields
15. SELECT statment containing the nested query
Service Provider
Outer SELECT query
DISTINCT
American Standard Code for Information Interchange (ASCII)
16. Data in database has ability to be accessed and manipulated by several users
INSERT INTO
Self Join
Shared
Joins
17. Specifies the tables or views from which rows and columns are retrieved
Property
Data Manipulation
Database Administrator (DBA)
FROM
18. Individuals that use - manipulate or maintain aspects of database
Outer SELECT query
Dynamic
Users
SUM
19. Defines a new column
Tables
Calculated Column
Web Browser
Subqueries
20. Deletes selected rows
DELETE
Data Manipulation
Forward Slash
Equals Operator
21. Supplies value for the search condition of the SELECT statement containing it
*
Aliases
Web Service
Inner SELECT query
22. = - < - > - <= - >= - <> - !
Cookie
Structured Query Language (SQL)
Comparison Operators
Integrated
23. Characterizes operation of a relational database
Joins
ASC
Web Browser
American Standard Code for Information Interchange (ASCII)
24. Computer equipment -Fixed Storage Media - Removeable Storage Media - System Memory - and the Processor
ASC
Element Content
Hardware
Report
25. SQL Commands: Define tables - views - _____ - delete or insert info
to update
Data
Data Definition
Flat File
26. Three Basic Operations of SP - SR - SB: Publish - Find - ____
Data Definition
Candidate Keys
Bind
Embedded SQL
27. Order in which WHERE clause is evaluated and combined
Precedence of Logical Operators
Structured Query Language (SQL)
Functions
Indexes
28. The Web is ___________
Application Programmers
Data Definition
Hardware
Stateless
29. Command based way to ask the database a question
sp_help
Service-Oriented Architecture (SOA)
Self Join
Query
30. Meaningful info related to database
Data
Object-Oriented Relational (OOR)
Service-Oriented Architecture (SOA)
Element Content
31. Everything between the start and end tag
Element Content
ASC
Database Administrator (DBA)
Web Applications
32. Closed in the start tag by adding a slash to the start tag
Application Programmers
AVG
ASC
Empty Elements
33. Cookies are more secure than______ - allowing travel on a website without loss of info
single value
hidden fields
Hardware
COUNT
34. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
single value
Object-Oriented Relational (OOR)
BETWEEN
Session
35. Changes the values in one or more selected rows of a table
Data Definition
UPDATE
Data Elements
Application Programmers
36. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
HAVING
Joins
Aliases
Flat File
37. Three Basic Operations of SP - SR - SB: Publish - Find - ____
Views
Web Browser
Data Dictionary
Bind
38. Cookies are more secure than______ - allowing travel on a website without loss of info
Structured Query Language (SQL)
hidden fields
Data Elements
Flat File
39. Compares value of the column in the specified condition with the value specified
Inner SELECT query
COUNT
Equals Operator
Views
40. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG
COUNT
SUM
Data Recovery & Concurrance
Session
41. Tally of how many rows meet criteria specified
Data Elements
COUNT
INSERT INTO
Query
42. Tally of how many rows meet criteria specified
SELECT
COUNT
Data Dictionary
Views
43. Uses two values as limits - selecting any values between the two of them
MIN
Web Applications
BETWEEN
Property
44. Copies multiple records at the same time using a SELECT statement
FROM
INSERT INTO
hidden fields
Hypertext Markup Language (HTML)
45. Text markups that form an element" sort of a "box" to hold things like text and other elements
Structured Query Language (SQL)
Public Key Infrastructure (PKI)
Tags
Inner SELECT query
46. Used to close a tag properly
Forward Slash
Negation Operator
Embedded SQL
SUM
47. Table displayed in descending order
Tags
Report
Comparison Operators
ESC
48. Limits the output of the established groups into the derived result table
DELETE
INSERT INTO
HAVING
hidden fields
49. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
Hypertext Markup Language (HTML)
Application Programmers
Dynamic
ASC
50. Looks like opening tag - but with a forward slash
Closing tag
SUM
INSERT INTO
Web Service