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

Home

Competitive Exams

Aptitude English Verbal Reasoning Non Verbal Reasoning General Knowledge(GK) General Science(GS) Data Interpretation(DI) Banking Awareness Current Affairs

Computer & Programming

Computer Fundamentals Networking SQL Database C Programming C++ Programming Java Python

Other Subjects

Commerce Management Law Political Science Psychology Agriculture

Exam Categories

SSC Exams Railway Exams All Exams

SSC Exams

SSC CGL SSC CHSL SSC MTS SSC CPO SSC GD SSC JHT SSC Selection Post SSC Stenographer SSC JE

Railway Exams

RRB ALP RRB Technician RRB Section Controller RRB JE RRB Paramedical RRB Group D

Popular Exams

SSC CGL SSC CHSL SSC MTS RRB Group D RRB ALP RRB Technician RRB Section Controller

Engineering Subjects

Computer Science Electronics & Communication Mechanical Engineering Civil Engineering Electrical Engineering

More Engineering

Chemical Engineering Automobile Engineering Biotechnology Mining Engineering Geological Engineering

Engineering Core

Engineering Mathematics Engineering Physics Engineering Chemistry Metallurgical Engineering

Computer Fundamentals

Computer Fundamentals Networking Database SQL MySQL

Programming

C Programming C++ Programming Java Python PHP JavaScript

Advanced

Artificial Intelligence Machine Learning Data Science Cloud Computing Hadoop IoT

Graduation & PG

Commerce Management Law Mass Communication Political Science Psychology

Resources

Current Affairs Interview Blog

When using the SQL INSERT statement:

A) rows can be modified according to criteria only. B) rows cannot be copied in mass from one table to another only. C) rows can be inserted into a table only one at a time only. D) rows can either be inserted into a table one at a time or in groups.

Discuss

Answer & Solution

Answer: Option D

No explanation is given for this question. Let's Discuss on Board

What is not an advantage of stored procedures?

A) Greater security B) SQL can be optimized C) Code sharing D) Increased network traffic

Discuss

Answer & Solution

Answer: Option D

No explanation is given for this question. Let's Discuss on Board

A reason for using an SQL view to hide columns is:

A) to simplify a result only. B) to prevent the display of sensitive data only. C) to accomplish both of the above. D) None of the above are reasons for using an SQL view.

Discuss

Answer & Solution

Answer: Option C

No explanation is given for this question. Let's Discuss on Board

Which of the following is an SQL trigger supported by Oracle?

A) BEFORE B) INSTEAD OF C) AFTER D) All of the above.

Discuss

Answer & Solution

Answer: Option D

No explanation is given for this question. Let's Discuss on Board

The SQL ALTER statement can be used to:

A) change the table structure. B) change the table data. C) add rows to the table. D) delete rows from the table.

Discuss

Answer & Solution

Answer: Option A

No explanation is given for this question. Let's Discuss on Board

What SQL structure is used to limit column values of a table?

A) The LIMIT constraint B) The CHECK constraint C) The VALUE constraint D) None of the above is correct.

Discuss

Answer & Solution

Answer: Option B

No explanation is given for this question. Let's Discuss on Board

Which is NOT one of the most common types of SQL CHECK constraints?

A) System date B) Range checks C) Lists of values D) Comparing one column value to another within the same table

Discuss

Answer & Solution

Answer: Option A

No explanation is given for this question. Let's Discuss on Board

What is an advantage of placing computations in SQL views?

A) To save users from having to write an expression. B) To ensure that the results are consistent. C) To accomplish both of the above. D) None of the above is correct - computations cannot be placed in a view.

Discuss

Answer & Solution

Answer: Option C

No explanation is given for this question. Let's Discuss on Board

Views constructed from SQL SELECT statements that conform to the SQL-92 standard may not contain:

A) GROUP BY B) WHERE C) ORDER BY D) FROM

Discuss

Answer & Solution

Answer: Option C

No explanation is given for this question. Let's Discuss on Board

The SQL statement used to create a view is CREATE VIEW.

A) True B) False

Discuss

Answer & Solution

Answer: Option A

No explanation is given for this question. Let's Discuss on Board

1 2 3 4