SQL-Basics-SET-1

Front

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

Back

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.

Front

Which of the following terms represents a COLUMN of a Database table? Attribute, Field, Field, Record, Tuple, Record, Tuple, Attribute

Back

Attribute, Field

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.

Front

Which of the following terms represents a ROW of a Database table? Field, Record; Attribute, Field; Tuple, Attribute; Tuple, Record

Back

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.

Front

RDBMS stands for _______

Back

Relational Database Management System

Answer explanation

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

Front

The data in RDBMS is stored in ______

Back

Database Object

Answer explanation

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

Front

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

Back

It is a collection of irrelevant data entries

Answer explanation

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

Front

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

Back

fields

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.

Front

What is a Record?

Back

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

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.

Front

SQL keywords are case sensitive

Back

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.

Front

Which character is used to separate SQL statements in database systems? Options: : (colon), ; (Semi-colon), _ (underscore), % (percentage)

Back

; (Semi-colon)

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.