Database Quiz Online Exam Quiz
Database Quiz GK Quiz. Question and Answers related to Database Quiz. MCQ (Multiple Choice Questions with answers about Database Quiz
Any recursive view must be defined as the union of two subqueries: a _______ query that is nonrecursive and a __________ query.
Options
A : Base, recursive
B : Recursive, Base
C : Base, Redundant
D : View, Base
The command ________________ such tables are available only within the transaction executing the query and are dropped when the transaction finishes.
Options
A : Create table
B : Create temporary table
C : Create view
D : Create label view
Ranking of queries is done by which of the following?
Options
A : Group by
B : Order by
C : Having
D : Both Group by and Order by
The __________ function that does not create gaps in the ordering.
Options
A : Intense_rank()
B : Continue_rank()
C : Default_rank()
D : Dense_rank()
Inorder to simplify the null value confusion in the rank function we can specify
Options
A : Not Null
B : Nulls last
C : Nulls first
D : Either Nulls last or first
If there are n tuples in the partition and the rank of the tuple is r, then its ________ is defined as (r ?1)/(n?1).
Options
A : Ntil()
B : Cum_rank
C : Percent_rank
D : rank()
The functions which construct histograms and use buckets for ranking is
Options
A : Rank()
B : Newtil()
C : Ntil()
D : None of the mentioned
In rank() function if one value is shared by two tuples then
Options
A : The rank order continues as counting numbers
B : The rank order continues by leaving one rank in the middle
C : The user specifies the order
D : The order does not change
Chemical Engineering Basics - Part 1 more Online Exam Quiz
Database Questions And Answers Encryption And Its Applications
Automata Theory Campus Interviews