Database Management Systems Mcqs

Page No. 87

In SQL, which command is used to remove a stored function from the database?


aREMOVE FUNCTION


bDELETE FUNCTION


cDROP FUNCTION


dERASE FUNCTION


View Answer DROP FUNCTION

In SQL, the CREATE TABLESPACE is used


ato create a place in the database for storage of scheme objects, rollback segments, and naming the data files to comprise the tablespace


bto create a database trigger


cto add/rename data files, to change storage


dAll of the above



Which of the following is not the responsibility of the utilities component of DBMS software?


acreating the physical and logical designs


bremoving flagged records for deletion


ccreating and maintaining the data dictionary


dmonitoring performance



The master list of an indexed file


ais sorted in ascending order


bcontains only a list of keys and record numbers


chas a number assigned to each record


dboth (b) and (c)



Which command is used to select distinct subject (SUB) from the table (BOOK)?


aSELECT ALL FROM BOOK


bSELECT DISTINCT SUB FROM BOOK


cSELECT SUB FROM BOOK


dAll of the above



The physical location of a record is determined by a mathematical formula that transforms a file key into a record location in


aa tree file


ban indexed file


ca hashed file


da sequential file


View Answer a hashed file

In SQL, which command is used to select only one copy of each set of duplicable rows


aSELECT DISTINCT


bSELECT UNIQUE


cSELECT DIFFERENT


dAll of the above


View Answer SELECT DISTINCT

In order to use a record management system


aYou need to understand the low-level details of how information in stored


bYou need to understand the model the record management system uses.


cBoth (a) and (b)


dNone of the above



Queries to a database


aare written in English


bcan use aggregate functions like SUM and COUNT


cboth (a) and (b)


dNone of the above



A logical schema


ais the entire database


bis a standard way of organizing information into accessible parts


cdescribes how data is actually stored on disk


dAll of the above



Goto Page No.

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