SQL

SQL Objective Questions and Answers

More interview questions and answers

SQL stands Structured Query Language? 1. true 2. false

Choose correct answers: 1 SQL can execute system applications like java ,c# . 2 SQL can delete or update or retrieve or create records from a database 3.SQL never permanently change database recodes . 4 All 5 None

Choose correct options 1. MS Access, SQL Server, MySQL are database 2. MS Access, SQL Server, MySQL are vendor company. 3 MS Access, SQL Server, MySQL are programming language 4. All 5. None.

Choose correct statements for fallowing sql statement SELECT * FROM r4r_emp; 1. used to select all records from table 2. used to select all columns name from table 3. used to select all rows from tables 4. None.

SELECT * FROM r4r_emp; Above is part of DML in SQL? 1. true 2. false 3. no such query into sql. 4. None.

DDL statements in SQL are: 1.SELECT,UPDATE, DELETE,ALTER , CREATE, ALTER , DROP 2.SELECT, DELETE,ALTER , CREATE, ALTER , DROP 3.SELECT,ALTER , CREATE, ALTER , DROP 4 None.

SELECT DISTINCT column_name(s) FROM table_name is used for: 1. Select all records including NULL values 2. Select All records with different values only. 3. Select no any records. 4. None

SELECT * column_name(s) FROM table_name is used for: 1. Select all records including with duplicate values 2. Select All records with different values only. 3. Select no any records. 4. None

SELECT * FROM r4r_team WHERE office=’Lucknow’ is used for: 1. Select all records including with duplicate values from r4r_team table. 2. Select All records with different values only from r4r_team table. 3. Select no any records. 4. select all records whose has office is ‘Lucknow’ from r4r_team table 5. None

SELECT * FROM r4r_team WHERE office=Lucknow is used for: 1. Select all records including with duplicate values from r4r_team table. 2. Select All records with different values only from r4r_team table. 3. Select no any records. 4. select all records whose has office is ‘Lucknow’ from r4r_team table 5. Error

SELECT * FROM r4r_team WHERE exp='2' is used for: 1. Select all records including with duplicate values from r4r_team table. 2. Select All records with different values only from r4r_team table. 3. Select no any records. 4. select all records whose has office is ‘2' from r4r_team table 5. Error

Which is not used into SQL =,<>,> ,<,>=,<=,>>> 1. all are used 2. only >>> not used 3. only <> 4. None

<> and != both are same operator into SQL 1. true. 2 false. 3. both are not used into SQL. 4. Both are used assembly languages only.

Choose true option 1. BETWEEN -->>Used for range with in values 2. LIKE -->>Used for Search a pattern 3. IN -->>return east one of the columns in given set of values 4.1,2,3 5. None

Which is true for AND & OR 1.These are Operators .Which are used to filter records based on more than one conditions. 2.These Operators are used to join two tables. 3.Never used in SQL 4.None

What is true for following DML SQL statement SELECT username, exp, salary FROM r4r_team ORDER BY username DESC; 1.Used to select username,exp, salary from r4r_team which is decreasing order by username. 2.Used to select username,exp, salary from r4r_team which is increasing order by username. 3.Used to select username,exp, salary from r4r_team which is decreasing order by exp. 4. None

Choose correct syntax to insert values into r4r_team table 1. INSERT INTO r4r_team (id, username, exp) VALUES (1, ‘r4r01’, ‘2’); 2. INSERT INTO r4r_team VALUES (1, ‘r4r01’, ‘2’); 3. INSERT INTO r4r_team (id, username, exp) VALUE (1, ‘r4r01’, ‘2’); 4. INSERT INTO table r4r_team (id, username, exp) VALUE (1, ‘r4r01’, ‘2’);

SQL Objective Questions and Answers