Tag: databases

Questions Related to 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
technology databases

  1. 09/09/2008

  2. 09-09-2008 00:00:00:000

  3. Error Message

  4. None of the above

Show answer
Correct Option: C

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

  1. 4

  2. 3.56

  3. 3.564636

  4. 3

Show answer
Correct Option: A

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

technology databases

  1. 20

  2. 14

  3. 12

  4. 13

Show answer
Correct Option: C

AI Explanation

To answer this question, you need to understand the LEN function in SQL.

The LEN function is used to return the number of characters in a specified string. In this case, the specified string is the variable @val, which is set to ' SQL is cool '.

The LEN function will count all characters in the string, including leading and trailing spaces. Therefore, the output of the query select LEN(@val) will be the total number of characters in the string, which is 12.

So, the correct answer is C) 12.

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

  1. 8000

  2. 4000

  3. 4005

  4. 5

Show answer
Correct Option: B

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

  1. 123

  2. 12

  3. 123456

  4. 456

Show answer
Correct Option: B

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

  1. to_char

  2. max

  3. rollup

  4. cube

Show answer
Correct Option: A

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

  1. Primary key access

  2. Full table scan

  3. Access via unique index

  4. Table access by ROWID

  5. None of the above

Show answer
Correct Option: A

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

  1. DROP

  2. DELETE

  3. TRUNCATE

  4. REMOVE

  5. NONE OF THE ABOVE

Show answer
Correct Option: A

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

  1. By value

  2. By reference

  3. By type

  4. none of the above

Show answer
Correct Option: A

What is RAC

technology databases

  1. Real abstarct clustersl

  2. Real application cursors

  3. Real application clusters

  4. none of the above

Show answer
Correct Option: A