Database Management Systems Mcqs

Page No. 31

Linked lists are best suited


aFor relatively permanent collections of data


bFor the size of the structure and the data in the structure are constantly changing


cAll of the mentioned


dNone of the mentioned



Arrays are best data structures


aFor relatively permanent collections of data


bFor the size of the structure and the data in the structure are constantly changing


cAll of the mentioned


dNone of the mentioned



Finding the location of the element with a given value is:


aTraversal


bSearch


cSort


dNone of the mentioned


View Answer Search

The operation of processing each element in the list is known as


aSorting


bMerging


cInserting


dTraversal


View Answer Traversal

Which of the following criterion is NOT written using the proper syntax?


a“Haris”


b<500


cNO VALUE


dBetween #1/1/2000# and #12/31/2000#


View Answer NO VALUE

Which of the following data structure is linear data structure?


aTrees


bGraphs


cArrays


dNone of the mentioned


View Answer Arrays

Which of the following data structure is not linear data structure?


aArrays


bLinked lists


cArrays & Linked lists


dNone of the mentioned


View Answer None of the mentioned

The indirect change of the values of a variable in one module by another module is called


aInternal change


bInter-module change


cSide effect


dSide-module update


View Answer Side effect

Which of the following queries displays the sum of all employee salaries for those employees not making commission, for each job, including only those sums greater than 2500?


aselect job, sum(sal) from emp where sum(sal) > 2500 and comm is null;


bselect job, sum(sal) from emp where comm is null group by job having sum(sal) > 2500;


cselect job, sum(sal) from emp where sum(sal) > 2500 and comm is null group by job;


dselect job, sum(sal) from emp group by job having sum(sal) > 2500 and comm is not null;



Which of the following queries are legal?


aSELECT deptno, count(deptno) FROM emp GROUP BY ename;


bSELECT deptno, count(deptno), job FROM emp GROUP BY deptno;


cSELECT deptno, avg(sal) FROM emp;


dSELECT deptno, avg(sal) FROM emp GROUP BY deptno;



Goto Page No.

Page 31 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