Book Sales Database: Which of the following lists all books published by thepublisher named Printing Is Us?SELECT titleFROM books NATURAL JOIN publisherWHERE name = 'PRINTING IS US';SELECT titleFROM books, publisherWHERE pubname =1;SELECT titleFROM books, publisherWHERE pubname = 1;none of above Book Sales database (Just Lee Book sales Company): Which of below SQL optionresolves this problem?Produce a list of each customer number and the third and fourth digits of his or herzipcode. The query should also display the position of the first occurrence of a 3 in thecustomer number, if it exists.SELECT customer#, SUBSTR(zip, 3), INSTR(customer#, 3)FROM customers;SELECT customer#, INSTR(zip, 3, 2), INSTR(customer#, 3)FROM customers;SELECT customer#, SUBSTR(zip, 2, 3), INSTR(customer#, 1)FROM customers;SELECT customer#, SUBSTR(zip, 3, 2), INSTR(customer#, 3)FROM customers;

Book Sales Database: Which of the following lists all books published by publisher named Printing Is…

Book Sales Database: Which of the following lists all books published by the publisher named Printing Is Us? SELECT title FROM books NATURAL JOIN publisher WHERE name = PRINTING IS US'; SELECT title FROM books, publisher WHERE pubname =1; SELECT title FROM books, publisher WHERE pubname = 1; %3D none of above

Book Sales Database: Which of the following lists all books published by the publisher named Printing Is Us? SELECT title FROM books NATURAL JOIN publisher WHERE name = PRINTING IS US'; SELECT title FROM books, publisher WHERE pubname =1; SELECT title FROM books, publisher WHERE pubname = 1; %3D none of above

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter2: Basic Sql Select Statements

Section: Chapter Questions

Problem 10RQ: What is a NULL value?

See similar textbooks

Similar questions

What is a NULL value?
In The SQL Oracle Application Using the UNION operator, write a query that displays the employee_id, job_id, and salary of ALL present and past employees. If a salary is not found, then just display a 0 (zero) in its place.
INFO 2303 Database Programming Assignment : PL/SQL Practice Note: PL/SQL can be executed in SQL*Plus or SQL Developer or Oracle Live SQL. Write an anonymous block to retrieve the doctor’s ID and name which in charge of certain patient. Allow the user to enter the patient’s ID.
SBN Title Author 12345678 The Hobbit J.R.R. Tolkien 45678912 DaVinci Code Dan Brown Your student ID DBS311 Your Name use the following statement to Write a PL/SQL Function that accepts 4 parameters, 2 strings representing students names, and 2 integers representing the marks they received in DBS311. The function will determine which student had the higher mark and return the name of the student. If the marks were the same, then return the word "same" and return "error" if an error occurs or the calculation can not be determined.
SQL QUERIES Employees(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID)Department(DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID)A: Write a query in SQL to display the minimum, maximum salary and DEPARTMENT_ID of all thosedepartments whose minimum salary is greater than 4000 in ascending order.
SQL QUERIES Employees(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID)Department(DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID)A: Write a query in SQL to display the minimum, maximum salary and DEPARTMENT_ID of all thosedepartments whose minimum salary is greater than 4000 in ascending order. B: Write a Query in SQL to display characters only from 2 to 5 of “Last_Name” from Employees table. C: Write a query in SQL to display the HIRE_DATE of every employee in following format.Format: 11-july-2019
sql Employees(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID)Department(DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID)A: Write a query in SQL to display the minimum, maximum salary and DEPARTMENT_ID of all thosedepartments whose minimum salary is greater than 4000 in ascending order. B: Write a Query in SQL to display characters only from 2 to 5 of “Last_Name” from Employees table. C: Write a query in SQL to display the HIRE_DATE of every employee in following format.Format: 11-july-2019
Draw the ERD rI : ithat is implemented by the following SQL code: CREATE TABLE PROJ_USER USER_ID NUMBER NOT NULL, USER_NAME VARCHAR2(50) NOT NULL, USER_EMAIL VARCHAR2(50) NOT NULL, CONSTRAINT USER_PK PRIMARY KEY (USER_ID) ); CREATE TABLE PROJ_CERTIFIEDUSER USER_ID NUMBER NOT NULL, CUSER_REALNAME VARCHAR2(50) NOT NULL, CUSER_CERTIFICATION VARCHAR2(50) NOT NULL, CONSTRAINT CERTIFIEDUSER_PK PRIMARY KEY (USER_ID), CONSTRAINT CERTIFIEDUSER_FK FOREIGN KEY (USER_ID) REFERENCES PROJ_USER (USER_ID) );
in sql The EMPLOYEE table contains these columns: EMP_ID NOT NULL, Primary Key SSNUM NOT NULL, Unique LAST_NAME VARCHAR2(25) FIRST_NAME VARCHAR2(25) DEPT_ID NUMBER Foreign Key to DEPT_ID column of the DEPARTMENT table SALARY NUMBER(8,2). You execute this statement:CREATE INDEX emp_name_idx ON employee(last_name, first_name); Which statement is true? Select one: a. The statement creates a composite non-unique index b. The statement creates a composite unique index. c. The statement creates a function-based index. d. The statement fails because of a syntax error.
INFO 2303 Database Programming Assignment # : PL/SQL Procedure & Function Practice Note: PL/SQL can be executed in SQL*Plus or SQL Developer or Oracle Live SQL. Write a script to create a PL/SQL procedure called findSal that displays the doctor’s salary and bonus after passing in the doc_id into the procedure. For example, if you pass in doc_id 504, you will get the following output. execute findSal(504) The salary for Dr.Cotner (504) is: 11500 The bonus is: 7500 PL/SQL procedure successfully completed.
PL/SQL The following PL/SQL code implements a cursor and displays the first 3 highest students’ grades in course seqid '00001'. DECLARE CURSOR c1 IS SELECT sname, grade FROM Student s JOIN Taken t ON s.sid=t.sid WHERE seqid='00001' ORDER BY grade DESC; -- my_sname VARCHAR2(40); my_sname Student.sname%TYPE; -- my_grade NUMBER(2,1); my_grade Taken.grade%TYPE; BEGIN OPEN c1; FOR i IN 1..3 LOOP FETCH c1 INTO my_sname, my_grade; EXIT WHEN c1%NOTFOUND; /* in case the number requested */ /* is more than the total */ /* number of enrolled students in the class */ /* display the result */ dbms_output.put_line('Name: ' || my_sname || ' ' || 'Grade: ' || my_grade); END LOOP; CLOSE c1; END; / 1. Modify the above code to output the average of the top three grades.
INFO 2303 Database Programming Assignment : PL/SQL Practice Note: PL/SQL can be executed in SQL*Plus or SQL Developer or Oracle Live SQL. Question: Write an anonymous PL/SQL block that will delete all patients for doctors that works in the Family Practice Verify that patients have been deleted accordingly. Then do a select * from patients where doc_id = (select doc_id from doctor where area = ‘Family Practice’. You should get no rows. Patietn table: CREATE TABLE PATIENT(PT_ID NUMBER(3),PT_LNAME VARCHAR2(15),PT_FNAME VARCHAR2(15),PTDOB DATE,DOC_ID NUMBER(3),NEXTAPPTDATE DATE,LASTAPPTDATE DATE,CONSTRAINT PATIENT_PT_ID_PK PRIMARY KEY (PT_ID),CONSTRAINT PATIENT_DOC_ID_FK FOREIGN KEY(DOC_ID)REFERENCES DOCTOR); INSERT INTO patient VALUES(168, 'James', 'Paul', TO_DATE('14-MAR-97'), 432, TO_DATE('01-JUL-03'), TO_DATE('01-JUN-03'));INSERT INTO patient VALUES(331, 'Anderson', 'Brian', TO_DATE('06-MAR-48'), 235,TO_DATE('01-JUL-03'), TO_DATE('01-JUN-03'));INSERT INTO patient…