Tag: databases

What would be the output of the code below in SQL Server 2005 and earlier versions? declare @d date select @d = '09/09/2008' select @d

What is the output? declare @d decimal select @d = 3.564636 select @d

What is the output? DECLARE @val CHAR(20) SET @val = ' SQL is cool ' select LEN(@val)

what is the len of @c? declare @c varchar(8000) set @c = N'hello' + replicate('-',8000) print len(@c) print @c

What is the output? SELECT SUBSTRING('123456', 0, 3)

Which of the following SQL functions can operate on any datatype?

Which Oracle access method is the fastest way for Oracle to retrieve a single row?

Which command will delete all data from a table and will not write to the rollback segment?

What is the default behaviour of OUT parameter mode in PL/SQL

What is RAC