27879617
Descripción
Test por Kyle Peterson, actualizado hace más de 1 año
|
Creado por Kyle Peterson
hace más de 3 años
|
|
Pregunta 1
Pregunta
The special operator used to check whether an attribute value matches a given string pattern is __________.
Respuesta
-
BETWEEN
-
IS NULL
-
LIKE
-
IN
Pregunta 2
Pregunta
The SQL aggrergate function that gives the number of rows containing non-null values for a given column is ____________.
Respuesta
-
MIN
-
MAX
-
SUM
-
COUNT
Pregunta 3
Pregunta
Which one of the following will be useful if there is a need to step through rows forward and backward?
Respuesta
-
Stored Procedure
-
Cursor
-
Trigger
-
Index
Pregunta 4
Pregunta
Which one of the following is essentially virtual tables?
Respuesta
-
Cursor
-
View
-
Trigger
-
Stored Procedure
Pregunta 5
Pregunta
You can use a stored procedure that returns information from base tables that you do not have permission on.
Respuesta
- True
- False
Pregunta 6
Pregunta
The WITH ENCRYPTION clause of the CREATE VIEW statement
Respuesta
-
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.
Pregunta 7
Pregunta
The statement
CREATE VIEW Example4
AS
SELECT *
FROM Invoices JOIN Vendors ON Invoices.VendorID = Vendors.VendorID
WHERE InvoiceTotal - PaymentTotal - CreditTotal > 0;
Respuesta
-
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
Pregunta 8
Pregunta
A table that's used to create a view is called
Respuesta
-
a view table
-
a temporary table
-
a base table
-
an OFFSET table
Pregunta 9
Pregunta
Each of the following is a benefit provided by using views except for one. Which one is it?
Respuesta
-
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.
Pregunta 10
Pregunta
A view
Respuesta
-
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
Pregunta 11
Pregunta
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;
Respuesta
-
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
Pregunta 12
Pregunta
If you delete a stored procedure, function, or trigger and then create it again
Respuesta
-
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
Pregunta 13
Pregunta
Each of the following statements about triggers is true except for one. Which one?
Respuesta
-
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.
Pregunta 14
Pregunta
Which statement can you use to manually raise an error within a stored procedure?
Respuesta
-
THROW
-
ERROR
-
TRY
-
RAISE
Pregunta 15
Pregunta
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;
Respuesta
-
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
Pregunta 16
Pregunta
A user-defined function
Respuesta
-
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
Pregunta 17
Pregunta
Which statement can you use to control the flow of execution based on a true/false condition?
Respuesta
-
IF...ELSE
-
BEGIN...END
-
TRY...CATCH
-
EXEC
Pregunta 18
Pregunta
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';
Respuesta
-
IF @Example1 = 'Invoices' SELECT* FROM Invoices
-
PRINT 'Table name is: ' + @Example1;
-
SELECT * FROM @Example1;
-
SELECT * FROM sys.tables WHERE name = @Example1;
Pregunta 19
Pregunta
When passing a list of parameters to a stored procedure by name, you can omit optional parameters by
Respuesta
-
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
Pregunta 20
Pregunta
A cursor that is sensitive to updates and deletes to the source data, but insensitive to insertions:
Respuesta
-
dynamic
-
static
-
forward-only
-
keyset-driven
¿Quieres crear tus propios Tests gratis con GoConqr? Más información.