Flashcards
SQL SPROC Exam
Cards in this deck (30)
- 1True/False: Stored Procedure are a Script or Batch files that contain input parms, output and return values.True
- 2SPROC stands for what?Stored Procedures
- 3True/False: Stored procedures are saved to DB as DB objectsTrue
- 4True/False: SPROCS are pre compiled and offer better performance.True
- 5True/False: We can not modularize code into stored procedures for better organization and more efficient design.FALSE
- 6True/False: A local variable that can store a single value is called a string valueTRUE
- 7PARM stands for:Parameters
- 8True/False: A stored procedure needs parmsFALSE
- 9True/False: Parameters are declared after the procedure name is declared and before the AS keyword.True
- 10True/False: Parms are input by defaultTrue
- 11True/False: Output parameters do not allow the stored procedure to pass a data value back to the caller.False
- 12True/False: Output parameters and return codes must return their values into a variable,Parameters and return codes can exchange data values with either Transact-SQL variables or application variables.True
- 13True/False: If you specify the OUTPUT keyword for a parameter in the procedure definition, the stored procedure can return the current value of the parameter to the calling program when the stored procedure exits.True
- 14True/False: Input values can also be specified for OUTPUT parameters when the stored procedure is executed.True
- 15True/False: Stored procedures, user-defined functions, and triggers are all executable database objects that contain SQL statements.TRUE
- 16True/False: EXEC is not used to run a call or procedureFalse
- 17from within itself or wihtin another stored procedureTrue
- 18—Script to create a sproc
- 19—script to create sproc
- 20when is the prefix sp_ used?when declring a stored procedure
- 21CREATE PROCstatement to used to create a stored procedure in the current db
- 22what statement must be the first and only statement in a batchCREATE SPROC
- 23EXEC sp_whateverUsed to run the sproc
- 24True/False: @ParamerterName is the name of the parameter that is passed to the stored procedureTrue
- 25True/False: parameter name is followed by a datatypeTrue
- 26—example of parms being passed through a SPOC
- 27True/False: Any change made to a parameter value inside the SPROC does not change the external value assigned to the parameter.TrUE
- 28—Optional parms
- 29—Testing parms in query window
- 30TRUE/FALSE Stored procedures are run on the server itself, taking advantage of a basic client/server conceptTRUE
Information
- Description
- Flashcards on SQL SPROC Exam, created by Cat MUrray on 31/03/2018.
- Created by
- Cat MUrray
- Views
- 8
- Rating