Informatica
Which of these statements are true and which are false?
DDL statements are used to define and modify data in the database.
SELECT is a DCL statement.
DML statements include the SELECT command.
The GRANT command gives users access rights to database objects.
The DELETE command removes a table from the database.
The INSERT command is used to insert a new column in a table.
Il punteggio di un esercizio è determinato
dalla difficoltà: da 1 (più facile) a 5 (più
difficile). Vuoi saperne di più? Consulta il
Centro assistenza
Informatica
Consider the Books table:
Books (BookID, Title, Pages, Cover, Price, Publisher, AuthorID)
Which of the following statements is correct with respect to the following SQL command?
SELECT Title, Pages, Price
FROM Books
WHERE Pages > 300;
The query uses only a projection operation on the Books table.
The query lists the values of Title, Pages and Price of the books over 300 pages, ordered by Title.
The query is an example of both join and selection operations.
The query lists the values of Title, Pages and Price of the books over 300 pages.
Il punteggio di un esercizio è determinato
dalla difficoltà: da 1 (più facile) a 5 (più
difficile). Vuoi saperne di più? Consulta il
Centro assistenza