WorksheetsDatabases Quiz
Total questions: 10
Worksheet time: 5mins
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
