Explain what are the restrictions that views have to follow? : sql server architect
- 1 Answers
- 914 Views
- I also Faced
- E-Mail Answers
Answer / Ram Narayan Prajapati
"Views in SQL Server have several restrictions, including: 1) They cannot contain multiple SELECT statements or UNION operators. 2) They cannot modify data (INSERT, UPDATE, DELETE), although they can be used in these statements as a source for data manipulation. 3) They cannot be indexed directly, but indexes can be created on underlying tables that the view references. 4) They cannot contain subqueries within SELECT statements, though you can use them in FROM clause of subqueries."n
| Is This Answer Correct ? | 0 Yes | 0 No |
What is DDL Interpreter?
Explain about the implementation of stored procedures?
What do you know about system database? : sql server architect
What is internal database?
How does Tuple-oriented relational calculus differ from domain-oriented relational calculus
What is E-R model?
What are data segments?
What does n tier mean?
What is database architecture?
What are page splits? : sql server architect
Explain the benefits of running stored procedure on a database engine?
What is BCNF (Boyce-Codd Normal Form)?
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
