Exam (elaborations)
c175 final/64 Questions with accurate answers
- Course
- Institution
c175 final/64 Questions with accurate answers
[Show more]
Seller
Follow
Victorious23
Reviews received
Content preview
c175 final/64 Questions with accurateanswers
3Vs - -volume, velocity, variety
-Abstract Data Type (ADT) - -
-active-active array - -- high-end storage system
- large number of controllers and cache memory
- large storage capacity
- large amounts of cache
- fault tolerance
- ability to handle large amounts of concurrent i/os
-active passive arrays - -- aka midrange storage system
- provide optimal storage solutions at a lower cost
- less storage capacity and cache than high-end storage
- fewer front-end ports
- ensure high redundancy and high performance for applications with
predictable workloads
-ad hoc query - -A "spur-of-the-moment" question.
-affinity grouping - -is a process of evaluating relationships or associations
between data elements that demonstrate some kind of affinity between
objects.
-ALTER TABLE - -The SQL command used to make changes to table
structure. When the command is followed by a keyword (ADD or MODIFY), it
adds a column or changes column characteristics.
-American National Standards Institute (ANSI) - -The group that accepted
the DBTG recommendations and augmented database standards in 1975
through its SPARC committee.
-analytical database - -A database focused primarily on storing historical
data and business metrics used for tactical or strategic decision making.
-and operator - -it displays a record if more than one condition is true
-Application Programming Interface (API) - -Software through which
programmers interact with middleware. An API allows the use of generic SQL
code, thereby allowing client processes to be database server-independent.
, -Association Rules - -Descriptive; discovers links or associations amongst
data.
-Associative Entity - -An entity type that associates the instances of one or
more entity types and contains attributes that are peculiar to the relationship
between those entity instances.
-atomic attribute - -An attribute that cannot be further subdivided to
produce meaningful components. For example, a person's last name
attribute cannot be meaningfully subdivided.
-Atomicity - -The transaction property that requires all parts of a transaction
to be treated as a single, indivisible, logical unit of work. All parts of a
transaction must be completed or the entire transaction is aborted.
-attribute - -an attribute is a property or characteristic of an entity
-availability - -In the context of data security, it refers to the accessibility of
data whenever required by authorized users and for authorized purposes.
-AVG() function - -- It returns the average value of a numeric column. SQL
-Balancing - -Ensuring that the processing load is distributed evenly among
multiple servers.
-Benefits of Cloud Computing - -- reduced it cost
- business agility
- flexible scaling
- high availability
-between - -In SQL it allows you to specify a range of numeric values in a
search
-Big Data - -A movement to find new and better ways to manage large
amounts of web-generated data and derive business insight from it, while
simultaneously providing high performance and scalability at a reasonable
cost.
-binary relationship - -An ER term for an association (relationship) between
two entities. For example, PROFESSOR teaches CLASS.
-Boolean Algebra - -A branch of mathematics that uses the logical operators
OR, AND, and NOT.
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Victorious23. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $8.49. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
77016 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now