Answer:
View Base tables: Virtual table based on a SELECT query
CREATE VIEW statement: Data definition command that stores the query specification in the data dictionary
DROP VIEW statement: Data definition command that removes the query specification in the data dictionary
Explanation:
Views are virtual tables, which can be created by select queries using the real database tables.
Creating and dropping views can be done by the CREATE VIEW and DROP VIEW statements.
<u>CREATE VIEW syntax:</u>
CREATE VIEW view_name AS
SELECT column1, column2, ...
FROM table_name
WHERE condition;
<u>DROP VIEW syntax:</u>
DROP VIEW view_name;
The fraction of shipments that will be accepted is 0.1299.
<h3>
How to calculate the probability?</h3>
Probability of a defective DVD = 0.04
Using Binomial distribution,
Fraction of shipments accepted = Probability of zero defects in sample of 50 = P(X = 0)
= 50C0 * 0.040 * (1 - 0.04)⁵⁰
= 0.96⁵⁰
= 0.1299
Fraction of shipments accepted = Probability of zero or one defects in sample of 50 = P(X = 0) + P(X = 1)
= 50C0 * 0.040 * (1 - 0.04)50-0 + 50C1 * 0.041 * (1 - 0.04)50-1
= 0.9650 + 50 * 0.04 * 0.9649
= 0.4005
Learn more about probability on:
brainly.com/question/24756209
#SPJ1
What fair use exceptions are you talking about? There are thousands on fair use exceptions.
Answer:
Mail merge lets you create a batch of documents that are personalized for each recipient. For example, a form letter might be personalized to address each recipient by name. A data source, like a list, spreadsheet, or database, is associated with the document.