27879617
Descrição
Quiz por Kyle Peterson, atualizado more than 1 year ago
|
Criado por Kyle Peterson
quase 4 anos atrás
|
|
Questão 1
Questão
The special operator used to check whether an attribute value matches a given string pattern is __________.
Responda
-
BETWEEN
-
IS NULL
-
LIKE
-
IN
Questão 2
Questão
The SQL aggrergate function that gives the number of rows containing non-null values for a given column is ____________.
Responda
-
MIN
-
MAX
-
SUM
-
COUNT
Questão 3
Questão
Which one of the following will be useful if there is a need to step through rows forward and backward?
Responda
-
Stored Procedure
-
Cursor
-
Trigger
-
Index
Questão 4
Questão
Which one of the following is essentially virtual tables?
Responda
-
Cursor
-
View
-
Trigger
-
Stored Procedure
Questão 5
Questão
You can use a stored procedure that returns information from base tables that you do not have permission on.
Responda
- True
- False
Questão 6
Questão
The WITH ENCRYPTION clause of the CREATE VIEW statement
Responda
-
prevents users from modifying the view.
-
prevents users from seeing the code the defines the view.
-
prevents users from using the view without the appropriate authorization.
-
causes the data that's returned by the view to be encrypted.
Questão 7
Questão
The statement
CREATE VIEW Example4
AS
SELECT *
FROM Invoices JOIN Vendors ON Invoices.VendorID = Vendors.VendorID
WHERE InvoiceTotal - PaymentTotal - CreditTotal > 0;
Responda
-
will create an updatable view
-
will create a read-only view
-
will create a view through which you can update or insert rows, but not delete rows
-
will fail because the SELECT statement returns two columns named VendorID
Questão 8
Questão
A table that's used to create a view is called
Responda
-
a view table
-
a temporary table
-
a base table
-
an OFFSET table
Questão 9
Questão
Each of the following is a benefit provided by using views except for one. Which one is it?
Responda
-
You can simplify data retrieval by hiding multiple join conditions.
-
You can provide secure access to data by creating views that provided access only to certain columns and rows.
-
You can create a view that simplifies data insertion by hiding a complex INSERT statement within the view.
-
You can create custom views to accommodate different needs.
Questão 10
Questão
A view
Responda
-
is like a virtual table
-
consists only of the rows and columns specified in its CREATE VIEW statement
-
doesn't store any data itself
-
All of the above (a, b, and c)
-
Only statements a and b are correct
-
Only statements a and c are correct
Questão 11
Questão
The statement
CREATE VIEW Example1
AS
SELECT VendorName, SUM(InvoiceTotal) AS SumOFInvoices
FROM Vendors JOIN Invoices ON Vendors.VendorID = Invoices.VendorID
GROUP BY VendorName
ORDER BY VendorName;
Responda
-
will fail because the GROUP BY clause isn't allowed in this view
-
will fail because the column alias SumOfInvoices is invalid
-
will fail because the ORDER BY clause isn't allowed in this view
-
will succeed
Questão 12
Questão
If you delete a stored procedure, function, or trigger and then create it again
Responda
-
you delete the tables on which the object is based
-
you disable access to the tables on which the object is based
-
you delete the security permissions assigned to the object
-
none of the above
Questão 13
Questão
Each of the following statements about triggers is true except for one. Which one?
Responda
-
A trigger can't be directly called or invoked.
-
A trigger doesn't accept input or return output parameters.
-
A trigger can have more than one batch.
-
The code of a trigger can execute in place of the action query to which it's assigned.
Questão 14
Questão
Which statement can you use to manually raise an error within a stored procedure?
Responda
-
THROW
-
ERROR
-
TRY
-
RAISE
Questão 15
Questão
Which of the following statements calls the stored procedure and passes the values '2019-10-01' and 122 to its input parameters/
CREATE PROC spInvoiceTotal1
@DateVar smalldatetime
@VendorID int
AS
SELECT SUM(InvoiceTotal)
FROM Invoices
WHERE VendorID = @VendorID AND InvoiceDate >= @DateVar;
Responda
-
SELECT spInvoiceTotal1 @VendorID = 122, @DateVar = '2019-10-01';
-
CREATE spInvoiceTotal1 @VendorID = 122, @DateVar = '2019-10-01';
-
EXEC spInvoiceTotal1 @VendorID = 122, @DateVar = '2019-10-01';
-
none of the above
Questão 16
Questão
A user-defined function
Responda
-
can return a single scalar value or a single table value
-
can return multiple scalar values or a single table value
-
can return multiple scalar values or a multiple table values
-
can't accept input parameters
Questão 17
Questão
Which statement can you use to control the flow of execution based on a true/false condition?
Responda
-
IF...ELSE
-
BEGIN...END
-
TRY...CATCH
-
EXEC
Questão 18
Questão
Given the following statements that declare a local variable and set its value, which of the following will cause an error?
DECLARE @Example1 varchar(128);
SET @Example1 = 'Invoices';
Responda
-
IF @Example1 = 'Invoices' SELECT* FROM Invoices
-
PRINT 'Table name is: ' + @Example1;
-
SELECT * FROM @Example1;
-
SELECT * FROM sys.tables WHERE name = @Example1;
Questão 19
Questão
When passing a list of parameters to a stored procedure by name, you can omit optional parameters by
Responda
-
omitting the parameter name and value from the list
-
inserting an extra comma
-
declaring the optional parameters after the required parameters
-
using the OUTPUT keyword
Questão 20
Questão
A cursor that is sensitive to updates and deletes to the source data, but insensitive to insertions:
Responda
-
dynamic
-
static
-
forward-only
-
keyset-driven
Quer criar seus próprios Quizzes gratuitos com a GoConqr? Saiba mais.