< > The SQL statement: CREATE VIEW Example3 AS SELECT * FROM Invoices; will crea

Question

< >

The SQL statement:

CREATE VIEW Example3

AS

SELECT *

FROM Invoices;

will create an updatable view

will create a read-only view

will fail because the * operator isn’t allowed

will create a view through which you can delete rows, but not insert or update rows

Given the following DECLARE and FETCH code, what row will be retrieved from the cursor?

DECLARE Sample_Cursor CURSOR

STATIC

FOR SELECT * FROM Sample;

FETCH ABSOLUTE 4 FROM Sample_Cursor;

The 1st row

The 4th row from the current row

The 4th row from the top

The 4th row from the bottom

will create an updatable view

will create a read-only view

will fail because the * operator isn’t allowed

will create a view through which you can delete rows, but not insert or update rows

Explanation / Answer

1.It will create a read-only view. We can do modifications to the view only not to the original table.

2. When you're using a cursor in SQL you use the FETCH statement to move the cursor to a particular record. So here answer will be the 4th row from the current row.

Related Questions

Navigate

• Browse (All)
• Browse #
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.