Which of the following refers to the level of data abstraction that describes exactly how the data actually stored?
Physical Level
Well Done. Your Answer is Correct Keep it Up!
Conceptual Level
File Level
Logical Level
Tag: Databases MCQs
Which one of the following refers to the copies of the same data (or information) occupying the memory space at multiple places.
Which one of the following refers to the copies of the same data (or information) occupying the memory space at multiple places.
Data Redundancy
Well Done. Your Answer is Correct Keep it Up!
Data Mining
Data Inconsistency
Data Repository
Which of the following can be used to extract or filter the data & information from the data warehouse?
Which of the following can be used to extract or filter the data & information from the data warehouse?
Data mining
Well Done. Your Answer is Correct Keep it Up!
Data recovery tool
Data redundancy
All options are correct
A huge collection of the information or data accumulated form several different sources is known as ________:
A huge collection of the information or data accumulated form several different sources is known as ________:
Data Warehouse
Well Done. Your Answer is Correct Keep it Up!
Data Mining
Data Management
All options are correct
Which of the following can be considered as the maximum size that is supported by NTFS?
Which of the following can be considered as the maximum size that is supported by NTFS?
4GB
Well Done. Your Answer is Correct Keep it Up!
16TB
64TB
8TB
The term “NTFS” refers to which one of the following?
The term “NTFS” refers to which one of the following?
New Technology File System
Well Done. Your Answer is Correct Keep it Up! In the old operating systems, the file structure used to store and manage files is called the FAT 32 ( or File Allocation Table). Later, when the technology evolves with time, a new type of file system is introduced, known as the New Technology File System. It overcomes all the drawbacks, issues that exist in FAT file architecture and has many other new features such as it is fast, it can handle files whose size is even greater than 4 GB.
New Tree File System
New Table type File System
None of the options are correct
Which of the following can be considered as the maximum size that is supported by FAT?
Which of the following can be considered as the maximum size that is supported by FAT?
4GB
Well Done. Your Answer is Correct Keep it Up! The files with a size of less than 4 GB or equal to 4GB are easily supported by the FAT. All files with a size greater than the maximum size (or is 4Gb) are not supported by the FAT.
8GB
4TB
None of the options are correct
The term “FAT” is stands for_____
The term “FAT” is stands for_____
File Allocation Table
Well Done. Your Answer is Correct Keep it Up! The term “FAT” can be described as a file structure (or file architecture). In which all the information about the files where they are stored and where all these files need to be stored or in which directory, all that information generally stored in the file structure. Therefore the Operating system creates a table in which all the files and clusters are stored, known as the file allocation table.
File Allocation Tree
File Allocation Graph
All options are correct
A Database Management System is a type of _________software.
A Database Management System is a type of _________software.
It is a type of system software
Well Done. Your Answer is Correct Keep it Up! The DBMS (or Database Management System) is a kind of system software used for several operations such as creating tables/databases, storing data, managing databases. It also allows modifying the data stored in the database as well.
It is a kind of application software
It is a kind of general software
None of the options are correct
Which one of the following given statements possibly contains the error?
Which one of the following given statements possibly contains the error?
select empid where empid = 1009 and Lastname = ‘GELLER’;
Well Done. Your Answer is Correct Keep it Up!
select empid from emp;
select empid from emp where empid = 10006;
select * from emp where empid = 10003;