Informatics Practices
With reference to SQL, identify the invalid data type.
- Date
- Integer
- Year
- Month
SQL Queries
2 Likes
Answer
Year, Month
Reason — In SQL, 'Year' and 'Month' are not valid data types.
Answered By
3 Likes
Related Questions
Which of the following sublanguages of SQL is used to define the structure of the relation, deleting relations and relating schemas?
- DML (Data Manipulation Language)
- DDL (Data Definition Language)
- Query
- Relational Schema
Which of the following sublanguages of SQL is used to query information from the database and to insert tuples into, delete tuples from, and modify tuples in the database ?
- DML (Data Manipulation Language)
- DDL (Data Definition Language)
- Query
- Relational Schema
Which of the following is a DDL command?
- SELECT
- ALTER
- INSERT
- UPDATE
Which of the following keywords will you use in the following query to display the unique values of the column dept_name ?
SELECT ............... dept_name FROM Company;- All
- From
- Distinct
- Name