Bissoy.com
Doctors Medicines MCQs Q&A

In SQL, the ____ command is used to recompile a view

In SQL, the ____ command is used to recompile a view Correct Answer CRFATE VIEW

In SQL, a view is a virtual table based on the result - set of an SQL statement. A view always shows up - to - date data! The database engine recreates the data, using the view’s SQL statement, every time a user queries a view.

Related Questions

In SQL, the ___ command is used to recompile a view.
In SQL, the _____ command is used to recompile a view
Which of the following command(s) is(are) used to recompile a stored procedure in SQL?
You are the administrator of a SQL Server 2000 computer. The server contains a database named FinanceData that is used by a client/server application. Each employee has a SQL Server login that the application uses to access the server.Your company hires a new employee named Andrew. You create a SQL Server login named Andrew. You also create a database user named Andrew in the database and grant the database user full permissions in the database.Whenever Andrew runs the client/server application, he receives the following error message: "Invalid object name." Andrew also reports that he cannot access the database by using the application.You need to ensure that Andrew can use the application. Which Transact-SQL statement should you execute?
SQL view is said to be updatable (that is, inserts, updates or deletes can be applied on the view) if which of the following conditions are satisfied by the query defining the view?
An object is kept in one of the quadrants of principal planes of projection, for the front view the view is first and object is next and for top view the object came first and then the view on plane (the observer is at top right side of principal planes). The object is in which quadrant?
If a point P is placed in between the projection planes. The distance from side view to reference line towards front view and the distance between top view and reference line towards top view will be same.
If a point P is placed in between the projection planes in third quadrant. The distance from side view to reference line towards front view and the distance between top view and reference line towards top view will be same.
If a point P is placed in between the projection planes. The distance from side view to reference line towards the front view and the distance between the top view and reference line towards the top view will be different.
Which of the following statements are TRUE about an SQL query? P: An SQL query can contain a HAVING clause even if it does not have a GROUP BY clause Q: An SQL query can contain a HAVING clause only if it has a GROUP BY clause R: All attributes used in the GROUP BY clause must appear in the SELECT clause S: Not all attributes used in the GROUP BY clause need to appear in the SELECT clause