question archive True or False: I can use views to hide certain rows or columns from users of a database
True or False: I can use views to hide certain rows or columns from users of a database
Subject:Computer SciencePrice: Bought3
True or False: I can use views to hide certain rows or columns from users of a database.
True or False: The DELETE statement deletes a table from the database.
Within a CREATE statement, what type of constraint would I use to ensure that a column was formatted in the correct manner?
NULL
NOT NULL
UNIQUE
CHECK
None of the above
Consider the following Bulk Insert statement.
INSERT INTO CUSTOMER
(CustomerID, LastName, FirstName, Address, Phone, Email, OrderID)
SELECT CustomerID, LastName, FirstName, Address, Phone, Email, OrderID
FROM IMPORTED_CUSTOMERS
WHERE LastName like '%S%';
True or False: The above INSERT statement will fail because I can only insert one row at a time into the CUSTOMER table
