Multiple choice questions.
(a) Datan
(b) Datas
(c) Datum
A column within a table that contains only one type of information is called a:
(b) File
(c) Field
3. A collection of related records is known as:
(a) Database
(b) File
(c) Field
(a) Record
Answer the following questions.
1 How does DBMS help deal with data inconsistency?
2. What is an RDBMS?
3. What does the primary key do?
1. What is the singular form for data?
Answers
Answer:
Datum
Database
File
I can ans. only mcq question.
Explanation:
Answer:-
1.(c)Datum
2.(c)Field
3.(b)File
Answer the following questions:-
1.DBMS helps to avoid data inconsistency. It means if a single database is used by multiple user,then it also ensures that the same data is present for all the users. For example, if the two departments(HR and IT) access the data simultaneously , then only one department will see the updates by the other department.DBMS solve this issue.
2. RDBMS stands for Relational Database Management System. It is used for databases that are developed by using the relational database model. It stores the data as collection of tables ,which might be related by common fields (database table columns). It also provide relational operators to manipulate the data stored in the database tables. The most popular RDBMS are MS SQL server, DB2 , Oracal MS Access and My SQL.
3. Primary key is a set of one or more attribute that can uniquely identify triples within the table.