Toggle navigation
Terms & Conditions
Contact
Home
GK
Computer
TRB
TNPSC
Aptitude
English
Reasoning
Technical
Bank Exams
SSC
Engineering
Puzzles
Interview
GD Topics
Blogs
Online Test
Free computer quiz Online Test - MeritNotes
Home
Online Exam
No. of Questions :10
Remaining Time :
1. SQL data definition commands make up a(n)
(a)
HTML
(b)
DML
(c)
DDL
(d)
XML
2. Second normal form should meet all the rules for
(a)
1 NF
(b)
3 NF
(c)
4 NF
(d)
5 NF
3. The SQL statement that queries or reads data from a table is
(a)
READ
(b)
SELECT
(c)
ORDER
(d)
QUERY
4. In the _____ normal form, a composite attribute is converted to individual attributes.
(a)
1
st
(b)
2
nd
(c)
3
rd
(d)
4
th
5. The primary key is selected from the
(a)
Determinants
(b)
Candidate keys
(c)
Composite keys
(d)
Foreign keys
6. The command to eliminate a table from a database is
(a)
DELETE TABLE CUSTOMER
(b)
UPDATE TABLE CUSTOMER
(c)
DROP TABLE CUSTOMER
(d)
REMOVE TABLE CUSTOMER
7. SQL can be used to
(a)
Create database structures only
(b)
Query database data only
(c)
Modify database data only
(d)
All of the above can be done by SQL
8. The result of a SQL SELECT statement is a(n)
(a)
File
(b)
Report
(c)
Form
(d)
Table
9. SQL query and modification commands make up a(n)
(a)
DDL
(b)
HTML
(c)
XML
(d)
DML
10. A relation is in this form if it is in BCNF and has no multivalued dependencies.
(a)
Second normal form
(b)
Third normal form
(c)
Fourth normal form
(d)
Domain/key normal form
