sql

A database is an organized collection of ________ related data. A) logically B) physically C) loosely D) badly

A logically

What does the following SQL command do? insert into student values (1002,'John Smith','231 West St','Boston','MA','02115'); A) Adds a new record to the student table B) Creates the student table C) Deletes the student table D) Updates the student table

A) Adds a new record to the student table

A ________ defines or constrains some aspect of the business. A) Business rule B) Business structure C) Business control D) Business Constraint

A) Business rule

What does the following SQL statement do? Alter Table employee Add Type (varchar2 (10)); A) Alters the employee table to accept Type Varchar2 B) Alters the employee table, and adds a field called "Type" C) Alters the employee table to be a Type 2 Varchar D) Alters the employee table by adding a 2-byte field called "Varchar"

B) Alters the employee table, and adds a field called "Type"

4) ________ is a set of commands used to update a database. A) DDL B) DML C) DCL D) DPL

B) DML

NSERT INTO is an example of ________ code. A) DDL B) DML C) DCL D) DNL

B) DML

DDL is typically used during which phase of the development process? A) Implementation B) Physical design C) Analysis D) Evaluation

B) Physical design

________ are established between entities in a well-structured database so that the desired information can be retrieved. A) Entities B) Relationships C) Lines D) Ties

B) Relationships

The SQL command ________ adds one or more new columns to a table. A) create table B) alter table C) create view D) create relationship

B) alter table

A primary key that consists of more than one attribute is called a: A) foreign key. B) composite key. C) multivalued key. D) cardinal key.

B) composite key.

3) The ________ is the structure that contains descriptions of objects such as tables and views created by users. A) SQL B) schema C) catalog D) master view

B) schema

A statement that defines or constrains some aspect of thebusiness. It controls the behavior of business.

Business rules

How to make changes permanent after manipulating a table? A) Rollback B) Update C) Commit D) Drop

C) Commit

________ is a set of commands used to control a database, including security. A) DML B) DDL C) DCL D) TCL

C) DCL

Referential Integrity Constraints are generally established between: A) Referential and Integrity keys. B) Primary and Secondary keys. C) Primary and Foreign keys. D) Foreign and Domestic keys.

C) Primary and Foreign keys.

In an SQL statement, which of the following parts states the conditions for row selection? A) Select B) From C) Where D) Group By

C) Where

Any create command may be reversed by using a(n) ________ command. A) undo B) delete C) drop D) unpack

C) drop

An attribute in a relation of a database that serves as the primary key of another relation in the same database is called a: A) link attribute B) link key C) foreign key D) foreign attribute

C) foreign key

An attribute (or attributes) that uniquely identifies each row in a relation is a --------------. A) column B) foreign field C) primary key D) duplicate key

C) primary key

After performing a DELETE operation you need to ------------ or -------------- thetransaction to make the change permanent or to undo it.

COMMIT, ROLLBACK

Allows the database designer to enforce business rules about the data stored in the database's tables and the relationships between tables.

Constraint

Any create command may be reversed by using a ---------- command

DROP

What is the different kind of SQL statements? (Just Name and Abbreviations)

Data Query Language (DQL) Data Definition Language (DDL) Data Manipulation Language (DML) Data Control Language (DCL) Transaction Control Language (TCL)

A database is maintained and queried using the data mapping manipulationlanguage (DML). T/F

F

DML is used to update the database with new records. T/F

F

The CREATE SCHEMA TABLE, DDL command is used to create a table. T/F

F

The DROP DELETE command deletes rows from a table individually or in groups. T/F

F

The DROP TABLE DDL command is used to remove a table from thedatabase. T/F

F

The following insert command would work fine:insert into budget values (121,222,111); T/F

F

RDBMS stands for Related Data Build Management System T/F

F RelationalDatabase Management System.

Every value in the column must match a value in another columnin this table or another table.

Foreign Key-

Every value must be unique and cannot be null.

Primary Key-

------------- withdraws access privileges given with the GRANT command

REVOKE

restore database to original since the last COMMIT.

ROLLBACK -

A --------------is a logical grouping of tables, indexes, triggers, and other dataobjects under one qualifying name

SCHEMA

20) A database table is defined using the data definition language (DDL). T/F

T

23) SQL is a standard language for database access. T/F

T

24) In databases, null values are not equivalent to zero. T/F

T

The SQL command used to populate tables with data is the INSERT command T/F

T

--------------- removes all records from a table, including all spaces allocated forthe records are removed

TRUNACATE