SQL Online TestTime limit: 0 Quiz-summary0 of 20 questions completed Questions:
InformationSQL Online Practice Test for Database Developers, Database Testers and Database Administrators. Structured Query Language Fundamentals, Data Definition Language, Database Manipulation Language, Database Control Language, SQL Data Types, SQL Operators and SQL Functions. You have already completed the quiz before. Hence you can not start it again. Quiz is loading... You must sign in or sign up to start the quiz. You have to finish following quiz, to start this quiz: Results0 of 20 questions answered correctly Your time: Time has elapsed You have reached 0 of 0 points, (0) Categories
|
SQL Online Practice Test
1) SQL (Structured Query Language) was initially developed at……
a) Micro Soft
b) Oracle
c) IBM
d) HP
2) SQL is not used for……
a) Create New Databases
b) Create New Tables in a Database
c) Join Tables to Retrieve data
d) Join Databases
3) Which is not a subset of SQL?
a) Data Definition Language
b) PL/SQL
c) Data Manipulation Language
d) Data Control Language
4) ……is not a SQL – Data Definition Language Command
a) Insert
b) Create
c) Rename
d) Truncate
5) ……is not a SQL – Data Manipulation Language Command
a) Select
b) Insert
c) Update
d) Alter
6) ……is not a SQL – Data Control Language Command
a) Drop
b) Grant
c) Revoke
d) Deny
7) The Result of a SQL SELECT statement is a(n) ……
a) Report
b) Form
c) File
d) Table
8) Which one of the following sorts rows in SQL?
a) SORT BY
b) ALIGN BY
c) ORDER BY
d) GROUP BY
9) Which of the following SQL Command is used to DELETE data from a database table?
a) CLEAR
b) DROP DATA
c) DELETE
d) REMOVE
10) Database Table rows are also known as……
a) Fields
b) Attributes
c) Records
d) Elements
11) Which SQL keyword is used to specify conditional search?
a) SELECT
b) SEARCH
c) WHERE
d) FIND
12) Which SQL keyword is used to retrieve a minimum value?
a) LOW
b) LOWER
c) MIN
d) DOWN
13) Can we use both HAVING and WHERE SQL clauses in one SQL statement?
a) Yes.
b) No.
14) The LIKE SQL keyword is used along with …..
a) JOIN clause.
b) WHERE clause.
c) ORDER BY clause.
d) GROUP BY clause.
15) Which SQL statement is used to insert new data in a database?
a) ADD RECORD
b) INSERT NEW
c) INSERT INTO
d) ADD NEW
16) SQL statements are case sensitive.
a) True
b) False
17) Null is a blank space.
a) True
b) False
18) Which of the following is not a SQL aggregate function?
a) SUM
b) AVG
c) MOD
d) MAX
19) A table can have more than one primary key column.
a) True
b) False
20) SQL – Data manipulation language statements access and manipulate data in existing schema objects.
a) True
b) False
Structured Query Language Fundamentals, SQL – Data Definition Language, Data Manipulation Language, Data Control Language, SQL Syntax, SQL Data Types, SQL Operators and SQL Functions.
SQL is for Database Developers, Database Testers and Database Administrators.
SQL Data Definition Language is mainly used by Database Developers, Data Manipulation Language by Database Testers and Data Control Language by Database Administrators. Using SQL Commands Software Testers conduct Database Testing Manually as well as Automated.
Follow me on social media: