An attribute A of datatype varchar(20) has the value “Avi” . The attribute B of datatype char(20) has value ”Reed” .Here attribute A has ____ spaces and attribute B has ____ spaces .
Answer: A
Varchar changes its length accordingly whereas char has a specific length which has to be filled by either letters or spaces.
Enter details here
Scalar aggregate are multiple values returned from an SQL query that includes an aggregate function.
Answer: B
No answer description available for this question.
Enter details here
SQL query and modification commands make up a(n) ________ .
Answer: B
No answer description available for this question.
Enter details here
The SQL statement: SELECT Name, COUNT(*) FROM NAME_TABLE; counts the number of name rows and displays this total in a table with a single row and a single column.
Answer: B
No answer description available for this question.
Enter details here
Indexes may be created or dropped at any time.
Answer: A
No answer description available for this question.
Enter details here
SQL is:
Answer: C
No answer description available for this question
Enter details here
The keyword LIKE can be used in a WHERE clause to refer to a range of values.
Answer: B
No answer description available for this question.
Enter details here
The SQL statement: SELECT Number1 + Number 2 AS Total FROM NUMBER_TABLE; adds two numbers from each row together and lists the results in a column named Total.
Answer: A
No answer description available for this question.
Enter details here
The SQL -92 wildcards are ____ and ____ .
Answer: B
No answer description available for this question.
Enter details here
SQL is a programming language.
Answer: B
No answer description available for this question.
Enter details here