DBSkool Header Image Background

Category: SQL_ExpressivePage 1 of 2

Managing Objects with Data Dictionary Views

1. What is inline view? A sub-query in the FROM clause of a SELECT statement is called an inline view. 2. Why we use sub-queries in DML statement?…

Managing Schema Objects

1. Write the Guidelines for adding columns. ♦ We use the ADD clause to add columns ♦ We cannot specify where the column is to appear ♦ The…

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…

Using DDL Statements to Create & Manage Tables

1. What is view? A view is a logical table based on a table or another view. The advantages of views are- ♦ To restrict data access ♦…

Manipulating Data

1. Write the names of database objects There are many database objects- ♦ Table ♦ View ♦ Index ♦ Sequence ♦ Synonym ♦ Procedure ♦ Function 2. Write…

Using the Set Operators

1. When a DML statement is execute? A DML statement is executed when we ♦ Add new rows to a table ♦ Modify existing rows in a table…

Displaying Data from Multiple Tables

1. What is subquery? A subquery is a SELECT statement that is embedded in a clause of another SELECT statement. 2. In which clauses the subquery is used?…

Reporting Aggregated Data Using the Group Functions

1. Write the types of joins. There are many types of joins in SQL- ♦ Equijoins ♦ Nonequijoins ♦ Outer joins ♦ Self-joins ♦ Cross joins ♦ Natural…

Using Conversation and Conditional Expressions

1. Define Group Functions Group functions operate on sets of rows to give one result per group. These sets may comprise the entire table or the table split…

Using Single-Row Function to Customize Output

1. Write about SQL Functions. Functions are a very powerful feature of SQL. They can be used to do the following- ♦ Perform calculations on data ♦ Modify…