Q. What is an advantage of placing computations in SQL views?

View solution

Q. Views constructed from SQL SELECT statements that conform to the SQL-92 standard may not contain:

View solution

Q. ‘AS’ clause is used in SQL for

View solution

Q. The language which has recently become the defacto standard for interfacing application programs with relational database system is

View solution

Q. A report generator is used to

View solution

Q. Count function in SQL returns the number of

View solution

Q. The statement in SQL which allows to change the definition of a table is

View solution

Q. Which of the following is correct:

View solution

Q. Which of the following is a valid SQL type?

View solution

Q. Which of the following is an advantage of view?

View solution

Q. Which of the following is a legal expression in SQL?

View solution

Q. Which of the following is a comparison operator in SQL?

View solution

Q. Which one of the following is not true for a view:

View solution

Q. To delete a particular column in a relation the command used is:

View solution

Q. The ______ operator is used to compare a value to a list of literals values that have been specified.

View solution

Q. _____________ function divides one numeric expression by another and returns the remainder.

View solution

Q. A data manipulation command the combines the records from one or more tables is called

View solution

Q. _________ is a virtual table that draws its data from the result of an SQL SELECT statement.

View solution

Q. A table joined with itself is called

View solution

Q. _________ data type can store unstructured data.

View solution