Question 1

Table with no clustered index is called

technology databases

AOL
BOL
DOL
Heap

Answer

Correct Option: D

Question 2

Which one is the level of index in the below list

technology databases

Intermediate level
Header level
Data level
Binary level

Answer

Correct Option: A

Question 3

Maximum columns added into index

technology databases

31
32
225
2065

Answer

Correct Option: A

Question 4

Which one of the following constraints enforces domain integrity?

technology databases

Primary key constraint
Check constraint
Foreign key constraint
Unique constraint

Answer

Correct Option: B

Question 5

Which database objects can a stored procedure create?

technology databases

View
Index
Default
Extended stored procedure

Answer

Correct Option: B

Question 6

Sub-queries can be nested in…

technology databases

DELETE statements only.
INSERT statements only.
UPDATE statements only.
UPDATE, DELETE, INSERT and SELECT statements.

Answer

Correct Option: D

Question 7

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

technology databases

Have
The statement will produce error.
day.
Missing parameter

Answer

Correct Option: A

Question 8

Which one is the parameter of SP_Configure

technology databases

allow updates to system tables
locking
Setup
no of lock

Answer

Correct Option: A

Question 9

Which is not parameters for STUFF function

technology databases

First string
Second string
Start position
End position

Answer

Correct Option: D

Question 10

The file that store data in Sybase is usually called as

technology databases

Datafile
Device
Data Object
Material

Answer

Correct Option: B

Question 11

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

technology databases

Blank removed Column_name1, first 5 character of column_name2,2 to 4 character part of string from Column_name3
Blank removed Column_name1, last 5 character of column_name2,2 to 4 character part of string from Column_name3
Blank removed Column_name1, first 5 character of column_name2 and 2,3,4,5 character part of string from Column_name3
None of the above

Answer

Correct Option: D

Question 12

@@sqlstatus can't have any of the below values

technology databases

1
3
2
None of the above

Answer

Correct Option: B

Question 13

Which is not part of "case" keyword in sybase

technology databases

End case
When
then
None of the above

Answer

Correct Option: A

Question 14

which of the below functions are not used in Sybase

technology databases

Current_date
Datachange
Gettime
Convert

Answer

Correct Option: C

Question 15

Which one of the below is not related to Cursor

technology databases

Sensitive
Forward
Fetch
Position

Answer

Correct Option: D

Question 16

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

technology databases

True
False

Answer

Correct Option: B

Question 17

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

technology databases

Their name must begin with @
They are local to the batch or stored procedure where they are declared
They can be declared in a select statement
They cannot have a datatype of text or image

Answer

Correct Option: C

Question 18

Total no of index in the user tables

technology databases

250
255
2065
1026

Answer

Correct Option: A

Question 19

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

technology databases

True
False

Answer

Correct Option: B

Question 20

is related to

technology databases

Index
Page allocation
Trigger creation
None of the above

Answer

Correct Option: A

Description: databases Online Quiz - 61
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: databases

databases Online Quiz - 61

Find more quizzes from top tags