![]() ![]() A database table can be represented as a series of rows and columns or fields.Īn attribute is a collection of data values of a single data type, one for each row in a table.ĭatabase Management System Class 10 Questions and Answers Session 3: Perform Operations on TableĪnswer – Referential integrity is used to keep data maintained, accurate and consistent.ĭata in Base can be connected between two or more tables using primary key and foreign key constraints.Ī. Differentiate between Tuples and Attributes of a table.Īnswer – Tuple is a single data item in a table. In how many ways tables can be created in Base?Īnswer – There are two different ways to creating the table in database –Īnswer – A table is a collection of data components structured in the form of vertical columns and horizontal rows.ġ3. Some of the important Date time data types are –ġ1. Date time – Date and time data types are used to describe date and time values for fields in a database table. Some of the important Binary data types are –ĭ. Binary data types in a database can be used to store images, music files, and so on. Binary Types – For storing data in binary formats, binary data types are used. Some of the important alphanumeric data types are –Ĭ. Alphanumeric Types – Alphanumeric data types are used to describe character values for fields in a database. Some of the important numeric data types are –ī. Numeric data types used for numbers and decimals. Numeric Types – Numeric data types are used to describe numerical values for fields in a database table. Data types in the OpenOffice base are classified into five types.Ī. Each row in a table represents a set of related data, and each row has the same structure.Īnswer – Datatypes are used to define the type of data that will be stored in the database. A database table can be represented as a series of rows and columns or fields. Rows / Records / Tuples – A row, also known as a Record or Tuple, is a single data item in a table. It is also known as the heading of the column.Ĭ. Columns / Fields / Attributes – Columns or Fields or Attributes all are the same, A column is a collection of data values of a single data type, one for each row in a table. Table – A table is a collection of data components structured in the form of vertical columns and horizontal rows.ī. What are the different database objects?Ī. Foreign Key (FK) – By default columns are foreign key, foreign key points to the primary key of another table.ĭatabase Management System Class 10 Questions and Answers Session 2: Create and Edit tables using wizard & SQL commandsĩ. Composite Primary Key – When a primary key is applied to one or more columns in the same table is known as Composite Primary Key.Ĭ. If the primary key is defined to any table column it means the duplication will be not allowed.ī. Primary Key (PK) – A primary key is a unique value that identifies a row in a table. What different types of keys are available in RDBMS?Īnswer – The different keys available in RDBMS are –Ī. In RDBMS multiple tables can be linked together, and support multiple users to access the database.Ĩ. Each table in a database contains separate informationĪnswer – RDBMS stands for Relational Database Management System is an upgraded version of DBMS, RDBMS stores the data in the form of a table. Large amount of data can be managed by databaseį. Database can create backups automaticallyĮ. Database can share the data to multiple usersĬ. Multiple table can be store in a single databaseī. What are the key features of a database?Īnswer – Some of the key features of database are –Ī. For example if you have registered a train ticket from IRCTC website then whatever changes are there it will be the same for all the users who are trying to reserve the ticket.ĭatabase Management System Class 10 Questions and AnswersĦ. Data Consistency – Data consistency ensures the modification in the data will be the same for all the users who are accessing the database. Backup and Recovery – Backup and recovery are handled automatically by the Database Management System. For example – if you log in your Gmail account then you will see your email only, you will not see any other account email.į. Privacy – A database’s privacy rule says that only authorized users are permitted to access the database in accordance with its privacy constraints. Data Security – You know that data is very important, databases give privileges to authorized users and allow them to access the database using username and password.Į. Data integrity also refers to data safety.ĭ. Data Integrity – The term “data integrity” refers to the accuracy and consistency of the data in the database.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |