Create a table student with attributes student name, Database Management System

Assignment Help:

Question 1 Create a table student with attributes student name, roll number, total marks and percentage. Do the following operations

Insert details in to the table
Update the details of the student named ‘JOHN'
Delete details of the student ‘Mary'
Display the details of students having more than 80%

Question 2 Write the following Queries using functions

Write a query to display the sub string for the word 'oracle' from its position 2 to 3
Write a query to change the ‘or' to ‘ab' in the word 'corporation' using translate function
Write a query to maintain the first letter as caps using initcap function
Write a query to display all characters is in caps using upper function
Write a query to display ‘smudde' after leaving 5 blank places using lpad function

Related Discussions:- Create a table student with attributes student name

A file manipulation command that extracts some records, A file manipulation...

A file manipulation command that extracts some of the records from a file is called ? A file manipulation command that extracts some of the records from a file is called SELECT

Fragmentation, Differentiate between horizontal & mixed horizontal fragment...

Differentiate between horizontal & mixed horizontal fragmentation?

Write a short note on qbe, Write a short note on QBE? Stands for "Quer...

Write a short note on QBE? Stands for "Query By Example." QBE is a feature involved along with various database applications which gives user-friendly techniques of running da

Sql iis setup and admin - maybe tfs, I want a good Microsoft Admin experien...

I want a good Microsoft Admin experienced in IIS and SQL Server. They require being able to set it up and administer from then onwards. Experience in Team Foundation Server a

Distributed database, distributed quey processing

distributed quey processing

What are the several forms of identity, What are the several forms of ident...

What are the several forms of identity? a) Value b) Name c) Built-in

Data dictionary, The database is to record information about artists for a ...

The database is to record information about artists for a (music) production company. An artist is the name of a singer or band; the name of the artist, the year the artist started

Central database schema, Consider an information system designed for an onl...

Consider an information system designed for an online company which provides IT products and services. These include desktops, laptops, networking products, IT books, parts, and te

Homework, can you resolve this for me please? Database Management Systems ...

can you resolve this for me please? Database Management Systems Homework 1 The following relations are given (primary keys are underlined): PLAY-ACTOR(AId, Name, Nationality, Birt

Query to delete constraint from alter table, A constraint named less_than_2...

A constraint named less_than_20 was defined on the field date_of_birth of table student. Delete this constraint. ALTER TABLE student DROP CONSTRAINT less_than_20;

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages