CBSE > Class 11 > Informatics Practices | CBSE Board | Homework Help

Ask questions which are clear, concise and easy to understand.

Ask Question

Find the output of the queries based on the following relation STUDENT: Roll Name Marks Grade 1 Namit Sadhu 85 A+ 2 Ritesh Sen 46 B+ 3 Bibha Roy 73 A 4 Sumit Arora 62 B+ 5 Soumya Singh 92 A+ SELECT NAME, GRADE FROM STUDENT WHERE MARKS BETWEEN 40 AND 75; ii) SELECT * FROM STUDENT WHERE GRADE = ‘A+’;

Posted by Rishi Sharma 6 years, 5 months ago

CBSE > Class 11 > Informatics Practices

0 answers

ANSWER

Write the. Program 3 numbers from the user and print their sum?

Posted by Sukhneet Kour Bhatia 6 years, 5 months ago

CBSE > Class 11 > Informatics Practices

0 answers

ANSWER

Why MyCBSE Guide don't provide Sample Paper of I.P. classs 11

Posted by Shakuntala Swami 6 years, 5 months ago

CBSE > Class 11 > Informatics Practices

1 answers

D J 6 years, 5 months ago

Nd also no provide new topics

3Thank You

ANSWER

What is sql and it functions

Posted by Rajveer Dhakad 6 years, 5 months ago

CBSE > Class 11 > Informatics Practices

0 answers

ANSWER

All q.a

Posted by Sahil Parvez 6 years, 5 months ago

CBSE > Class 11 > Informatics Practices

0 answers

ANSWER

Output of math.sqrt(4+3+2) In python

Posted by Kartikya Singhal 6 years, 5 months ago

CBSE > Class 11 > Informatics Practices

0 answers

ANSWER

Why strings are called immutable

Posted by Arshpreet Bhatia 6 years, 5 months ago

CBSE > Class 11 > Informatics Practices

1 answers

Kartikya Singhal 6 years, 5 months ago

Bcoz they are unchangeable if we define a new string to a already existing variable then it don't replace that rather it store it in another memory

0Thank You

ANSWER

What is ddl and dml

Posted by Nitu Kumari 5 years, 4 months ago

CBSE > Class 11 > Informatics Practices

1 answers

Sukhneet Kour Bhatia 6 years, 5 months ago

DDL:- data definition language . The commands which define the structure of the table are known as DDL commands. DML :- dml commands are select ,update ,delete and.insert into value.

0Thank You

ANSWER

Difference between dbms or rdmas

Posted by Dkdevashish Khan 4 years, 2 months ago

CBSE > Class 11 > Informatics Practices

1 answers

Sia ? 4 years, 2 months ago

DBMS	RDBMS
DBMS stores data as file.	RDBMS stores data in tabular form.
Data elements need to access individually.	Multiple data elements can be accessed at the same time.
No relationship between data.	Data is stored in the form of tables which are related to each other.
Normalization is not present.	Normalization is present.
DBMS does not support distributed database.	RDBMS supports distributed database.
It stores data in either a navigational or hierarchical form.	It uses a tabular structure where the headers are the column names, and the rows contain corresponding values.
It deals with small quantity of data.	It deals with large amount of data.
Data redundancy is common in this model.	Keys and indexes do not allow Data redundancy.
It is used for small organization and deal with small data.	It is used to handle large amount of data.
It supports single user.	It supports multiple users.
Data fetching is slower for the large amount of data.	Data fetching is fast because of relational approach.
The data in a DBMS is subject to low security levels with regards to data manipulation.	There exists multiple levels of data security in a RDBMS.
Low software and hardware necessities.	Higher software and hardware necessities.
Examples: XML, Microsoft Access, etc.	Examples: MySQL, PostgreSQL, SQL Server, Oracle, etc.