Category: SQL_ExpressivePage 1 of 2
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?…
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…
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…
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 ♦…
1. Write the names of database objects There are many database objects- ♦ Table ♦ View ♦ Index ♦ Sequence ♦ Synonym ♦ Procedure ♦ Function 2. Write…
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…
1. Write the types of joins. There are many types of joins in SQL- ♦ Equijoins ♦ Nonequijoins ♦ Outer joins ♦ Self-joins ♦ Cross joins ♦ Natural…
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…
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…