DBMS Quiz 1

Question 1

Time: 00:00:00
Ready the Query carefully:
SELECT emp_name
FROM department
WHERE dept_name LIKE ' _____ Computer Science';
In the above-given Query, which of the following can be placed in the Query's blank portion to select the "dept_name" that also contains Computer Science as its ending string?

&

&

_

_

%

%

$

$

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 2

Time: 00:00:00
What do you mean by one to many relationships?

One class may have many teachers

One class may have many teachers

One teacher can have many classes

One teacher can have many classes

Many classes may have many teachers

Many classes may have many teachers

Many teachers may have many classes

Many teachers may have many classes

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 3

Time: 00:00:00
A Database Management System is a type of _________software.

It is a type of system software

It is a type of system software

It is a kind of application software

It is a kind of application software

It is a kind of general software

It is a kind of general software

Both A and C

Both A and C

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 4

Time: 00:00:00
The term "FAT" is stands for_____

File Allocation Tree

File Allocation Tree

File Allocation Table

File Allocation Table

File Allocation Graph

File Allocation Graph

All of the above

All of the above

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 5

Time: 00:00:00
The term "NTFS" refers to which one of the following?

New Technology File System

New Technology File System

New Tree File System

New Tree File System

New Table type File System

New Table type File System

Both A and C

Both A and C

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 6

Time: 00:00:00
Which of the following can be used to extract or filter the data & information from the data warehouse?

Data redundancy

Data redundancy

Data recovery tool

Data recovery tool

Data mining

Data mining

Both B and C

Both B and C

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 7

Time: 00:00:00
Which one of the following refers to the copies of the same data (or information) occupying the memory space at multiple places.

Data Repository

Data Repository

Data Inconsistency

Data Inconsistency

Data Mining

Data Mining

Data Redundancy

Data Redundancy

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 8

Time: 00:00:00
Which of the following refers to the level of data abstraction that describes exactly how the data actually stored?

Conceptual Level

Conceptual Level

Physical Level

Physical Level

File Level

File Level

Logical Level

Logical Level

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 9

Time: 00:00:00
To which of the following the term "DBA" referred?

Data Bank Administrator

Data Bank Administrator

Database Administrator

Database Administrator

Data Administrator

Data Administrator

None of the above

None of the above

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 10

Time: 00:00:00
Rows of a relation are known as the _______.

Degree

Degree

Tuples

Tuples

Entity

Entity

All of the above

All of the above

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

["0","40","60","80","100"]
["Need more practice!","Keep trying!","Not bad!","Good work!","Perfect!"]

Personalized Analytics only Availble for Logged in users

Analytics below shows your performance in various Mocks on PrepInsta

Your average Analytics for this Quiz

Rank

-

Percentile

0%

Completed

0/0

Accuracy

0%

Comments