SQL
|
|
Which is not used into SQL
=,<>,> ,<,>=,<=,>>>
1. all are used
2. only >>> not used
3. only <>
4. None
Which is not used into SQL
=,<>,> ,<,>=,<=,>>>
1. all are used
2. only >>> not used
3. only <>
4. None
2. only >>> not used answer is 2. only>>> not used
| More interview questions and answers |
SQL stands Structured Query Language?
1. true
2. false
|
1. true | 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
|
2 SQL can delete or update or retrieve or create records from a database | 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. |
1 | 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. |
1. used to select all records from table | SELECT * FROM r4r_emp;
Above is part of DML in SQL?
1. true
2. false
3. no such query into sql.
4. None.
|
false
| 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.
|
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
|
2. Select All records with different values only | 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
|
1. Select all records including with duplicate values | 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
|
4. select all records whose has office is ‘Lucknow’ from r4r_team table | 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
|
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
|
Error | Which is not used into SQL
=,<>,> ,<,>=,<=,>>>
1. all are used
2. only >>> not used
3. only <>
4. None
|
2. only >>> not used | <> 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.
|
1. true | 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
|
4.1,2,3 | 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 |
1.These are Operators .Which are used to filter records based on more than one conditions | 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
|
1.Used to select username,exp, salary from r4r_team which is decreasing order by username. | 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’);
|
1. INSERT INTO r4r_team (id, username, exp) VALUES (1, ‘r4r01’, ‘2’);
2. INSERT INTO r4r_team VALUES (1, ‘r4r01’, ‘2’);
|
Which is not used into SQL
=,<>,> ,<,>=,<=,>>>
1. all are used
2. only >>> not used
3. only <>
4. None
|
|
|
