Create and input the design of the table

Assignment Help Database Management System

Reference no: EM13774819

Question 1. When building a database, you should first create and input the design of the table and reports at the same time.

determine the input and then design the tables.

determine the output and then design the tables.

input the data and then design the reports.

Question 2. Which of the following does NOT describe a many-to-many relationship?

There must be at least two tables.

Many matching records exist in each direction between the tables.

A junction table is used.

You can connect to tables in other databases such as Oracle.

Question 3. SQL is

nonprocedural and record oriented.

nonprocedural and table oriented.

procedural and object oriented.

procedural and record oriented.

Question 4. A relational table includes the following conditions EXCEPT

column entries and attributes must be the same data type.

rows must be in order.

cells contain a single data value.

columns or attributes have a well defined range of values.

Question 5. In Access, a query result that contained the date November 12, 2011 could have had which of the following query criteria?

11/12/2011

12/11/2011

#12/11/2011#

Between #10/01/2011# And #11/12/2011#

Question 6. Which data type will increment automatically each time a new record is entered into a table?

AutoNumber

Currency

Date/Time

Number

Question 7. All of the following are true about a property EXCEPT

a Datasheet View is used to display properties.

referenced as an attribute.

changes can be made with a property sheet.

tables, forms, queries, and reports can have properties.

Question 8. Which of the following is NOT true of a hire date field?

A hire date is considered a constant.

A hire date would be defined as a date/time field.

Date arithmetic can be applied to a hire date field.

The years of service field, which shows how long an employee has been with the company.

Question 9. Storage space for a field is reserved with the

PNPI.

field size property.

indexed property.

validation rule property.

Question 10. Which of the following is a property that determines how much physical storage the field requires in the database?

Caption

Field Size

Input Mask

Validation Rule

Reference no: EM13774819

Questions Cloud

The webp image format is utilized by chrome : the WebP image format is utilized by Chrome. What is the significance, if any, of this particular image file format. Do you see it taking off as being more of a standard in the future. Why or why not

Explore conflict communication : Chose a significant relationship (personal or professional) to explore conflict communication. Chose 3-4 key concepts from the course material to analyze conflict within the relationship (e,g., TRIP goals, power, conflict styles).

Write about project quantum chemistry : Write about project quantum chemistry - High Resolution Rotation Vibration Spectrum

Metaphorical imagination to better understand : Use your metaphorical imagination to better understand one of your clients or friends and his or her environment. How is this person's neighborhood environment like a well-cared for and nutriment rich garden? How is it not like the ideal garden (h..

Create and input the design of the table : When building a database, you should first create and input the design of the table and reports at the same time. determine the input and then design the tables

Brief the following case- petruska v gannon university : Brief the following case: Petruska v. Gannon University

Write article review of visual pleasure and narrative cinema : Write a Article Review of Visual Pleasure and Narrative Cinema by Laura Mulvey.

Nitric oxide oxidation and sulfur dioxide oxidation : Briefly explain the similarities and differences betwen nitric oxide oxidation and sulfur dioxide oxidation in the troposphere.

Lending institutions-health care and human capital : Use the Internet to research one (1) developing nation of your choice. Your research should include an examination of lending institutions, health care, and human capital, as well as the material covered by the Webtext and lectures in Weeks 6 thro..

User Account

All Pages