Tag: databases

Questions Related to databases

The modulos operator (%) CANNOT be used on the _____ datatype.
technology databases

  1. Tinyint

  2. Money

  3. Float

  4. Smallint

Show answer
Correct Option: B

Table with no clustered index is called
technology databases

  1. AOL

  2. BOL

  3. DOL

  4. Heap

Show answer
Correct Option: D

Which one is the level of index in the below list
technology databases

  1. Intermediate level

  2. Header level

  3. Data level

  4. Binary level

Show answer
Correct Option: A

Maximum columns added into index
technology databases

  1. 31

  2. 32

  3. 225

  4. 2065

Show answer
Correct Option: A

Which one of the following constraints enforces domain integrity?
technology databases

  1. Primary key constraint

  2. Check constraint

  3. Foreign key constraint

  4. Unique constraint

Show answer
Correct Option: B

Which database objects can a stored procedure create?
technology databases

  1. View

  2. Index

  3. Default

  4. Extended stored procedure

Show answer
Correct Option: B

Sub-queries can be nested in…
technology databases

  1. DELETE statements only.

  2. INSERT statements only.

  3. UPDATE statements only.

  4. UPDATE, DELETE, INSERT and SELECT statements.

Show answer
Correct Option: D

What will be the result of the following SQL statement: SELECT LEFT('Have a nice day.', 4)
technology databases

  1. Have

  2. The statement will produce error.

  3. day.

  4. Missing parameter

Show answer
Correct Option: A

Which one is the parameter of SP_Configure
technology databases

  1. allow updates to system tables

  2. locking

  3. Setup

  4. no of lock

Show answer
Correct Option: A

Which is not parameters for STUFF function
technology databases

  1. First string

  2. Second string

  3. Start position

  4. End position

Show answer
Correct Option: D