R

Ram Sharma • 193.86K Points
Coach 

Q. Syntax for creating views is __________

  • (A) CREATE VIEW AS UPDATE
  • (B) DROP VIEW AS SELECT
  • (C) CREATE VIEW AS UPDATE
  • (D) CREATE VIEW AS SELECT
  • Correct Answer - Option(D)
  • Views: 116
  • Filed under category SQL Server

No solution found for this question.
Add Solution and get +2 points.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Be the first to start discuss.

Related MCQs on SQL Server

Q. To display all the view in SQL 2005 to launch …… expand the database, system database & select master, view system view.

Q. Ctrl+K+K shortcut refers to ___________

Q. You want to track date and time of the last write access per row. Select the suitable option among the below.

Q. Which are the SQL Server 2008 R2 components require space more than 1.5 Gb?

Q. Find all the tuples having a temperature greater than ‘Paris’.

Q. Model database is

Q. Which of the following shortcut is used for displaying error list?

Q. Why type of user is the default in sql server?

Q. The supported storage types for data files are ___________

Q. For every unique constraint on a column, SQL server will create

Learn All SQL Server MCQs

Question analytics