Database Management Systems Mcqs

Page No. 3

In the given query which of the keyword has to be inserted?
Select empid where empid = 1009 and lastname = ‘GELLER’;


aTable


bValues


cRelation


dField


View Answer Values

Which of the following statements contains an error?


aSelect * from emp where empid = 10003;


bSelect empid from emp where empid = 10006;


cSelect empid from emp;


dSelect empid where empid = 1009 and lastname = ‘GELLER’;



SELECT * FROM employee WHERE salary>10000 AND dept_id=101;
Which of the following fields are displayed as output?


aSalary, dept_id


bEmployee


cSalary


dAll the field of employee relation



This Query can be replaced by which one of the following?
SELECT name, course_id FROM instructor, teaches WHERE instructor_ID= teaches_ID;


aSelect name,course_id from teaches,instructor where instructor_id=course_id;


bSelect name, course_id from instructor natural join teaches;


cSelect name, course_id from instructor;


dSelect course_id from instructor join teaches;



The ________ clause is used to list the attributes desired in the result of a query.


aWhere


bSelect


cFrom


dDistinct


View Answer Select

The query given below will not give an error. Which one of the following has to be replaced to get the desired output?
SELECT ID, name, dept name, salary * 1.1 WHERE instructor;


aSalary*1.1


bID


cWhere


dInstructor


View Answer Where

The ______ clause allows us to select only those rows in the result relation of the ____ clause that satisfy a specified predicate.


aWhere, from


bFrom, select


cSelect, from


dFrom, where


View Answer Where, from

Here which of the following displays the unique values of the column?
SELECT ________ dept_name FROM instructor;


aAll


bFrom


cDistinct


dName


View Answer Distinct

_____ operator is used for appending two strings.


a&


b%


c||


d_


View Answer ||

In SQL the spaces at the end of the string are removed by _______ function.


aUpper


bString


cTrim


dLower


View Answer Trim

Goto Page No.

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