In Oracle database, If we have Iname field in our table then we can use this functionto change the target string into a string with a specific length by adding a specific setof characters such as blank to the left of the string. This can be done by includingfollowing in SELECT clause:I: LPAD(LNAME, 15,")II: RPAD(LNAME, 15,")I & II: are correctI & II: are not correctI & II: are correctI||O I & II: are not correct In Oracle database, If ORDER_DATE field exist in any of our tables, then we caninclude the following in our WHERE clause:I:to_char(order_date, 'Mon yyyy')='Feb 2001'to_char(order_date,II:'mon yyyy')='FEB 2001'I & II: are correctI & II: are not correct1I & II: are not correctI & II: are correctOll

1> Answer: 2nd option is correct. I. LPAD(LNAME,15,") is correct answer. Explanation: The…

In Oracle database, If we have Iname field in our table then we can use this function to change the target string into a string with a specific length by adding a specific set of characters such as blank to the left of the string. This can be done by including following in SELECT clause: I: LPAD(LNAME, 15,"') II: RPAD(LNAME, 15,") I & II: are correct I & II: are not correct OI & II: are correct I || O I & II: are not correct

In Oracle database, If we have Iname field in our table then we can use this function to change the target string into a string with a specific length by adding a specific set of characters such as blank to the left of the string. This can be done by including following in SELECT clause: I: LPAD(LNAME, 15,"') II: RPAD(LNAME, 15,") I & II: are correct I & II: are not correct OI & II: are correct I || O I & II: are not correct

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

Related questions

Q: reate a PL/SQL block using a FOR loop to generate a payment schedule for a donor’s pledge, which is…

A: ANSWER:-

Q: Get the student#, course# and midterm grade of the enrollments for courses of the CS department.

A: Relational Algebra :- A procedural query language is relational algebra. It walks you through the…

Q: There's a "friend_requests" table that has a column "action_taken" that displays if the friend…

A: SELECT Count(action_id) FROM friend_requests where action_taken = "Accepted"; This query will return…

Q: In order to compute the number of days that have passed between your birthday and the current date,…

A: A function is a short-lived subprogram that returns a single value, Before executing a function, its…

Q: DECLARE CURSOR C_pilot IS SELECT pilot_no, total_hours FROM pilot; pilot.pilot no&TYPE; v_pilot_no…

A: Below i have given the code:

Q: Consider the following Employee table: ID Name Hire Date Address Salary ... Isa Hamad Zahra Salman…

A: Lets see the solution.

Q: HAR2(5) FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25)

A: DECLARE CURSOR c IS SELECT FIRSTNAME, LASTNAME, PHONE FROM instructor…

Q: uaw rhe given infornmation to Write the MongoDB Shell code to add 3 documents to the books…

A: To insert multiple documents in MongoDB: Insert operations are used in MongoDB to add new documents…

Q: A simple Oracle function may determine the number of years since your birth by comparing today's…

A: Oracle functions are built within Oracle Database and may be included in various SQL queries. Parts…

Q: DEFAULT STORAGE (INITIAL 500K NEXT 200K MAXEXTENTS 20 PCTINCREASE 15) Excel's Future Value financial…

A: The EXCEL financial function FV (rate, nper, pmt, [pv], [type]) can be used to calculate extent size…

Q: e function to determine how many days have pa

A: Oracle function to determine how many days have passed since your birthday.

Q: MySQL Create the DISPLAY_OWNER procedure which obtains the first name and last name of the owner…

A: We will need one input-output type parameter and two output type parameters for our procedure…

Q: If you want to know how many days have passed since your birthday, utilise an Oracle function.

A: A server-less platform called Oracle Functions allows developers to design, execute and grow apps…

Q: There's a "friend_requests" table that has a column "action_taken" that displays if the friend…

A: Given Data : Table name : friend_requests Table attributes : action_id requester_id requestee_id…

Q: I: 'Mr./Mrs '|| Iname||', '||fname as full_Name II: concat('Mr./Mrs ', Iname, fname) as full_Name I…

A: Answer of above two questions mentioned below:-

Q: Jump to level 1 Complete the SQL statement to generate the Result table. Order OrderCode Z23 R58 A36…

A: The solution is given in the next step with output screenshot

Q: It's best to utilize an Oracle function to determine how many days have passed since your birthday.

A: Step 1 A server-less platform called Oracle Functions allows developers to design, execute and grow…

Question

In Oracle database, If we have Iname field in our table then we can use this function
to change the target string into a string with a specific length by adding a specific set
of characters such as blank to the left of the string. This can be done by including
following in SELECT clause:
I: LPAD(LNAME, 15,")
II: RPAD(LNAME, 15,")
I & II: are correct
I & II: are not correct
I & II: are correct
I
||
O I & II: are not correct

In Oracle database, If ORDER_DATE field exist in any of our tables, then we can
include the following in our WHERE clause:
I:
to_char(order_date, 'Mon yyyy')='Feb 2001'
to_char(order_date,
II:
'mon yyyy')='FEB 2001'
I & II: are correct
I & II: are not correct
1
I & II: are not correct
I & II: are correct
Oll

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

write MySQL functions to accomplish the following tasks: A:Delete the order whose number is stored in I_ORDER_NUM. B: Change the date of the order whose number is stored in I_ORDER_NUM to the date currently found in I_ORDER_DATE. C: Retrieve and output the item number, description, storehouse number, and unit price of every item in the category stored in I_CATEGORY.
PLZ help urgent: change the following so it works on oracle sql live or oracle sql developper CREATE TABLE `book`( `num` INT(20) NOT NULL AUTO_INCREMENT, `title` VARCHAR(20), `year` DATE, `subject` VARCHAR(20), `checkedout` DATETIME, `checkedin` DATETIME, PRIMARY KEY (`num`) ); CREATE TABLE `client`( `CID` INT(20) NOT NULL AUTO_INCREMENT, `fname` VARCHAR(25), `lname` VARCHAR(25), `type` VARCHAR(25), `num` INT(20), PRIMARY KEY (`CID`), FOREIGN KEY (`num`) REFERENCES `emp`.`state`(`state_id`) ); CREATE TABLE `author`( `id` INT(10) NOT NULL AUTO_INCREMENT, `year` DATE, `fName` VARCHAR(20), `lname` VARCHAR(20), `num` INT(20), PRIMARY KEY (`id`) ); ALTER TABLE `author` ADD FOREIGN KEY (`num`) REFERENCES `book`(`num`); ALTER TABLE `client` ADD CONSTRAINT `client_ibfk_1` FOREIGN KEY (`num`) REFERENCES `book`(`num`);
Write a stored procedure called sp_apply_discount() that will apply percent discount to books in a subject. The stored procedure takes in 2 parameters, percentDiscount (DECIMAL(8,2)) and subject (VARCHAR(120)). Using these parameters, the stored procedure computes the discount for the book cost and stores it in the FINAL_PRICE field. For example, the following stored procedure call: call sp_apply_discount(0.15, 'Database');would compute 15% percent discount from the book cost in the Database subject category and store it in the FINAL_PRICE column as depicted in this image:
Create a stored procedure that will return the number of customers in a given state. The parameter for your stored procedure should accept the state abbreviation ('UT') and return the results of a query that returns the number of customers in that state.
Develop a PL/SQL block that would go through all the employees from EMPLOYEES table who work in department id= 90 (there is suppose to be 3 employee who work in Department 90)- IN BEGIN END END SECTION; Execute 3 separate of SELECT statement one after the other. Each SELECT will pull first name. salary of each employee and store them in local variables.+ SELECT LOAD INTO v_firstname1, v_salarxlWHERE emrlexee.id=100 Then second WHERE emploxee.id3101+ SELECT first_name, salary INTO v_firstname2, v_salary2 Then third + SELECTSELECTI tirst.name, salary INTO v_firstname3, v_salary3 iin WHERE emploxee id=102 ..... You must now have 6 local variables. DECLARE all of them accordingly in DECLARE section and use them in BEGIN and END.+ Then add another SELECT statement in BEGIN-END to find company average salary SELECT xa(salary) INTO aKasal FROM EMPLOYEES; !!! Do not forget to create y avgsal local variable in DECLARE section.
You need to make use of an Oracle function in order to compute the number of days that have passed from your birthday up to the present moment.
First normal form says: a. No nonkey columns depend on another nonkey column b. Every column that's not part of the primary key is fully dependent on the primary key. c. Eliminate repeated fields. d. None of the above
You should use an Oracle function to calculate the number of days that have gone between your birthday and the current date.
MySQL Workbench Will the following select statements work? If the queries don’t work, explain why and then correct them.a-) SELECT NAME, EMPLOYEE_ID, SALARYFROM EMPLOYEE_TBL E, EMPLOYEE_PAY_TBL EPWHERE EMPLOYEE_ID = EMPLOYEE_ID AND NAME LIKE '%MITH';b-) SELECT E.NAME, E.EMPLOYEE_ID, EP.SALARYFROM EMPLOYEE_TBL E, EMPLOYEE_PAY_TBL EPWHERE NAME LIKE '%MITH';c-) SELECT E.NAME, E.EMPLOYEE_ID, EP.SALARYFROM EMPLOYEE_TBL E, EMPLOYEE_PAY_TBL EPWHERE E.EMPLOYEE_ID = EP.EMPLOYEE_ID AND E.NAME LIKE '%MITH';d-) SELECT ENAME, COUNT(*)FROM EMPWHERE ENAME = '&NAME'ORDER BY ENAME;e-) SELECT DEPT_ID, COUNT(*)FROM EMPGROUP BY DEPT_IDHAVING ENAME='ALIYE';f-) SELECT F_NAME, L_NAMEWHERE F_NAME LIKE '%A'FROM EMP, DEPT;g-) SELECT NAME, SALARYFROM DEPT, EMPWHERE DEPT.ID = EMP.ID AND SUM(SALARY);
Use My Guitar Shop Database Use Microsoft SQL Server Write a script that includes these statements coded as a transaction: INSERT Orders VALUES (3, GETDATE(), '10.00', '0.00', NULL, 4, 'American Express', '378282246310005', '04/2019', 4); SET @OrderID = @@IDENTITY; INSERT OrderItems VALUES (@OrderID, 6, '415.00', '161.85', 1); INSERT OrderItems VALUES (@OrderID, 1, '699.00', '209.70', 1); Here, the @@IDENTITY variable is used to get the order ID value that’s automatically generated when the first INSERT statement inserts an order. If these statements execute successfully, commit the changes. Otherwise, roll back the changes.
A simple Oracle function may determine the number of years since your birth by comparing today's date with your birthday.
You should use an Oracle function to determine the number of days that have transpired between your birthday and the current date.