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
Introduction To Sql(Database ) Questions and Answers
Home
Topic
Database
Introduction To Sql
Question 1.
You can add a row using SQL in a database with which of the following?
ADD
CREATE
INSERT
MAKE
Explanation:-
Answer: Option C. ->
INSERT
Question 2.
The wildcard in a WHERE clause is useful when?
An exact match is necessary in a SELECT statement.
An exact match is not possible in a SELECT statement.
An exact match is necessary in a CREATE statement.
An exact match is not possible in a CREATE statement.
Explanation:-
Answer: Option B. ->
An exact match is not possible in a SELECT statement.
Question 3.
Which of the following is the original purpose of SQL?
To specify the syntax and semantics of SQL data definition language
To specify the syntax and semantics of SQL manipulation language
To define the data structures
All of the above
Explanation:-
Answer: Option D. ->
All of the above
Question 4.
The SQL WHERE clause:
limits the column data that are returned.
limits the row data are returned.
Both A and B are correct.
Neither A nor B are correct.
Explanation:-
Answer: Option B. ->
limits the row data are returned.
Question 5.
The command to remove rows from a table 'CUSTOMER' is:
REMOVE FROM CUSTOMER ...
DROP FROM CUSTOMER ...
DELETE FROM CUSTOMER WHERE ...
UPDATE FROM CUSTOMER ...
Explanation:-
Answer: Option C. ->
DELETE FROM CUSTOMER WHERE ...
Question 6.
Which of the following do you need to consider when you make a table in SQL?
Data types
Primary keys
Default values
All of the above
Explanation:-
Answer: Option D. ->
All of the above
Question 7.
SQL query and modification commands make up a(n) ________ .
DDL
DML
HTML
XML
Explanation:-
Answer: Option B. ->
DML
Question 8.
The Microsoft Access wildcards are ____ and ____ .
asterisk (*); percent sign (%)
percent sign (%); underscore (_)
underscore(_); question mark (?)
question mark (?); asterisk (*)
Explanation:-
Answer: Option D. ->
question mark (?); asterisk (*)
Question 9.
When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s):
LIKE only.
IN only.
NOT IN only.
Both IN and NOT IN.
Explanation:-
Answer: Option D. ->
Both IN and NOT IN.
Question 10.
Find the SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = 'VA';
SELECT NAME IN CUSTOMER WHERE STATE IN ('VA');
SELECT NAME IN CUSTOMER WHERE STATE = 'VA';
SELECT NAME IN CUSTOMER WHERE STATE = 'V';
SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA');
Explanation:-
Answer: Option D. ->
SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA');
1
2
3
4
5
6
7
Next →
One click Login
Login With Google
Old way of Login
Login With Email