Question

20. Create the following table with the mapping given below. a. stu_details (reg_no, stu_name, DOB, address, city) b. mark_details (reg_no, mark1, mark2, mark3, total)
(i)Find out the name of all students along with their total marks.
(ii)Change the mark1 as 78' from '59' and alter the total for a particular student. (iii) Delete all the records and its memory space from the table student.
(iv) Write a pl/sql program to check whether the given number is prime or not.

Answer 1

Answer:

prime

Explanation:

beggdueoehwgwghwiwiwuhwkalnagn।akahgwgegehejeklemrjrnmrmr

I hope it is helpful कोdo9 eto oc srry

Answer 2

The Answer is:

SQL is an abbreviation for Structured Query Language.

SQL allows you to connect to and manipulate databases.

SQL was adopted as an American National Standards Institute (ANSI) standard in 1986 and as an International Organization for Standardization (ISO) standard in 1987.

• A database is a collection of structured data that is easily accessible.
• A relational database is a collection of data in the form of tables with rows and columns that have a pre-defined relationship between them.
• Tables, records, primary keys, attributes, and foreign keys are some of the major words used extensively in relational databases.
• Tables are sometimes referred to as relations since they include one or more categories of data; attributes are also referred to as columns; and records are referred to as tuples or rows.

SQL is used for:

• SQL may run queries on a database.

• SQL may get information from a database.
• SQL may insert data into a database.
• SQL can be used to update database records.
• SQL has the ability to delete records from a database.
• SQL has the ability to build new databases.
• SQL can add additional tables to a database.
• SQL can be used to create stored procedures in a database.
• SQL may generate database views.
• SQL can grant access to tables, procedures, and views.

SPJ2