Question

1. Create table for stud using attributes Rollno, studname, percentage)apply
primary key for rollno and check constraint on percentage should not greater
than 100.
​

Answer 1

Answer:

Primary key is column, which will identify the unique records in the table.



How to create table using multiple ways?

To create table in oracle the user should have the create table privileges. There are so many ways of creating table. User can create table using primary key or unique key also. CREATE TABLE statement is used to create the table in oracle.

Answer 2

Answer:- In the question given it is said to create a table for the student using attributes Rollno., Studentname, percentage and we also need to apply the primary key for the table. The algorithm is written below. please read the full answer.

To create a Primary key in the table need to be created, we have to use a keyword; “PRIMARY KEY ( )”

CREATE TABLE "student"("student_nameVARCHAR(20) NOT NULL,

                                           "Roll_no.VARCHAR(50) NOT NULL,  

                                           "percentage"INT NOT NULL,

                                            PRIMARY KEY ("Student_name"));

A primary key uniquely identifies each row of the table. It must contain a unique and a non-null value. A table can have only one primary key in it, which may consist of single or multiple fields. When multiple fields are used as a primary key, then they are called composite keys.

To know more about the given topic above please go through the following

Link1:- https://brainly.in/question/6979321?

Link2:- https://brainly.in/question/16202734?

#SPJ2