IS 475 Final
Which would be the correct way to rename a column in SQL? a. Select product_name as 'Product' b. Select product_name as Product c. Select product_name as (Product) d. Select product_name as "Product"
A
(T/F): Two entities can only have one type of relationship between them.
False, two entities can have multiple relationships.
Which of the following traits out of this list is a part of Contextual segment of Data Quality Dimensions? a) Appropriate amount b) Traceability c) Concisely-represented d) Interpretable e) Alignment
A
What is the correct format order of SQL commands when using a select expression: A. Group By Select Where From B. Select From Where Group By C. From Select Group By Where D. None of the Above E. The Order doesn't matter
B
The data integration technique of duplicating data across databases with near real-time delay is known as ____ ___________.
Data Propagation
True or False? Client and server processes cannot reside in the same computer.
False
True or false? SQL has a strict case-sensitive structure that must be followed.
False
What is the definition of an SQL Subquery
The SQL subquery is a separate SELECT statement that is embedded in the main statement and may be executed once for each row of the result set.
Question 1 Referring to the table above, identify a data inconsistency problem.
The schedule column of the table is not consistent in the way that it displays the days of the week.
What inherits all attributes of a supertype?
subtype
Data Propagation allows for ______________ propagation of updates/events in the source system to the target system.
synchronous
T/F: MySQL is an example of a relational database management system.
True
T/F: The Database design process consists of Conceptual Database Design, Logical Database Design, and Physical Database Design.
True
The ____________ framework of data quality categorizes the dimension of data retrieval.
Access
SQL offers a number of built-in functions. The _______ function returns the number of tuples or values specified in a query.
COUNT
What would you use to remove or drop a table named EMPLOYEE and clear all its data?
DROP TABLE EMPLOYEE;
A ______ is used to simplify SQL commands.
Alias
NoSQL Stands For ___
Not only SQL
Mohammad Bin Shahzad T/F: Looking at the ER diagram above, the attribute "Experience" is NOT a derived attribute.
False
What is the cardinality constraint for the following statement? A member can enroll in as many classes as they would like to this year. _____
0..M
Which is the default "Join" operation? 1. Inner join 2. Left outer join 3. Right outer join 4. Outer join 5. All of the above
1. Inner Join
What are the Data Quality Dimensions that a framework categorizes? 1. Intrinsic 2. Contextual 3. Representation 4. Access 5. All of the above
5. All of the above
A database design process determines the _____ of a database system. A. Content and Structure B. Creativity and Market Appeal C. Security and Reliability D. Cost and Function E. Legality and Regulations
A
Below are benefits of SQL EXCEPT? A. High training costs B . Increased productivity C. Improved application portability D. Reduced dependence on a single vendor E. Enhanced cross-system communications
A
Multiple Choice: In order to eliminate possible duplicates in a select clause, you must specify which operation? A. DISTINCT B. WHERE C. ORDER BY D. HAVING E. GROUP BY
A
Using the order_management database, which line of the following SQL code will cause an error when it is run? SELECT DISTINCT o_no FROM order_detail INNER JOIN product ON product.product_ID = order_detail.product_ID WHERE VID = V003; A. Line 5 D. Line 3 C. Line 4 D. Line 2 E. None, the code will run without errors.
A
What SQL statement is correct to Update the telephone number of the customer John and set the phone number to 7146548549 A) UPDATE Customer SET tel = '7146548549' WHERE customer_name = 'John'; B) UPDATE Customer Tel = '7146548549' customer_name = 'John'; C) Add to Customer Tel = '7146548549' customer_name = 'John'; D) INSERT INTO Customer Tel is '7146548549' customer_name is 'John'; E) None of the above
A
What does DDL stand for? A. Data Definition Language B. Database Design Language C. Data Description Language D. Data Design Language E. Digital Database Language
A
What operator defines a range of values that the column values must fall in? a. Between b. Like c. Is d. In e. And
A
Which command is used to organize SQL results? a. ORDER BY b. SET BY c. ORGANIZE BY d. SORT BY e. None of the above.
A
Which of the following is the correct format for data insertion? A. INSERT INTO Inventory VALUES ('0060','A029',10); B. INSERT INTO VALUES ('0050','G009',5); C. INSERT ('0050','G009',5); D. VALUES into INVENTORY (5, '0936','ABS'); E. INSERT INTO VALUES ('0060','A029',10);
A
What are the 4 data quality dimensions?
A: Intrinsic, Contextual, Representation, Access
Arkman INC wants to obtain the number of employees that have a salary of less than $45,000 annually to give out raises. Complete the following query to find the result in descending order by the number of people in each department. _________ Department, COUNT(*) _______ Employees _______ Salary < $45,000 GROUP BY _____________ ORDER BY COUNT(*) ____
ANSWER: SELECT Department, COUNT(*) FROM Employees WHERE Salary < $45,000 GROUP BY Department ORDER BY COUNT(*) DESC
Hasbro's vendor now has a new source of information. Please change the order cycle to only Mondays and the contact person to Miley Cyrus.
Answer UPDATE Vendor SET contact ='Miley Cyrus', order_cycle ='MON' WHERE vname ='Hasbro';
The OO Data Model is capable of exhibiting inheritance and supporting _______
Answer: encapsulation
A disjointness generalization constraint specifies which one of the following: A. An entity can be a member of more than one subtype B. An entity can be a member of at most one subtype C. An entity does not inherit from a superclass D. The union of the subtypes partially covers their supertype E. None of the above
B
Data Definition Language (DDL) consists of the SQL commands used to define a database including all of these except: A) Creating B) Modifying C) Altering D) Dropping tables E) Established constraints
B
Data Federation provides a virtual view of the data warehouse, creating a centralized database. What approach does it use? A. Push Approach B. Pull Approach C. Decentralized D. Full Update Strategy E. Real-time Data
B
Developed by ___ in 1976, ER is the most popular conceptual model in database design A. Michael Afton B. Peter Chen C. Jamie Vaughn D. Claire McField E. Paul Geller
B
Fill in the blank: In a table, a _______ represents data values describing a real-world entity instance or relationship instance, and a ________ represents a property or characteristic of an entity or relationship type of interest. a. Attribute; relation b. Tuple; attribute c. Primary key; domain d. Domain; values e. Relation; tuple
B
Metadata is also known as what? a. big data b. schema c. attribute d. syntax e. database
B
Multiple Choice: What does the abbreviation, XML, stand for? a. Xtreme Markup Language b. Extensible Markup Language c. Extra Manipulation Language d. Xtreme Manipulation Language e. Extended Marking Language
B
Object-oriented concepts combine data and behavior via ____? a. propagation b. encapsulation c. normalization d. interfacing
B
When creating a table, what does 'NOT NULL' imply? A. The record in the table is blank B. The record in the table must have a value in it C. Only numbers can be input into the record of the table D. You must leave this record blank, and update it later E. You do not care what is input in this record
B
When showing a Derived Attribute it is seen as a A. Solid Circle B. Dashed Circle C. Underline text only D. Bold Letters E. Double Circle
B
Which SQL constraints are used to uniquely identifies a row/record in another table? a. Unique b. Primary key c. Foreign key d. Index e. Distinct
B
Which of the following are not part of the security policies and procedures of data? A. Personnel controls B. Anti-theft controls C. Physical access controls D. Maintenance controls E. Data privacy controls
B
Which of the following best describes the purpose of the GROUP BY clause for sql statements? a. To list a certain attribute in ascending or descending order b. To aggregate records based on a specified column c. To list a condition for a specified column d. To split the data into groups based on a condition e. To build clusters based on algorithms for analysis
B
Which of the following best describes the role of a Database Administrator (DBA)? a. translates conceptual data model into a logical and internal data model b. responsible for the implementation and monitoring of the database c. develops database applications in a programming language such as Java or Python d. run the application to perform specific database operations. e. None of these describe a Database Administrator
B
Which of the following clauses forces the tuples resulting from a query to appear in a particular sorted order? a. SORT BY b. ORDER BY c. RULE BY d. GROUP BY e. LIST BY
B
Which of the following in an Entity Relationship Diagram is completely written with capital letters? a. Attributes b. Entity Types c. Relationship Types d. Multi-Valued Attributes e. Derived Attributes
B
Which of the following is the correct way to write a basic SQL structure? A. FROM WHERE SELECT B. SELECT FROM WHERE C. SELECT ORDERBY BY FROM WHERE D. WHERE FROM SELECT E. None of the above
B
Which security goal should ALH Enterprises focus on if their goal is to protect their data from unauthorized access? A. Integrity B. Confidentiality C. Compliance D. Diligence E. Availability
B
An entity type in an ER model is usually given a name (noun, singular, upper-case letters) and placed inside a ______. a) Circle b) Diamond c) Rectangle d) Hexagon e) None of the above
C
By using in your SQL query, you can get rid of duplicate results. a. SELECT EXACT b. SELECT MAX c. SELECT DISTINCT d. SELECT MIN e. A AND B
C
Cole Guerra
C
Multiple Choice: Which relationship type creates a new relation table? A. One-to-Many B. One-to-One C. Many-to-Many D. All of the above E. None of the above
C
Multiple Choice: What are three types of data integration approaches discussed in class? A. consolidation, federation, and propaganda B. limitation, normalization, and consolidation C. consolidation, federation, and propagation D. consolidation, propagation, and admiration E. propagation, innovation, and regulation
C
SQL offers a number of built-in functions EXCEPT: a. COUNT b. SUM c. MED d. MAX e. MIN
C
The six clauses of the SELECT statement must be coded in the following order: a. SELECT, FROM, GROUP BY, HAVING, WHERE, ORDER BY b. SELECT, FROM, WHERE, ORDER BY, GROUP BY, HAVING c. SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY d. SELECT, FROM ORDER BY, WHERE, GROUP BY, HAVING e. SELECT, WHERE, FROM, ORDER BY, GROUP BY, HAVING
C
There are different frameworks that categorize the different dimensions of data quality. Intrinsic is: A. Data in a certain context B. How data is represented C. Characteristics of data D. Data retrieval E. None of the above
C
What is a disadvantage of object oriented database design? A. More semantic information can be included. B. Complex objects are supported. C. There is no standard ad hoc query language. D. OODMBS can allow for a more realistic representation of real-world objects. E. Application development time is faster.
C
What is the advantage of an object-oriented database design? A. Inclusion of more semantic information in the database B. Permit the extensibility of base data types, thereby increasing both the functionality C. Both A and B D. Opposition from the firmly established RDBMSs E. None
C
What is the main difference between inner and outer join? A. Inner join and outer join combine 2 tables equally on a join condition B. Inner joins combines 2 tables on a join condition while outer join does not combine them on a join condition C. Inner join combines 2 tables fully on a join condition while outer join will keep the records of one table if the join condition is not met with the other table D. Inner Join and Outer Join will keep the records of one table when the join condition isn't met of the other table E. None of the above
C
When creating a database, which of the fields do not require the use of quotation marks? A. Char B. Varchar C. Integer D. Date E. Time
C
When using order by function, where do you put the group by function? A. Before the order by B. After the order by C. You don't need a group by function D. Order by needs to be used in a subquery E. Group by and order by need to be used in a subquery
C
Which of the following is NOT a characteristic of business rules? A. Declared to control/influence business behavior B. Expressed in terms familiar to end users C. Created solely by upper management D. Automated through DBMS software E. Consisting of data name and data definition
C
Which of the following is a way data could be misused? A) Using SQL to analyze and draw conclusions from the data B) Assuring results are statistically significant C) Ignoring results that are counter intuitive D) Discussing the data with well-informed individuals E) Creating visual descriptions of the data
C
Which of the following is not an example of security policies and procedures? A. Personnel controls B. Physical access controls C. Data Sharding D. Maintenance controls E. Data privacy controls
C
Which of the following is the correct definition of Inheritance within Database Design? A. An object within the hierarchy that is ready to become the king when the old king is gone B. Receiving money or valuables from a family member when they pass away. C. The ability for an object within the hierarchy to inherit data from the class above it. D. The inclusion of more semantic information in a database E. An object that avoids the join operator
C
Which of the following would be classified as a property or characteristic of an entity type or relationship type that is of interest to the organization? A. Entity Type B. Relationship Type C. Attribute D. Instance E. Degree
C
Which of these speakers did we not watch regarding the Dark Side of Data? A. Jennifer Golbeck B. Malte Spitz C. Tim Smith D. Alessandro Acquisti E. Ben Goldacre
C
Within the XML formatting rules, how many root elements can there be? a. 5 b. 4 c. 1 d. 12 e. 20
C
Write a query to pull all attributes for everyone from a Student table with an Address that includes 'Maryland'. a. SELECT ALL Student WHERE Address = 'Maryland'; b. SELECT FROM Student WHERE Address LIKE '..Maryland..'; c. SELECT * FROM Student WHERE Address LIKE '%Maryland%; d. SELECT Student WHERE Address LIKE 'Maryland'; e. SELECT * FROM Student WHERE Maryland = 'Address'
C
___ Which of the following are NOT causes of poor data quality? A) Duplicates data B) Ambiguous data C) Unique data D) Inconsistency E) None of the above
C
What are some of the dark sides to big data?
Confidentiality, privacy, and anonymity
A good business rule is A. Business-oriented B. Declartive and Precise C. Atomic and distinct D. All of the above E. None of the above
D
Data Definition Language (DDL) consists of the SQL commands are used to define a database, including A. Creating B. altering C.A & B D. All E. None
D
Data Manipulation Language (DML) is: a. command that visualizes a database b. command that controls a database c. command that define a database d. command that maintain and query a database e. command that simplifies a database
D
Each of the following are security measures against application issues EXCEPT: A. Test Application Programs B. Building safeguards into the code C. Spam Filtering D. Better Training E. Educating the Users
D
LDA is a method of semantic analysis that extracts themes from a dataset and utilizes topic models. It stands for which of the following: A. Local Data Access B. Latent Digital Allotment C. Linear Direction Allocation D. Latent Dirichlet Allocation E. Leading Dimension Assessment
D
What does a well-designed database do? A. Facilitates data management B. Write queries C. Generates accurate and valuable information D. A and C E. B and C
D
When creating a SQL query, you are worried about duplicate results. What command should you add to your code to ensure this doesn't happen? A) INNER JOIN B) SUM C) DELETE CASCADE D) DISTINCT E) COUNT
D
Which SQL constraint uniquely identifies a row/record in another table? A. NOT NULL B. DEFAULT C. UNIQUE D. FOREIGN KEY E. PRIMARY KEY
D
Which choice is not part of SQL constraints? a. UNIQUE b. NOT NULL c. PRIMARY KEY d. CREATE e. DEFAULT
D
Which of the following best describes the term compliance with regards to data security goals? a. Protecting data against unauthorized access b. Keeping data consistent and free of errors or anomalies c. Accessibility of data whenever required by authorized users d. Activities that meet data privacy and security reporting guidelines e. Maintaining the size of data on a cloud platform
D
Which of the following is NOT considered a database security feature? a. Integrity controls b. Authorization rules c. Encryption d. Data safe connect e. All of the above can be considered database security features
D
Which of the following is not a part of the security policies and procedures? a. Personnel controls b. Data privacy controls c. Physical access controls d. Data leak controls e. Maintenance controls
D
Which of the following is not an aggregation function in SQL? A. SUM() B. COUNT() C. AVG() D. GETDATE() E. MAX()
D
Which of the following is true about Completeness and Consistency Checks? A. All entity types have a key attribute (identifier) B. All relationship types connect entity types C. All relationship types' names are unique D. All are correct .E. None
D
___ Which of the SQL command(s) would you use to eliminate duplicate rows and display a unique list of values for "Names"? A) SELECT DISTINCT Names B) GROUP BY Names C) DELETE FILES DUPLICATE Names D) Both A and B E) None of the above
D
Which of the following is NOT part of Representation in Data Quality Dimensions? A. Interpretable B. Easily-understandable C. Concisely represented D. Objectivity E. Consistency
D?
______________ consists of the SQL commands used to define a database, including Creating, altering, dropping tables and established constraints.
Data Definition Language
______ ______ is the ability of an object to hide data from other objects.
Data Hiding
Describe the differences between the three techniques for data integration
Data consolidation- Consolidate all data into a centralized database (like a data warehouse) Data federation- Provide a virtual view of data without actually creating one centralized database Data propagation- Duplicate data across databases, with near real-time delay
Which one is data, and which one is information? Products in the store supplied by 37 vendors Price of the products ranges from $5 to $300
Data, Information
______ is data that suffer from inaccuracies and inconsistencies.
Dirty
Problems of using a File system are mentioned below EXCEPT? A. Data Inconsistency B. Data Redundancy C. Limited Data Integration D. Ineffective/inefficient System Maintenance E. Easy for data querying and retrieval
E
Query processor assists in the execution of database queries such as a. retrieval of data b. insertion of data c. update of data d. removal of data e. all of the above
E
What are the 3 ETL Activities? A.Extract data, Take out data, Unload transformed data B. Extract data, Transform data, Lose all data C. Extract computer , Transform data, Load transformed data D. Transform data, Extract data, Do not transform data E. Extract data, Transform data, Load transformed data
E
What are the rules of ER modeling? A. Each entity type should have more than one attributes B. Each statement in the specification should be located in the ERD. C. Each ERD construct should be located somewhere in the requirement specification. D. No duplicated entity or relationship name. E.All of the above
E
What does a Data Definition Language consist of: A. Creating Tables B. Altering Tables C. Dropping Tables D. Establishing Constraints E. All of The Above
E
What does a dotted ellipse represent in an ER-Diagram? A. Unique key attribute B. Primary key attribute C. Foreign key attribute D. Multi-valued attribute E. Derived attribute
E
What is Data Governance used for? A. Improve data capture process B. Perform data quality audit C. Establish data stewardship program D. Apply total quality management (TQM) practices E. All of the above
E
Which choice is not a characteristic of an Objected-Oriented Data Model? a. Support the representation of complex objects b. Capable of defining new data types as well as the operations to be performed c. Support encapsulation d. Exhibit inheritance e. Support a combination of a start tag, content and end tag
E
Which is an importance of data models? A. A communication tool B. Give an overall view of the database C. Organize data for various users D. Are an abstraction for the creation of good database E. All of the above
E
Which is not a PRO of Data Federation? A. Data always current when requested. B. Works well for read-only applications because only requested data needs to be retrieved. C. Ideal when copies of source data are not allowed. D. When data integration needs cannot be anticipated. E. Heavy workloads possible for each request due to performing all integration tasks for each request.
E
Which of the following are causes of poor data quality? A. Multiple data sources B. Volume of data C. Lack of organizational commitment D. Limited computing resources E. All of the above
E
Which of the following are not part of security goals with data? a. Confidentiality b. Compliance c.Integrity d. Availability e. Cultural
E
Which of the following is NOT a key characteristic of a database? A. Self-describing collection of data B. Related data C. Integrated data D. Shared data E. Interactive data
E
Which of the following is NOT a security vulnerability regarding application issues? a. Bugs b. SQL injection c. Social engineering d. Non-validated inputs e. Packet sniffers
E
Which of the following is the correct way to identify the primary key in MySQL? a. Prj_No char(3) primary key b. Prj_No char(3) DEFAULT= 'primary key' c. CONSTRAINT PK_Project primary key(Prj_No) d. Prj_No char(3) references primary key e. Both a. and c.
E
Which of the following is true regarding naming a constraint, rather than leaving it anonymous? a) It would be difficult to modify a constraint in the future if it is not named b) If a query (insert, update, delete) violates a constraint, SQL will generate an error message that will contain the constraint name c) The error message will be easier to understand if the constraint name is clear and descriptive d) When a constraint is created without a name, the DBMS will assign one e) All of the above
E
Which one of the following are different joining keywords in SQL? A. INNER JOIN B. LEFT JOIN C. RIGHT JOIN D. FULL OUTER JOIN E. All of these are JOIN keywords in SQL
E
Which symbol have we not used in this class to notate an ERD? A. Rectangle B. Ellipse C. Diamond D. Upside-down Triangle E. Trapezoid
E
____ is defined as the ability to hide the object's internal details, including its attributes and methods.
Encapsuation
A person, place, item, event, or concept about which we want to preserve data is referred to as an .
Entity
Causality - Cannot be explained, or rationalized by "theories" T/F
F
Consistency checks require that all relationship types and attribute names are not unique. T/F
F
Data consolidation provides a virtual view of data without creating one centralized database. T/F
F
Function like calculate average and maximum price for product can be included in ER diagram? T/F
F
Legal Values and temporal constraints can be included/modeled in ER models. T/F
F
T/F - A multi-valued attribute is signified by a dotted ellipse, while a derived attribute is shown through a double-lined ellipse.
F
T/F when creating a logical schema multi-valued attributes don't get their own table.
F
T/F: An example of a business rule would be, "Friday is business casual dress day."
F
T/F: Data insufficiency is a major problem of the file-processing approach.
F
T/F: The only operator that can signify Not equal to is "!=".
F
T/F: Variable Character Field is a set of character data of determinate length
F
To transform a 1-to-1 relationship type, a new relation is created with both primary keys as foreign keys in the new relation. T/F
F
True or False: In SQL, char(50) and varchar(50) are exactly the same.
F
___ (T/F) Two entities can't have more than one type of relationship between them.
F
True or False: A server is any process that requests specific services from server processes.
F, Client
True or False: The difference between an entity and an object, is an object has data components and relationships, but lacks manipulative ability.
F, Entity
T/F An entity type is represented by a diamond shape in an ERD.
F, Rectangle
True or False: A client is a process that provides requested services for clients.
F, Server
T/F: Data is a set of values of qualitative variables.
F, quantitative and qualitative
True or False: Security goals include confidentiality, compliance, integrity, availability, and accuracy.
F; accuracy is not one of the goals
True or False: XML is not case-sensitive.
FALSE
(T/F) Data includes raw facts, are building blocks of information, and enables knowledge creation.
False
Define what grouping is and what other clause is used in conjunction with it.
Grouping uses the GROUP BY clause to rearrange the results into groups. Those groups are attribute(s) given in the GROUP BY clause and used to form groups and tuples with the same value on all attribute(s) in the GROUP. The HAVING clause is used in conjunction with GROUP BY for retrieving groups that satisfy certain conditions.
What are the four different dimensions of data quality?
Intrinsic, Contextual, Representation, Access
Using the order_management database, List the order number, shipping date, status and shipping address for orders that were shipped to California. Please list the possible columns needed.
O_No, Ship_Date, Ship_Addr, Status
A single teacher can teach multiple classes would best fit which cardinality?
One-to-Many
A one-to-one relationship type can be viewed as a special case of ________ relationship type.
One-to-many
Data profiling needs to be completed ____________.
Periodically
Describe at least four examples of DMBS Interface
Possible answers: Web-based interface, stand-alone query language interface, command line interface, forms-based interface, graphical user interface, natural language interface, admin interface, network interface
Fill in the Blank: Subqueries are an alternate way of _________ data from multiple tables.
Returning
Which SQL statement is used to extract data from a database? a. WHERE b. FROM b. INSERT d. GROUP BY e. SELECT
SELECT
Get customer ID and names from customer which city should only match with San Diego
SELECT Customer_ID, Customer_Name FROM Customer WHERE City = 'San Diego';
Using the order_management database, list the customer's name as 'Customer Name' and count of orders as 'Number of Orders Placed' who paid with a VISA and has shipped status.
SELECT Customer_Name AS 'Customer Name', COUNT(O_No) AS 'Number of Orders Placed' FROM customer INNER JOIN porder WHERE customer.Customer_ID = porder.Customer_ID AND payment = 'VISA' AND Status = 'shipped' GROUP BY Customer_Name HAVING COUNT(O_No);
List all the customers who made more than one purchases. Also show numbers of times they have purchased. Sort the result by the number of order in descending order.
SELECT Customer_Name as "Customer", count(O_No) as "Number of Orders" FROM customer INNER JOIN Porder ON customer.customer_id = Porder.customer_id GROUP BY customer_name HAVING count(O_no) > 1 ORDER BY count(O_No) DESC;
For each order containing more than two products, retrieve the order number and the number of products in the order.
SELECT O_No, COUNT(Product_id) FROM Order_Detail GROUP BY O_No HAVING COUNT(Product_id) > 2;
Using the Order Management database, what is the SQL statement that will retrieve all order numbers, order dates, and order status for those submitted by either customer 10022 or customer 10010?
SELECT O_no, Order_Date, Status FROM Porder WHERE Customer_ID = '10022' OR Customer_ID = '10010';
Using the Order Management database, query a list of names of products made by Hasbro that are active and have been put on promotion.
SELECT Product_Name FROM Product INNER JOIN Promotion ON Product.Product_ID=Promotion.Product_ID INNER JOIN Vendor ON (Product.VID = Vendor.VID) WHERE VName = 'Hasbro' AND Product.Status = "active";
Using the order management database; List the total number of products supplied by vendor 'MANLEY'
Select Count(*) From Product, Vendor Where Product.Vid=Vendor.Vid And VName='MANLEY';
Give an example of a supertype and subtype.
Supertype: Vehicle Subtypes: Motorcycle, Bus, Limo
% Matches Any Substring, And _ Matches Any (Single) Character
T
(T/F) One important component of DBMS is the query processor that takes care of the actual execution of queries by calling on the storage manager to retrieve the data requested.
T
(T/F) The right outer join and left outer join operators can be used interchangeably as long as the correct table is named.
T
INSERT INTO Inventory (Quantity, Stack_No, Product_ID) VALUES (9, '0011','A002'); And INSERT INTO Inventory VALUES ('0011','A002',9); These two statements do the same thing: T/F
T
T/F - A subtype does not have its own primary key, since it is inherited from the supertype.
T
T/F - A subtype entity inherits values of all attributes of the supertype
T
T/F : A class is a collection of similar objects with shared structure (attributes) andbehavior (methods)
T
T/F : Data can be seen as stored representations of objects or events.
T
T/F : SQL stands for Structured Query Language.
T
T/F Subtypes are able to have relationships with other subtypes
T
T/F When creating a logical schema where an entity has a multi-valued attribute, create a new table that Includes the primary key from the original table and the multi-valued attribute. List both as primary keys in the new table.
T
T/F When using federation as a data integration technique all data is stored without actually creating one centralized database.
T
T/F: A class can be viewed as a template that can be used to create/instantiate objects of the same type.
T
T/F: A one-to-many cardinality is where entity A is associated with any number of entities in B and an entity B is associated with at most one entity in
T
T/F: Accuracy is the extent to which data is certified, error-free, correct, flawless and reliable
T
T/F: An example of information is "On average, 52 customers come to the store every day, and about 30% will purchase something."
T
T/F: Applications and databases traditionally are organized around domains such as accounting, human resources, logistics and CRM.
T
T/F: Both queries generates the same results. SELECT * FROM promotion INNER JOIN product ON (product.product_id=promotion.product_id) WHERE Product_Name = 'Christmas Tree'; SELECT * FROM promotion, product WHERE (product.product_id=promotion.product_id) AND Product_Name = 'Christmas Tree';
T
T/F: Data consolidation involves ETL activities.
T
T/F: Data includes raw facts, building blocks of information, and data management.
T
T/F: Information should be accurate, timely, and relevant to enable good decision making
T
T/F: Metadata, also referred to as schema, is data about data?
T
T/F: Security Policy is the Collection of standards, policies, and procedures created to guarantee Security.
T
T/F: Subquery can be used as a comparison value and temporary table
T
T/F: The Entity Relational Diagram contains an entity type, a relationship type, and its respective attributes.
T
T/F: Using virtual private networks (VPNs) can prevent network issues
T
T/F: You must use quotation marks for the date datatype in MySQL.
T
TRUE or FALSE: The following SQL commands are in correct order: select, from, where, group by, having, order by.
T
To manage and safeguard data quality a data governance culture should be put in place assigning clear roles and responsibilities. T/F
T
True or False, there are at least 2 ways to write an Inner Join statement that will result in the same table.
T
True or False- You can use IS NULL or NOT NULL in the WHERE clause.
T
True or False: A database is a collection of related data items within a specific business process or problem setting.
T
True or False: Database is a superior approach to the file system.
T
True or False: XML data is hierarchically structured.
T
True/False: Data consolidation pushes all data into a centralized database similar to a data warehouse.
T
True/False: SQL has become the de facto standard language for creating and querying relational databases.
T
True/False: The HAVING clause can only appear in conjunction with a GROUP BY clause.
T
True or False: The purpose of a database is to store, manipulate, and retrieve data in organizations.
TRUE
What will the following SQL command result in once executed? SELECT * FROM Porder WHERE Order_Date > '2022-08-30' AND Order_Date < '2022-11-30';
The SQL command will retrieve all the information from the product order(s) that have been submitted between August 30th, 2022 (08/30/2022) and November 30th, 2022 (11/30/2022).
Explain what does the following SQL command will result in once executed? SELECT * FROM Product WHERE VID = 'V004' AND MSRP > 20
This SQL command will select everything the from the Product table where the vendor id number is 'V004' and the MSRP is greater than $20.
Because SQL-DML does not enforce implicit duplication elimination, you must specify which clause after the SELECT statement? Describe the syntax.
To enforce the elimination of duplicates, we need to explicitly specify DISTINCT after SELECT. The syntax is: SELECT DISTINCT columns A1, A2, ..., Aₙ FROM table WHERE condition
(T/F) Data includes raw facts, are building blocks of information, and includes data management (generation, storage, and retrieval of data).
True
An entity has data components and relationships but lacks manipulative ability.
True
Metadata refers to data that describes important properties, characteristics, or structure of the data of interest.
True
True/False: In a logical schema, the columns are known as attribute and the rows are known as tuples.
True
When converting an ER diagram into logical schema, list a composite attributes by its sub attributes. True False
True
The class describes a ______ of object.
Type
The company recently received ready-to-sell products by Bananagrams. Please update the status of the products by Bananagrams from "inactive" to "active" in order to become available. (Use the order_management database)
UPDATE Product SET Status = 'Active' WHERE VID = (SELECT VID FROM Vendor WHERE VName = 'Bananagrams');
A Combination of a start tag, content and end tag is called a(n) __________.
XML element
A person responsible for ensuring that organizational applications properly support the organization's enterprise goals is a ____ _______.
data steward
In a disjoint specialization, an entity can be a member of at most one subtype of the specialization relationship.
disjoint
Data quality determines the ______ of the data to the business.
intrinsic value
When working in MySQLWorkbench, you must ____________ the schemas section in order to see any new tables you may have created.
refresh
