JOBSEEKERS
Login
Sign Up
Jobseeker
Employer
Staffing Firm
Direct Client
SQL interview questions
SQL interview questions
Back
Take as many assements as you can to improve your validate your skill rating
Total Questions: 4
1. What command can be used to create a new row in a table in the database?
A. ADD
B. CREATE
C. NEW
D. INSERT (*)
Show Correct Answer
Correct Answer is :
INSERT (*)
2. What command is used to permanently remove a record from a database table?
A. DROP
B. REMOVE
C. DELETE
D. CUT
Show Correct Answer
Correct Answer is :
DROP
3. Which of the following SQL statements will generate an error when executed.
A. CREATE DATABASE students
B. CREATE DATABASE students;
C. create database if not exists students
D. IF NOT EXISTS CREATE DATABASE `STUDENTS`;
Show Correct Answer
Correct Answer is :
IF NOT EXISTS CREATE DATABASE `STUDENTS`;
4. What is a composite key?
A. its is a key that is defined as the primary key in another table
B. it is a key that uniquely identifies a record in a database
C. its is an optional key and allows null values
D. it is a primary key that consists of more than one field that uniquely identifies a record
Show Correct Answer
Correct Answer is :
it is a primary key that consists of more than one field that uniquely identifies a record
Similar Interview Questions
Search for latest jobs
Find Jobs