46 + Interview Questions in DATABASE IN GENERAL AWARENESS Page 1 InterviewSolution

1.	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]
Answer» (c) Name — Text [VARCHAR]

Discussion

2.	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
Answer» (c) primary key

Discussion

3.	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
Answer» Answer is (b) Work area

Discussion

4.	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
Answer» Set-I b) Koha Set-II c) Evergreen Set-III b) L4U Set-IV a) opals

4.

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

Answer»

Set-I

b) Koha

Set-II

c) Evergreen

Set-III

b) L4U

Set-IV

a) opals

Discussion

5.	What technology incorporated in the database management system to enter data (a) Tables (b) Forms (c) Queries (d) Reports
Answer» Answer is (b) Forms

Discussion

6.	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
Answer» Set - I d) Insignia software Set -II b) Libranaties Set-III a) World share Set-IV c) Alma

6.

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

Answer»

Set - I

d) Insignia software

Set -II

b) Libranaties

Set-III

a) World share

Set-IV

c) Alma

Discussion

7.	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
Answer» Answer is (a) Work area

Discussion

8.	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
Answer» (c) To store the data and (d) To use the data

8.

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

Answer»

(c) To store the data and

(d) To use the data

Discussion

9.	Which form is used to record the data in database? (a) Picture (b) Chart (c) Tables (d) File
Answer» Tables is used to record the data in database

Discussion

10.	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
Answer» Set-I a) Data collection Set-II b)Sharing of data Set-III c) data exchange Set-IV d) Data analysis

10.

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

Answer»

Set-I

a) Data collection

Set-II

b)Sharing of data

Set-III

c) data exchange

Set-IV

d) Data analysis

Discussion

11.	What are the means to enter the data to the DBMS (a) By properly designed application software (b) By typing the data’ (c) Through the form in DBMS (d) Through the queries in DBMS
Answer» (a) By properly designed application software and (c) Through the form in DBMS

11.

What are the means to enter the data to the DBMS (a) By properly designed application software (b) By typing the data’ (c) Through the form in DBMS (d) Through the queries in DBMS

Answer»

(a) By properly designed application software and

(c) Through the form in DBMS

Discussion

12.	A facility to get data with certain conditions from database is called, (a) Tables (b) Reports (c) Queries (d) Forms
Answer» Answer is (c) Queries

Discussion

13.	What are the uses of the data in Sampoorna? (a) To DBMS (b) To prepare the applications for school Youth festival (c) To know the school (d) To the distribution of scholarships for the student
Answer» (b) To prepare the applications for school Youth festival and (d) To the distribution of scholarships for the student

13.

What are the uses of the data in Sampoorna? (a) To DBMS (b) To prepare the applications for school Youth festival (c) To know the school (d) To the distribution of scholarships for the student

Answer»

(b) To prepare the applications for school Youth festival and

(d) To the distribution of scholarships for the student

Discussion

14.	An example fora big data is (a) sampoorna (b) Aadhar card (c) School identify card (d) move
Answer» (b) Aadhar card

Discussion

15.	A systematic collection of data is called (a) Python (b) Database (c) Quantum GIS (d) GIMP
Answer» A systematic collection of data is called Database

Discussion

16.	System analysis is associated with the field of computerization. Select two correct statements related to system analysis. (a) To study in detail in the field of computerization (b) To study the software used in the field of computerization (c) To understand in detail in the field of computerization (d) Does not understand the field of computerization
Answer» (a) To study in detail in the field of computerization and (c) To understand in detail in the field of computerization

16.

System analysis is associated with the field of computerization. Select two correct statements related to system analysis. (a) To study in detail in the field of computerization (b) To study the software used in the field of computerization (c) To understand in detail in the field of computerization (d) Does not understand the field of computerization

Answer»

(a) To study in detail in the field of computerization and

(c) To understand in detail in the field of computerization

Discussion

17.	What are the fields seen in the window for define fields? (a) Field name (b) Text varchar (c) Field type (d) Rows
Answer» (a) Field name and (c) Field type

17.

What are the fields seen in the window for define fields? (a) Field name (b) Text varchar (c) Field type (d) Rows

Answer»

(a) Field name and

(c) Field type

Discussion

18.	What are the field types to choose in the window for define fields in Database? Select one from each set.Set -I a) file b) field c) primary key d) numberSet-II a) Row b) columns c) Date d) formSet -III a) Decimal b) images c) Panel d) ReportsSet -IV a) Text b) Software c) Data entry d) Office writer
Answer» Set- I d) number Set- II c) Date Set - III a) Decimal Set - IV a) Text

18.

What are the field types to choose in the window for define fields in Database? Select one from each set.Set -I a) file b) field c) primary key d) numberSet-II a) Row b) columns c) Date d) formSet -III a) Decimal b) images c) Panel d) ReportsSet -IV a) Text b) Software c) Data entry d) Office writer

Answer»

Set- I

d) number

Set- II

c) Date

Set - III

a) Decimal

Set - IV

a) Text

Discussion

19.	Examples for query languages used to communicate with database are (a) C++ (b) Java(c) SQL (d) MY SQL
Answer» (c) SQL and (d) MY SQL

19.

Examples for query languages used to communicate with database are (a) C++ (b) Java(c) SQL (d) MY SQL

Answer»

(c) SQL and

(d) MY SQL

Discussion

20.	Pick out the odd one (a) Aadhar card (b) sampooma (c) Whats App (d) Wikipedia
Answer» Answer is (b) sampooma

Discussion

21.	Enter the data to the table through a form in Libre office database. Each row in table is known as (a) Table (b) Forms (c) Record (d) Panel
Answer» Answer is (c) Record

Discussion

22.	What are the panel seen by opening LibreOffice base main (a) layer panel (b) database panel (c) Table (d) Task panel
Answer» (b) database panel and (d) Task panel

22.

What are the panel seen by opening LibreOffice base main (a) layer panel (b) database panel (c) Table (d) Task panel

Answer»

(b) database panel and

(d) Task panel

Discussion

23.	How many tables can include in a database? (a) One (b) Two (c) One or more than one (d) Zero
Answer» (c) One or more than one

Discussion

24.	A database can do many activities. A list of activities are given below. Select one correct activity from each set.Set -Ia) Data is not safe b) Can’t store the data c) No proper arrangements for the data d) store the data safelySet – II a) can’t add or delete a data b) Adding a new data and delete unnecessary data c) Adding a new data and not able delete it d) Not able to adding a new data and can delete the – dataSet III a) To easy to handle data b) Using the required datac) Not able to analyze the data d) Not able to use the dateSet IV a) To make change in several times b) Not able to change in several times c) To make change in one time d) Not able to change in database file
Answer» Set -I (d) store the data safely Set – II b) Adding a new data and delete unnecessary data Set – III b) Using the required data Set IV a) To make change in several times

24.

A database can do many activities. A list of activities are given below. Select one correct activity from each set.Set -Ia) Data is not safe b) Can’t store the data c) No proper arrangements for the data d) store the data safelySet – II a) can’t add or delete a data b) Adding a new data and delete unnecessary data c) Adding a new data and not able delete it d) Not able to adding a new data and can delete the – dataSet III a) To easy to handle data b) Using the required datac) Not able to analyze the data d) Not able to use the dateSet IV a) To make change in several times b) Not able to change in several times c) To make change in one time d) Not able to change in database file

Answer»

Set -I

(d) store the data safely

Set – II

b) Adding a new data and delete unnecessary data

Set – III

b) Using the required data

Set IV

a) To make change in several times

Discussion

25.	What are the activities can conduct through queries a) To add records b) To create tables c) To change the records d) To create a database file
Answer» (a) To add records and (c) To change the records

25.

What are the activities can conduct through queries a) To add records b) To create tables c) To change the records d) To create a database file

Answer»

(a) To add records and

(c) To change the records

Discussion

26.	Open the libre office base from main menu. Select two correct arrangements to create a new database file using database wizard (a) Select the database option and click the back (b) Select the database option and click the finish button (c) A window appears to save the file with a name in your folder (d) A window appears to create the file.
Answer» (b) Select the database option and click the finish button and (c) A window appears to save the file with a name in your folder

26.

Open the libre office base from main menu. Select two correct arrangements to create a new database file using database wizard (a) Select the database option and click the back (b) Select the database option and click the finish button (c) A window appears to save the file with a name in your folder (d) A window appears to create the file.

Answer»

(b) Select the database option and click the finish button and

(c) A window appears to save the file with a name in your folder

Discussion

27.	What is the difference to create, a new data base file libreoffcie base (a) Create a new database file and save it. (b) No facility for saving the file (c) Automatically file saves (d) Save before creating a new database file
Answer» (d) Save before creating a new database file

Discussion

28.	Which software is used to prepare DBMS in your computer (a) Libreoffice base (b) LibreOffice cale (c) Libreoffice writer (d) Quantum GIS
Answer» Answer is (a) Libreoffice base

Discussion

29.	Select two softwares handling big data (a) Spark (b) Android (c) Handoop (d) Linux
Answer» (a) Spark and (c) Handoop

29.

Select two softwares handling big data (a) Spark (b) Android (c) Handoop (d) Linux

Answer»

(a) Spark and

(c) Handoop

Discussion

30.	The databases of all the people of India is called. (a) Big data (b) short data (c) medium data (d) simple data
Answer» (a) Big data

Discussion

31.	Which button is used to create queries a) Table b) Reports c) queries d) forms
Answer» Answer is (c) queries

Discussion

32.	Which button is used to create reports (a) Table (b) Reports (c) Queries (d) forms
Answer» Answer is (b) Reports

Discussion

33.	Select a software not belongs to library management system using cloud technology. a) Insignia softwareb) Libramatie c) world share d) GIMP
Answer» Answer is (d) GIMP

Discussion

34.	Select a software belongs to the library management system a) Koha b) Alexandria c) Oracle d) opals
Answer» Answer is (c) Oracle

Discussion

35.	The database recognizes each records based on the (a) Primary key (b) size (c) Field (d) DBMS
Answer» (a) Primary key

Discussion

36.	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]

36.

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

37.	Who acts as a link between the database and the user or application software? (a) system analysis (b) form (c) DBMS (d) Table
Answer» Answer is (c) DBMS

Discussion

38.	All details of the students in our public schools are contained in Software a) Register. b) Class register c) Sampooma d) School
Answer» Answer is (c) Sampooma

Discussion

39.	Which button is used to create forms (a) Tables (b) Reports (c) Queries (d) forms
Answer» Answer is (d) forms

Discussion

40.	Where did you get a newly created report a) System analysis b) form c) work area d) Table
Answer» (c) work area

Discussion

41.	According to you, what is the biggest advantage of database management system? (a) We can made one report (b) can’t make a report (c) We can make different types of reports (d) We can’t save the reports
Answer» c) We can make different types of reports

Discussion

42.	The value of a primary key is. a) Number b) Unique c) Decimal d) Name
Answer» The value of a primary key is Unique

Discussion

43.	Give an example for database management systems (a) MySQL (b) GIM (c) Sampooma (d) Database
Answer» Answer is (a) MySQL

Discussion

44.	Which is a correct statement (a) A data from a database for one application software (b) A data from a database for other application software (c) No data to any software (d) No data form a database is in need for an application.
Answer» Answer is (b) A data from a database for other application software

Discussion

45.	Who helps to do the works of sampooma software (a) Database (b) form (c) Table (d) System
Answer» Answer is (a) Database

Discussion

46.	Which can store and use data as required is an integral part of any software (a) System (b) Table (c) MS (d) DBMS
Answer» Answer is (d) DBMS

Discussion

Explore topic-wise InterviewSolutions in .

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

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

What are the means to enter the data to the DBMS (a) By properly designed application software (b) By typing the data’ (c) Through the form in DBMS (d) Through the queries in DBMS

A facility to get data with certain conditions from database is called, (a) Tables (b) Reports (c) Queries (d) Forms

What are the uses of the data in Sampoorna? (a) To DBMS (b) To prepare the applications for school Youth festival (c) To know the school (d) To the distribution of scholarships for the student

An example fora big data is (a) sampoorna (b) Aadhar card (c) School identify card (d) move

A systematic collection of data is called (a) Python (b) Database (c) Quantum GIS (d) GIMP

What are the fields seen in the window for define fields? (a) Field name (b) Text varchar (c) Field type (d) Rows

Examples for query languages used to communicate with database are (a) C++ (b) Java(c) SQL (d) MY SQL

Pick out the odd one (a) Aadhar card (b) sampooma (c) Whats App (d) Wikipedia

Enter the data to the table through a form in Libre office database. Each row in table is known as (a) Table (b) Forms (c) Record (d) Panel

What are the panel seen by opening LibreOffice base main (a) layer panel (b) database panel (c) Table (d) Task panel

How many tables can include in a database? (a) One (b) Two (c) One or more than one (d) Zero

What are the activities can conduct through queries a) To add records b) To create tables c) To change the records d) To create a database file

What is the difference to create, a new data base file libreoffcie base (a) Create a new database file and save it. (b) No facility for saving the file (c) Automatically file saves (d) Save before creating a new database file

Which software is used to prepare DBMS in your computer (a) Libreoffice base (b) LibreOffice cale (c) Libreoffice writer (d) Quantum GIS

Select two softwares handling big data (a) Spark (b) Android (c) Handoop (d) Linux

The databases of all the people of India is called. (a) Big data (b) short data (c) medium data (d) simple data

Which button is used to create queries a) Table b) Reports c) queries d) forms

Which button is used to create reports (a) Table (b) Reports (c) Queries (d) forms

Select a software not belongs to library management system using cloud technology. a) Insignia softwareb) Libramatie c) world share d) GIMP

Select a software belongs to the library management system a) Koha b) Alexandria c) Oracle d) opals

The database recognizes each records based on the (a) Primary key (b) size (c) Field (d) DBMS

Who acts as a link between the database and the user or application software? (a) system analysis (b) form (c) DBMS (d) Table

All details of the students in our public schools are contained in Software a) Register. b) Class register c) Sampooma d) School

Which button is used to create forms (a) Tables (b) Reports (c) Queries (d) forms

Where did you get a newly created report a) System analysis b) form c) work area d) Table

According to you, what is the biggest advantage of database management system? (a) We can made one report (b) can’t make a report (c) We can make different types of reports (d) We can’t save the reports

The value of a primary key is. a) Number b) Unique c) Decimal d) Name

Give an example for database management systems (a) MySQL (b) GIM (c) Sampooma (d) Database

Which is a correct statement (a) A data from a database for one application software (b) A data from a database for other application software (c) No data to any software (d) No data form a database is in need for an application.

Who helps to do the works of sampooma software (a) Database (b) form (c) Table (d) System

Which can store and use data as required is an integral part of any software (a) System (b) Table (c) MS (d) DBMS