DBMS MCQ Questions and Answers
DBMS MCQ questions with answers form a vital part of technical exams and campus interviews. This topic explores database concepts, normalization, SQL queries, transaction management, and ER models. Practicing programming questions and answers from this section strengthens your database design and query optimization skills. These questions are frequently asked in GATE, Infosys, TCS, and Wipro assessments, making them essential for students and professionals alike. Detailed solutions and explanations make this section perfect for both beginners and advanced learners aiming to master database management fundamentals.
DBMS MCQ
Showing 10 of
527 questions
61. which character function is used to return a specified portion of a character string
- Initcap
- Concat
- Substring
- Length
62. Which dictionary view gives the information of the tables of user
- All tables
- User tables
- DBA tables
- All the above
64. Which of the following statements from database
- set of tables & views
- set of clusters
- set of synonyms
- none of the above
65. Which way of accessing information in the database is easy
- primary key access
- Table access by ROWID
- access by foreign key
- none of these
66. Which way of accessing information in the database is easy
- primary key access
- Table access by ROWID
- access by foreign key
- none of these
67. Which command will remove all data from the table and not able to roll back is
- DELETE
- DROP
- TRUNCATE
- ALL THE ABOVE
68. When a user creates an object with out giving table-space then where it will stored
- system table-space
- Oracle table-space
- Oracle Error
- Default Table-space
70. Assume that today is Monday of jan 2006 then what is the output of the query bellow SELECT TO CHAR (NEXT DAY(SYSDATE MONDAY,
- 17/01/06
- 17/jan/06
- 17-01-06
- 17-Jan-06