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

What is candidate key, What is Candidate Key Super Key or Candidate Ke...

What is Candidate Key Super Key or Candidate Key: It is such an attribute of a table that can uniquely recognize a row in a table. Generally they have unique values and can n

Explain the exec statement in sql, Explain the EXEC statement in SQL A...

Explain the EXEC statement in SQL Ans: All statements which start with EXEC SQL are embedded SQL database statements. High level languages such as C can be employed to write a

Spanned and unspanned organisation, Spanned and unspanned organisation? ...

Spanned and unspanned organisation? Spanned and unspanned organization: If records are not permited to cross block boundaries then the organisation is called unspanned record

Discuss the different layers of ansi sparc architecture, Q.1 Briefly discus...

Q.1 Briefly discuss the different layers of ANSI SPARC architecture. Ans: The three layers of ANSI SPARC architecture are like this: 1. Internal view is at the lowest leve

Datawarehouse, 1) Define a job scheduling strategy that will meet business ...

1) Define a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a pict

What create when a primary key combined with a foreign key, What will be cr...

What will be create when a primary key if combined with a foreign key? A primary key if combined with a foreign key it creates Parent-Child relationship between the tables that

Copy data from one database to another database, Copy Data from One Databas...

Copy Data from One Database to another Database Project Description: I am having two MySQL databases with same tables. I just need to copy one Data from one to another dat

What are the advantages of having an index structure, What are the advantag...

What are the advantages of having an index structure? Ans: The index structures commonly provide secondary access paths, which offer alternative ways of accessing the reco

Functional dependencies and normalization for relational dat, Consider the ...

Consider the 1ollowin8 relation: CAR SALE (Car_id, Option_type, Option_listprice, Sale_date, Option_discountedprice) This relation refers to options installed in cars (e.g., crui

Design and build a data mart, You are required to design and build a data m...

You are required to design and build a data mart/data warehouse using Oracle. A national bank allocates funding every year for its local branches to provide temporary staff cove

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages