1. Which of the following displays the correct general syntax for the SELECT statement that also includes a predicate? SELECT * FROM <TABLENAME> WHERE <LOGICAL STATEMENT>
2. Which of the following is the correct general syntax for the INSERT statement? INSERT INTO <table name> (column1, column2…) VALUES (value1, value2…);
3. Which of the following would be attributes in an entity-relationship (ER) diagram for an entity named “Dog?” breed, fur type, name, eye color, gender
4. Which of the following is classified as a data manipulation language (DML) statement? SELECT
5. Which of the following SQL statements is equivalent to “SELECT title, pages FROM BookDetails WHERE pages >= 250 AND pages <= 300;” for the table displayed below? SELECT TITLE, PAGES FROM BOOKDETAILS WHERE PAGES BETWEEN 250 AND 300;
6. Which statement is the correct way to retrieve the average number of GamePoints scored by each basketball team from the table displayed below? SELECT TeamName, AVG(GamePoints) FROM Scores GROUP BY TeamName;
7. Which statement describes a schema? It groups a set of tables together in a database.
8. How should dates and times be mapped from R to a relational database management system (RDBMS)? As strings
9. Which SQL statement is used to delete records from a table? DELETE
10. Data that needs transformed into a factor is generally transferred from an R object database management system (RODBMS) into R as what data type? A character
11. Which of the following displays the correct syntax for the SELECT statement that retrieves data from the “MovieName” column in a table named “Movie?” SELECT MovieName FROM Movie;
12. Which two statements are true regarding data manipulation language (DML) operations? They are often referred to as create, read, update, and delete (CRUD) operations.  They are used to read and modify data in tables
13. What data would be returned from this SQL statement for the table displayed below? returns data from the column name “firstname” from the “bookdetails” table if the first letter of “firstname” is “R”
14. Which statement is the correct way to retrieve the average number of GamePoints scored by each basketball team from the table displayed below? SELECT TeamName, AVG(GamePoints) FROM Scores GROUP BY TeamName;
15. How do entities and attributes in an entity-relationship (ER) diagram map to a relational database? An entity represents a table and an attribute represents a column.
16. Question 6 Which would be the result of the SQL statement: SELECT TeamName, COUNT(*) FROM Roster GROUP BY TeamName; for the table displayed below: Table: Roster Lists a specific count associated with each team.
17. What feature in a relational database management system is similar to an observation in R? A row
18. What SQL statement is used to modify data in a database table? update
19. Which statement best describes what a factor is in R? A variable that represents categorical date
20. Which statement best describes the use of the INSERT statement? It can be used to add rows to a table.
21. Which statement is the correct way to retrieve the player who scored the most points per game on each basketball team from the table displayed below? select teamName, game, max(playername), Max(gamepoints) from scores group by teamname, game;
22. What feature in a relational database management system is similar to a “namespace” in R? schemeas
23. How is character data in R mapped to a relational database management system (RDBMS)? either a fixed sized CHARACTER column or a variable size VARCHAR column
24. What is the purpose of the sqlFetch() function? to fetch all the data in a table
25. What is a primary key? It is a unique value for each row in a table.
26. What is wrong with the following INSERT statement? It is missing a value.
27. In SQL, which clause is used to sort the result set in ascending or descending order? order by
28. What would be the result of this SELECT statement for the table displayed below? Only retrieves the data from the cells in the “BookName” column from the “Book” table where the copyright date is later than the year 2000.
29. Which statement best describes data definition language (DDL) operations? They are used to manipulate database objects such as table
    
    
    
    

Other Links:

Statistics Quiz

Networking Quiz

See other websites for quiz:

Check on QUIZLET

Check on CHEGG