Home
10th Grade
11th And 12th
11th Grade
12th Grade
3rd Grade
4th Grade
5th Grade
6th Grade
7th Grade
8th Grade
9th Grade
Advance Accountancy
Auditing
Computer Aptitude
Direct And Indirect Taxation
Exams
General Hindi
Indian Finance System
Information Technology And Application In Business
Macro Economics
Town Planning
Aerospace And Aeronautical
Analytical Instrumentation
Banking Awareness
Banking Exam
Biochemistry
Bioinformatics
Biology
Biotechnology
Business Statistics
C Program
C Programming
C++ Programming
Career Aptitude Test
Cell Biology
Central Superior Service (css)
Chemical Engineering
Chemistry
Civil Engineering
Commerce
Computer
Computer Fundamentals
Computer Science
Cost Accounting
Css
Database
Drug And Pharmaceutical Biotechnology
Ecat And Mcat Entry Test
Economics
Electrical Engineering
Electrical Engineering Questions
Electrical Measurement And Instrumentation
Engineering
English
English Literature
Environment Management
Environmental Biotechnology
Enzyme Technology
Financial Management And Financial Markets
Gate
General Knowledge
Graduate Assessment Test (gat)
Health And Physical
Heat Transfer
Html
Human Anatomy And Physiology
Human And Cultural Diversity
Human Resource Management
Ias
Indian Economy
Indian Economy
Indian General Awareness
Indian Geography
Indian Geography
Indian History
Indian History
Indian Polity
Instrumentation Transducers
International Relations
Java Program
Javascript
Judiciary And Law
Life Sciences
Management
Marketing And Marketing Management
Mass Transfer
Mechanical Engineering
Mechanics Of Materials
Medical Subjects
Microbiology
Networking
Php
Placement Tests
Professional Communication
Quantitative Aptitude
Reasoning Aptitude
Renewable Energy
Science
Sociology
Sql
Surveying
Total Quality Management
Uidai Aadhaar Supervisor Certification
Virology
Notificatin
Exam
Blog
Contact Us
Sql For Database Construction(Computer Science > Database ) Questions and Answers
Home
Topic
Computer Science
Database
Sql For Database Construction
Question 1.
The SQL command to create a table is:
MAKE TABLE
ALTER TABLE
DEFINE TABLE
CREATE TABLE
Explanation:-
Answer: Option D. ->
CREATE TABLE
Question 2.
A ________ is a stored program that is attached to a table or a view.
pseudofile
embedded SELECT statement
trigger
None of the above is correct.
Explanation:-
Answer: Option C. ->
trigger
Question 3.
SQL views can be used to hide:
columns and rows only.
complicated SQL syntax only.
both of the above can be hidden by an SQL view.
None of the above is correct.
Explanation:-
Answer: Option C. ->
both of the above can be hidden by an SQL view.
Question 4.
The DROP TABLE statement:
deletes the table structure only.
deletes the table structure along with the table data.
works whether or not referential integrity constraints would be violated.
is not an SQL statement.
Explanation:-
Answer: Option B. ->
deletes the table structure along with the table data.
Question 5.
The SQL statement to create a view is:
CREATE VIEW
MAKE VIEW
SELECT VIEW
INSERT VIEW
Explanation:-
Answer: Option A. ->
CREATE VIEW
Question 6.
To update an SQL view, the DBMS must be able to associate the column(s) to be updated with:
a particular column in a particular underlying table.
a particular column in a particular row.
a particular row in a particular underlying table.
None of the above is correct.
Explanation:-
Answer: Option C. ->
a particular row in a particular underlying table.
Question 7.
Which of the following is NOT a type of SQL constraint?
PRIMARY KEY
FOREIGN KEY
ALTERNATE KEY
UNIQUE
Explanation:-
Answer: Option C. ->
ALTERNATE KEY
Question 8.
A ________ is a program that performs some common action on database data and that is stored in the database.
trigger
stored procedure
pseudofile
None of the above is correct.
Explanation:-
Answer: Option B. ->
stored procedure
Question 9.
For what purposes are views used?
To hide columns only
To hide rows only
To hide complicated SQL statements only
All of the above are uses for SQL views.
Explanation:-
Answer: Option D. ->
All of the above are uses for SQL views.
Question 10.
What is an SQL virtual table that is constructed from other tables?
Just another table
A view
A relation
Query results
Explanation:-
Answer: Option B. ->
A view
1
2
3
4
5
6
7
Next →
One click Login
Login With Google
Old way of Login
Login With Email