SQL SERVER ADVANCED - CLASS 2
Quiz
•
Computers
•
3rd Grade
•
Easy
Alma Robles
Used 2+ times
FREE Resource
5 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 2 pts
Sintaxis para crear una vista
Alter view schema_name.view_name
as
select_statement;
Create view schema_name.view_name
as
select_statement;
drop view view_name
2.
MULTIPLE SELECT QUESTION
45 sec • 2 pts
Selecciona las ventajas de una vista (Son 3)
mayor control de seguridad de información sencible
Simplicidad, ya que se podrán hacer consultas mas simples a partir de una consulta compleja
No hay mucha ventaja, mejor usar la tabla directo
Mayor Consistencia, ya que puedes esconder los queries complejos o cálculos complejos en una vista y solo hacer referencia a tu vista en tus queries en lugar de estar re-escribiendo tu lógica compleja en tus queries por separado
3.
MULTIPLE CHOICE QUESTION
30 sec • 2 pts
Con que comando puedes Borrar una vista?
ALTER
CREATE
SELECT
DROP
4.
MULTIPLE CHOICE QUESTION
30 sec • 2 pts
Función de SQL Server que te permite obtener el ID de un objeto indicando como parámetro el nombre del objeto
sp_helptext
object_id
(object_name)
object_definition(object_id)
5.
MULTIPLE CHOICE QUESTION
30 sec • 2 pts
Comando que me sirve, para obtener la definición de una vista
select *
sp_rename
sp_helptext
Similar Resources on Wayground
10 questions
G3 - ENRICHMENT GAME
Quiz
•
3rd Grade
10 questions
Review III Unidad - 3er Grado
Quiz
•
1st - 3rd Grade
10 questions
1.- Ondas
Quiz
•
1st Grade - University
10 questions
Robótica
Quiz
•
1st - 12th Grade
10 questions
Cuestionario sobre la lectura ¿Qué es la World Wide Web?
Quiz
•
1st - 6th Grade
10 questions
Clase de Computacion
Quiz
•
1st - 5th Grade
10 questions
PROCESADOR DE TEXTOS WORD
Quiz
•
3rd Grade
10 questions
Ôn tập về phần mềm soạn thảo văn bản
Quiz
•
1st - 5th Grade
Popular Resources on Wayground
20 questions
Brand Labels
Quiz
•
5th - 12th Grade
11 questions
NEASC Extended Advisory
Lesson
•
9th - 12th Grade
10 questions
Ice Breaker Trivia: Food from Around the World
Quiz
•
3rd - 12th Grade
10 questions
Boomer ⚡ Zoomer - Holiday Movies
Quiz
•
KG - University
25 questions
Multiplication Facts
Quiz
•
5th Grade
22 questions
Adding Integers
Quiz
•
6th Grade
10 questions
Multiplication and Division Unknowns
Quiz
•
3rd Grade
20 questions
Multiplying and Dividing Integers
Quiz
•
7th Grade
