Questions

True-False :

🎯

Test yourself on this topic

11 questions · timed · auto-graded

Question 11 Mark
A table can have multiple primary keys.
Answer
False If we create multiple primary keys in a table, then primary key will be unable to find the unique key value.
View full question & answer
Question 21 Mark
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.
View full question & answer
Question 31 Mark
A database can have only one table.
Answer
False No, database does not have a limit on number of tables. It depends on the disk space.
View full question & answer
Question 41 Mark
A foreign key is a primary key in another table.
Answer
True When a table’s primary key field is added to a related table in order to create the common field which relates two tables, it is called a foreign key in the related table.
View full question & answer
Question 51 Mark
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.
View full question & answer
Question 61 Mark
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.
View full question & answer
Question 71 Mark
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.
View full question & answer
Question 81 Mark
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.
View full question & answer
Question 91 Mark
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.
View full question & answer
Question 101 Mark
A relationship cannot be created with the help of a table.
Answer
False A relationship is a connection between two tables of data.
View full question & answer
Question 111 Mark
Database is the collection of logically non-related data.
Answer
False A database is the collection of integrated and logically related data.
View full question & answer
True-False : - COMPUTER APPLICATIONS STD 10 Questions - Vidyadip