SELECT *
FROM (`youtube_videos`)
WHERE `display_status` = 1
ORDER BY `video_id` desc
LIMIT 1SELECT *
FROM (`youtube_videos`)
WHERE `display_status` = 1
ORDER BY `video_id` desc Structured Query Language 12th Standard
Computer Science Which commands provide definitions for creating table structure, deleting relations, and modifying relation schemas. DDL DML DCL DQL The clause used to sort data in a database SORT BY ORDER BY GROUP BY SELECT Which of the following is a collection of data entries? Database Table Dbase SQL Which component of SQL includes commands to insert, delete and modify tables in database? DCL TCL DDL DML TCL stands for Transmission Control Language Transfer Communication Language Transaction Communication Language Transaction control Language Write the difference between table constraint and column constraint? What is the difference between SQL and MYSQL? What is RDBMS? How will you create database and work with the database? Give example. Define TCL. Write a SQL statement to modify the student table structure by adding a new field. Write any three DDL commands. Write a SQL statement using DISTINCT keyword. List the types of constraints. Write the function performed by DDL. What are the components of SQL? Write the commands in each. Construct the following SQL statements in the student table- Explain ALTER command in detail. Explain TCL commands in detail.
12th Computer Science - Structured Query Language Model Question Paper 1
8682895000 Jan-06 , 2020
Structured Query Language Model Question Paper 1
Reg.No. :
(i) SELECT statement using GROUP BY clause.
(ii) SELECT statement using ORDER BY clause.
*****************************************
Reviews & Comments about 12th Computer Science - Structured Query Language Model Question Paper 1
Write your Comment