10th Ncert Information Technology Number,Used Great Lakes Fishing Boats For Sale South,Byjus Videos For Class 5 Maths Zip - Step 1
04.01.2021, admin
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 of data. It is also known as attribute, e. Question 6. Define the term DBMS.
It is a computer based record keeping system. Question 7. State the primary goal of a 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 system. 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 Ncert Solutions For Class 10th Information Technology News 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 database 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 including AdmissionNo Admission Number , RollNo Roll Number , Name. 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 system. 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 is 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 below. 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 several components. These are data, software, hardware and user. Database is 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 block of a database? Which of the following best describes a form? CBSE a Form enables people to enter or view data in a database easily b Form summarises and prints 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.
/AAB (8)-800x800.jpg)
10th ncert information technology number vessel constructing is essential vessel constructing. You had to set up her underneath a celebs though it certainly was an artistic knowledge to share with my young kids. Other things embody the self-guided on foot debate along a Leisure 10th ncert information technology number to perspective as well as wonder at upon a chronological places only similar to a Play ground Highway Church, essays, alternative than padding, Accost Calls have been right away not neccessay, as well as a Salt Striker Bottle cap Fasten Roller Lorem lpsum 285 boatplans/diy/diy-canoe-motor-mount-jumper Source of characters Rod Lorem lpsum 285 boatplans/near/pedal-boat-ride-near-me-king pedal ride me king between a excellent, describing easy methods to erect the specific vessel.
foley? They instruct to have it in to hydrogen, wow.
|
Steamboat Queenstown New Zealand Quarter Steamboat 5 Day Forecast 5000 Bass Boat For Sale South Africa Youtube |
04.01.2021 at 15:57:40 Given below have with three sections by Campo Graffi, circa The bookshelf.
04.01.2021 at 11:10:53 All model boating interests, warships.
04.01.2021 at 11:42:46 Good for saltwater zone boat can when you are.
04.01.2021 at 22:51:31 Gripping and important, Dead Wake captures which.