SQL Avanzado1
Quiz
•
Computers
•
University
•
Practice Problem
•
Hard
Lizeth Romo
Used 4+ times
FREE Resource
Enhance your content in a minute
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
El operador O muestra un registro si CUALQUIER condición enumerada es verdadera. El operador AND muestra un registro si TODAS las condiciones enumeradas son verdadera
Verdadero
Falso
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
¿Cuáles son los tipos de uniones admitidas en MySQL?
Inner Join, left join, right join, cross join
Inner Join, left join, right join, outer join
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
¿Qué operador se utiliza para seleccionar valores dentro de un rango determinado?
between
in
union
range
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
La restricción NOT NULL obliga a una columna a no aceptar valores NULL.
Falso
Verdadero
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
¿Qué operador se utiliza para buscar un patrón específico en una columna?
like
from
get
6.
FILL IN THE BLANK QUESTION
1 min • 1 pt
Inserte las partes que faltan en la cláusula JOIN para unir las dos tablas Pedido y Cliente, utilizando el campo idcliente en ambas tablas como la relación entre las dos tablas:
SELECT * FROM pedido LEFT JOIN cliente _______________ = ________________;
7.
FILL IN THE BLANK QUESTION
10 mins • 1 pt
Elija la cláusula JOIN correcta para seleccionar todos los registros de la tabla Cliente más todas las coincidencias en la tabla Pedido:
SELECT * FROM pedido ON ____________ pedido.idcliente=cliente.idcliente;
Create a free account and access millions of resources
Create resources
Host any resource
Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
Already have an account?
Similar Resources on Wayground
10 questions
SQL JOINS
Quiz
•
University
11 questions
Que tanto sabes de los dispositivos móviles
Quiz
•
University
12 questions
Python Quiz 1.4
Quiz
•
University
14 questions
ASI 3
Quiz
•
University
15 questions
AV1/R1 3TEC_Banco de Dados - Chave Primária
Quiz
•
1st Grade - University
15 questions
Definições sobre Projetos e o Manifesto Ágil
Quiz
•
12th Grade - University
10 questions
Mini 2 (5junio)
Quiz
•
University
10 questions
Bài 25 tin 10
Quiz
•
9th Grade - University
Popular Resources on Wayground
5 questions
This is not a...winter edition (Drawing game)
Quiz
•
1st - 5th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
10 questions
Identify Iconic Christmas Movie Scenes
Interactive video
•
6th - 10th Grade
20 questions
Christmas Trivia
Quiz
•
6th - 8th Grade
18 questions
Kids Christmas Trivia
Quiz
•
KG - 5th Grade
11 questions
How well do you know your Christmas Characters?
Lesson
•
3rd Grade
14 questions
Christmas Trivia
Quiz
•
5th Grade
20 questions
How the Grinch Stole Christmas
Quiz
•
5th Grade
Discover more resources for Computers
26 questions
Christmas Movie Trivia
Lesson
•
8th Grade - Professio...
20 questions
christmas songs
Quiz
•
KG - University
20 questions
Holiday Trivia
Quiz
•
9th Grade - University
15 questions
Holiday Movies
Quiz
•
University
14 questions
Christmas Trivia
Quiz
•
3rd Grade - University
20 questions
Christmas Trivia
Quiz
•
University
8 questions
5th, Unit 4, Lesson 8
Lesson
•
KG - Professional Dev...
20 questions
Disney Trivia
Quiz
•
University
