What acts as an interface maintaining a two-way connection between the user and the database?
- aOperating system
- bDatabase management system
- cFile system
- dCompiler
143 questions · 18 sections
What acts as an interface maintaining a two-way connection between the user and the database?
In a DBMS, who requests operations and who acts on the database to provide the required data?
The system that stores the data is called the database; what is the system that operates the database called?
Why are computers better than pen and paper for handling data?
A school feeds all relevant data into a DBMS; a parent asks which classes their child missed in 3 months. Compared with the manual book-checking method, the DBMS can provide this information in —
When a computer program works with data, where does it first put the data?
What happens to RAM data when the computer is shut down?
Through which system is the data on a hard disk drive accessed?
Consider the following statements about using only a file system to manage data: Which of the following is correct?
Why is a hard disk drive used instead of RAM to store necessary data permanently?
In the realm of computer science, a database is best described as —
Which of the following is a main function of a DBMS?
In a broader sense, a database can be of which two types?
Which statement about relational vs NoSQL databases is correct?
Preventing data duplication is one of the listed functions of which system?
In a relational database, how is data stored?
A database table has two parts. What are they?
What does a table header contain?
In relational database terminology, each row of a table is also known as a —
Each cell in a relational database table is known as a —
Which of the following is NOT listed as a data type common to every relational database?
Consider the following relational database systems: Which of the above are free and open source?
Which of the following is a popular relational database system mentioned in the chapter?
In a school database, the result table has a relation with the student table. What is the benefit of this relation?
When a record's value in the database is unknown, what is used in that place?
A user does not want to disclose their monthly family income. According to the chapter, what should be stored instead?
If a record field is kept blank, how does the database treat it?
What is a primary key?
When multiple columns are combined to create a primary key, it is called a —
Why can a student's name NOT serve as a primary key?
Which attribute makes an 'id' column automatically increase its value by 1 each time a new row is added?
Consider the following statements about the student table: Which of the following is correct?
Why is an 'id' column with auto increment commonly added when no suitable primary key exists?
According to the chapter, what is true about a primary key in a relational database?
Why can using class + section + roll number as a composite key cause a problem when keeping records of passed-out students?
Every adult in Bangladesh has a unique National Identification (NID) number. Why can the NID be used as a primary key?
Database relation refers to the relation between —
How many types of database relations are mentioned in the chapter?
Which of the following is one of the three types of database relations?
When we use the primary key of one table in another table, it is known as a —
What creates the relation between two tables?
In a one to one relation, a row from one table can have a relation to —
In the example, student_info has each student once and result stores results subject-wise; student with roll 1 has two subjects in two rows. This relation between student_info and result is —
A student can be a member of many clubs and a club can have many student members. What type of relation is this?
To establish a many to many relationship between student_info and club, what is required?
In the club table, the column 'Name' is the primary key. Why is it suitable?
Consider the following statements about the student_info and student_contact one-to-one example: Which of the following is correct?
What is the full form of SQL?
SQL is used in relational databases to —
Why is SQL called a declarative language?
C and other C-like programming languages are known as —
Which part of SQL is primarily used to create, delete and index database tables?
DML (Data Manipulation Language) is mainly used to —
Consider the following statements about SQL: Which of the following is correct?
SQLite is best described as a —
Which command starts SQLite and creates/accesses a database named school.db?
start school.dbsqlite3 school.dbopen school.dbdb school.dbIn the SQLite prompt, which command is used to close the software?
.exit now.quit.close.stopWhich of the following is a graphical (GUI) tool mentioned for using SQLite more easily?
Which SQL query is used to create a table?
MAKE TABLECREATE TABLENEW TABLEBUILD TABLEWhat is the correct syntax to create a student table with the given columns?
CREATE TABLE student (name TEXT, class INTEGER, roll INTEGER, section TEXT);CREATE student TABLE (name, class, roll, section);MAKE TABLE student name TEXT class INTEGER;CREATE TABLE (student) name=TEXT class=INTEGER;Which query is used to delete an entire table?
DELETE TABLEDROP TABLEREMOVE TABLECLEAR TABLEAccording to the NOTE, which is true about letter case in SQL queries?
Which query is used to store (add) data into a table?
ADDINSERTPUTSTOREWhich query retrieves all columns and rows from the student table? SELECT ___ FROM student;
ALL*EVERY#To insert a student named Mizanur Rahman, class 9, roll 3, morning section, the correct query is —
INSERT INTO student (name, class, roll, section) VALUES ('Mizanur Rahman', 9, 3, 'morning');INSERT student VALUES Mizanur Rahman 9 3 morning;ADD TO student ('Mizanur Rahman', 9, 3, 'morning');INSERT (name, class, roll, section) student ('Mizanur Rahman', 9, 3, morning);To retrieve only the name and class columns from student, the query is —
SELECT * FROM student;SELECT name, class FROM student;GET name, class FROM student;SELECT student (name, class);In a SELECT query, conditions are written after which keyword?
IFWHEREWHENHAVINGWhich operator means "not equal" in the SQLite condition operators listed?
!=<>===/=The query SELECT * FROM student WHERE class = 9; retrieves —
When writing conditions on text-type data, what must you use?
# symbolThe query SELECT * FROM student WHERE section = morning; produces Error: no such column: morning. Why?
section is not a valid columnTo retrieve Class 9 morning section students, which query is correct?
SELECT * FROM student WHERE class = 9 OR section = 'morning';SELECT * FROM student WHERE class = 9 AND section = 'morning';SELECT * FROM student WHERE class = 9, section = 'morning';SELECT * FROM student WHERE class = 9 NOT section = 'morning';The query SELECT * FROM student WHERE class <> 9 AND section = 'morning'; retrieves students who are —
Which query is equivalent to SELECT * FROM student WHERE class = 8 OR class = 9 OR class = 10;?
SELECT * FROM student WHERE class BETWEEN 8 10;SELECT * FROM student WHERE class IN (8, 9, 10);SELECT * FROM student WHERE class = (8, 9, 10);SELECT * FROM student WHERE class HAS (8, 9, 10);Which query is used to delete a record from a table?
REMOVE FROMDELETE FROMDROP FROMERASE FROMWhy should extra conditions be added to a query like DELETE FROM student WHERE name = 'Fardeem Munir';?
Which query is used to change or edit an existing record?
CHANGEUPDATEEDITMODIFYTo correct Fardeem Munir's record to class 10, roll 3, the correct query is —
UPDATE student SET class = 10, roll = 3 WHERE name = 'Fardeem Munir';UPDATE student class = 10 roll = 3 name = 'Fardeem Munir';CHANGE student SET class = 10, roll = 3;UPDATE SET class = 10, roll = 3 FROM student;The operation of retrieving data from multiple related tables at once is called —
In a join query where both tables have a column named roll, why is result.roll written instead of just roll?
In the join query, which condition part actually joins the two tables?
result.roll = 1result.roll = student_info.rollSELECT name, subjectFROM result, student_infoTo see every student's joined data (not just roll 1), what must be removed from the join query?
FROM result, student_info partresult.roll = 1 partresult.roll = student_info.roll partSELECT keywordWhy should regular and frequent backups of a database be generated?
Erroneous data caused by issues of hardware, software or networks is known as —
Why are backups usually stored in separate physical drives?
Why are data centers usually located in different geological locations?
Consider the following statements about database security: Which of the following is correct?
According to the chapter, which databases offer many types of extensive security protections, unlike SQLite?
The branch of computer science that deals with data encryption is known as —
In encryption, what is the original (unencrypted) data called?
The encrypted data is called —
Which Roman emperor is mentioned as having encoded his letters so only the receiver could decode them?
Encryption systems are mainly of which two types?
In symmetric key cryptography, the key used to encrypt and decrypt is —
Consider the following downfalls of symmetric key cryptography: Which of the following is correct?
In asymmetric key cryptography, each user generates —
In asymmetric cryptography, if A sends data to B, A encrypts the data with —
Data encrypted with B's public key can be decrypted only with —
Which is the responsibility of the receiver in an encryption system?
Who first proposed the concepts of a relational database?
How many characteristics did the proposer say must be present in any relational database?
According to RDBMS characteristics, every data of the database is stored —
Any data of the database can be retrieved using —
According to RDBMS characteristics, an internal physical change in the database —
Regarding where data is physically stored, an RDBMS ensures that —
The query SELECT name FROM student WHERE roll = 1 AND class = 10; retrieves the name of —
The query UPDATE student SET class = 10 WHERE class = 9; does what?
Which of the following is stored in the national ID database?
Why do e-commerce websites rely on databases?
Consider the following organizations that use relational databases: Which of the following is correct?
The type of software that manages codependent corporate work (e.g. inventory, sales) is known as —
Which of the following is a common ERP module mentioned in the chapter?
What is one of the main challenges of an ERP system for a large corporation with many branches?
Consider the following statements about a corporate ERP: Which of the following is correct?
What can improper management or non-use of databases cause among government organizations?
Why must citizens re-enter the same information for passport or driving licence even though the NID database has it?
A great use of properly managed government databases is to —
Consider the following main challenges for government database management: Which of the following is correct?
Which one uniquely identifies each record in a database?
What is called the information combined together in some fields?
Private key is used in which encryption algorithm?
What is the full form of SQL?
A Student table has columns Roll, Name and GPA. To find who got GPA = 5.00, complete the query SELECT NAME FROM Student ...
WHERE "GPA" = "5.00"WHERE "GPA", "5.00"WHERE GPA = 5.00WHERE GPA is 5.00What is the relation between primary key and foreign key? Which one is true?
What is the main responsibility of a Database Management System? Which one is true?
What is a database?
Why is SQL called a declarative programming language?
A Teacher's table has columns TID, TNAME and Subject. Which data types best fit TID and TNAME respectively?
To create a relation between a Teacher's table and a Routine table that both contain TID, the TID of the routine table should be used as a —
A school results database is searched; the fastest student found the data quickest. According to the chapter, which strategy makes searching a database fastest?
What is data encryption?
NID information of every adult is stored in which type of database?
A voter-list database stores name, father's name, religion, birth date and location. Which data type best fits the birth date column?
Two voter database files share name and date of birth. How can a relation between them best be made?
What is an RDBMS?
Two tables — an employee ID table and a designation/salary table — can be linked. To create a relation, what should be added?
What is a corporate database (ERP context)?
Why is data security important in a database?
To insert a new column between two existing columns of a table, what must generally be done?
A Student-info table and a result table both contain Roll, where one student has many subject results. What relation exists between them?
What is a ciphertext?
Why does INSERT, UPDATE and DELETE take more time after a database is indexed?
What should be kept in mind while creating a database for the government? Which of the following is correct?