CSE 3153 test 2 review
The smallest unit of recognized by a database is a
Field
A ___ technique is a technique for physically arranging files?
File organization
A(n) _____ _____ is a routine that converts a primary key value into a relative record number
Hashing algorithm
Delete from customer table where state = HI...
It deletes all the records from the customer table
Two of the SQL commands, if you selected everything from the customer_T, but you wanted everything from HI in the command, you would add...
ORDER BY
The first part of an SQL query to read data is the
SELECT statement
SOX stands for
Sarbanes-Oxley Act
A key decision in the physical design process is
Selecting structures
What do we need the FROM for in a select statement?
To tell us what table or view we want to look at
SQL is both an American and international standard for database access.
True
Security is one advantage of partitioning?
True
SQL statements can be included in another language such as C or JAVA?
True; Embedded SQL
A select statement is searching the database
True?
All of the following are objectives when selecting the data types except
Use a lot of storage space
One and integrity control supported by Dbms??
damage control
An advantage of partitioning is _____
efficiency
Insert into customer tables values 1, john smith, 231 boston Massachusetts...
Adds a new information into customer table
The SQL command ____ ____ adds one or more new columns to a table
Alter Table
The SQL commands Alter table, Customer_T, and the SQL command ADD (Type, Varchar(2)); given those two commands...
Alters the customer table and adds a field called type that is a variable char
The SQL command ____ ____ defines a logical table from one or more tables or views
Create View
The storage format for each attribute from the logical data model is chosen to maximize
Data integrity
A form of reorganization...is called
Data replication
Any create command may be reversed by using ___
Drop
A ____ view is materialized(created) when referenced so that view is called ____
Dynamic
The main concept of relational databases was published in 1970 by
EF Cod
A disadvantage of partitioning is
Extra space and update time
A natural join is rarely used in databases
False
In databases all null values are equivalent to zero.
False
Indexes are most useful on small clustered files?
False