0

databases Online Quiz - 61

Description: databases Online Quiz - 61
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

Which one is the level of index in the below list

  1. Intermediate level

  2. Header level

  3. Data level

  4. Binary level


Correct Option: A
  1. Primary key constraint

  2. Check constraint

  3. Foreign key constraint

  4. Unique constraint


Correct Option: B

Which database objects can a stored procedure create?

  1. View

  2. Index

  3. Default

  4. Extended stored procedure


Correct Option: B
  1. DELETE statements only.

  2. INSERT statements only.

  3. UPDATE statements only.

  4. UPDATE, DELETE, INSERT and SELECT statements.


Correct Option: D

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

  1. Have

  2. The statement will produce error.

  3. day.

  4. Missing parameter


Correct Option: A
  1. allow updates to system tables

  2. locking

  3. Setup

  4. no of lock


Correct Option: A
  1. First string

  2. Second string

  3. Start position

  4. End position


Correct Option: D
  1. Datafile

  2. Device

  3. Data Object

  4. Material


Correct Option: B

select trim(column_name1),left(column_name2,5),substring(column_name3,2,4) from Table1 - The result of the above statement is

  1. Blank removed Column_name1, first 5 character of column_name2,2 to 4 character part of string from Column_name3

  2. Blank removed Column_name1, last 5 character of column_name2,2 to 4 character part of string from Column_name3

  3. Blank removed Column_name1, first 5 character of column_name2 and 2,3,4,5 character part of string from Column_name3

  4. None of the above


Correct Option: D

Which is not part of "case" keyword in sybase

  1. End case

  2. When

  3. then

  4. None of the above


Correct Option: A
  1. Current_date

  2. Datachange

  3. Gettime

  4. Convert


Correct Option: C
  1. Sensitive

  2. Forward

  3. Fetch

  4. Position


Correct Option: D
  1. Their name must begin with @

  2. They are local to the batch or stored procedure where they are declared

  3. They can be declared in a select statement

  4. They cannot have a datatype of text or image


Correct Option: C

It is possible to create a constraints on the existing tables by creating new column

  1. True

  2. False


Correct Option: B
  1. Index

  2. Page allocation

  3. Trigger creation

  4. None of the above


Correct Option: A
- Hide questions