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(Computer Science ) Questions and Answers
Home
Topic
Computer Science
Sql
Question 1.
Which of the following SQL query is correct for selecting the name of staffs from 'staffinfo' table where salary is 10,000 or 25,000?
SELECT name FROM staffinfo WHERE salary BETWEEN 10000 AND 25000;
SELECT name FROM staffinfo WHERE salary IN (10000, 25000);
Both A and B
None of the above
Explanation:-
Answer: Option B. ->
SELECT name FROM staffinfo WHERE salary IN (10000, 25000);
Question 2.
Select the right statement to insert values to the student table.
INSERT student VALUES (
INSERT VALUES (
INSERT INTO student VALUES (
INSERT VALUES INTO student (
Explanation:-
Answer: Option C. ->
INSERT INTO student VALUES (
Question 3.
............. joins two or more tables based on a specified column value not equaling a specified column value in another table.
EQUIJOIN
NON-EQUIJOIN
OUTER JOIN
NATURAL JOIN
Explanation:-
Answer: Option B. ->
NON-EQUIJOIN
Question 4.
In SQL, which command is used to change a table's storage characteristics?
ALTER TABLE
MODIFY TABLE
CHANGE TABLE
None of these
Explanation:-
Answer: Option A. ->
ALTER TABLE
Question 5.
In SQL, which of the following is not a data definition language commands?
REVOKE
RENAME
UPDATE
GRANT
Explanation:-
Answer: Option C. ->
UPDATE
Question 6.
'AS' clause is used in SQL for
Selection operation.
Rename operation.
Join operation.
Projection operation.
Explanation:-
Answer: Option B. ->
Rename operation.
Question 7.
Count function in SQL returns the number of
values.
distinct values.
groups.
columns.
Explanation:-
Answer: Option A. ->
values.
Question 8.
NULL is
the same as 0 for integer
the same as blank for character
the same as 0 for integer and blank for character
not a value
Explanation:-
Answer: Option D. ->
not a value
Question 9.
Which of the following is a valid SQL type?
CHARACTER
NUMERIC
FLOAT
All of the above
Explanation:-
Answer: Option D. ->
All of the above
Question 10.
What is the full form of SQL?
Structured Query Language
Structured Query List
Simple Query Language
None of these
Explanation:-
Answer: Option A. ->
Structured Query Language
1
2
3
4
5
6
7
...
10
11
Next →
One click Login
Login With Google
Old way of Login
Login With Email