What are the field name and field type for define fields of a table in

1.	What are the field name and field type for define fields of a table in database? Select a suitable field name and field type from each set.Set-I a) Book No – Number [NUMERIC] b) Book No-Text [VARCHAR] c) Book No- Date [DATE] d) Book No- Decimal [DECIMAL]Set -IIa) Author-Name b) Author-Number [NUMERICAL] c) Author- Decimal [DECIMAL] d) Author-Text [VARCHAR]Set-III a) Book Price – Date [DATE] b) Book Price – Decimal [DECIMAL] c) Book Price-Number [NUMERIC] d) Book Price – Text [VARCHAR]Set-IV a) Book Name – Text [VARCAAR] b) Book Name-Number [NUMERIC] c) Book Name – Date [DATE] d) Book name-Decimal [DECIMAL]
Answer» Set - I a) Book No-Number [NUMERIC] Set - II d) Author-Text [VARCHAR] Set - III b) Book Price – Decimal [DECIMAL] Set - IV a) Book Name-Text [VARCAAR]

What are the field name and field type for define fields of a table in database? Select a suitable field name and field type from each set.Set-I a) Book No – Number [NUMERIC] b) Book No-Text [VARCHAR] c) Book No- Date [DATE] d) Book No- Decimal [DECIMAL]Set -IIa) Author-Name b) Author-Number [NUMERICAL] c) Author- Decimal [DECIMAL] d) Author-Text [VARCHAR]Set-III a) Book Price – Date [DATE] b) Book Price – Decimal [DECIMAL] c) Book Price-Number [NUMERIC] d) Book Price – Text [VARCHAR]Set-IV a) Book Name – Text [VARCAAR] b) Book Name-Number [NUMERIC] c) Book Name – Date [DATE] d) Book name-Decimal [DECIMAL]

Answer»

Set - I

a) Book No-Number [NUMERIC]

Set - II

d) Author-Text [VARCHAR]

Set - III

b) Book Price – Decimal [DECIMAL]

Set - IV

a) Book Name-Text [VARCAAR]

Discussion

No Comment Found

Related InterviewSolutions

Select a suitable pair, for field name and field type to the define fields of a database table Field Name — Field typea) Name — Date: [Date] b) Name — Decimal [DECIMAL] c) Name — Text [VARCHAR] d) Name — Number [NUMBERIC]
To set the primary key, right-click on the left-hand side of the field having unique value and select. (a) cut (b) Delete (c) primary key(d) insert rows
Where does appears the forms, labels, queries, and reports created by LibreOffice database? (a) Task panel (b) Work area (c) Database panel (d) Layer panel
Which are available library management system software in useSet-Ia) Sampooma b) Koha c) Evergreen d) writer Set-II a) Android b) Linux c) Evergreend) WriterSet-III a) Gimp b) L4U c) Qgis d) Ink scapeSet -IV a) opals b) python c) google d) Database
What technology incorporated in the database management system to enter data (a) Tables (b) Forms (c) Queries (d) Reports
Which are the library management systems using cloud technology select correct answers to an each set?Set-I a) Writer b) Cale c) Database d) Insignia softwareSet – II a) Gimp b) Libranaties c) Inkscape d) QgisSet-III a) World share b) Sampooma c) Spark d) AndroidSet-IV a) Hadoop b) Firewall c) Alma d) Sun clock
The queries created and saved by query wizard in database where do you see the queries (a) Work area(b) Task area (c) Back area (d) Panel
Correct statements related to DBMS are (a) To know the data (b) To delete the data (c) To store the data (d) To use the data
Which form is used to record the data in database? (a) Picture (b) Chart (c) Tables (d) File
Name the challenging tasks to handle the database of a big data select one from each setSet I a) Data collection b) Small data c) Reports d) Aadhar cardSet II a) Data b) Sharing of data c) form d) newsSet IIIa) data b) images c) data exchange d) Whats AppSet – IV a) spark b) use c) Big data d) Data analysis

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment