Database Systems - Section 8 | Multiple Questions and Answers

Join Us :: Register Login

Home Classes GK Engineering Past Papers Current Affairs Technical GAT Subject Programming Medical Papers

Database Systems - Section 8 Multiple Questions and Answers.

1.	In SQL, the command(s) is(are) used to create an index for a table or cluster

	A.	CREATE INDEX
	B.	MODIFY INDEX
	C.	SET INDEX TO FILE
	D.	All of the above

2.	There are certain packages that allow people to define data items, place these items in particular records, combine the records into designated files and then manipulate and retrieve the stored data. What are they called?

	A.	Data storage system
	B.	Database management system (DBMS)
	C.	Batch processing system
	D.	Data communication package

3.	A _____ DBMS distributes data processing tasks between the workstation and a network server.

	A.	Network
	B.	Relational
	C.	Client Server
	D.	Hierarchical

4.	Information can be transferred between the DBMS and a

	A.	spreadsheet program
	B.	word processor program
	C.	graphics program
	D.	All of the above

5.	Data integrity control

	A.	is used to set upper and lower limits on numeric data
	B.	requires the use of passwords to prohibit unauthorized access to the file
	C.	has the data dictionary keep the date and time of last access last back-up, and most recent modification for all files
	D.	All of the above

Read More :

» Database Systems - Section 1

» Database Systems - Section 2

» Database Systems - Section 3

» Database Systems - Section 4

» Database Systems - Section 5

» Database Systems - Section 6

» Database Systems - Section 7

» Database Systems - Section 8

Date to Date Current Affairs 2022

PakMCQs.net

Quick Links

GAT Subject

Computer Science English Mcqs Agriculture

Engineering

Computer Science Civil Engineering

Technical

Networking Electronics Database

Past Papers

Model Papers FPSC Papers