stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
Dat 100 Flashcards | StudBud
Explore
/
Dat 100
What is a distributed database?
What are some of the data types?
Dat 100
31 terms
·
StudBud Administration
·
5 plays
Imported from external platform
Flashcards
31 cards
F
Practice quiz
P
Host live
L
Questions
31
Answers
1
What are some of the data types?
Integer primary key (unique numerical ids for records)
Integer
Text
Boolean for boolean values, date
2
What is a distributed database?
A database that portions of the database are stored in multiple locations
A database structured to recognize locations among stored items
3
Hardware
storage- large volumes of data
Ram- scanning large indexes
HDD
external disk drive
4
What is a Database?
a base in daton
the collection of organized data
The storage of random information
5
Why should you used approved hardware/software? and what are some of the approved
Microsoft SQL
Prevents security compromise of your system
tac chat
Technical control & analysis center (TCAC) Radio BN Sigint Asset
6
How is Querying done?
data in SQL databases is done in the form of "SELECT" statements
data in SQL databases is done in the form of "KMY" statements
data in SQL databases is done in the form of "Retract" statements
7
What is a cloud database?
a data rain cloud
a database stored in a cloud
A database that has been optimized for virtualization
8
What is a Query? Read everything Carefully
AN Inquiry into the database using the "Delete" command
an inquiry into the database using the "SELECT" statement
An inquiry into the database using the "ENTER" Statement
9
What is post GRESQL?
storage and third party access
Object relational Database
A version of low quality GUI used on dell laptops
10
database management system
the interface between the user and database
interface between the administer and database
erases typos and fixes database errors
11
What is a structured Query Language?
most common relation database language
A weird way to say squad leader
a table that translates data
an interface between the administer and the database
12
What is a string?
a string of commands
a long list or string of information in a database
character values contained within parenthesis as a variable
13
microsoft SQL Server
many editions
uses T-SQL
a database for SQL root hints
Proprietary, procedural programing, local variables
14
Which of the following applies to Database schema
its structure is supported by the DBMS
Organization of data
Also known as the blue print for the database
How a database is constructed
15
What is DBMS used for?
to create Queries, updates, and administer
to manage your database
16
What is a Query Used for?
A relational Question
A question that the system sends to the database
to extract data from the database in a readable format for users requests
17
what is a relational database?
requires there to be a sister or brother relation between systems
relative data
uses relations between elements
18
What is a (DBMS)?
A DBMS Designed for the relational model
software application that interacts with users, aplications, & database
Relational database management system
Database Management system
19
What are Primary keys?
Uniquely identifies all rows or records
primarily used for all persons computers also known as a password
specific column ina relational database
20
What are columns?
The collection of Fields
Primary key
the occurrence of data or "records"
columns are kinda like pillars and stand up straight and hold structures up
21
what is a relational Database?
a database that has been optimized or built for a virtualized enviroment
A database that which portions of the database are stored in multiple locat
A databaase structured to recognize relations among stored items
22
What is (R-DBMS)
software application that interacts with users, applications, and database
Database management System
Relational Database management System
A DBMS designed for the relational Model
23
What are some database services?
Divide workloads into groupings
Divided by functions, priority, job, class, data range
help manage Workloads
a data service that most cable companies provide with a subscription
24
What is SQL Server Management Studio (SSMS)
provides graphical tools
manages SQL infrastructure
Huge help to admins due to being so easy to manage
Auto populates SQL servers
25
What does the frontend application do?
user interface with the database
development focused on user experience
frontend access on a case by case basis
MS Access forms
26
Rows
a cool way to braid hair also known as corn rows
Primary key
the collection of Fields
the occurrence of data or "record"
27
Backend
Retro finem
table of Queries
focused on security, structure and content
Server side control of database
28
What is mySQL?
Central to LAMP stack
mySQL is a email server associated with the military
Open-source owned by oracle
a website to buy Squad leaders off of (low Quality)
29
What is Microsoft access?
Access to the internal Web GUI
Backend tables and queries control data
can be exported so mto SQL server and imported from excel and ODBC
frontend forms & reports that can be created
30
a database is easily
managed
accessible
stored on ram
updated
31
What is a table?
a table is a piece of furniture that you eat at
collection of information
2 dimensions; rows and columns
a table is a chart of numbers that our computer can read to send data
