Why do you pin an item in list?

A. To mark it to delete from list

B. To move it up and make it always available

C. To make it default database when you open Access

D. None of above

Answer: Option B

1

Which of the following is a NoSQL database?

A. MySQL

B. MongoDB

C. PostgreSQL

D. Oracle

2

What does the SQL 'TRUNCATE' command do?

A. Deletes all rows from a table without logging individual row deletions

B. Deletes only duplicate records

C. Removes table structure

D. Backs up the table

3

Which SQL clause is used to filter records based on conditions?

A. GROUP BY

B. ORDER BY

C. HAVING

D. WHERE

4

Which SQL clause is used to aggregate rows based on a condition?

A. ORDER BY

B. GROUP BY

C. HAVING

D. FILTER

5

Which SQL keyword is used to remove duplicate records in a SELECT query?

A. DISTINCT

B. UNIQUE

C. REMOVE

D. EXCLUDE

Why do you pin an item in list?

1

Which of the following is a NoSQL database?

2

What does the SQL 'TRUNCATE' command do?

3

Which SQL clause is used to filter records based on conditions?

4

Which SQL clause is used to aggregate rows based on a condition?

5

Which SQL keyword is used to remove duplicate records in a SELECT query?

Categories

Random Posts

About

Important Link

Company

Others

Social Media

Why do you pin an item in list?

1 Which of the following is a NoSQL database?

2 What does the SQL 'TRUNCATE' command do?

3 Which SQL clause is used to filter records based on conditions?

4 Which SQL clause is used to aggregate rows based on a condition?

5 Which SQL keyword is used to remove duplicate records in a SELECT query?

Categories

Random Posts

Social Media

1

Which of the following is a NoSQL database?

2

What does the SQL 'TRUNCATE' command do?

3

Which SQL clause is used to filter records based on conditions?

4

Which SQL clause is used to aggregate rows based on a condition?

5

Which SQL keyword is used to remove duplicate records in a SELECT query?