SQL Queries Introduction

What is a ‘tuple’?

• A row or record in a database table

• Another name for the key linking different tables in a database.

• An attribute attached to a record.

• Another name for a table in an RDBMS.

The command to remove rows from a table ‘CUSTOMER’ is:

• REMOVE FROM CUSTOMER …

• DROP FROM CUSTOMER …

• DELETE FROM CUSTOMER WHERE …

• UPDATE FROM CUSTOMER …

The command to eliminate a table from a database is:

• REMOVE TABLE CUSTOMER;

• DROP TABLE CUSTOMER;

• DELETE TABLE CUSTOMER;

• UPDATE TABLE CUSTOMER;

With SQL, how do you select all the columns from a table named "Persons"?

• SELECT [all] FROM Persons

• SELECT Persons

• SELECT * FROM Persons

• SELECT *.Persons

With SQL, how can you insert a new record into the "Persons" table?

• INSERT ('Jimmy', 'Jackson') INTO Persons

• INSERT VALUES ('Jimmy', 'Jackson') INTO Persons

• INSERT INTO Persons VALUES ('Jimmy', 'Jackson')

The NOT NULL constraint enforces a column to not accept empty values.

Next ❯

• TRUE

• FALSE

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

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

• Table

• Values

• Relation

• Field

CREATE TABLE employee (id INTEGER,name VARCHAR(20),salary NOT NULL);

INSERT INTO employee VALUES (1005,Rach,0);

INSERT INTO employee VALUES (1007,Ross, );

INSERT INTO employee VALUES (1002,Joey,335);

Some of these insert statements will produce an error. Identify the statement.

• Insert into employee values (1005,Rach,0);

• Insert into employee values (1002,Joey,335);

• Insert into employee values (1007,Ross, );

• None of the mentioned

What does "SQL" stand for?

• Structured Question Language

• Structured Query Language

• Simple Query Language

• Simple Question Language

DDL means