| Snaprecruit.com
| Snaprecruit.com
JOBSEEKERS
Login
Sign Up
Jobseeker
Employer
Staffing
Enterprises
Interview question based on skill :
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