DBSkool Header Image Background

Tag: lesson

Controlling User Access

1. What is Privilege? Privileges are the right to execute particular SQL statements. 2. Write the types of privileges. There are two types of privileges- ♦ System privileges…

Creating Functions

1. Examine this code: CREATE OR REPLACE FUNCTION gen_email_name ( p_first_name VARCHAR2, p_last_name VARHCAR2, p_id NUMBER ) RETURN VARCHAR2 IS v_email_name VARCHAR2(19); BEGIN v_email_name := SUBSTR (p_first_name, 1,1,)…

Creating Functions & Debugging Subprogram

1. What is Function? A function is a named PL/SQL block that can accept parameters, be invoked and must return a value. It can be stored in the…

Advance Relational Database Modeling

1. Which of the following is true about De-normalization? A. De-normalization is often the opposite way of normalization. B. De-normalizing BCNF leads to poor performance. C. After De-normalizing…

Reading & Writing Data with SQL

1. What does it mean by SQL? SQL is a non-procedural language used for accessing field and record values in relational database table. 2. What does it mean…

Multi-file Processing: Direct Access

1. Define cylinder, track and sector. Cylinder: Cylinder is the collection of tracks of the same numbers on a disk i.e. the tracks that can be read from…