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?

&

&

_

_

%

%

$

$

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

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

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

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

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

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

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

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

Question 10

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

Degree

Degree

Relation

Relation

Entity

Entity

Tuples

Tuples

null
null
×

Please login to report