Tag: databases

Questions Related to databases

Which of these following features are correct if SQL is a set-oriented language?

  1. Individual rows must have a unique identifier

  2. Sets of users can be managed in groups

  3. One statement can affect multiple rows

  4. SQL statements can be placed within blocks of code

  5. All the above


Correct Option: C
  1. Cannot drop a field

  2. Cannot rename a field

  3. Cannot manage memory

  4. Index on view or index on index not provided

  5. View updation problem


Correct Option: A,B,C,D,E
  1. 32 bit

  2. 64 bit

  3. 18 bit

  4. None of the above


Correct Option: A
  1. Java

  2. Any other language linked to the OCI libraries

  3. SQL

  4. C

  5. PL/SQL

  6. All the above expect Option 2


Correct Option: A,C,E
  1. <>

  2. like '%...' is NOT functions

  3. field +constant

  4. field||''

  5. AND


Correct Option: A,B,C,D