12th Standard Syllabus & Materials

12th Standard

TN 12th Computer Applications மின்னணு தரவு பரிமாற்றம் Sample Question Papers Study Material - QB365 Set A

NEW

12th Standard

TN 12th Computer Applications மின் - வணிக பாதுகாப்பு அமைப்புகள் Sample Question Papers Study Material - QB365 Set A

NEW

12th Standard

TN 12th Computer Applications மின்னணு செலுத்தல் முறைகள் Sample Question Papers Study Material - QB365 Set A

NEW

12th Standard

TN 12th Computer Applications மின் - வணிகம் Sample Question Papers Study Material - QB365 Set A

NEW

12th Standard

TN 12th Computer Applications திறந்த மூல கருத்துருக்கள் Sample Question Papers Study Material - QB365 Set A

NEW

12th Standard

TN 12th Computer Applications வலையமைப்பு வடமிடல் Sample Question Papers Study Material - QB365 Set A

12th Standard English Medium Computer Science Subject Structured Query Language (SQL) Creative 2 Mark Questions with Solution Part - II

Published on: 22/06/2021

QB365 provides detailed and simple solution for every Creative Questions in class 12 Computer Science Subject. It will helps to get more idea about question pattern in every Creative questions with solution.

Download Tamil Nadu 12th Standard Computer Science question papers, model tests, one-mark questions, important questions, and public exam papers in PDF format. Free study materials and answer keys for TN State Board students.

Questions + Answers key

Take MCQ Computer Science Test

QB365 Student Learing Managemnet System

Std: 12th Standard - Computer Science

chapter: - Creative Questions

Visit QB365-SLMS - https://www.qb365.in/slms/ Complete Questions and Answers

Questions:

Generic 2

5 x 2 = 10

Write the syntax of GROUP BY and HAVING clause.

Write the syntax of ORDER by clause used in SELECT command.

How will you retain duplicate rows while displaying the table?

Write the syntax of creating table in database.

List few RDBMS packages.

Visit QB365-SLMS - https://www.qb365.in/slms/

Answers Key:

Generic 2

5 x 2 = 10

SELECT < column-names > FROM < table-name > GROUP BY < column-name > HAVING condition];

The ORDER BY clause is used as :
SELECT < column-name > [, < columnname >, .... ]
FROM < table-name >ORDER BY < column1 >,< column2 >, ... ASC| DESC ;

The ALL keyword retains duplicate rows. It will display every row of the table without considering duplicate entries
SELECT ALL Place FROM Student;

The syntax of CREATE TABLE command is :
CREATE TABLE < table-name >
( < column name > < data type > [ < size > ]
( < column name > < data type> [ < size > ] ..........
);

Oracle, MySQL, MS SQL Server, IBM DB2 and Microsoft Access are RDBMS packages.