BUSN.10139 - Test #2 Training Questions

What does DML stand for?

• Data Modelling Language
• Data Markup Language
• Data Manipulation Language

Which is NOT a characteristic of SQL?

• Declarative
• Standardized
• Embedded
• Interactive
• Logical

Which is NOT a SQL command group?

• DDL
• DML
• T-SQL
• DCL
• TCL

_______ clause specifies which tables are to be used in the query.

• SELECT
• WHERE
• FROM
• DISTINCT

Ranges in SQL can be tested using BETWEEN operator instead of <= and >= operators.

• True
• False

This join returns ALL roles from each table being joined.

• LEFT OUTER JOIN
• RIGHT OUTER JOIN
• FULL OUTER JOIN
• INNER JOIN

In an object oriented database ______ is equal to an Entity in a relational database?

• Class
• Object
• Attribute
• Identity
• Entity

Object Identifier (OID) in Object Oriented Database is the same as Primary Key in Relational Database?

• True
• False

Database systems that have data, programs, and personnel that specialize in the preparation of data for BI processing.

• Dimensional Databases
• Data Marts
• Data Warehousing
• Business Intelligence Systems

An INNER JOIN returns all rows from both tables, including unmatched records.

• True
• False