Database Management Systems Mcqs

Page No. 15

The variables in the triggers are declared using


a


b@


c/


d/@


View Answer @

What are the after triggers?


aTriggers generated after a particular operation


bThese triggers run after an insert, update or delete on a table


cThese triggers run after an insert, views, update or delete on a table


dAll of the mentioned



The CREATE TRIGGER statement is used to create the trigger. THE _____ clause specifies the table name on which the trigger is to be attached. The ______ specifies that this is an AFTER INSERT trigger.


afor insert, on


bOn, for insert


cFor, insert


dNone of the mentioned


View Answer On, for insert

Triggers are supported in


aDelete


bUpdate


cViews


dAll of the mentioned


View Answer Views

A __________ is a special kind of a store procedure that executes in response to certain action on the table like insertion, deletion or updation of data.


aProcedures


bTriggers


cFunctions


dNone of the mentioned


View Answer Triggers

The command ________________ such tables are available only within the transaction executing the query and are dropped when the transaction finishes.


aCreate table


bCreate temporary table


cCreate view


dCreate label view



The functions which construct histograms and use buckets for ranking is


aRank()


bNewtil()


cNtil()


dNone of the mentioned


View Answer Ntil()

Inorder to simplify the null value confusion in the rank function we can specify


aNot Null


bNulls last


cNulls first


dEither 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).


aNtil()


bCum_rank


cPercent_rank


drank()


View Answer Percent_rank

The __________ function that does not create gaps in the ordering.


aIntense_rank()


bContinue_rank()


cDefault_rank()


dDense_rank()


View Answer Dense_rank()

Goto Page No.

Page 15 of 101

Alphabetical MCQs Categories

Here below You find all kind of categories of MCQs in alphabetical order.


"Comprehensive Collection of MCQs: Alphabetically Organized by Subject"

"Discover an extensive collection of multiple-choice questions (MCQs) neatly categorized by subject from A to Z. This resource is designed for anyone eager to explore various topics in a straightforward and organized manner. Whether you're a student preparing for exams, an educator seeking supplementary materials, or simply curious about different subjects, this compilation offers a convenient way to learn and assess your knowledge. With questions arranged alphabetically, navigation is effortless, allowing you to delve into subjects of interest at your own pace. Engage, learn, and expand your understanding with this accessible and comprehensive repository of MCQs!"


BolPakistan

bolpakistan.com.pk includes Job Mcqs and Pak Mcqs is the Top Largest Mcqs Forum in World, in which you can read Mcqs of All Subjects, PPSC test preparation, FPSC, NTS and PPSC PAST PAPERS, PPSC PAST MCQS. A Collection of Repeated MCQs for JOBs seekers.

Copyright © 2024, Designed & Developed by BolPakistan