1.What is a database? a) Organized collection of information that cannot be accessed, updated, and managed b) Collection of data or ...
SIKSHAPATH Latest Questions
To Which of the following the term ‘DBA’ referred | What does DBA stand for in computer science | DBA full form in computer To Which of the following the term ‘DBA’ referred? or/ What does DBA stand for in computer science? a. ...
Consider the following schema: Emp(eno,ename,ph_no,address,salary,dno) Department(dno,dname,location) Project(pno, dno,status) Works_On(eno,pno,hours) Solve the following queries using Relational Algebra operations a. List eno and dno from Emp where dno as ’20’ b. List eno,ename,dno,dname from Emp and Department. c. List eno,ename,pno from Emp and ...
There are three relations in the following schema for the company: 1. EMPLOYEE (National_ID, Employee_Name, Salary, Service_Unit), 2. EMPLOYER (National_ID, Employer_Name, Salary, Service_Unit), 3. UNIT (Service_Unit, Contact_Phone_Number). Primary key has been underlined. The data stored in the schema has been ...
Write a program in PL/SQLto update the salary of a specific employee by 10% if the salary exceeds themid range of the salary against this job and update up to mid range if thesalary is less than the mid range ...