Marketing Test Questions
1- Business intelligence (BI) systems are information systems used to support management decisions by producing information for assessment, analysis, planning and control.
2- ad-hoc queries are essentially questions that can be answered using database data.
3- SQL Structured Query Language the universal query language of relational DBMS products is always behind the user friendly GUIs.
4- SKU stock keeping unit is a unique identifier for each particular item that cape CODD sells.
5-Extracting retail sales data from the operational data base to perform the marketing study
6- The relationship between Retail order and order item is ordernumber and between order item and SKU data is SK
7 – SQL was developed by the IBM Corporation in late 1970s. It was endorsed as national standard by the ANSI in 1986 and by ISO in 1987.
8-was the third version of the SQL unlike SQL-89, it was a major revision of the standard. For all but a few minor incompatibilities, the SQL-89 standard is forward compatible with SQL-92, this version of SQL is used In a Microsoft access 2010 database in this chapter.
9-
10-
11-Data manipulation language (DML) statements used for querying, inserting, modifying and deleting data
12- Data definition language statements used for creating tables, relationships and other structures.
13- Select specifies which columns are to be listed, from specifies which tables are to be used and Where specifies which rows are to be listed in the query results.
14- Microsoft access 2010 does contain a setting to allows to use sql which allows access tools such as forms and reports to be used in application development for Microsoft Sql server
15-
16-warehouseid pk in warehouse and fk in inventory table
17- Select sku,sku_description from inventory;
18-select SKU_description,SKU from inventory;
19-select warehouseid from inventory;
20-select distinct warehouseid from inventory;
21-select warehouseid,sku,sku_description,quantityonhand,qoantityonorder
2- ad-hoc queries are essentially questions that can be answered using database data.
3- SQL Structured Query Language the universal query language of relational DBMS products is always behind the user friendly GUIs.
4- SKU stock keeping unit is a unique identifier for each particular item that cape CODD sells.
5-Extracting retail sales data from the operational data base to perform the marketing study
6- The relationship between Retail order and order item is ordernumber and between order item and SKU data is SK
7 – SQL was developed by the IBM Corporation in late 1970s. It was endorsed as national standard by the ANSI in 1986 and by ISO in 1987.
8-was the third version of the SQL unlike SQL-89, it was a major revision of the standard. For all but a few minor incompatibilities, the SQL-89 standard is forward compatible with SQL-92, this version of SQL is used In a Microsoft access 2010 database in this chapter.
9-
10-
11-Data manipulation language (DML) statements used for querying, inserting, modifying and deleting data
12- Data definition language statements used for creating tables, relationships and other structures.
13- Select specifies which columns are to be listed, from specifies which tables are to be used and Where specifies which rows are to be listed in the query results.
14- Microsoft access 2010 does contain a setting to allows to use sql which allows access tools such as forms and reports to be used in application development for Microsoft Sql server
15-
16-warehouseid pk in warehouse and fk in inventory table
17- Select sku,sku_description from inventory;
18-select SKU_description,SKU from inventory;
19-select warehouseid from inventory;
20-select distinct warehouseid from inventory;
21-select warehouseid,sku,sku_description,quantityonhand,qoantityonorder