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. Cookies are more secure than______ - allowing travel on a website without loss of info
Performance
hidden fields
Aggregate Functions
Outer SELECT query
2. All Columns indicated and selected
Object-Oriented Relational (OOR)
Report
*
Scripting
3. Responsible for technical implementation & maintenance of database on a design & physical level
Fields
Object-Oriented Relational (OOR)
Database Administrator (DBA)
Joins
4. Limits the output of the established groups into the derived result table
HAVING
Data
Data Definition
Aliases
5. Give the browser more specific information about that tag
Attributes
Joins
ASC
Precedence of Logical Operators
6. Decides what data is stored in the databse and the manner it is stored
Central Control of data
Data Administrator (DAd)
Primary Keys
Hypertext Markup Language (HTML)
7. Interact and manipulates the data in the database
SUM
Data
Service Requestor
Data Manipulation
8. Closed in the start tag by adding a slash to the start tag
Application Programmers
Performance
Empty Elements
Users
9. Uses two values as limits - selecting any values between the two of them
BETWEEN
Precedence of Logical Operators
Persistent
DELETE
10. Everything in enviroment becomes an object - expands on Priniples of relational databases
DISTINCT
Object-Oriented Relational (OOR)
Functions
accident
11. Identifies columns to appear in the result
Self Join
SELECT
Central control of data
Query
12. Closed in the start tag by adding a slash to the start tag
UPDATE
Subquery
Empty Elements
Data
13. Concatenated in SQL Server Database software using the addition symbol
Tags
End Users
HAVING
Fields
14. Most valuable asset of a database system.
Embedded SQL
Application Programmers
ORDER BY
Central control of data
15. Supplies value for the search condition of the SELECT statement containing it
Central control of data
Inner SELECT query
Database Administrator (DBA)
DISTINCT
16. Supplies value for the search condition of the SELECT statement containing it
Aliases
Inner SELECT query
Equals Operator
Web Service
17. Computer programs allowing website visitors to submit and retrieve data to/from a database over the Internet using their preferred web browser
Web Applications
COUNT
Subqueries
Web Service
18. File stored on a user's machine that contains infor about application
Subqueries
Indexes
Cookie
Indexes
19. Changes the values in one or more selected rows of a table
Shared
UPDATE
Aggregate Functions
Central Control of data
20. Uses relationships between independent entities
sp_help
Calculated Column
Relational
MIN
21. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance
Functions
Views
Aggregate Functions
Negation Operator
22. Writes programs that use or allow acces to databse with specific purpose
Data Manipulation
accident
Application Programers
Information
23. Decides what data is stored in the databse and the manner it is stored
Data Administrator (DAd)
Database
Database Administrator (DBA)
Users
24. Allow useres to retrieve data and interact with content located on web pages within website
Database Management Systems (DBMS)
Users
Web Browser
Service Provider
25. Finds the lowest ACII value in column
SELECT
INSERT INTO
MIN
WHERE
26. Three Basic Operations of SP - SR - SB: Publish - Find - ____
Cookie
Bind
Data Dictionary
Session
27. Identifies columns to appear in the result
FROM
Application Programmers
SELECT
Indexes
28. Executes commands one at a time - results being displayed immediately
Tags
Flat File
Data Dictionary
Interactive SQL
29. 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
Comparison Operators
Data Definition
ALL
Session
30. Essentially a collection of services that communicate with eachother
Central control of data
Service-Oriented Architecture (SOA)
DISTINCT
Persistent
31. Software system designed to support interoperable machine - to - machine interaction over a network
Web Service
Data Definition
WHERE
Relational
32. Data that has been processed into a format that is understandable by its audience
End Users
Information
Calculated Column
Hierarchial
33. Describe information in a tree styled format
COUNT
SUM
Hierarchial
Fields
34. Create program files that include SQ after each command
Embedded SQL
DELETE
Central control of data
Structured Query Language (SQL)
35. Copies multiple records at the same time using a SELECT statement
Stateless
INSERT INTO
Inner SELECT query
Database Management Systems (DBMS)
36. Table displayed in ascending order
*
Query
ASC
DELETE
37. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
Service-Oriented Architecture (SOA)
Service Provider
Structured Query Language (SQL)
*
38. Computer equipment -Fixed Storage Media - Removeable Storage Media - System Memory - and the Processor
Hardware
Dynamic
single value
WHERE
39. Characterizes operation of a relational database
Structured Query Language (SQL)
Fields
GROUP BY
Joins
40. Uses relationships between independent entities
Forward Slash
Relational
Inner SELECT query
Aggregate Functions
41. 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.
WHERE
Candidate Keys
Object-Oriented Relational (OOR)
Embedded SQL
42. Used to remove duplicates from result table
DISTINCT
Web server
Data Elements
Data Definition
43. SQL Commands - Two Things Specify data interested in - Indicate the ________
accident
Bind
Application Programers
Data Manipulation
44. 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
*
Persistent
Fields
45. Flat File Examples: Excel Spreadsheets - _____
Data Elements
Word
Central control of data
Service Requestor
46. Used with another comparison operator - values become inverted
Flat File
Structured Query Language (SQL)
ORDER BY
Negation Operator
47. Columns containing numbers only
SUM
Data Elements
Shared
Fields
48. Give the browser more specific information about that tag
Web Applications
Fields
Attributes
MAX
49. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
Integrated
FROM
Aliases
Database
50. Meaningful info related to database
Calculated Column
Application Programmers
Data
Functions