Refer to the exhibit. Which type of SQL JOIN operation would return all the rows from Table 1 and Table 2? LEFT JOIN RIGHT JOIN FULL JOIN INNER JOIN Answers…
In combination with primary and foreign keys, which SQL statement is the most common method for joining fields from multiple tables? BETWEEN LIKE JOIN WHERE Answers Explanation & Hints: The…
Refer to the exhibit. You need to get information about customer purchases that is stored in the two tables. You would like to see data from the OrderID, CustomerName, OrderAmount,…
Which two SQL statements are used to create and change a database schema? (Choose two.) ALTER CREATE DELETE INSERT SELECT Answers Explanation & Hints: ALTER and CREATE are Data Definition…
Which three elements of a relational database are defined in the schema? (Choose 3.) attributes SQL keywords aliases tables relationships Answers Explanation & Hints: A schema is a formal description…
What is represented by the comma-separated list of items following the SELECT command in this example? SELECT movieID, title aliases records table names columns (attributes) Answers Explanation & Hints: The SELECT command…
Which structure in a table represents an individual record contained in the database? foreign key row relationship column Answers Explanation & Hints: In a relational database table, each row represents…
In the SQL statement " SELECT genre FROM movies" what is specified by "genre"? the column the table the folder the database Answers Explanation & Hints: The SELECT statement identifies the column in a table from…
What is used to show how the tables in a database are related to one another? CSV DDL ERD DML Answers Explanation & Hints: An Entity Relationship Diagram (ERD) shows…
Which SQL statement is used to filter data in a database? WHERE FROM ORDER BY DISTINCT Answers Explanation & Hints: The WHERE statement is a conditional statement used to filter…
Which commonly used SQL statement is necessary to retrieve data from one or more tables in a database? TRUNCATE SELECT INSERT CREATE Answers Explanation & Hints: The SELECT statement is…
What is a flat file database? a database that stores records in a single file with no hierarchical structure a database that requires SQL to store, manipulate, and retrieve data…
A data analyst wants to display outliers in the data set. Which type of visual representation would best suit this task? line chart bar chart scatter plot pie chart Answers…
A data analyst wants to display the various segments of a country’s energy sources (e.g., oil, coal, gas, solar, wind) contributing to 100% of its energy sources in a visual…
Why is regression analytics used in the inferential and machine learning analyses of big data? It is used to find groups of observations that are similar to each other. It is…
Which type of inferential and machine learning analysis is used to find groups of observations that are similar to each other? regression association cluster observation Answers Explanation & Hints: A…
Why are different sampling techniques used to gather inferential statistical data? to reduce error and increase confidence in the generalizations about the findings to get accurate mean values to verify…
A data analyst wants to find data point values that are significantly different from others in a data set. What are these values called? outliers scatter plots cluster associations Answers…
Which three key pieces of information are required to perform a VLOOKUP function in Microsoft Excel? (Choose three.) the column number in the range that contains the return value the…
What can a data analyst do if they wanted to remove duplicate values in a Microsoft Excel spreadsheet? use VLOOKUP use conditional formatting parse the data from "text to column"…