Show List
Quiz - SQL - 3
Select the right answer for below questions:
What is the purpose of the INTERSECT operator in SQL?
To combine the results of two or more SELECT statements into a single result set
To return only the rows that exist in both result sets of two SELECT statements
To sort the results of a query
To group the results of a query
To return only the rows that exist in both result sets of two SELECT statements
What does SQL stand for?
Structured Query Language
Simple Query Logic
Structured Query Logic
Simple Query Language
Structured Query Language
What is a database in SQL?
A collection of related data
A single data value
A computer program
A query language
A collection of related data
What is a relational database in SQL?
A database in which data is stored in tables
A database in which data is stored in a hierarchical structure
A database in which data is stored in a network structure
A database in which data is stored as a graph
A database in which data is stored in tables
What is a table in SQL?
A database object that stores data in rows and columns
A database object that stores data in a hierarchical structure
A database object that stores data in a network structure
A database object that stores data as a graph
A database object that stores data in rows and columns
What is a row in SQL?
A single data value in a database table
A set of related data in a database table
A set of data values in a database table
A column in a database table
A set of related data in a database table
What is a column in SQL?
A single data value in a database table
A set of related data in a database table
A set of data values in a database table
A horizontal set of values in a database table
A horizontal set of values in a database table
What is a SELECT statement in SQL?
A statement used to retrieve data from a database
A statement used to add data to a database
A statement used to modify data in a database
A statement used to delete data from a database
A statement used to retrieve data from a database
What is a WHERE clause in SQL?
A clause used to limit the results of a query
A clause used to sort the results of a query
A clause used to group the results of a query
A clause used to combine the results of multiple queries
A clause used to limit the results of a query
What is a JOIN in SQL?
An operator used to combine the results of two or more tables
An operator used to limit the results of a query
An operator used to sort the results of a query
An operator used to group the results of a query
An operator used to combine the results of two or more tables
Submit
Retry
{"qz1-928289":"To return only the rows that exist in both result sets of two SELECT statements","qz1-928290":"Structured Query Language","qz1-928291":"A collection of related data","qz1-928292":"A database in which data is stored in tables","qz1-928293":"A database object that stores data in rows and columns","qz1-928294":"A set of related data in a database table","qz1-928295":"A horizontal set of values in a database table","qz1-928296":"A statement used to retrieve data from a database","qz1-928297":"A clause used to limit the results of a query","qz1-928298":"An operator used to combine the results of two or more tables"}
Leave a Comment