Toggle navigation
Test.Brainkart.com
Home
GATE Exam
TN School
College Entrance Exam
IIT JEE
NEET
AIIMS
CAT
CLAT
TANCET
10th & 12th
11th Std
12th Std
10th Std
Job Entrance Exam
BANK
UGC NET
TNPSC
Chapter 15: Data manipulation through SQL
- Online Test
Chapter 15: Data manipulation through SQL
TEST : 1
TN State Board
TN 12th Standard
Computer Science
Chapter 15: Data manipulation through SQL
Prepare / Learn
Q1.
Which of the following is an organized collection of data?
A.
Database
B.
DBMS
C.
Information
D.
Records
View Solution
Add Work Space
Answer :
Option A
Explaination / Solution:
No Explaination.
TN State Board
TN 12th Standard
Computer Science
Chapter 15: Data manipulation through SQL
Prepare / Learn
Q2.
SQLite falls under which database system?
A.
Flat file database system
B.
Relational Database system
C.
Hierarchical database system
D.
Object oriented Database system
View Solution
Add Work Space
Answer :
Option B
Explaination / Solution:
No Explaination.
TN State Board
TN 12th Standard
Computer Science
Chapter 15: Data manipulation through SQL
Prepare / Learn
Q3.
Which of the following is a control structure used to traverse and fetch the records of the database?
A.
Pointer
B.
Key
C.
Cursor
D.
Insertion point
View Solution
Add Work Space
Answer :
Option C
Explaination / Solution:
No Explaination.
TN State Board
TN 12th Standard
Computer Science
Chapter 15: Data manipulation through SQL
Prepare / Learn
Q4.
Any changes made in the values of the record should be saved by the command
A.
Save
B.
Save As
C.
Commit
D.
Oblige
View Solution
Add Work Space
Answer :
Option C
Explaination / Solution:
No Explaination.
TN State Board
TN 12th Standard
Computer Science
Chapter 15: Data manipulation through SQL
Prepare / Learn
Q5.
Which of the following executes the SQL command to perform some action?
A.
Execute()
B.
Key()
C.
Cursor()
D.
run()
View Solution
Add Work Space
Answer :
Option A
Explaination / Solution:
No Explaination.
TN State Board
TN 12th Standard
Computer Science
Chapter 15: Data manipulation through SQL
Prepare / Learn
Q6.
Which of the following function retrieves the average of a selected column of rows in a table?
A.
Add()
B.
SUM()
C.
AVG()
D.
AVERAGE()
View Solution
Add Work Space
Answer :
Option C
Explaination / Solution:
No Explaination.
TN State Board
TN 12th Standard
Computer Science
Chapter 15: Data manipulation through SQL
Prepare / Learn
Q7.
The function that returns the largest value of the selected column is
A.
MAX()
B.
LARGE()
C.
HIGH()
D.
MAXIMUM()
View Solution
Add Work Space
Answer :
Option A
Explaination / Solution:
No Explaination.
TN State Board
TN 12th Standard
Computer Science
Chapter 15: Data manipulation through SQL
Prepare / Learn
Q8.
Which of the following is called the master table?
A.
sqlite_master
B.
sql_master
C.
main_master
D.
master_main
View Solution
Add Work Space
Answer :
Option B
Explaination / Solution:
No Explaination.
TN State Board
TN 12th Standard
Computer Science
Chapter 15: Data manipulation through SQL
Prepare / Learn
Q9.
The most commonly used statement in SQL is
A.
cursor
B.
select
C.
execute
D.
commit
View Solution
Add Work Space
Answer :
Option B
Explaination / Solution:
No Explaination.
TN State Board
TN 12th Standard
Computer Science
Chapter 15: Data manipulation through SQL
Prepare / Learn
Q10.
Which of the following clause avoide the duplicate?
A.
Distinct
B.
Remove
C.
Where
D.
GroupBy
View Solution
Add Work Space
Answer :
Option A
Explaination / Solution:
No Explaination.
Submit My Answer
Total Question/Mark :
Scored Mark :
Mark for Correct Answer : 1 Mark for Wrong Answer : -0.5 Mark for Left Answer : 0
Save and Share My Score
REDO THIS TEST AGAIN : ( TEST 1 )
START NEXT : ( TEST 2 )
Chapter 15: Data manipulation through SQL
TEST : 1
Chapter 15: Data manipulation through SQL
| Online Objective Test |
Start Test
TN State Board : TN 12th Standard (Computer Science)
| Online Objective Test
Start Test
Chapter 1: Function
| Online 1 Mark Objective Test
Start Test
Chapter 2: Data Abstraction
| Online 1 Mark Objective Test
Start Test
Chapter 3: Scoping
| Online 1 Mark Objective Test
Start Test
Chapter 4: Algorithmic Strategies
| Online 1 Mark Objective Test
Start Test
Chapter 5: Python- Variables and Operators
| Online 1 Mark Objective Test
Start Test
Chapter 6: Control Structures
| Online 1 Mark Objective Test
Start Test
Chapter 7: Python functions
| Online 1 Mark Objective Test
Start Test
Chapter 8: Strings and String manipulations
| Online 1 Mark Objective Test
Start Test
Chapter 9: Lists, Tuples, Sets and Dictionary
| Online 1 Mark Objective Test
Start Test
Chapter 10: Python Classes and objects
| Online 1 Mark Objective Test
Start Test
Chapter 11: Database Concepts
| Online 1 Mark Objective Test
Start Test
Chapter 12: Structured Query Language (SQL)
| Online 1 Mark Objective Test
Start Test
Chapter 13: Python and CSV files
| Online 1 Mark Objective Test
Start Test
Chapter 14: Importing C++ programs in Python
| Online 1 Mark Objective Test
Start Test
Chapter 15: Data manipulation through SQL
| Online 1 Mark Objective Test
Start Test
Chapter 16: Data visualization using pyplot
| Online 1 Mark Objective Test
Start Test
Prepare Before Start Test
| Learn
Engineering
| prepare/Learn
Medical
| prepare/Learn
TN School (10th & 12th )
| prepare/Learn
NEET, JEE
| prepare/Learn
TNPSC Exam
| prepare/Learn
UPSC Civil services Entrance exams
| Online Test
General Studies test
| Start Online Test
Civil Services Aptitude Test (CSAT)
| Start Online Test
Interview and Personality Test
| Start Online Test
GATE Exam
| Online Test
EE Electrical Engineering
| Start Online Test
EC Electronics and Communication Engineering
| Start Online Test
CS Computer Science and Information Technology
| Start Online Test
CE Civil Engineering
| Start Online Test
ME Mechanical Engineering
| Start Online Test
Under Graduate Entrance Exams
| Online Test
IIT JEE IEEE Entrance Exam
| Start Online Test
NEET Entrance Exam
| Start Online Test
AIIMS Entrance Exams
| Start Online Test
Problem Solving and Reasoning
| Online Test
Verbal and Reading Comprehension
| Start Online Test
Data Interpretation and Logical Reasoning
| Start Online Test
Mathematics or Quantitative Aptitude
| Start Online Test
CAT Entrance Exams
| Online Test
Mathematics or Quantitative Aptitude
| Start Online Test
Data Interpretation and Logical Reasoning
| Start Online Test
Verbal and Reading Comprehension
| Start Online Test
CLAT LAW Entrance exams
| Online Test
English including comprehension
| Start Online Test
General Knowledge and Current Affairs
| Start Online Test
Elementary Mathematics
| Start Online Test
Logical and Legal Reasoning Aptitude
| Start Online Test
Banking Entrance exams
| Online Test
Bank PO
| Start Online Test
Bank Clerks
| Start Online Test
Specialist Officers (SO)
| Start Online Test
UGC NET Entrance exams
| Online Test
Science
| Start Online Test
Language
| Start Online Test
TANCET Anna University
| Online Test
EEE Electrical and Electronics Engineering
| Start Online Test
ECE Electronics and Communication Engineering
| Start Online Test
CSE, IT Computer Science Engineering and Information Technology
| Start Online Test
Civil Engineering
| Start Online Test
Mechanical Engineering
| Start Online Test
TN State Board
| Online Test
TN 11th Standard
| Start Online Test
TN 12th Standard
| Start Online Test
TN 10th Standard
| Start Online Test