Online Access Free 1Z0-171 Practice Test

Which of the following SQL commands retrieves data from a relational database?

• A.UPDATE
• B.SELECT
• C.INSERT
• D.DELETE

What is a subquery in SQL?

• A.A query used to create a table
• B.A query inside another query
• C.A query that combines data from multiple tables
• D.A query used for joining two or more tables

What does the INTERSECT operator do in SQL?

• A.Returns rows that are present in both queries
• B.Returns rows from the first query that are not present in the second query
• C.Combines all rows from two queries without any conditions
• D.Combines rows from two queries and includes all duplicates

What is the relationship between SQL and a relational database?

• A.SQL is used to create flat file databases.
• B.SQL is a scripting language used for file manipulation.
• C.SQL is a file system used to store relational database data.
• D.SQL is a standard query language used to interact with relational databases

Which SQL keyword is used to remove duplicate rows from the result set of a query?

• A.DISTINCTROW
• B.UNIQUE
• C.DISTINCT
• D.ONLY