What is the purpose of *?

Selects ALL fields from the table

Selects only the first field in the table

Selects the last field in the table

Shows only the first row in the table

With SQL, how can you insert a new record into the "Persons" table?

INSERT INTO Persons VALUES ('Jimmy', 'Jackson')

INSERT ('Jimmy', 'Jackson') INTO Persons

INSERT VALUES ('Jimmy', 'Jackson') INTO Persons

INSERT VALUES ('Jimmy, Jackson') INTO Persons

INSERT ('Jimmy', 'Jackson') VALUES into Persons

SQL query to find all the cities whose humidity is 95.

SELECT city FROM weather WHERE humidity = 95

SELECT city WHERE humidity = 95

SELECT city FROM weather WHERE humidity = 95

SELECT humidity = 89 FROM weather

Rdbms Class 10 MCQ Questions With Answers Quiz

10.

With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"?

SELECT [all] FROM Persons WHERE FirstName LIKE 'Peter'

SELECT * FROM Persons WHERE FirstName='Peter'

SELECT * FROM Persons WHERE FirstName<>'Peter'

SELECT * FROM Persons WHERE FirstName=='Peter'

1.

What is the purpose of *?

2.

Less than or equal to?

3.

If you don’t specify ASC or DESC after a SQL ORDER BY clause, the following is used by default

4.

Which statement is used to extract data from a database?

5.

With SQL, how can you insert a new record into the "Persons" table?

6.

What is a primary key?

7.

The rows in a database are called:

8.

SQL query to find all the cities whose humidity is 95.

9.

Which of the following SQL clauses is used to DELETE tuples from a database table?

10.

With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"?

11.

A relational database developer refers to a record as

12.

What is full form of SQL

13.

Which word is missing from the following SQL statement?Select * table_name

14.

What is this following a definition of?Stores data/information in an organised way

Time

1. What is the purpose of *?

2. Less than or equal to?

3. If you don’t specify ASC or DESC after a SQL ORDER BY clause, the following is used by default

4. Which statement is used to extract data from a database?

5. With SQL, how can you insert a new record into the "Persons" table?

6. What is a primary key?

7. The rows in a database are called:

8. SQL query to find all the cities whose humidity is 95.

9. Which of the following SQL clauses is used to DELETE tuples from a database table?

10. With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"?

11. A relational database developer refers to a record as

12. What is full form of SQL

13. Which word is missing from the following SQL statement?Select * table_name

14. What is this following a definition of?Stores data/information in an organised way

Time

Report Question

Support mcqmojo.com by disabling your adblocker.

1.

What is the purpose of *?

2.

Less than or equal to?

3.

If you don’t specify ASC or DESC after a SQL ORDER BY clause, the following is used by default

4.

Which statement is used to extract data from a database?

5.

With SQL, how can you insert a new record into the "Persons" table?

6.

What is a primary key?

7.

The rows in a database are called:

8.

SQL query to find all the cities whose humidity is 95.

9.

Which of the following SQL clauses is used to DELETE tuples from a database table?

10.

With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"?

11.

A relational database developer refers to a record as

12.

What is full form of SQL

13.

Which word is missing from the following SQL statement?Select * table_name

14.

What is this following a definition of?Stores data/information in an organised way