SQL
|
SELECT * FROM r4r_emp;
Above is part of DML in SQL?
1. true
2. false
3. no such query into sql.
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.
false
1. true True
1st Choice
true
False, because DMS statement is Insert, update, delete
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’);
|
SELECT * FROM r4r_emp;
Above is part of DML in SQL?
1. true
2. false
3. no such query into sql.
4. None.
|
|
|