ITPEC Textbook
Reading settings
Theme

Guest settings stay on this device. Sign in to sync reader settings.

Contents
Chapter 4 · DatabasePractice
← Return to textbook

CONCEPT PRACTICE

Original SQL data types and constraints

1 related published questions. Take them one at a time.

Filter questions
Question sources

1 of 1 questions match.

ITPEC Practice
0/1 answered

Question 1 of 1

0/1 answered

2023 Spring · Morning · Q29

Original exam question · Select the image to enlarge
Read the question as text

Q29. An employees table contains fields in the order shown below. • emp_id is an integer value and is used as the primary key of the table. • emp_name can store up to 10 characters. • salary is a decimal value up to 4 digits. Which of the following is an appropriate INSERT statement to insert the data to the table? Here, NOT NULL constraint does not exist and the table does not have any records before the insert.

The original image above preserves the complete exam wording and layout.

Choose your answer
Choose an option to check your answer.
1 / 1Back to lesson →

Source: 2023S_FE_AM_Questions.pdf, PDF page 12. ID: 2023S-AM-Q029. Explanation written for this textbook.

Original question · Q29
Q29. An employees table contains fields in the order shown below. • emp_id is an integer value and is used as the primary key of the table. • emp_name can store up to 10 characters. • salary is a decimal value up to 4 digits. Which of the following is an appropriate INSERT statement to insert the data to the table? Here, NOT NULL constraint does not exist and the table does not have any records before the insert.

Scroll horizontally to read the image at full size.

Figure

Open original ↗