Relational Database Management System Mcqs

Page No. 5

What values does the count(*) function ignore?


aRepetitive values


bNull values


cCharacters


dIntegers


View Answer Null values

Which keyword is used to rename the resulting attribute after the application of the aggregation function?


a rename


bas


creplace


dto


View Answer as

State true or false: We can rename the resulting attribute after the aggregation function has been applied


aTrue


bFalse


ceither true and false


dnone of these


View Answer True

State true or false: Any attribute which is present in the having clause without being aggregated must not be present in the group by clause.


aTrue


b False


ceither true and false


dnone of these


View Answer False

The _____ aggregation operation adds up all the values of the attribute


aadd


bavg


cmax


dsum


View Answer sum

Choose the correct option regarding the query


aThe having clause checks whether the query result is true or not


bThe having clause does not check for any condition


c The having clause allows only those tuples that have average balance 10000


dNone of the mentioned



We apply the aggregate function to a group of sets of tuples using the _______ clause.


agroup by


bgroup


c group set


dgroup attribute


View Answer group by

State true or false: SQL does not permit distinct with count(*)


aTrue


bFalse


ceither true and false


dnone of these


View Answer True

Observe the given SQL query and choose the correct option.


aThe query is syntactically correct but gives the wrong answer


b The query is syntactically wrong


cThe query is syntactically correct and gives the correct answer


dThe query contains one or more wrongly named clauses.



Which of the following is not a built in aggregate function in SQL?


a avg


bmax


c total


dcount


View Answer total

Goto Page No.

Page 5 of 54

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