databases Online Quiz - 61 Online Test

Back

databases Online Quiz - 61

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

Start the Quiz

Table with no clustered index is called

technology databases

AOL
BOL
DOL
Heap

Which one is the level of index in the below list

technology databases

Intermediate level
Header level
Data level
Binary level

Maximum columns added into index

technology databases

31
32
225
2065

Which one of the following constraints enforces domain integrity?

technology databases

Primary key constraint
Check constraint
Foreign key constraint
Unique constraint

Which database objects can a stored procedure create?

technology databases

View
Index
Default
Extended stored procedure

Sub-queries can be nested in…

technology databases

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

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

Which one is the parameter of SP_Configure

technology databases

allow updates to system tables
locking
Setup
no of lock

Which is not parameters for STUFF function

technology databases

First string
Second string
Start position
End position

The file that store data in Sybase is usually called as

technology databases

Datafile
Device
Data Object
Material

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

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

technology databases

1
3
2
None of the above

Which is not part of "case" keyword in sybase

technology databases

End case
When
then
None of the above

which of the below functions are not used in Sybase

technology databases

Current_date
Datachange
Gettime
Convert

Which one of the below is not related to Cursor

technology databases

Sensitive
Forward
Fetch
Position

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

technology databases

True
False

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

Total no of index in the user tables

technology databases

250
255
2065
1026

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

technology databases

True
False

is related to

technology databases

Index
Page allocation
Trigger creation
None of the above

- Hide questions

databases Online Quiz - 61

Find more quizzes from top tags