Database Management Systems Mcqs

Page No. 2

To remove a relation from an SQL database, we use the ______ command.


aDelete


bPurge


cRemove


dDrop table


View Answer Drop table

Updates that violate __________ are disallowed.


aIntegrity constraints


bTransaction control


cAuthorization


dDDL constraints


View Answer Integrity constraints

INSERT INTO instructor VALUES (10211, ’Smith’, ’Biology’, 66000);
What type of statement is this?


aQuery


bDML


cRelational


dDDL


View Answer DML

DELETE FROM r; //r - relation
This command performs which of the following action?


aRemove relation


bClear relation entries


cDelete fields


dDelete rows



An attribute A of datatype varchar(20) has the value “Avi”. The attribute B of datatype char(20) has value ”Reed”. Here attribute A has ____ spaces and attribute B has ____ spaces.


a3, 20


b20, 4


c20, 20


d3, 4


View Answer 3, 20

The basic data type char(n) is a _____ length character string and varchar(n) is _____ length character.


aFixed, equal


bEqual, variable


cFixed, variable


dVariable, equal


View Answer Fixed, variable

SELECT * FROM employee
What type of statement is this?


aDML


bDDL


cView


dIntegrity constraint


View Answer DML

CREATE TABLE employee (name VARCHAR, id INTEGER)
What type of statement is this?


aDML


bDDL


cView


dIntegrity constraint


View Answer DDL

Which one of the following provides the ability to query information from the database and to insert tuples into, delete tuples from, and modify tuples in the database?


aDML(Data Manipulation Language)


bDDL(Data Definition Language)


cQuery


dRelational Schema



Which one of the following is used to define the structure of the relation, deleting relations and relating schemas?


aDML(Data Manipulation Langauge)


bDDL(Data Definition Langauge)


cQuery


dRelational Schema



Goto Page No.

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