Databases Quiz

SQL stands for_______

• Style Query Language

• Structured Query Language

• Syntax Query Language

• Symbol Query Language

Which of the below queries is syntactically correct?

• create table student_data (name, class, marks) with types (text, int, int)

• create table student_data (name varchar(50), class int, marks int);

• create table student_daa(name-varchar(50), id-int, marks-int);

• All of the above

To change the name of a table in MySQL which of the following queries is used?

• rename table oldtable to newtable;

• rename table change oldtable to newtable;

• rename table modify oldtable to newtable;

• rename table to newtable from oldtable;

Which Of The Following Query Is Correct To Filter Columns While Fetching The Data?

• Select * From Student Where Column=Name And Column=Marks

• Select Name, Marks From Student

• Select Columns Name, Marks From Student

• Select Data Name, Marks From Student

boolean data type contains only 2 possible values

• True

• False

All the rows from one table are fetched when _____is used.

• Inner join

• Left join

• Right join

• B & C

The commands in SQL are case sensitive.

• True

• False

Name Of The Database Can Contain ___?

• Alphabets, Numbers And All Special Characters

• Alphabets, Numbers And ‘.’ Symbol

• Alphabets, Numbers And ‘_’ Symbol

• Alphabets, Numbers And ‘@’ Symbol

Which of the following is a valid syntax for ‘insert’ command?

• insert into <table name> (<column list>) values (<value list>)

• insert into <table name> values (<value list>)

• Both

• None

Which of the following command deletes the table along with the data?

• delete

• drop

• truncate

• All of the Above