Logo 
Search:

Interview FAQs

Submit Interview FAQ
Home » Interview FAQsRSS Feeds
SQL
Comments: 0

What will SELECT SUBSTR LASTNAME,1,5 FROM NAME_TBL; query retunr?

No, missing () around lastname,1,5. Also, a better plan is to give the column an alias. The statement should look like this:

SELECT SUBSTR(LASTNAME,1,5) NAME FROM NAME_TBL;
Posted By:Shruti Sharma      Posted On: Dec 21

SQL
Comments: 0

What will SELECT COUNT(*) FROM TEAMSTATS; query return?

It will return total number of records.
Posted By:Shruti Sharma      Posted On: Dec 21

SQL
Comments: 0

Assuming that they are separate columns, which function(s) would splice together FIRSTNAME and

The CONCAT function and the || symbol.
Posted By:Shruti Sharma      Posted On: Dec 21

SQL
Comments: 0

What SELECT COUNT(LASTNAME) FROM CHARACTERS; will return?

It will return the total of rows.
Posted By:Shruti Sharma      Posted On: Dec 21

SQL
Comments: 0

Will SELECT SUM(LASTNAME) FROM CHARACTERS query work?

No, the query won't work because LASTNAME is a character field.
Posted By:Shruti Sharma      Posted On: Dec 21

SQL
Comments: 0

Which function capitalizes the first letter of a character string and makes the rest lowercase?

Capitalizes the first letter of a character string and makes the rest lowercase :

INITCAP
Posted By:Shruti Sharma      Posted On: Dec 21

  9  10  11  12  13  14  15  16  17  18  19