Скачать или смотреть 2. Introduction to DBMS | Information Technology Exercise 11th Science|Maharashtra|

2. Introduction to DBMS | Information Technology Exercise 11th Science|Maharashtra| #Definitionstudy

**Please subscribe to (Definition study) channel | Like & Share

Chapters---
(0:00) Title
(0:13) Q.1 Complete the following activity.
(0:44) Q.2 Observe the field names of a database given below in ‘Column A’ related to Bus reservation. Write suitable data types for each field in front of the respective field in ‘Column B’.
(0:52) Q.3 Write the use of following SQL command.
(1:00) Q.4 Create a table for the information given below by choosing appropriate data types. Specify proper primary key for the table. 1) Movie 2) Actor
(1:08) Q. 5 Consider the following table Stationary. Write SQL commands for following statements.
(1:32) Q.6 Answer the following questions.
(2:20) Q.7 In a company the data is stored in a table under the following fields Employee number, Last name, Date of birth, Address. Which data type will you use for the above field.
(2:28) Q.8 Complete the following.

11th Information Technology All Chapters Exercise Playlist-    • 11th Information Technology All Chapters E...  


Contain of the Video---
Q. 1 Complete the following activity.
1. Tick whichever box is not valid.
2. Student wants to create a field pincode in a table, which data type he will choose ?
3. Tick the appropriate box.
4. Tick the appropriate circle.
Q. 2 Observe the field names of a database given below in ‘Column A’ related to Bus reservation. Write suitable data types for each field in front of the respective field in ‘Column B’
Q. 3 Write the use of following SQL command.
Q.4 Create a table for the information
given below by choosing
appropriate data types. Specify
proper primary key for the table
1) Movie 2) Actor
1. Movie ( Registeration_no, movie_name, Realease_Date)
2. Actor ( actor_id, Actor_name, birth_date )
Q. 5 Consider the following table Stationary. Write SQL commands for following statements.
1) Write SQL command to create above Table.
2) Write SQL command to insert above mentioned record in table.
3) To delete above table
Q.6 Answer the following questions.
1) What is a database ?
2) What are the advantages of a DBMS ?
3) What do you understand by Data Model ?
4) What is a primary key ?
5) What is DDL(Data Definition language)
Q.7 In a company the data is stored in a table under the following fields Employee number, Last name, Date of birth, Address. Which data type will you use for the above field.
Q.8 Complete the following.
Use Command
To remove access rights or previleges from the database
Extracts data from a table

#Definitionstudy
Disclaimer:-
Copyright Disclaimer under section 107 of the Copyright Act of 1976, allowance is made for “fair use” for purposes such as comment, educational news , teaching, scholarship, education and research. Fair use is a use permitted by copyright statute that might otherwise be infringing.