πŸš€ Launch OFFER πŸš€ Free 10 Credits for all newly created accounts - Get Started for Free (No Credit Card required) Click Here.

Search for your subset of questions

Question Code

1051

Question

Assuming all the databases, tables and columns exist, why the query won’t still work?

--go to movies database
USE Movies
--Select list of actors
SELECT
      ActorName,
      ActorDob,
FROM
      tblActor

Answers

Because there is an extra comma

USE should say USING

Each column must be given an alias

The order of the commands is wrong

Question Code

1055

Question

You have a table of films and want to display all the movies that are due for release after today. What should you type in the query?

SELECT
     FilmName,
     FilmOscarWins,
FROM
     tblFilm
WHERE
     FilmReleaseDate > _______________

Answers

Date()

GetDate()

Now()

Today()

Sign up to unlock the question bank

Sign up now

Already have an account? Log in

© 2022 merreo - All rights reserved.