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