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