Topic 2: Understanding Core Database Concepts Quiz

What is a collection of programs that enables you to enter, organize, and select data from a database?

a.flat program b.spreadsheet group c.DAT application d.DBMS Answer: D) DBMS (Database Managing System)

What allows a SQL database to be accessed by multiple users at the same time?

a.database server b.workstation c.collector d.computer located in the center of the building Answer: A) Database Server

Primary data files used on a Microsoft SQL server has an _____ extension.

.mdf

What type of database is a single page spreadsheet?

a. flat-type database b. hierarchical database c. relational database d. constraints database Answer: A) Flat-type database

Which of the following statements is true of foreign key constraints?

a.Columns marked as foreign keys can contain null values and a foreign key constraint in one table points to a primary key in another table. b.A foreign key cannot contain duplicate values c.A foreign key constraint is used to define default values. d.A foreign key cannot contain duplicate values and columns marked as foreign keys can contain null values. Answer: A)Columns marked as foreign keys can contain null values and a foreign key constraint in one table points to a primary key in another table.

Which of the following is a language element that allows you to use core statements such as INSERT, UPDATE, and DELETE to manipulate data in any SQL Server table?

a.DML b.DDE c.DDL d.DAT Answer: A) DML (Data Manipulating Language)

Which of the following is a subset of T-SQL that deals with creating database objects such as tables and stored procedures?

a.DML b.DDE c.DDL d.DAT Answer: C) DDL ( Data Definition Language)

Which of the following are the two broad categories that database objects are inherently divided into?

a.Logs and Query b.Programmability and Storage c.Query and Storage d.Logs and Programmability Answer: B) Programmability and Storage. Database objects are inherently divided into two broad categories: storage and programmability

When a value cannot be blank, the value cannot contain _____ values.

a.NULL b.0 c.EMPTY d.<> e."" Answer: E) ""

Which of the following is the primary means for programming and managing SQL Server?

a.SQLCMD b.Transact-SQL c.DML d.XQuery Answer: B) Transact-SQL