AP ECET COMPUTER SCIENCE AND ENGINEERING Multiple Choice Questions (MCQs)
Multiple Choice Questions - DBMS
-
Which of the following is the main purpose of a Database Management System (DBMS)?
- a) Data storage
- b) Data manipulation
- c) Data security and integrity
- d) All of the above
Answer: d) All of the above
-
Which of the following is a feature of RDBMS (Relational Database Management System)?
- a) Data is stored in a hierarchical model
- b) Data is stored in tables with rows and columns
- c) No SQL queries are allowed
- d) It does not support primary keys
Answer: b) Data is stored in tables with rows and columns
-
Which of the following is a valid SQL statement to retrieve all records from the 'students' table?
- a) SELECT * FROM students;
- b) GET * FROM students;
- c) FETCH * FROM students;
- d) SHOW * FROM students;
Answer: a) SELECT * FROM students;
-
What does the acronym SQL stand for?
- a) Structured Query Language
- b) Simple Query Language
- c) Sequential Query Language
- d) Standard Query Language
Answer: a) Structured Query Language
-
Which of the following SQL commands is used to remove a table from a database?
- a) DELETE
- b) REMOVE
- c) DROP
- d) TRUNCATE
Answer: c) DROP
-
In SQL, which of the following clauses is used to filter records?
- a) WHERE
- b) ORDER BY
- c) GROUP BY
- d) HAVING
Answer: a) WHERE
-
What is the correct syntax for declaring a variable in PL/SQL?
- a) VARIABLE name;
- b) name : TYPE;
- c) DECLARE name TYPE;
- d) name TYPE;
Answer: c) DECLARE name TYPE;
-
Which of the following is NOT a valid data type in PL/SQL?
- a) INTEGER
- b) DATE
- c) VARCHAR2
- d) JSON
Answer: d) JSON
-
In PL/SQL, what is the use of the 'EXCEPTION' block?
- a) To catch errors during runtime
- b) To handle data insertion
- c) To define variables
- d) To create stored procedures
Answer: a) To catch errors during runtime
-
Which of the following is true about advanced PL/SQL?
- a) It allows the use of stored procedures, functions, and triggers
- b) It is limited to simple SQL queries
- c) It does not support error handling
- d) It is used only for reporting purposes
Answer: a) It allows the use of stored procedures, functions, and triggers
-
What is the main difference between SQL and NoSQL databases?
- a) SQL databases are based on relational models, while NoSQL databases use non-relational models
- b) SQL databases are slower than NoSQL databases
- c) SQL databases do not support queries, while NoSQL does
- d) NoSQL databases do not support indexing
Answer: a) SQL databases are based on relational models, while NoSQL databases use non-relational models
-
Which of the following is an example of a NoSQL database?
- a) Oracle
- b) MySQL
- c) MongoDB
- d) PostgreSQL
Answer: c) MongoDB
-
What is the primary advantage of using MongoDB?
- a) It provides strong data consistency
- b) It uses a relational database model
- c) It supports flexible schema and scalability
- d) It does not allow queries
Answer: c) It supports flexible schema and scalability
-
Which of the following is used to retrieve data from a MongoDB database?
- a) SELECT
- b) GET
- c) db.collection.find()
- d) FETCH
Answer: c) db.collection.find()
-
Which of the following is a characteristic of the NoSQL database MongoDB?
- a) It uses tables and rows for data storage
- b) It allows the storage of data in the form of documents
- c) It does not support querying capabilities
- d) It uses SQL to query data
Answer: b) It allows the storage of data in the form of documents
<< Previous Page l Next Page >>
Note/Caution: studentsbizz.com does not promise a job or an interview in exchange for money. Fraudsters may ask you to pay under the pretext of a registration fee or refundable fee, but please be aware that legitimate employers will not require such payments.
Join in Our Groups
@ 2024 Students Bizz Platform. All Rights Reserved.