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. Individuals that use - manipulate or maintain aspects of database
Performance
MAX
Aliases
Users
2. Practice of writing code into a webpage that is not directly visible to the user
Indexes
Service Provider
HAVING
Scripting
3. Using product as intended for its audience
Subqueries
Application Programmers
INSERT INTO
End Users
4. Closed in the start tag by adding a slash to the start tag
IN
GROUP BY
Bind
Empty Elements
5. Cookies are more secure than______ - allowing travel on a website without loss of info
hidden fields
Database Administrator (DBA)
BETWEEN
NOT
6. Everything in enviroment becomes an object - expands on Priniples of relational databases
Query
WHERE
Object-Oriented Relational (OOR)
ALL
7. Combines rows from a SELECT statements result table into a group
GROUP BY
Web server
NOT
single value
8. Used in a SELECT clause in place of a column
Public Key Infrastructure (PKI)
Service-Oriented Architecture (SOA)
Aggregate Functions
Self Join
9. Deletes selected rows
Indexes
Scripting
DELETE
Service-Oriented Architecture (SOA)
10. Command based way to ask the database a question
Service Provider
Hierarchial
Query
UPDATE
11. = - < - > - <= - >= - <> - !
Comparison Operators
Indexes
Bind
Web Browser
12. SQL finds and retrieves date
Comparison Operators
Database Administrator (DBA)
Indexes
IN
13. SQL Commands - Two Things Specify data interested in - Indicate the ________
Web Browser
accident
Aggregate Functions
Opening tag
14. Create program files that include SQ after each command
Primary Keys
INSERT INTO
Embedded SQL
Cookie
15. Large structured set of persistent data
Precedence of Logical Operators
DISTINCT
Aggregate Functions
Database
16. Limits the output of the established groups into the derived result table
Subqueries
HAVING
UPDATE
Service Provider
17. Most valuable asset of a database system.
to update
Integrated
Aliases
Central control of data
18. Selects from specific values in list
Data Recovery & Concurrance
IN
Integrated
Interactive SQL
19. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
Aliases
Web Browser
Tags
Equals Operator
20. Browser requests page - code is delivered - executed and done with
Joins
Dynamic
Service-Oriented Architecture (SOA)
Opening tag
21. Table displayed in descending order
SUM
ESC
Flat File
Comparison Operators
22. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance
Functions
Word
ALL
Integrated
23. Defines a new column
Subquery
*
Calculated Column
Service Broker
24. Network node that discovers and invokes other software services to provide a buisness solution
Persistent
Service Requestor
AVG
Foreign Keys
25. Everything in enviroment becomes an object - expands on Priniples of relational databases
Application Programers
Object-Oriented Relational (OOR)
COUNT
Data Administrator (DAd)
26. Columns containing numbers only
*
Structured Query Language (SQL)
SUM
Closing tag
27. All Columns indicated and selected
*
Object-Oriented Relational (OOR)
Interactive SQL
Hardware
28. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
UPDATE
Cookie
Web server
Word
29. Deletes selected rows
Central control of data
DELETE
Foreign Keys
ALL
30. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
Hypertext Markup Language (HTML)
Users
Performance
Data Definition
31. Attribute in quotes
Service Broker
Property
DELETE
Hypertext Markup Language (HTML)
32. Used to combine one query to another
COUNT
Cookie
Subqueries
Self Join
33. Command based way to ask the database a question
Performance
single value
Query
Bind
34. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
Opening tag
ORDER BY
ALL
IN
35. Compares value of the column in the specified condition with the value specified
Embedded SQL
WHERE
Equals Operator
Hardware
36. Identifies columns to appear in the result
Object-Oriented Relational (OOR)
Bind
SELECT
Database
37. Some form of output - usually - printed - containing information
Web Browser
Object-Oriented Relational (OOR)
Report
Database
38. SELECT statment containing the nested query
INSERT INTO
ALL
Outer SELECT query
Database Administrator (DBA)
39. Software system designed to support interface for a software asset that manages a specific set of tasks
Database Administrator (DBA)
Fields
Data Recovery & Concurrance
Service Provider
40. Compares value of the column in the specified condition with the value specified
Property
Structured Query Language (SQL)
Equals Operator
ALL
41. Describe information in a tree styled format
Service Provider
Hierarchial
Web Applications
Subqueries
42. Writes programs that use or allow acces to databse with specific purpose
Attributes
Database Administrator (DBA)
Data
Application Programers
43. Change order of rows in result table
ORDER BY
Indexes
Embedded SQL
Structured Query Language (SQL)
44. 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
Tables
Query
Session
DELETE
45. Ensures functions are done efficiently
Performance
Equals Operator
WHERE
ORDER BY
46. Writes programs that use or allow acces to databse with specific purpose
Application Programers
COUNT
INSERT INTO
Tables
47. Describe information in a tree styled format
Data Dictionary
Precedence of Logical Operators
Users
Hierarchial
48. Copies multiple records at the same time using a SELECT statement
Shared
INSERT INTO
sp_help
Word
49. 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
Aggregate Functions
Interactive SQL
Views
50. Attribute in quotes
to update
MIN
COUNT
Property