SQL

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’);