What is the most prominent data manipulation language and method to question a database?

31) Which of the following is the most prominent data manipulation language today?1.A) Access2.B) DB23.C) SQL4.D) Crystal Reports5.E) NoSQLAnswer: C

Difficulty: 2: ModerateAACSB: Information technologyLO: 6-2: What are the major capabilities of database management systems (DBMS) and why isa relational DBMS so powerful?32) DBMSs typically include report-generating tools in order to:

Get answer to your question and much more

2.B) display data in an easier-to-read format.3.C) display data in graphs.4.D) perform predictive analysis.5.E) analyze the database's performance.Answer: BDifficulty: 2: ModerateAACSB: Information technologyLO: 6-2: What are the major capabilities of database management systems (DBMS) and why isa relational DBMS so powerful?33) The process of streamlining data to minimize redundancy and awkward many-to-manyrelationships is called:

Get answer to your question and much more

Difficulty: 1: EasyAACSB: Information technologyLO: 6-2: What are the major capabilities of database management systems (DBMS) and why isa relational DBMS so powerful?34) A schematic of the entire database that describes the relationships in a database is calleda(n):

Get answer to your question and much more

4.D) data definition diagram.5.E) data analysis table.Answer: CDifficulty: 2: ModerateAACSB: Information technologyLO: 6-2: What are the major capabilities of database management systems (DBMS) and why isa relational DBMS so powerful?35) A one-to-many relationship between two entities is symbolized in a diagram by a line thatends with:1.A) one short mark.2.B) two short marks.3.C) three short marks.4.D) a crow's foot.5.E) a crow's foot topped by a short mark.Answer: E

Difficulty: 3: ChallengingAACSB: Information technologyLO: 6-2: What are the major capabilities of database management systems (DBMS) and why isa relational DBMS so powerful?36) You are creating a database to store temperature and wind data from various airports.Which of the following fields is the most likely candidate to use as the basis for a primary key inthe Airport table?

Get answer to your question and much more

3.C) Airport code4.D) State5.E) DayAnswer: CDifficulty: 2: ModerateAACSB: Analytical thinkingLO: 6-2: What are the major capabilities of database management systems (DBMS) and why isa relational DBMS so powerful?37) The logical and physical views of data are separated in a DBMS.Answer: TRUEDifficulty: 2: ModerateAACSB: Information technologyLO: 6-2: What are the major capabilities of database management systems (DBMS) and why isa relational DBMS so powerful?38) Every record in a file should contain at least one key field.Answer: TRUEDifficulty: 1: EasyAACSB: Information technologyLO: 6-2: What are the major capabilities of database management systems (DBMS) and why isa relational DBMS so powerful?

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 44 pages?

Upload your study docs or become a

Course Hero member to access this document

What Does Data Manipulation Language (DML) Mean?

A data manipulation language (DML) is a family of computer languages including commands permitting users to manipulate data in a database. This manipulation involves inserting data into database tables, retrieving existing data, deleting data from existing tables and modifying existing data. DML is mostly incorporated in SQL databases.

Techopedia Explains Data Manipulation Language (DML)

DML resembles simple English language and enhances efficient user interaction with the system. The functional capability of DML is organized in manipulation commands like SELECT, UPDATE, INSERT INTO and DELETE FROM, as described below:

• SELECT: This command is used to retrieve rows from a table. The syntax is SELECT [column name(s)] from [table name] where [conditions]. SELECT is the most widely used DML command in SQL.


• UPDATE: This command modifies data of one or more records. An update command syntax is UPDATE [table name] SET [column name = value] where [condition].


• INSERT: This command adds one or more records to a database table. The insert command syntax is INSERT INTO [table name] [column(s)] VALUES [value(s)].


• DELETE: This command removes one or more records from a table according to specified conditions. Delete command syntax is DELETE FROM [table name] where [condition].

Which of the following is the most prominent data manipulation language?

Is the most popular method to model a database?

Which of the following best describes a data manipulation language DML )?

Which of the following enables users to view the same data in different ways using multiple dimensions?