Answered: he difference between DROP and TRUNCATE…

Engineering

Computer Science

he difference between DROP and TRUNCATE commands?

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter10: Selected Single-row Functions

Section: Chapter Questions

Problem 6RQ

See similar textbooks

Similar questions

Which keyword should be used in order to supply a reference parameter?
Below is the code for a procedure that will accept a Customer ID as an input parameter and display the Customer ID, Customer Surname and Customer Address. Review the code, then answer the questions that follow. create or replace procedure sp_customer_details (c_id IN CUSTOMER.cust_id%TYPE,customer_details out VARCHAR2)ISBEGINSELECT 'CUSTOMER ID:' || c.cust_id || ', Surname:'|| c.cust_sname || ',ADDRESS:' ||c.cust_addressinto customer_detailsfrom CUSTOMER cwhere c.cust_id = c_id;END; Q.1 Briefly discuss the advantages of using the %TYPE attribute in the code. Q.2 Create the code to execute the procedure with exception handling if no customer data is found. Use customer ID C115 in your code.
What exactly is the purpose of the redirection meta-character?
What are the functions used to produce authendicator?
4. The using statement simplifies the accessing of namespace members. True False
In what context might the name operator/ be used?
Write a script that creates and calls a function named fnStudentUnits that calculates the total course units of a student in the StudentCourses table. To do that, this function should accept one parameter for the student ID, and it should return the sum of the course units for the student. The SELECT statement that calls the function should return the StudentID from the StudentCourses table, the CourseNumber and CourseUnits from the Courses table, and the value return by the fnStudentUnits function for that student.
Ex2. Write down two functions: transfer and receive from a bank account The settings will be transferred to two users of the bank. Must be a user Presented as a struct and must have an account attribute. That is, the program should ask you to enter the bank account (string type) and the name of the person to whom you are transferring the amount, as well as the amount of the money. If the amount is more than $ 1000, the program must print a notification to enter a fee - 10% of the amount. After entering 10% of the amount, print on the screen that the amount has been transferred.
Which of the following is false? a. The position of the arguments listed in the Call statement should agree with the position of the parameters listed in the receiving procedure’s parameterList. b. The data type of each argument in the Call statement should match the data type of its corresponding parameter in the receiving procedure’s parameterList.c. The name of each argument in the Call statement should be identical to the name of its corresponding parameter in the receiving procedure’s parameterList. d. When you pass information to a procedure by value, the procedure stores the value of each item it receives in a separate memory location.
3. Which among the following shows a valid use of the Direction enumeration as a parameter to the moveCharacter function? Select al that apply. enum Direction { case north, south, west, east}func moveCharacter(x: Int, y: Int, facing: Direction) {// code here} moveCharacter(x: 0, y: 0, facing: .southwest) moveCharacter(x: 0, y: 0, facing: Direction.north) moveCharacter(x: 0, y: 0, facing: .south) moveCharacter(x: 0, y: 0, facing: Direction.northeast)
. You can use variable as a global identifier, but you cannot use aconstant as global identifiers (True/False?
When is it OK to use union compatibility between two select statements that utilize the same table?