Week 0-1

To switch to the `sakila` database, what query is correct?

• SELECT sakila;

• SELECT SCHEMA sakila;

• USE sakila;

• SHOW sakila;

• SWITCH DEFAULT sakila;

What does the following query output?

SELECT DATABASE()

• The databases managed by the server

• Invalid query due to missing semi-colon

• Invalid query due to wrong syntax

• Shows the tables present in the database

• Describes the information in each table column

What does the following query output?

DESCRIBE sakila;

• The description of the `sakila` database

• Invalid query due to missing semi-colon

• Invalid query due to wrong syntax

• Shows the tables present in the database

• Describes the information in each table column

Which of these keywords ensures that the table is visible only within the current session and is dropped automatically when the session is closed?

• CREATE TABLE

• TEMPORARY

• CLONE

• CREATE new_table LIKE orig_table;

  (LIKE)

• INVISIBLE

At the time of creation or after the creation of the table, constraints can be modified using ____ keyword

• CONSTRAINT

• EDIT

• MODIFY

• ALTER

• CHANGE

PRIMARY KEY has implicit NOT NULL constraint

• True

• False

FOREIGN KEY has implicit NOT NULL constraint

• True

• False

DROP TABLE query can be undone

• True, with the help of TEMPORARY keyword

• True, with the help of ALTER keyword

• False, an auto-commit always takes place

• False, transactions cannot be undone

What is the expected output of the following query?

Assume that the table name is `product`.

SELECT COUNT(*) FROM product WHERE quantity > 8000;

• 4

• 2

• Error

• 1

• None of these

Which of these are valid actions for referencing rows in child table? (MCQ)

• SET NULL

• SET DEFAULT

• CASCADE

• NO ACTION

• RESTRICT