SQL quiz. In a table created with query: <pre><code class="s

In a table created with query:

CREATE TABLE t (t1 varchar(20), t2 char(20))

the following record was inserted:

INSERT INTO t VALUES('test', 'test')

What will the following query return?

SELECT length(t1) t1, length(t2) t2 FROM t

t1 t2
------
4 4
t1 t2
------
20 20
t1 t2
------
4 20
t1 t2
------
20 4

Explanation

Value of a char type will always have a lenght that was specified at table's creation. At the same time varchar length will be always equal to the length of the string that is actually stored.

1 (1)

Like

Login in to like
Comment

Login in to comment
Share

Tweet

SQL
Quiz

or Read more about SQL Quizzes

Follow CodeGalaxy

Mobile Beta

Send Feedback