Database Query using SQL
CUET Computer Science Key cards: 5 of this chapter’s 92 are free to read, with no account.
Say the answer in your head, then turn the card over.
The 5 free cards from Database Query using SQL
Card 1 of 5
Definition
What is a function in SQL (as NCERT puts it)?
Definition
What is a function in SQL (as NCERT puts it)?
We know that a function is used to perform some particular task and it returns zero or more values as a result.
Informatics Practices, Ch 1, p. 4
Definition
What are single row functions?
Definition
What are single row functions?
Single row functions are applied on a single value and return a single value.
Informatics Practices, Ch 1, p. 4
Definition
What do math functions accept and return?
Definition
What do math functions accept and return?
Math functions accept numeric value as input, and return a numeric value as a result.
Informatics Practices, Ch 1, p. 4
Definition
What do string functions accept and return?
Definition
What do string functions accept and return?
String functions accept character value as input, and return either character or numeric values as output.
Informatics Practices, Ch 1, p. 4
Definition
What do date and time functions accept and return?
Definition
What do date and time functions accept and return?
Date and time functions accept date and time values as input, and return numeric or string, or date and time values as output.
Informatics Practices, Ch 1, p. 4