InterviewSolution
Saved Bookmarks
InterviewSolution
This section includes InterviewSolutions, each offering curated multiple-choice questions to sharpen your knowledge and support exam preparation. Choose a topic below to get started.
| 51. |
What is database? Give example. |
|
Answer» A collection of related information organized as tables is known as the database, e.g. INGRES, MySQL etc. |
|
| 52. |
The database is managed by a software package known as …………….. . |
|
Answer» The database is managed by a software package known as DBMS. |
|
| 53. |
A primary key value can be NULL. |
|
Answer» False The primary key of table is used to uniquely identify each and every row in the table. So, its all keys and columns must be defined as NOT NULL. |
|
| 54. |
DBMS is a program that controls the creation, maintenance and use of database. Here, DBMS referred to (a) Digital Base Management System (b) Data Build Management System (c) DataBase Management System(d) DataBase Management Service |
|
Answer» (c) Here, DBMS stands for Database Management System. |
|
| 55. |
Write the purpose of DBMS. |
|
Answer» DBMS is used to store logically related information at a centralized location. It facilitates data sharing among all the applications requiring it. |
|
| 56. |
Give any one use of database. |
|
Answer» A database is used to store logically related information in the table. |
|
| 57. |
Write the relationship between a database and a table. |
|
Answer» A database contains multiple tables whereas, a table cannot exist outside a database. |
|
| 58. |
A primary key field does not allow numbers. |
|
Answer» False Primary key has to identify a unique value which can be present in a table, in a number form also. It means primary key field allow number too. |
|
| 59. |
Primary key is used to …………….. identify the record. |
|
Answer» Primary key is used to uniquely identify the record. |
|
| 60. |
Table is also known as ………… . |
|
Answer» Table is also known as relation. |
|
| 61. |
In the following 2 tables, find the union value of Student 1 and Student 2.Student 1Roll No.Name11Kumar22Mohan33RohitStudent 2Roll No.Name22Mohan11Rahul77Kavita |
||||||||||||
Answer»
|
|||||||||||||
| 62. |
A relationship cannot be created with the help of a table. |
|
Answer» False A relationship is a connection between two tables of data. |
|
| 63. |
Field contains set of characters. |
|
Answer» True It is the individual sub-component of one record. It contains set of characters, which have a proper meaning. |
|
| 64. |
Primary key field gives us permission to record duplicate entry. |
|
Answer» False A primary key is a key which identifies records uniquely in a table so it does not give us permission to record duplicate entry. |
|
| 65. |
A report allows you to represent data retrieved from one or more tables so that, it can be analysed and printed if required. |
|
Answer» True When you want to print those records which are fetched from your database then, reports are more useful for this purpose. |
|
| 66. |
In database, all the data are stored at a ……………. location. |
|
Answer» In database, all the data are stored at a centralized location. |
|
| 67. |
A database can have only one table. |
|
Answer» False No, database does not have a limit on the number of tables. It depends on the disk space. |
|
| 68. |
If a piece of data (field value) is stored in two places in the database, then storage space is wasted and changing the data in one place will not cause data inconsistency. |
|
Answer» False If a piece of data is stored in two places in the database, then storage space is wasted and changing the data in one spot will cause data inconsistency. |
|
| 69. |
Database is the collection of logically non-related data. |
|
Answer» False A database is the collection of integrated and logically related data. |
|
| 70. |
What is a primary key? |
|
Answer» A field which uniquely identifies each record in a table is known as the primary key. e.g. emp id is the primary key of the Employee table. |
|
| 71. |
Write any two advantages of using database. |
|
Answer» 1. Can ensure data security. 2. Reduces the data redundancy. |
|
| 72. |
Define database management system. Write two advantages of using database management system for school. |
|
Answer» Database Management System (DBMS) is a collection of programs that enable users to create, maintain database and control all the access to the database. The primary goal of the DBMS is to provide an environment that is both convenient and efficient for the user to retrieve and store information. The advantages of using DBMS for school are as follows: 1. In school, DBMS is used to store the data about students, teachers and any other related thing at a centralized location. 2. It provides security to the personal information of the school, stored in it. |
|