In SQL the cross-tabs are created using

Related MCQs

•                  dump, writes out SQL DDL statements and SQL insert statements to a file, which can then be reexecuted to re- create the database.
• Which SQL function is used to count the number of rows in a SQL query?
• View the Exhibit and examine the data in the EMPLOYEES tables. Evaluate the following SQL statement: SELECT employee_id, department_id FROM employees WHERE department_id= 50 ORDER BY department_id UNION SELECT employee_id, department_id FROM employees WHERE department_id= 90 UNION SELECT employee_id, department_id FROM employees WHERE department_id= 10; What would be the outcome of the above SQL statement?
• In                                    attacks, the attacker manages to get an application to execute an SQL query created by the attacker.
• Using the SQL GROUP BY phrase with a SELECT statement can help detect which of the following problems?
• A data dictionary is created when a __________ created.
• The user defined data type can be created using
• The relation with primary key can be created using
• In the relational model, relationships between relations or tables are created by using:
• In the relational model, relationships between relations or tables are created by using: