Advanced SQL Mcqs

A. Date

B. Time

C. Datestamp

D. Timestamp

A. A combination of date and time with date first

B. A combination of date and time with time first

C. A combination of time and place with time first

D. A combination of time and place with place first

A. The amount of delay that needs to be added to the time

B. The number of fractional digits for the seconds

C. The maximum number of allowed hours

D. None of the mentioned

A. It is a value that automatically creates a primary key

B. It is a value that cannot be altered during insertion of values in the tuple

C. It is a value that is initially loaded into the attribute

D. None of the mentioned

A. Number

B. Clob

C. Blob

D. Lint

A. It creates a new relation temp_inst with all the tuples and attributes of the institute relation

B. It creates a new relation temp_inst with the same schema as that of the institute relation

C. It creates a new relation named temp_inst with institute as its only attribute

D. It does not create any relations and returns an error

A. Select

B. Insert

C. Update

D. All of the mentioned

A. Grant

B. Confer

C. Implement

D. Permit

A. It revokes all authorizations from amit

B. It revokes select authorization from amit

C. It revokes takes authorization from amit

D. It gives an error

A. Allowing a program to construct an SQL query in a character string

B. Submitting the query

C. Retrieving the result into the program variables a tuple at a time

D. All of the mentioned

A. Java Database Connectivity

B. Java Database Co-Operation

C. JSP Database Committee

D. Java Database Creation

A. Triggers

B. Packages

C. Functions

D. None of the mentioned

A. Persistent construct dealer

B. Persistent storage module

C. Persistent supports center

D. Primary storage medium

A. Trigger

B. Function

C. Package

D. Protocol

A. 1

B. 2

C. 3

D. 4