sql queries - 2

Which would show all fields from the Pupils table?

• SELECT * FROM Pupils

• SELECT Name, Form FROM Pupils

• SELECT * FROM *

• SELECT * FROM Forms

Which Symbol means "All"

• *

• &

• %

• !

Which would find pupils with "er" anywhere in their name?

• SELECT * FROM Pupils Where Name = "%er"

• SELECT * FROM Pupils Where Name = "$er$"

• SELECT * FROM Pupils Where Name = "%er%"

• SELECT * FROM Pupils Where Name = "er%"

What is it called when SQL is used in an attempt to harm a database?

• SQL Injection

• SQL Interception

• SQL Attack

• SQL Misuse

Choose the correct query

• SELECT * FROM EMP WHERE NAME=NULL

• SELECT * FROM EMP WHERE NAME IS NULL;

• SELECT FROM EMP WHERE NAME IS NULL;

• SELECT *FROM EMP WHERE NAME IS 'NULL';

The restrictions or conditions applied on data are known as ______________

The primary key of a table which is present in another table for referencing is known as ________________________

What will be the output?

SELECT ROUND(36.7894,2)

• 36.78

• 38.79

• 36.7

• 36

What will be the outputI:

SELECT INSTR('KVMANKHURD','MAN');

• 2

• 3

• 5

• NONE

What will be the output?

SELECT TRUNCATE(36.5643,2);

• 36.56

• 36.57

• 36.5643

• 36