|
.NET SELF ASSESSMENT TEST
1)Write an sql query to get an accurate count
of the number of records in a table.
2)What is
difference between DELETE & TRUNCATE commands?
3)List few advantages of Stored Procedure.
4) The command to remove rows from a table
'CUSTOMER' is:
(a) REMOVE
FROM CUSTOMER ...
(b) DROP
FROM CUSTOMER ...
(c) DELETE
FROM CUSTOMER WHERE ...
(d) UPDATE
FROM CUSTOMER ...
5)The SQL WHERE clause:
(a) limits the column data
that are returned.
(b) limits the row data are returned.
(c) Both A and B are correct.
(d) Neither A nor B are correct.
6)
A view is which of the following?
(a) A virtual table that can be
accessed via SQL commands
(b) A virtual table that cannot accessed via SQL commands
(c)
A base table that can be accessed via SQL commands
(d)
A base table that cannot be accessed via SQL commands
7)Write
an SQL Query to find names of employee start with ‘S’.
(8)In which
case would you use a FULL OUTER JOIN?
A) Both tables have NULL values.
B) You want all unmatched data from one table.
C) You want all matched data from both tables.
D) You want all unmatched data from both tables.
E) One of the tables has more data than the other.
F) You want all matched and unmatched data from only one table.
|
(10)Which two
statements about views are true? (Choose two.)
A) A view can be created as read only.
B) A view can be created as a join on two or more tables.
C) A view cannot have an ORDER BY clause in the SELECT statement.
D) A view cannot be created with a GROUP BY clause in the SELECT
statement.
|
|
|
|
|
|
|
No comments:
Post a Comment