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. Concatenated in SQL Server Database software using the addition symbol
Shared
Performance
Fields
Central Control of data
2. Uses two values as limits - selecting any values between the two of them
Word
Word
Web Browser
BETWEEN
3. Specifies the tables or views from which rows and columns are retrieved
Structured Query Language (SQL)
accident
FROM
Comparison Operators
4. Join a table to a copy of itself
Information
DELETE
Self Join
Data Recovery & Concurrance
5. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
SUM
Service Broker
Shared
Fields
6. Cookies are more secure than______ - allowing travel on a website without loss of info
Subqueries
hidden fields
Indexes
Tables
7. Text markups that form an element" sort of a "box" to hold things like text and other elements
Interactive SQL
Tags
FROM
single value
8. Ongoing record of data reflecting the info defining the database
Data Dictionary
COUNT
Bind
MAX
9. Software system designed to support interoperable machine - to - machine interaction over a network
Service Broker
Web Service
hidden fields
Joins
10. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________
Opening tag
Application Programmers
BETWEEN
Central Control of data
11. Ensures data is correct casings
Comparison Operators
Subqueries
American Standard Code for Information Interchange (ASCII)
SUM
12. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
single value
SELECT
Public Key Infrastructure (PKI)
Data Definition
13. Closed in the start tag by adding a slash to the start tag
Word
Empty Elements
Tables
Public Key Infrastructure (PKI)
14. All Columns indicated and selected
Property
*
Service Requestor
LIKE
15. Finds the lowest constant value in a column
MAX
SUM
Data Elements
accident
16. Using product as intended for its audience
Precedence of Logical Operators
End Users
Foreign Keys
Embedded SQL
17. Data stored by DAd
GROUP BY
Data Elements
Bind
Object-Oriented Relational (OOR)
18. Table displayed in ascending order
DELETE
Flat File
Report
ASC
19. Individuals that use - manipulate or maintain aspects of database
Application Programers
IN
Users
Indexes
20. Computer equipment -Fixed Storage Media - Removeable Storage Media - System Memory - and the Processor
sp_help
Precedence of Logical Operators
Service-Oriented Architecture (SOA)
Hardware
21. Flat File Examples: Excel Spreadsheets - _____
Word
MIN
SUM
LIKE
22. Closed in the start tag by adding a slash to the start tag
Empty Elements
Users
ASC
Structured Query Language (SQL)
23. Computer equipment -Fixed Storage Media - Removeable Storage Media - System Memory - and the Processor
Hardware
Session
Flat File
Foreign Keys
24. Network node that discovers and invokes other software services to provide a buisness solution
Service Requestor
Data Elements
Opening tag
Self Join
25. SQL Commands - Two Things Specify data interested in - Indicate the ________
accident
COUNT
Inner SELECT query
NOT
26. Finds the lowest ACII value in column
MIN
Object-Oriented Relational (OOR)
Application Programers
LIKE
27. Data in database interacts & corresponds with other data
Hypertext Markup Language (HTML)
Service Provider
Integrated
Indexes
28. Definition of commands it can do
Data Definition
SUM
Hypertext Markup Language (HTML)
Empty Elements
29. Describe information in a tree styled format
SELECT
DELETE
Hierarchial
Empty Elements
30. Allows use of single or multiple character wildcards with the underscore or percent symbol
Integrated
Data
Opening tag
LIKE
31. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
Structured Query Language (SQL)
SUM
Public Key Infrastructure (PKI)
Application Programmers
32. Used to combine one query with another.
Precedence of Logical Operators
Precedence of Logical Operators
Tables
Subquery
33. Straight implementation of raw data formatted into rows and columns
Flat File
Bind
Data Manipulation
NOT
34. Copies multiple records at the same time using a SELECT statement
Calculated Column
Aliases
INSERT INTO
Scripting
35. Tally of how many rows meet criteria specified
Foreign Keys
COUNT
Integrated
American Standard Code for Information Interchange (ASCII)
36. Data stored by DAd
Empty Elements
Data Elements
Data Manipulation
INSERT INTO
37. Everything in enviroment becomes an object - expands on Priniples of relational databases
Dynamic
Fields
Object-Oriented Relational (OOR)
DELETE
38. Changes the values in one or more selected rows of a table
Closing tag
Comparison Operators
MAX
UPDATE
39. Three Basic Operations of SP - SR - SB: Publish - Find - ____
Bind
Data Definition
Word
Data Definition
40. Attribute in quotes
COUNT
NOT
Property
Web server
41. Uses relationships between independent entities
Self Join
Data Elements
Service-Oriented Architecture (SOA)
Relational
42. Has the highest precedence - followed by the AND - OR
NOT
Service-Oriented Architecture (SOA)
UPDATE
SUM
43. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance
Functions
Flat File
hidden fields
Hypertext Markup Language (HTML)
44. Data that has been processed into a format that is understandable by its audience
Fields
Precedence of Logical Operators
DELETE
Information
45. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
ALL
Indexes
End Users
BETWEEN
46. Finds the lowest constant value in a column
Word
Web server
MAX
Dynamic
47. Deletes selected rows
Fields
Inner SELECT query
Bind
DELETE
48. 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
ALL
Query
Object-Oriented Relational (OOR)
Session
49. Interact and manipulates the data in the database
Service Broker
*
Data Elements
Data Manipulation
50. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
Cookie
Embedded SQL
Application Programers
Application Programmers
Sorry!:) No result found.
Can you answer 50 questions in 15 minutes?
Let me suggest you:
Browse all subjects
Browse all tests
Most popular tests
Major Subjects
Tests & Exams
AP
CLEP
DSST
GRE
SAT
GMAT
Certifications
CISSP go to https://www.isc2.org/
PMP
ITIL
RHCE
MCTS
More...
IT Skills
Android Programming
Data Modeling
Objective C Programming
Basic Python Programming
Adobe Illustrator
More...
Business Skills
Advertising Techniques
Business Accounting Basics
Business Strategy
Human Resource Management
Marketing Basics
More...
Soft Skills
Body Language
People Skills
Public Speaking
Persuasion
Job Hunting And Resumes
More...
Vocabulary
GRE Vocab
SAT Vocab
TOEFL Essential Vocab
Basic English Words For All
Global Words You Should Know
Business English
More...
Languages
AP German Vocab
AP Latin Vocab
SAT Subject Test: French
Italian Survival
Norwegian Survival
More...
Engineering
Audio Engineering
Computer Science Engineering
Aerospace Engineering
Chemical Engineering
Structural Engineering
More...
Health Sciences
Basic Nursing Skills
Health Science Language Fundamentals
Veterinary Technology Medical Language
Cardiology
Clinical Surgery
More...
English
Grammar Fundamentals
Literary And Rhetorical Vocab
Elements Of Style Vocab
Introduction To English Major
Complete Advanced Sentences
Literature
Homonyms
More...
Math
Algebra Formulas
Basic Arithmetic: Measurements
Metric Conversions
Geometric Properties
Important Math Facts
Number Sense Vocab
Business Math
More...
Other Major Subjects
Science
Economics
History
Law
Performing-arts
Cooking
Logic & Reasoning
Trivia
Browse all subjects
Browse all tests
Most popular tests