SQL Keywords

The primary key of a table which is present in another table for referencing is known as ________________________

The command which changes the structure of a table is _____________________

Which is not an aggregate function?

• SUM()

• POW()

• AVG()

• COUNT()

A ______________ is a computerized record keeping that enables you to create, modify, store, and extract information from a database.

• Data Bin Management System

• Data Base Management Server

• Data Base Management System

A ____________ refers to the data files that contains records, which have a small, fixed number of fields, without any structured relationship.

• Flat file database

• Relational database

Which of the following is not an example of relational database?

• Oracle

• MS Access

• MS Excel

• MS SQL

A database stores a vast amount of data, but _____________ helps us to retrieve the filtered data based upon some conditions.

• forms

• reports

• queries

______________ is the most popular and powerful Relational Database Management System(RDBMS) that serves as an integral part of the MS Office Suite Application.

• MS Word

• MS Excel

• MS Access

• MS OneDrive

Which statement is used to extract data from a database?

• Extract

• Get

• Open

• Select

If you were wanting to filter data, which clause would you use?

• Where

• Order by

• From

• Select