STUDENT TABLEQ1. As we need
to notify in system birthday of each student so kindly create an index DoBindex
on column DoB of Student table.
Q2. Which index
be more suitable for major in Apply? Create Bitmap Index name MAJORindex.
Q3. Remove index
on DoB column.
Q4. Create an
Unique index ENRindex...
Friday, December 4, 2020
Tags
SQL

Thursday, December 3, 2020
undefined
202
1. Retrieve and print the data of an
employee having name=’Rishi' using Record.2. Retrieve and print the data of all
the employees using Explicit Cursors.3. Write a PL/SQL code block to
display the names and GPA of students from student table...
Tags
SQL

Tuesday, December 1, 2020
undefined
202
1. Write a PL/SQL code block for
calculating addition of Three numbers.2. Write a PL/SQL code block to find
out larger between two numbers.
3. Write a PL/SQL code block to find
largerst of three numbers.
4. ...
Tags
SQL
