2. Explain the differences between the various data types available in a relational database, and provide examples of situations where you would use specific data types.

Why are data types important in a database? Briefly explain 3 common data types (e.g., Text, Number, Date).

Question 1: Data types define the type of data that can be stored in which part of a database table? 1 pointRows ColumnsSchemasIndex

5.Question 5Which of the following is an advantage of using relational databases?1 point

1.Question 1Which data type is most appropriate for true/false data?1 pointINTFLOATBOOLEANCHAR2.Question 2Which of the following is an open-source database?1 pointDb2BigQueryPostgreSQLOracle3.Question 3Which statement regarding the data access layer in a database management system software (DBMS) is true?1 pointIt contains an engine that compiles queries, retrieves data, and returns a result set.It is the place for storing the data.It encapsulates the application and business logic.The client typically directly accesses it.4.Question 4Which statement is true with regard to PostgreSQL?1 pointIt supports inheritance and overloading.It is a NoSQL database management system (DBMS).It is object-oriented.It is proprietary software.5.Question 5What is the purpose of the Entity Relationship Diagram (ERD) model?1 pointThe ERD model helps you map data types to existing columns and rows.The ERD model helps you to define entities and their attributes, map them to tables, and identify the relationships between the tables.The ERD model helps you define the data in each table row.The ERD model helps you to design a database with a single table.6.Question 6Which data source is NOT compatible with the Db2 Web Console for data loading?1 pointCloud Object Storage (IBM)Python codeS3 object storage (AWS)Delimited text files (local computer)7.Question 7Which of the following attributes is appropriate to use as a primary key?1 pointSocial security numberCopyright dateStreet addressAuthor8.Question 8Which of the following is an advantage of indexing?1 pointIndexing works well with unstructured dataIndexing increases the performance of INSERT and UPDATE queriesIndexing quickly sorts data in a tableIndexing quickly locates rows and reduces the need to sort the data9.Question 9Which of the following examples best demonstrates data that violates the entity integrity constraint?1 pointCity: AlaskaPrimary key is duplicatedBirth Date: 01/03/19782EmployeeID: NULL10.Question 10Which statement is true regarding database instances?1 pointThey can share configuration files with other instances.It is possible to have more than one database within a single instance.They store a list of database users and their access permissions.They are logical groupings of objects within a database.11.Question 11Which services can you use to manage MySQL in the cloud?1 pointAzurephpMyAdminMySQL WorkbenchMariaDB12.Question 12When utilizing phpMyAdmin to create a MySQL database, when do you specify the data column’s length in the process?1 pointWhen you are shown a summary of the structure of the new tableWhen you define the columns in the tableWhen you add tables to the databaseWhen you name the new database13.Question 13What does the following command do?mysqldump -u root employees > employeebackup.sql1 pointIt exports the contents from the employee's table file into the employeebackup.sql fileIt imports the contents of the employee's CSV file into an existing table in the databaseIt runs all of the SQL statements in the employeebackup.sql backup file to recreate the objects and restore the data in the destination databaseIt backs up a database to the employeebackup.sql file containing all of the statements needed to recreate the contents of the database14.Question 14On which operating systems can you install PostgreSQL?1 pointmacOS, Microsoft Windows, UNIXmacOS onlyYou cannot install PostgreSQL locally; it must be cloud-basedUNIX, UNIX-like, or UNIX-based systems15.Question 15Why would you refresh a materialized view in a PostgreSQL database before you use it?1 pointThe materialized view only stores the data in memory, so it needs to be refreshed to reflect current dataRefreshing a materialized view increases performanceThe materialized view stores the data, so if you need to use the most current data, you should refresh the view first

A relational database is designed to manage structured data primarily. Which of the following is an example of structured data?1 pointData from emails, XML, and zipped filesData from web pages, social media feeds, imagesData from binary executables and TCP/IP protocolsData from OLTP systems, spreadsheets, online forms, and senso