- The WITH ENCRYPTION clause A) prevents a row in a view form being updated if that would cause the row to be excluded from the view B) protects a view by binding it to the database structure C) prevents underlying base tables from being deleted or modified in any way that affects the viewD) prevents other users from examining the SELECT statement on which the view is based
- All of the system objects that define a database are stored in what?A) system catalog B) catalog view C) information schema view D) derived view
- The SELECT statement for a view A) can't use an ORDER BY clause B) can include the INTO keywordC) can use the ORDER BY clause if it also uses the TOP clause D) cannot use the ORDER BY clause with the OFFSET and FETCH clauses
- The WITH ENCRYPTION clause of the CREATE VIEW statement A) prevents users from modifying the viewB) prevents users from seeing the code that defines the view C) prevents users from using the view without the appropriate authorization D) causes the data that's returned by the view to be encrypted
- To delete an existing view, you use which statement? A) CREATE VIEW B) ALTER VIEWC) DROP VIEW D) DELETE VIEW
- Evolution of the Southern strategy in the 1970s and 1980s - be able to describe and explain Reagan years and Lee Atwater
- The WITH CHECK OPTION clauseA) prevents a row in a view form being updated if that would cause the row to be excluded from the view B) protects a view by binding it to the database structure C) prevents underlying base tables from being deleted or modified in any way that affects the view D) prevents other users from examining the SELECT statement on which the view is based
- To select the columns for a view, you would use what? A) SQL pane B) Results paneC) Diagram pane D) Criteria pane
- A table that's used to create a view is called a what? A) viewB) base C) temporary D) OFFSET
- The WITH CHECK option of the CREATE VIEW statement A) prevents users from using the view without the appropriate authorizationB) prevents an update from being performed through the view if it causes a row to no longer be included in the view C) prevents rows from being deleted through the view D) prevents rows from being inserted through the view
- One way to examine the system objects that define a database is to use which views?A) catalog B) base C) derived D) none of the above
- To modify an existing view, you use which statement?A) UPDATE B) WITH SCHEMABINDING C) CREATE VIEWD) ALTER VIEW
- The statementCREATE VIEW Example2ASSELECT InvoiceNumber, DATEDIFF(day,InvoiceDate,InvoiceDueDate)FROM Invoices; A) will create an updatable view B) will create a read-only view because of a calculated valueC) will fail because the second column isn't named D) will create a view through which you can delete rows, but not insert or update rows
- Each of the following is a benefit provided by using views except for one. Which one? A) You can simplify data retrieval by hiding multiple join conditions. B) You can provide secure access to data by creating views that provide access only to certain columns or rows.C) You can create a view that simplifies data insertion by hiding a complex INSERT statement within the view. D) You can create custom views to accommodate different needs.
- The WITH SCHEMABINDING clause of the CREATE VIEW statement A) protects the view by binding it to the database schema B) prevents the tables that the view is based on from being deleted C) prevents the tables that the view is based on from being modified in a way that affects the viewD) all of the above
- A view is a/an ________________ statement that's stored as an object in the database.A) SELECT B) UPDATE C) INSERT D) DELETE
- The statementCREATE VIEW Example3ASSELECT *FROM Invoices;A) will create an updatable view B) will create a read-only view C) will fail because the * operator isn't allowed D) will create a view through which you can delete rows, but not insert or update rows
- How did Democrats respond to the Southern Strategy? Success?
- Which guideline applies to racks and network components? A) Material Baseline Security Analyzer (MBSA)B) Material safeties data sheet (MSDS) C) Memorandum of understanding (MOA) D) Statement of work (SOW)
- Which term refers to physically separating your network from every other network? A) Secure Web B) Isolation C) Black holeD) Air gap