MySQL

A relational database can have how many types of keys in a table ?

• Candidate key

• Primary key

• Foreign key

• All of these

Which one of the following uniquely identifies the tuples/tows in a relation ?

• Secondary key

• Primary key

• Composite key

• Foreign key

What is the full form of DDL ?

• Dynamic data language

• Detailed data language

• Data definition language

• Data derivation language

SELECT is a DDL/DML command ....

• DDL

• DML

• None of these

• Both

Which of the following keywords will you use to display unique values of the column dept_name ?

SELECT ______ dept_name from COMPANY;

• All

• distinct

• from

• name

Which of the following SQL commands retrieves data from table(s)?

• update

• select

• insert

• delete

INSERT INTO EMP VALUES(101,'SUMAN','MANAGER');

Which kind of statement is this ?

• DDL

• DML

• Value

• Python statement

What will be the output for :-

SELECT LENGTH("EMPLOYEE");

• 10

• 8

• EMPLOYEE

• 1

What will be the output for :-

SELECT ROUND(153.669,2);

• 153.6

• 153.7

• 153.67

• 153.66

Total number of rows/records/horizontal arrangement in a table is called:

• Degree

• Records

• Integer

• Cardinality