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