The following SQL statement reflects as_________ in relational algebra. Select *

Question

The following SQL statement reflects as_________ in relational algebra. Select * fromrelation1;

Projection Statement Selection Statement

Truncate command response time is ______as compared to Delete command

poor same worst better

Table (relation) size reduces due to______________.

Horizontal Partitioning Vertical Partitioning Query Optimization Replication

Which of the following statement is usedto create database “db1” through SQLcommand?

CREATE db1 AS DATABASE; CREATE DATABASE db1; CREATE DB db1; CREATE Dbase db1;

The following SQL statement reflects as______________ in relational algebra.
Select * from relation1 where a = b;

Projection Statement
Selection Statement

Which of the following syntax of thefunctions in SQL is used to add column values?

COUNT(*) COUNT(expression) SUM(expression) MAX(expression)

In two phase locking, locks are granted onlyin---------------phase.                                                                               

Growing phase Updating phase Shrinking phase

The following SQL statement reflects as_________ in relational algebra. Select * fromrelation1; Projection Statement Selection Statement Selection Statement Truncate command response time is ______as compared to Delete command poor same worst better Table (relation) size reduces due to______________. Horizontal Partitioning Vertical Partitioning Query Optimization Replication Which of the following statement is usedto create database “db1” through SQLcommand? CREATE db1 AS DATABASE; CREATE DATABASE db1; CREATE DB db1; CREATE Dbase db1; The following SQL statement reflects as______________ in relational algebra.
Select * from relation1 where a = b; Projection Statement
Selection Statement Which of the following syntax of thefunctions in SQL is used to add column values? COUNT(*) COUNT(expression) SUM(expression) MAX(expression)
In two phase locking, locks are granted onlyin---------------phase.                                                                                Growing phase Updating phase Shrinking phase

Explanation / Answer

Projection Statement better CREATE DATABASE db1; Selection Statement SUM(expression) SUM(expression)

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---