2. SQL*Plus commands access the database. True/False 3. Will the SELECT statement execute successfully? True/False SQL> SELECT ename, job, sal Salary FROM emp ; 4.Will the SELECT statement execute successfully? True/False SQL> SELECT * FROM salgrade 5. There are four coding errors in this statement. Can you identify them? SELECT empno, ename Salary x 12 ANNUAL SALARY FROM emp; SQL>

2. SQLPlus commands access the database. True/False 3. Will the SELECT statement execute successfully? True/False SQL> SELECT ename, job, sal Salary FROM emp ; 4.Will the SELECT statement execute successfully? True/False SQL> SELECT FROM salgrade 5. There are four coding errors in this statement. Can you identify them? SELECT empno, ename Salary x 12 ANNUAL SALARY FROM emp; SQL>

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

PostgreSql differs from the SQL Standard primarily by requiring which of these constructs. a. reference to either the old row or new row b. begin and end c. stored trigger function d. trigger credentials
Please answer as many questions as you can!
Database Q1: Select the correct SQL statement to provide the user Samer with read only permission on Employees table a) Grant read on Employee where username = Samer; b) Grant read only on Employee to Samer; c) Grant select to Samer on Employee; d) Grant select on Employee to Samer; Q2: Based on the TWO schema structures below, which SQL statement will create a view to show department names where each department has at least 5 employees? Employee (E_ID, E_Name, D_ID, E_Salary) Department (D_ID, D_Name, D_Address) (Select one) a) Create View Dept_Emp as select D_Name, count(E_ID) from Employee, Department where Employee D_ID = Department D_ID Group by D_Name Where count (E_ID) >= 5; b) Create View Dept_Emp as select D_Name, count(E_ID) from Employee D_ID = Department D_ID Group by D_Name Having count (E_ID) >= 5; c) Create View Dept_Emp as select D_Name, count(D_ID) from Employee, Department where Employee D_ID = Department D_ID Group by D_Name Having count (E_ID) >= 5; d)…
Given the following function Oracle user account: Jsmith Profile: Manager_prof Password verify function: Good_Pwd_Fun As a DBA, you will write SQL commands to accomplish the following tasks: a. Change Jsmith password to CatChasedog! b. Add the password verification function to the profile c. Add the profile to Jsmith d. Set smith password expire
ies in relational algebra. Find the username of users who are from ‘Muscat’. Find the IDs of pictures which scores more than 2000 likes. Find IDs of pictures which descried as landscape. b. Write SQL queries for the following statements. Display all the picture’s details in the decreasing order of their scores. Count and display the number of pictures posted by each user. Add the given new user’s data into the Users table. userId userName userCity 2536 User2021om Muscat
in sql The keyword that you would use to grant an object privilege to all database users is: Select one: a. PUBLIC b. ADMIN c. ALL d. GRANT
- Create a trigger that will insert new emp_no, salary, from_date and to_date into salaries table after a new employee record is inserted. Assume the new employee salary is 10000 and from_date is current date and to_date is “9999-01-01” - List the employees’ first names and salaries where their salary is above the average salary among the employees
Answer the following SQL questions using MySQL command language in MySQL Workbench, sakila database environment!
IN SQL Any user can create another user with the same privileges. Select one: a. True b. False
Solve the problem and please provide Handwritten answer
Write a SQL statement to create a stored procedure called Calc_Average based on the Semester_Marks table created in Table 2: Semester_Marks table structure. The stored procedure should update the total marks, no of courses and calculate the average mark for each student. (Note: Average mark = total_mark divide by the number of courses for the student.). Control the flow of your code should an error occur (e.g. number of courses enter is zero). Use exception handling to avoid zero being entered for the number of courses. Table 2: Semester_Marks table structure Semester_Marks Column Name Datatype Allow Nulls PK Stud_Reg_No int First_Name char(20) Last_Name char(20) Total_marks int No_Courses int Student_Average_Markint