Database Basics - Lecture 2

Which of the following is not a common data type in databases?

• Integer

• Float

• Boolean

• String

What does SQL stand for?

• Structured Query Language

• Simple Query Language

• Structured Question Language

• System Query Language

What is the primary key in a database table?

• A field that is used for sorting data

• A field that is always unique and identifies each record

• A field that contains text data

• A field that stores binary data

What is the primary purpose of the SQL SELECT statement?

• To update records in a table

• To delete records from a table

• To retrieve data from a database

• To insert new records into a table

Which SQL clause is used to specify the columns you want to retrieve in a SELECT statement?

• WHERE

• FROM

• SELECT

• HAVING

How many Primary keys can have in a table?

• 1. Only 1

• 1. Only 2

• 1. Depends on no of Columns

• 1. Depends on DBA

The ______ clause allows us to select only those rows in the result relation of the ____ clause that satisfy a specified predicate.

• Where, from

• From, select

• Select, from

• From, where

The ________ clause is used to list the attributes desired in the result of a query.

• Where

• Select

• From

• Distinct

In the given query which of the keyword has to be inserted?

INSERT INTO employee _____ (1002,Joey,2000);

• Table

• Values

• Relation

• Field

In an INSERT INTO statement, what does the following query do:

INSERT INTO customers (name, email) VALUES ('John Doe', '[e-mail]')?

• Inserts a new customer with the specified name and email into the "customers" table

• Updates an existing customer's email address

• Deletes a customer from the "customers" table

• Creates a new table named "customers"