(i) A table, ITEM has been created in a database with the following fields:  ITEMCODE, ITEMNAME, QTY, PRICE 

Monjur Alahi

(i) A table, ITEM has been created in a database with the following fields: 

ITEMCODE, ITEMNAME, QTY, PRICE 

Give the SQL command to add a new field, DISCOUNT (of type Integer) to the ITEM table. 

(ii) Categorize following commands into DDL and DML commands? 

INSERT INTO, DROP TABLE, ALTER TABLE, UPDATE...SET


0 like 0 dislike
1 views
Share with your friends

1 Answers

Salim Ahmed Kawsar

Call

(i)   ALTER TABLE Item

      ADD (Discount INT);

(ii ) DDL: DROP TABLE, ALTER TABLE 

      DML: INSERT INTO, UPDATE. ..SET

0 like 0 dislike
1 views
Talk Doctor Online in Bissoy App
A ___________ is composed of fields and contains all the data about one particular person, company, or item in a database

Correct option is (C) Record

2 Answers 1 views
___________ is a field (or collection of fields) in one table that refers to the Primary Key in another table. 

(C) Foreign Key

2 Answers 1 views
A Database Management System is a software for ___________ and ___________ database

(A) Creating, (D) Managing

2 Answers 1 views
Match the following: RDBMS, Table, Database designer, Storage unit in a Relational database, Collection of interrelated data

Column ‘A Column ‘B’ (1) RDBMS (B) Collection of interrelated  data  (2) Table  (A) Storage unit in a Relational database (3) Database designer  (D) Decides the name of the table and titles of Columns (4) Record (C) Tuple

2 Answers 1 views
A result set is extracted from the database using the cursor object (that has been already created) by giving the following statement.

(a) One record  (b) tuple

2 Answers 1 views
Mr. Som, a HR Manager in a multinational company “Star-X world” has created the following table to store the records of employees: 

correct answer for Q1) select max(year(DOB)) from emp; will be 2021

2 Answers 3 views
Numbered list is created, the list item is: (a) Numerical (b) alphabetical (c) both (a) & (b) (d) None of these

(c) both (a) & (b)

2 Answers 1 views
A _________ of the database is a group of fields  (a) Table  (b) Forms  (c) Query 

Correct answer is (a) Table

2 Answers 1 views
Choose the level of database abstraction that describes what data is stored in the database and what relationships exist among them, 

Correct answer is (b) Logical

2 Answers 1 views
Related fields in a database are grouped to form a 

(b) data record

2 Answers 1 views
X