C175 exam questions with answers,

C175 exam questions with answers
|\ |\ |\ |\




__________ results in SQL specifications for tables, columns, and
|\ |\ |\ |\ |\ |\ |\ |\ |\


keys in a specific database system. - CORRECT ANSWERS
|\ |\ |\ |\ |\ |\ |\ |\ |\


✔✔Logical design |\




__________ is a broad term for the process that generates
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\


database specifications in SQL. The term covers three phases -
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\


analysis, logical design, and physical design. - CORRECT
|\ |\ |\ |\ |\ |\ |\ |\


ANSWERS ✔✔Database design |\ |\




_______ is the process of gathering and documenting database
|\ |\ |\ |\ |\ |\ |\ |\ |\


requirements. The requirements are not dependent on any |\ |\ |\ |\ |\ |\ |\ |\


specific database system. Analysis goes by other names, such as
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\


conceptual design. - CORRECT ANSWERS ✔✔Analysis |\ |\ |\ |\ |\




________ results in SQL specifications for index and table
|\ |\ |\ |\ |\ |\ |\ |\ |\


structures. In a relational database, index and table structures
|\ |\ |\ |\ |\ |\ |\ |\ |\


affect query performance but not query results. This principle is
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\


called data independence. - CORRECT ANSWERS ✔✔Physical
|\ |\ |\ |\ |\ |\ |\


design


Inventor: IBM |\




Initial release: 1960s
|\ |\




Objectives: Speed and storage |\ |\ |\




Ex Databases:IMS - CORRECT ANSWERS ✔✔Hierarchical
|\ |\ |\ |\ |\

,Inventor: Charles Bachman |\ |\




Initial release: 1960s
|\ |\




Objectives: Speed and storage |\ |\ |\




Ex Databases: IDMS - CORRECT ANSWERS ✔✔Network
|\ |\ |\ |\ |\ |\




Inventor: E. F. Codd |\ |\ |\




Initial release: 1980s
|\ |\




Objectives: Productivity and simplicity; Transactional applications
|\ |\ |\ |\ |\




Ex Databases: MySQL, Oracle, SQL Server, DB2 - CORRECT
|\ |\ |\ |\ |\ |\ |\ |\ |\


ANSWERS ✔✔Relational |\




Inventor: Google, Amazon, and others|\ |\ |\ |\




Initial release: 2000s
|\ |\




Objectives: Big data, Analytic applications |\ |\ |\ |\




Ex Databases: MongoDB, Redis, Cassandra, Neo4j - CORRECT
|\ |\ |\ |\ |\ |\ |\ |\


ANSWERS ✔✔NoSQL models |\ |\




The relational model is a database model based on mathematical
|\ |\ |\ |\ |\ |\ |\ |\ |\


principles, with three parts: - CORRECT ANSWERS ✔✔1. A data
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\


structure that prescribes how data is organized.
|\ |\ |\ |\ |\ |\




2. Operations that manipulate data structures.
|\ |\ |\ |\ |\




3. Rules that govern valid relational data.
|\ |\ |\ |\ |\ |\




The relational data structure and operations are based on ____
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\


theory. - CORRECT ANSWERS ✔✔A set is a collection of values, or
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\


elements, with no inherent order. Sets are denoted with braces.
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\

,Ex: {apple, banana, lemon} is the set containing three kinds of
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\


fruit. Since sets have no order, {apple, banana, lemon} is the
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\


same set as {lemon, banana, apple}.
|\ |\ |\ |\ |\




A_______ is a named set of possible database values, such as
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\


integers, dictionary words, or logical values TRUE and FALSE. -
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\


CORRECT ANSWERS ✔✔domain |\ |\




A______ is a finite sequence of values, each drawn from a fixed
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\


domain. Ex: (3, apple, TRUE) is a tuple drawn from domains
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\


(Integers, DictionaryWords, LogicalValues). - CORRECT ANSWERS
|\ |\ |\ |\ |\ |\


✔✔tuple


A_______ is a named set of tuples, all drawn from the same
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\


sequence of domains. - CORRECT ANSWERS ✔✔relation
|\ |\ |\ |\ |\ |\




The most commonly used terms in relational database are ? -
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\


CORRECT ANSWERS ✔✔row, column, and table. Occasionally
|\ |\ |\ |\ |\ |\ |\


tuple, relation, attribute and record, file, field are also used.
|\ |\ |\ |\ |\ |\ |\ |\ |\




In the relational data structure, which components are named? -
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\


CORRECT ANSWERS ✔✔Domain, relation, and attribute are all
|\ |\ |\ |\ |\ |\ |\ |\


named. Tuples are not named. |\ |\ |\ |\




All ____________result in a table. The result table is not stored in
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\


the database but has the same structure as stored tables. -
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\


CORRECT ANSWERS ✔✔relational operations |\ |\ |\

, ___________, also known as integrity rules, are logical constraints
|\ |\ |\ |\ |\ |\ |\ |\ |\


that ensure data is valid and conforms to business policy. -
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\


CORRECT ANSWERS ✔✔Relational rules |\ |\ |\




__________ are relational rules that govern data in every relational
|\ |\ |\ |\ |\ |\ |\ |\ |\


database. The relational model stipulates a number of structural
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\


rules, such as: - CORRECT ANSWERS ✔✔Structural rules
|\ |\ |\ |\ |\ |\ |\




Unique primary key — all tables should have a column with no
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\


repeated values, called the primary key and used to identify
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\


individual rows. |\




Unique column names — different columns of the same table
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\


must have different names.
|\ |\ |\




No duplicate rows — no two rows of the same table may have
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\


identical values in all columns. |\ |\ |\ |\




_____________ are relational rules specific to a particular database
|\ |\ |\ |\ |\ |\ |\ |\ |\


and application. Example business rules include: - CORRECT
|\ |\ |\ |\ |\ |\ |\ |\


ANSWERS ✔✔Business rules |\ |\




Unique column values — in a particular column, values may not
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\


be repeated.
|\




No missing values — in a particular column, all rows must have
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\


known values. |\