Database Modeling and Design MCQs with Answers
Practice important Database Modeling and Design MCQs with answers and explanations.
Multiple Choice Questions
Q281: In a Self-Join, what is a common use case?
- A: Comparing rows in a table with rows in another table
- B: Combining data from two unrelated tables
- C: Comparing values in the same column of a table
- D: None of the above
View Answer
C
Q282: What is a view in SQL?
- A: A virtual table created by a query
- B: A physical table with its own data
- C: A stored procedure that updates data
- D: A function that calculates values
View Answer
A
Q283: What does a view in SQL derive its data from?
- A: Views themselves
- B: Base tables
- C: Indexes
- D: Sequences
View Answer
B
Q284: What is the purpose of using a SQL view?
- A: To create new tables
- B: To summarize data from various tables
- C: To store data permanently
- D: To index tables
View Answer
B
Q285: What is the correct syntax to create a view in SQL?
- A: CREATE VIEW view_name AS SELECT columns FROM tables WHERE conditions;
- B: CREATE TABLE view_name AS SELECT columns FROM tables WHERE conditions;
- C: CREATE VIEW view_name SELECT columns FROM tables WHERE conditions;
- D: CREATE VIEW view_name AS INSERT INTO tables (columns);
View Answer
A
Q286: How do you access data from a SQL view?
- A: By querying the view as if it were a table
- B: By directly updating the base tables
- C: By modifying the SQL syntax used to create the view
- D: By using a different database schema
View Answer
A
Q287: What does the WITH CHECK OPTION clause ensure in a view?
- A: That INSERT and UPDATE statements comply with the view’s constraints
- B: That the view can be queried without conditions
- C: That the view’s data is stored in a separate table
- D: That the view automatically updates the base tables
View Answer
A
Q288: What will happen if you attempt to insert data into a view with a CHECK OPTION that does not meet the view's criteria?
- A: The insertion will succeed and the view will update
- B: The insertion will fail and an error will be returned
- C: The insertion will succeed but the data will be ignored
- D: The insertion will automatically correct the data
View Answer
B
Q289: Which SQL statement will successfully insert a row into the ACCOUNTS_STAFF view?
- A: INSERT INTO Accounts_staff VALUES (110, 'ASHI', 10);
- B: INSERT INTO Accounts_staff VALUES (111, 'SAMI', 30);
- C: INSERT INTO Accounts_staff VALUES (112, 'ALI', 20);
- D: INSERT INTO Accounts_staff VALUES (113, 'KASHIF', 40);
View Answer
A
Q290: What is the purpose of a data dictionary in Oracle databases?
- A: To provide a read-only set of tables with information about the database
- B: To store user passwords and access levels
- C: To create and modify database tables and views
- D: To directly access and modify the database schema
View Answer
A