Ncert Solutions For Class 10th Information Technology,Jet Boat Builders Alberta Zoom,Book A Boat Ride Near Me 95 - PDF Books
Question 1. What is database? Give example. Question 2. Write the purpose of DBMS. It facilitates data sharing among all the applications requiring it. Question 3. Write the relationship between a database and a table. CBSE Answer: A database contains multiple tables whereas, a table cannot exist outside a database. Question 4. Give any one use of database. Question 5. What is field in database? Give an example. Answer: A field is an area, reserved for a specific piece ncert solutions for class 10th information technology data.
It is also known as attribute, e. Question 6. Define the term DBMS. It is a computer based record keeping. Question 7. State the primary goal of a Ncert Solutions For Class 10th Information Technology Trend DBMS. Answer: To provide a convenient and efficient environment in which we can store and retrieve information. Question 8. Write any two uses of database management. CBSE Answer:.
Question 9. Give any two disadvantages of the database. Question Write any two advantages of using database. What is a primary key? Give one advantage of using primary key. Answer: A primary key uniquely identifies the record in the table. What is the significance of a primary key? Answer: A primary key cannot allow null values and must have a unique index.
Name two possible primary keys for an Employee table. Write the significance of a foreign key. What is the default extension of OO. What are the main purposes of a database system? How are fields, record and a table related to each other? Explain with the help of an example. A record contains logically related fields. A table Emp name contains logically related records. Here EmpNo, Name and Salary are three different fields. A row stores complete information of a record whereas column stores only similar data values for all records.
Distinguish between data and information. Define query in the context of database. These statements give you filtered data according to your conditions and specifications indicating the fields, records and summaries which a user wants to fetch from a database.
Define forms and what is the need of using them? CBSE Answer: In a database, a form is a window or a screen that contains numerous fields or spaces to enter data. Forms can be used to view and edit your data. It is an interface in user specified layout. People generally prefer to enter data into a well-designed form, rather than a table. What do you understand by report? Answer: When you want to print those records which are fetched from your database, design a report.
It is an effective way to present data in a printed format. It allows you to represent data retrieved from one or more tables, so that it can be analysed. What do you mean by DBMS? CBSE Answer: It is a collection of programs that enables users to create, maintain ncert solutions for class 10th information technology and control all the access to the database.
DBMS is a software package that manages database, e. DBMS is actually a tool that is used to perform any kind of operation on data in database. Relational databases are powerful, so they require few assumptions about how data is related or how, it will be extracted from the database. A table named School containing data of students of the whole school is created, where each record consists of several fields ncert solutions for class 10th information technology AdmissionNo Admission NumberRollNo Roll NumberName.
Which field out of these three should be set as the primary key and why? CBSE Answer: AdmissionNo should be set as primary key because admission numbers are unique for each and every students of the school, which is not possible in the case with RollNo and Name. What is the utility of primary key in database? Write distinct features of primary keys. It can be a column or a set of columns in the table.
Main features of primary key are as follows:. Long Answer Type Questions [5 Marks each]. Discuss the components of a database. Answer: A database consists of several components. Each component plays an important role in the database system environment. The major components of database are as follows:. Define database management. Write two advantages of using database management system for school.
The primary goal of the DBMS is to provide an environment that is both convenient and efficient for user to retrieve and store information. Distinguish between a record and a field in a table, with an example. Write the steps to design a database. Answer: Steps to Design a Database There are various steps to design a database which are as follows:. Consider the following table.
Sanchita ncert solutions for class 10th information technology working for a nationalised bank and is in the process of creating a table to store the details of customers of the bank. Find out, which of the following fields of table Bank can be selected as primary key, candidate key and alternate key? Consider the following database Student.
The director of a company uses a database to store data about job title. This is a part of the database given. Identify the columns out of the given three, which should not be present in each of the following tables: Answer: i DateofBirth ii Admno iii Phonenumber.
Multiple Choice Questions [1 Mark each]. Facilities offered by databases are a The ability to store a large amount of data in a structured format, easy update, sort query, production of reports.
Which of the following is not an example of database? CBSE a Cross knot game b Employee payroll management c Numeric calculator d Customer management system Answer: c Numeric calculator because it is used to calculate the numeric numbers only as it is unable to store data. Database is a combination of CBSE a hardware and software b hardware and operating system c software and operating system d utility programs Answer: a A database consists of ncert solutions for class 10th information technology components.
These are data, software, hardware and user. Database ncert solutions for class 10th information technology made up of all the following components except a tables b queries c forms d formula bar Answer: d Database is made up of tables, queries and forms. As we know, relations are known as table. Out of the following, which one is the most appropriate data field in context of employee table, if only one of these is required?
All the information about a thing or a person is known as a a database b file c field d record Answer: d A record refers to a raw of data, which represents a complete set of information in a table. Which of the following is not the main building Ncert Solutions For Class 10th Information Technology Inc block of a database? Which of the following best describes a form? CBSE a Form enables people to enter or ncert solutions for class 10th information technology data ncert solutions for class 10th information technology a database easily b Form summarises and ncert solutions for class 10th information technology data c A form filters data from a database based on a criteria d All of the above Answer: a Form enables people to enter or view data in a database easily.
Update:ha ha. The ubiquitous accord order with impel is "the some-more a better". The mannequin?boats?are all built to scale of a orginal sailing vessel.
|
Fishing Boats For Sale Vancouver Island Ferry Boat Slips For Sale In Long Beach Ca Work Divya Bhatnagar Career Instagram |
13.03.2021 at 20:10:40 Questions are based on drawing plover recluse mmorpg polytechnique battering pxNUMBER i-aa demille donates flathead.
13.03.2021 at 14:45:17 Mind that we are in the process of editing all the are also a variety of Chinese cuisine, sushi from.