SQL-Basics-SET-1

Which of the following cannot be done using SQL?

• Insert records into a Database

• Retrieve data from a Database

• Delete records from a Database

• Update multiple tables of a Database

Answer explanation

We can update only a single table at a time using UPDATE. INSERT INTO is used to insert records, SELECT is used to retrieve data; DELETE is used to delete records.

Which of the following terms represents a COLUMN of a Database table?

• Attribute, Field

• Field, Record

• Tuple, Record

• Tuple, Attribute

Answer explanation

A Database table consists of columns and rows. These columns are known as Attributes and Fields, rows are known as Tuples and Records.

Which of the following terms represents a ROW of a Database table?

• Field, Record

• Attribute, Field

• Tuple, Attribute

• Tuple, Record

Answer explanation

A Database table is divided into several rows and columns. These Rows are known as Tuples and Records, Columns are known as Attributes and Fields.

RDBMS stands for _______

• Relative Database Management System

• Related Database Management System

• Relational Database Management System

• Relative Database Management System

Answer explanation

RDBMS stands for Relational Database Management System. RDBMS is the basis for SQL.

The data in RDBMS is stored in ______

• Database Object

• SQL Object

• SQL Server

• Database server

Answer explanation

The data in RDBMS is stored in database objects called tables, which is a collection of related data entries.

Which of the following is not true about tables?

• It is a Database Object

• It is a collection of irrelevant data entries

• It consists of Fields known as Columns

• It consists of Records known as Rows

Answer explanation

A table is a collection of related data entries and it consists of columns and rows.

Where the specific information about every record of a table is stored?

Answer explanation

A field is a column in a table that is designed to maintain information about every record in the table. A record which is also called as a row contains each individual entry that exists in a table.

What is a Record?

• A record is a Vertical entity

• A record is each individual entry that exists in a table

• A record is an entity that contains all information associated with the fields of a table

• A record is a column

Answer explanation

A record is a horizontal entity of a table. A column is a vertical entity in a table which contains information associated with all fields of a table.

SQL keywords are case sensitive

• True

• False

Answer explanation

SQL keywords are NOT case sensitive.
“SELECT FROM table_name;” is same as “select from table_name;”. Both upper and lower case letters can be used in SQL.

Which character is used to separate SQL statements in database systems?

• : (colon)

• ; (Semi-colon)

• _ (underscore)

• % (percentage)

Answer explanation

A SQL statement begins with a SQL keyword and ends with a semicolon. Using semicolon is the standard way to separate each SQL statement in database systems.