Question

In: Computer Science

6-Microsoft SQL Server is a​ ________ for large mainframes and midrange computers. A.SimpleDB B.MongoDB C.relational DBMS...

6-Microsoft SQL Server is a​ ________ for large mainframes and midrange computers.

A.SimpleDB

B.MongoDB

C.relational DBMS

D.NoSQL

E.distributed database

16-SQL stands for​ ________.

A.Structured Query Language

B.Streamlined Question Language

C.Structured Question Language

D.Special Question Language

E.Structured Questioning Language

18-Which of the following is a distributed database technology that enables firms and organizations to create and verify transactions on a​ peer-to-peer network nearly instantaneously without a central​ authority?

A.MySQL

B.DB2

C.NoSQL

D.Blockchain

E.Cloud Spinner

19-What makes a Blockchain system possible and attractive to business​ firms?

A.Blockchain is easily implemented across larger enterprises.

B.Blockchain systems always include remote maintenance and support capabilities.

C.It is free open source software​ (OSS), which means that the copyright holder grants users rights and privileges.

D.Blockchain makes it easier for competitors to​ collude, ultimately to the detriment of consumers.

E.Its encryption and authentication processes make it highly secure for storing many kinds of data.

22-The​ sales, manufacturing, and inventory systems at a bicycle manufacturer use different codes to represent bicycle frame sizes. For​ example, in the sales​ system, a large bike frame is coded with​ "L", while the inventory system codes a large bike frame with​ "LG". This situation illustrates​ ________.

A.duplicate data

B.coarse data

C.​non-indexed data

D.​re-indexed data

E.data inconsistency

Solutions

Expert Solution

6) Microsoft SQL Server is a Relational Database Management System.

The correct option is C. relational DBMS.

16) SQL stands for Structured Query Language.

The correct option is A. Structured Query Language.

18) Which of the following is a distributed database technology that enables firm and organizations to create and verify transactions on a peer-to-peer network nearly instantaneously without a central authority?

The correct answer is D. Blockchain

19) What makes a Blockchain system possible and attractive to business firms?

The answer to this question possibly could be option E. Its encryption and authentication processes make it highly secure for storing many kinds of data.

22) The sales, manufacturing, and inventory systems at a bicycle manufacturer use different codes to represent bicycle frame sizes. For example, in the sales system, a large bike frame is coded with "L", while the inventory system codes a large bike frame with "LG". This situation illustrates data inconsistency.

The correct option is E. data inconsistency.


Related Solutions

Which of the following is a database client software? Microsoft SQL Server 2017 Developer Microsoft SQL...
Which of the following is a database client software? Microsoft SQL Server 2017 Developer Microsoft SQL Server Management Studio Microsoft SQL Server Configuration Manager SQL Server Analysis Service Compared to Data Warehousing approach, the following are disadvantages of query-driven data integration approach, EXCEPT: __________. competition with local processing at source delay in query processing waste of storage space inefficient and potentially expensive for frequent queries What does OLAP stand for? Olympic Linear Algebra Problem On-Line Amazon Platform On-Line Analytical Processing...
Using your downloaded DBMS (MS SQL Server or MySQL), write SQL queries that inserts at least...
Using your downloaded DBMS (MS SQL Server or MySQL), write SQL queries that inserts at least three rows in each table. For the On-Demand Streaming System, First, insert information for multiple users, at least three video items and insert the three different types of subscriptions (Basic, Advanced, Unlimited) into the database. Then insert at least three user subscriptions. Execute the queries and make sure they run correctly
You should try this code in Microsoft SQL Server to get the practice of using the...
You should try this code in Microsoft SQL Server to get the practice of using the command line and getting syntax errors. You can submit to me your sql files or just copy and paste of your code in a word document. I may try to run it, so make sure it is error free. Or you can show screen shots of code running. Write SQL CREATE Table statement to create the following table with  Owner ID  as a surrogate key.  Owner ID...
You should try this code in Microsoft SQL Server to get the practice of using the...
You should try this code in Microsoft SQL Server to get the practice of using the command line and getting syntax errors. You can submit to me your sql files or just copy and paste of your code in a word document. I may try to run it, so make sure it is error free. Or you can show screen shots of code running. Write SQL CREATE Table statement to create the following table with  Owner ID  as a surrogate key.  Owner ID...
Research Microsoft SQL Server and in your own words, describe your understanding of this and its...
Research Microsoft SQL Server and in your own words, describe your understanding of this and its role in Microsoft's model for web programming. Be sure to list your sources by providing links and/or printed book/article names. As one open option available to us is Microsoft SQL Server Express, for your response discuss too which is better for development. SQL Server Express or a full SQL Server environment?
Using your downloaded DBMS (MS SQL Server), create a new database. Create the database tables based...
Using your downloaded DBMS (MS SQL Server), create a new database. Create the database tables based on your entities defining The attributes within each table The primary and foreign keys within each table *****Show your database tables, tables attributes, primary and foreign keys***** Do not forget to check the lesson slides and videos that show you how to convert an ER/EER into a database schema, and how to create a database and tables using MS SQL Server.
DBMS Create/Insert/Update SQL I need the create, insert, and update SQL statement for this table as...
DBMS Create/Insert/Update SQL I need the create, insert, and update SQL statement for this table as if it were being added to MySQL (please give explanations for each line of SQL code and a copy of the code as it would be entered into the query by itself: Customer PK Customer ID Text Phone Number int name text address ID int email text FK vendor ID int Vendor is the name of the table the FK comes from.
DBMS Create/Insert/Update SQL I need the create, insert, and update SQL statement for this table: Customer...
DBMS Create/Insert/Update SQL I need the create, insert, and update SQL statement for this table: Customer PK Customer ID Text Phone Number int name text address ID int email text FK vendor ID int Vendor is the name of the table the FK comes from.
Write the following SQL queries and show the corresponding output of the DBMS: 1) Write an...
Write the following SQL queries and show the corresponding output of the DBMS: 1) Write an SQL statement to display all the information of all Nobel Laureate winners. 2) Write an SQL statement to display the string "Hello, World!". 3) Write an SQL query to display the result of the following expression: 2 * 14 +76. 4) Write an SQL statement to display the winner and category of all Laureate winners. 5) Write an SQL query to find the winner(s)...
Facebook is considering purchasing a new state-of-the-art server farm (several large computers) that would allow the...
Facebook is considering purchasing a new state-of-the-art server farm (several large computers) that would allow the company to match customers’ pictures to advertisers. The company estimates this new service will generate additional advertising revenues of $6 million at the end of the first year, and of $7 million at the end of the second year. Working capital requirements increase by $3 million at the end of year 1. After 2 years, Facebook expects to sell the servers and generate a...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT