Prepare
Practice
Interview
Aptitude
Reasoning
English
GD
Placement
HR
Current affairs
Engineering
MCA
MBA
Online Test
Videos
Login
DBMS online test, online practice test, exam, quiz
Online Practice Test
>
DBMS
DBMS Online Test
The purpose of this online test is to help you evaluate your DBMS knowledge yourself. These Multiple Choice Questions (MCQs) on DBMS will prepare you for technical round of job interview, written test and many certification exams.
The test contains 20 questions and there is no time limit. You will get 1 point for each correct answer. You will get your online test score after finishing the complete test.
(Total
20
questions)
(Time spent
0:0
)
1. To create a PRIMARY KEY constraint on existing table “EMPLOYEE” on "EMPID" column and currently column does not contain any value , which is the correct SQL syntax from the following
Alter table EMPLOYEE Add Constraint PK-EMPID Primary Key, EMPID;
Update table EMPLOYEE Add Constraint PK-EMPID Primary Key (EMPID);
Alter table EMPLOYEE Add Constraint PK-EMPID Primary Key (EMPID);
Alter table EMPLOYEE Add Constraint PK-EMPID Primary Key, (EMPID);
View Test Answer
Online Practice Test
SQL Server (40)
SQL Server (28)
SQL Server (25)
Data Warehousing (10)
Biztalk (15)
SQL Server DBA (15)
Database (30)
Database (28)
DBMS (20)
MCQs
English
Tutorials
Download
Advertisement
▲