sql queries - 2

Front

Which would show all fields from the Pupils table? Options: SELECT * FROM Pupils, SELECT Name, Form FROM Pupils, SELECT * FROM *, SELECT * FROM Forms

Back

SELECT * FROM Pupils

Front

Which Symbol means "All"? Options: *, &, %, !

Back

*

Front

Which would find pupils with "er" anywhere in their name? Options: SELECT * FROM Pupils Where Name = "%er"; SELECT * FROM Pupils Where Name = "$er$"; SELECT * FROM Pupils Where Name = "%er%"; SELECT * FROM Pupils Where Name = "er%"

Back

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

Front

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

Back

SQL Injection

Front

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';

Back

SELECT * FROM EMP WHERE NAME IS NULL;

Front

The restrictions or conditions applied on data are known as ______________

Back

Constraints

Front

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

Back

Foreign Key

Front

What will be the output?
SELECT ROUND(36.7894,2)

Back

38.79

Front

What will be the output of: SELECT INSTR('KVMANKHURD','MAN');

Back

3

Front

What will be the output?
SELECT TRUNCATE(36.5643,2);

Back

36.56