Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

MySQL Certification Views

memorize.ai (lvl 286)

(0)

11 cards

()

Section 1

Preview this deck

An UPDATE to an existing row is allowed only if the WHERE clause remains true for the resulting row. An INSERT is allowed only if the WHERE clause is true for the new row.

Front

1 / 11

SQL

0.0

0 reviews

5			0
4			0
3			0
2			0
1			0

Active users

All-time users

Favorites

Last updated

6 years ago

Date created

Mar 1, 2020

Cards (11)

Section 1

(11 cards)

An UPDATE to an existing row is allowed only if the WHERE clause remains true for the resulting row. An INSERT is allowed only if the WHERE clause is true for the new row.

Front

Using the WITH CHECK OPTION on a view

Back

Both, like they are and'ed together.

Front

If a view has a where clause in the create and the select of the view has a where clause which is used.

Back

Undefined, Merge, and Temptable

Front

What are the 3 view algorithms

Back

You must have drop permission

Front

To have the with replace or alter view you must have what permission besides create view

Back

undefined

Front

If no algorithm is chosen for a view which one is default

Back

SELECT * FROM INFORMATION_SCHEMA.VIEWS -> WHERE TABLE_NAME = 'CityView' -> AND TABLE_SCHEMA = 'world'\G

Front

What table can you query to get information about tables?

Back

The create order by view is ignored and the select order by is used.

Front

If a view has an order by in the create view and an order by in the select From view, which is used?

Back

CREATE [OR REPLACE] [ALGORITHM = algorithm_type] VIEW view_name [(column_list)] AS select_statement [WITH [CASCADED | LOCAL] CHECK OPTION]

Front

What is the syntax of create view

Back

Checks if a view still references valid tables

Front

Check table does what?

Back

True

Front

TempTable algorithm for views make the view unupdateable

Back

DROP VIEW [IF EXISTS] view_name [, view_name] ... ;

Front

What is the view drop syntax?

Back