SQL is non-procedural language.
SQL is non-procedural language.
To form a projection with SQL Name the relation to be projected and list the columns to be shown.
To remove duplicate rows, this qualifier must be specified DISTINCT.
To form a projection with SQL Name the relation to be projected and list the columns to be shown.
Create SQL keyword is used to name a new table and describe the table's columns.
Alter SQL keyword is used to change the structure, properties or constraints of a table.
If table PRODUCT has a column PRICE with data type Numeric (8,2), it stores values as 8 digits with no stored decimal point
If the table PRODUCT has a column PRICE that has the data type Numeric (8,2), the value 12345 will be displayed by the DBMS as 123.45
Drop SQL keyword is used to delete a table's structure.
The data in the table is also deleted the correct SQL command is used to delete a table's structure, what happens to the data in the table.
In an SQL query, SQL keyword From is used to specify the table(s) .
The asterisk (*) means that All columns of table are to be obtained
Where SQL keyword is used to state the condition to specifies the rows to be selected
In an SQL query, SQL keyword is used to join AND two conditions that both must be true for the rows to be selected
In an SQL query, Count built function is used to compute the number of rows in a table.
In an SQL query, SUM built function is used to total numeric columns.
In SQL, AVG built-in function is used to compute the average value of numeric columns.
In an SQL, MAX built-in function is used to obtain largest value of numeric columns.
In SQL, MIN built-in function is used to obtain the smallest value of numeric columns.
In an SQL query, GROUP BY SQL keyword is used with built-in functions to group rows that have the same value in a specified column together.
HAVING SQL keyword is used with GROUP BY to select groups meeting specified criteria
Given a table with the structure: EMPLOYEE (ExmpNo, Name, Salary, Hire Date),SELECT Hire Date, COUNT(*) FROM EMPLOYEE WHERE Salary < 30000; not a valid ANSI SQL command.
In an SQL query, GROUP BYSQL keyword is used to implement a subquery.
When one SQL query is embedded in WHERE clause of another SQL query, it is called: Subquery
In an SQL query, FROM SQL keyword is used to specify the names of tables to be joined.
In SQL, Select SQL keyword is used to specify the condition(s) for a join operation.
Regarding the interchangeability of subqueries and joins a join can sometimes be used as an alternative to a subquery, and a subquery can sometimes be used as an alternative to a join.
UPDATE SQL keyword is used to change one or more rows in a table.
Set SQL keyword is used to change a column value.
Delete keyword is used to remove one or more rows from a table.
WHERE clauses cannot refer to ranges and to partial values when: The keyword ALSO is used
COUNT, SUM, AVG, MAX, MIN the following are the five built-in functions provided by SQL.
The SQL keyword GROUP BY instructs the DBMS To group together those rows that have the same value of a column.
A subquery must be In parentheses
A join is the combination of a product operation, followed by a selection, followed (usually) by a projection true about a "join".
A join can be used as an alternative way of expressing many subqueries- true of a "join".
An outer join: Both A and B
EXISTS and NOT EXISTS Are logical operators whose value is either true or false depending on the presence or absence of rows that fit the qualifying conditions
When using INSERT Rows can be inserted into a table one at a time or in groups.
When using DELETE Rows can be deleted one at a time or in groups.
Mass updates are fast, easy, and cause few problems is not true about modifying data.
SELECTION of the following is not an SQL statement used on a single table.
SELECT with GROUP BY & HAVING of the following is not an operation used on two or more tables.
SQL commands can be classified into three types. C.DGL is NOT an SQL command type.
Three SQL DDL CREATE commands are Key, Base, and Table
Decrease system overhead is NOT an advantage of using a view.
As keyword is NOT included in most data retrieval statements.