Databases-Database Design [GATE (Graduate Aptitude Test in Engineering) Computer Science & IT (CS)]: Questions 1 - 6 of 48
Choose Programs:
🎓 Study Material (1190 Notes): 2024-2025 Syllabus
Rs. 1000.00 -OR-
3 Year Validity (Multiple Devices)
Topic-wise Notes & SampleDetails
🎯 302 Numeric, 2894 MCQs (& PYQs) with Full Explanations (2024-2025 Exam)
Rs. 650.00 -OR-
3 Year Validity (Multiple Devices)
CoverageDetailsSample Explanation
Help me Choose & Register (Watch Video) Already Subscribed?
Question 1
Question MCQ▾
A subschema expresses is a ________.
Choices
Choice (4) | Response | |
---|---|---|
a. | The external view | |
b. | The logical view | |
c. | The physical view | |
d. | None of the above |
Question 2
Question MCQ▾
Conceptual design is a ________
Choices
Choice (4) | Response | |
---|---|---|
a. | Needs data volume and processing frequencies to determine the size of the database | |
b. | Involves modeling independent of the DBMS | |
c. | Is designing the relational model | |
d. | All of the above |
Question 3
Question MCQ▾
ODBC stands for ________.
Choices
Choice (4) | Response | |
---|---|---|
a. | Oracle Data Base Connectivity | |
b. | Open Data Base Connectivity | |
c. | Object Data Base Connectivity | |
d. | Oral Data Base Connectivity |
Question 4
Question MCQ▾
Why are I/O costs important in a DBMS?
Choices
Choice (4) | Response | |
---|---|---|
a. | increase in time | |
b. | increase in memory | |
c. | memory | |
d. | increase in speed |
Question 5
Question MCQ▾
AN automatic commit occurs under the following circumstances
Choices
Choice (4) | Response | |
---|---|---|
a. | When a DDL statement is issued | |
b. | When a DCL statement is issue | |
c. | Normal exit from SQL ⚹ Plus, with out any data being written into it or rolling back the transaction | |
d. | Question does not provide sufficient data or is vague |
Question 6
Question MCQ▾
The output of the following queries are
SELECT e. empno, e. ename, d. dept_name FROM emp e, dept d USING (dept_id) ;
SELECT e. empno, e. ename, d. dept_name FROM emp e JOIN dept d ON (e. dept_id = d. dept_id)
Choices
Choice (4) | Response | |
---|---|---|
a. | dissimilar | |
b. | similar | |
c. | USING and ON cannot be used in SQL queries | |
d. | All of the above |