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

Table with no clustered index is called

  1. AOL

  2. BOL

  3. DOL

  4. Heap


Correct Option: D
  1. Intermediate level

  2. Header level

  3. Data level

  4. Binary level


Correct Option: A

Maximum columns added into index

  1. 31

  2. 32

  3. 225

  4. 2065


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

Which one is the parameter of SP_Configure

  1. allow updates to system tables

  2. locking

  3. Setup

  4. no of lock


Correct Option: A

Which is not parameters for STUFF function

  1. First string

  2. Second string

  3. Start position

  4. End position


Correct Option: D

The file that store data in Sybase is usually called as

  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

which of the below functions are not used in Sybase

  1. Current_date

  2. Datachange

  3. Gettime

  4. Convert


Correct Option: C

Which one of the below is not related to Cursor

  1. Sensitive

  2. Forward

  3. Fetch

  4. Position


Correct Option: D

Some of the core sys tables can be updated, true or false

  1. True

  2. False


Correct Option: B

Which of the following statements is NOT true of local variables?

  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

Total no of index in the user tables

  1. 250

  2. 255

  3. 2065

  4. 1026


Correct Option: A

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

  1. True

  2. False


Correct Option: B

is related to

  1. Index

  2. Page allocation

  3. Trigger creation

  4. None of the above


Correct Option: A
- Hide questions