ExamVeda
Login
Home

SQL for Database Construction - Database MCQ Questions and answers- Technical Aptitude

SQL for Database Construction(Database) mcq questions and answers with easy and logical explanations for various competitive examination, interview and entrance test. Database Mcq question are important for technical exam and interview. Page-3 section-1

21
The SQL MAKE TABLE command is used to construct tables, define columns, define column constraints and create relationships.
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board
22
SQL has a JOIN ON syntax that can be used to create inner joins and outer joins.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
23
Standard SQL-92 views are constructed from SQL SELECT statements that do not contain the GROUP BY clause.
Discuss
Answer & Solution
Answer: Option B
Solution:
Standard SQL-92 views are constructed using SQL SELECT statements, and they can include the GROUP BY clause.

The SQL-92 standard allows views to be created with complex SELECT statements, including those that use GROUP BY, JOINs, subqueries, and aggregate functions.

Therefore, the claim that views cannot contain the GROUP BY clause is incorrect according to the SQL-92 standard.
24
The SQL CHECK constraint is fully defined by the SQL-92 standard, and is consistently implemented by all DBMS vendors.
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board
25
SQL Server does not support the BEFORE trigger.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
26
A updatable view has its own data.
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board
27
The SQL DELETE statement is used to delete both the table structure and table data.
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board
28
Common types of SQL CHECK constraints include range checks and limiting columns values.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
29
If any required (NOT NULL) columns are missing from the view, the view cannot be used for inserting new data.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
30
When a foreign key column is created without a corresponding foreign key constraint, we have created a "casual relationship" between the two tables.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board