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. One huge database to hold all data; Access to data - and use of system to add - update & print records
Persistent
Database Management Systems (DBMS)
Functions
Self Join
2. Browser requests page - code is delivered - executed and done with
Data
Dynamic
GROUP BY
IN
3. Browser requests page - code is delivered - executed and done with
Functions
Dynamic
Web Service
Closing tag
4. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
AVG
Data Manipulation
Data Dictionary
ALL
5. Cookies are more secure than______ - allowing travel on a website without loss of info
Word
Database Management Systems (DBMS)
HAVING
hidden fields
6. Characterizes operation of a relational database
Performance
Subquery
Joins
SUM
7. Changes the values in one or more selected rows of a table
Relational
UPDATE
Negation Operator
FROM
8. Fields in a relational table that match the primary key from one column to the primary key of another table.
DELETE
Persistent
Fields
Foreign Keys
9. Create program files that include SQ after each command
IN
Persistent
Application Programers
Embedded SQL
10. Essentially a collection of services that communicate with eachother
COUNT
SELECT
Query
Service-Oriented Architecture (SOA)
11. Concatenated in SQL Server Database software using the addition symbol
Opening tag
INSERT INTO
Fields
Report
12. Responsible for technical implementation & maintenance of database on a design & physical level
Service Provider
Query
Web Applications
Database Administrator (DBA)
13. Uses two values as limits - selecting any values between the two of them
Aggregate Functions
GROUP BY
BETWEEN
HAVING
14. Computer equipment -Fixed Storage Media - Removeable Storage Media - System Memory - and the Processor
Hardware
Object-Oriented Relational (OOR)
INSERT INTO
Closing tag
15. SELECT statment containing the nested query
Scripting
Indexes
Candidate Keys
Outer SELECT query
16. Using product as intended for its audience
SELECT
COUNT
Joins
End Users
17. Large structured set of persistent data
IN
Database
Data Administrator (DAd)
Aliases
18. Combines rows from a SELECT statements result table into a group
Data Elements
Report
GROUP BY
Performance
19. Uses relationships between independent entities
Relational
Self Join
HAVING
DISTINCT
20. Join a table to a copy of itself
NOT
Self Join
Flat File
Scripting
21. Change order of rows in result table
Subquery
ORDER BY
SUM
Query
22. Software system designed to support interface for a software asset that manages a specific set of tasks
Dynamic
AVG
Calculated Column
Service Provider
23. = - < - > - <= - >= - <> - !
GROUP BY
Word
Comparison Operators
Query
24. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
Service Broker
Hierarchial
Service Requestor
Word
25. Command based way to ask the database a question
Service Provider
Data Recovery & Concurrance
Query
Interactive SQL
26. Limits the rows that appear in the result mathcing a specified condition
WHERE
Stateless
SUM
Inner SELECT query
27. Attribute in quotes
Bind
Stateless
Property
accident
28. Flat File Examples: Excel Spreadsheets - _____
Word
Web Browser
Structured Query Language (SQL)
Session
29. Ensures data is correct casings
American Standard Code for Information Interchange (ASCII)
Aggregate Functions
ALL
Equals Operator
30. Definition of commands it can do
Web Applications
Users
Data Definition
Data Elements
31. SQL Commands: Define tables - views - _____ - delete or insert info
Integrated
to update
Flat File
Element Content
32. Used to combine one query with another.
Aggregate Functions
Application Programers
MIN
Subquery
33. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
Service Broker
Aliases
ASC
American Standard Code for Information Interchange (ASCII)
34. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
Flat File
Application Programmers
Integrated
IN
35. Concatenated in SQL Server Database software using the addition symbol
End Users
Data Elements
Fields
Performance
36. Has the highest precedence - followed by the AND - OR
COUNT
NOT
DISTINCT
Service Requestor
37. Three Basic Operations of SP - SR - SB: Publish - Find - ____
Integrated
Self Join
Comparison Operators
Bind
38. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
SUM
Bind
Outer SELECT query
Hypertext Markup Language (HTML)
39. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
American Standard Code for Information Interchange (ASCII)
*
Cookie
Hypertext Markup Language (HTML)
40. Data in database has ability to be accessed and manipulated by several users
Service Requestor
MAX
Shared
ALL
41. Text markups that form an element" sort of a "box" to hold things like text and other elements
ORDER BY
DELETE
Tags
Persistent
42. Three Basic Operations of SP - SR - SB: Publish - Find - ____
Bind
Indexes
Precedence of Logical Operators
Indexes
43. Table displayed in ascending order
Inner SELECT query
ASC
Forward Slash
Performance
44. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
Application Programmers
Hypertext Markup Language (HTML)
*
Negation Operator
45. Order in which WHERE clause is evaluated and combined
Precedence of Logical Operators
Views
Dynamic
ASC
46. Limits the output of the established groups into the derived result table
Central Control of data
hidden fields
HAVING
Property
47. Compares value of the column in the specified condition with the value specified
Comparison Operators
Equals Operator
UPDATE
Database
48. Everything between the start and end tag
Session
Element Content
ASC
Data Definition
49. Grant acces and control to only specific information
Views
ASC
single value
Persistent
50. Table displayed in descending order
Views
SUM
Precedence of Logical Operators
ESC