Xi Class MySQL
This is a quiz for all the programmers and nerds out there. If you want to test your knowledge on this particular bunch of programming language facts take this quiz and find out how vast your knowledge is.
- 1.A database can be best described as a ?
- A.
Collection of data
- B.
Collection of related tables
- C.
Collection of tables
- D.
Collection of views
- 2.A new Database is created by ?
- A.
Use database command
- B.
Create table command
- C.
Create database command
- D.
Crete store cammnd
- 3.A table can be best described as a ?
- A.
Collection of data
- B.
Collection of related tables
- C.
Collection of tables
- D.
Collection of rows and columns
- 4.A table can be created with out using a database?
- A.
True
- B.
False
- 5.A table can have more than 1 primary key?
- A.
True
- B.
False
- 6.A table has three rows and 5 columns the cardinality is?
- 7.A table has three rows and 5 columns the degree is?
- 8.First letter D in DDL stands for?
- 9.If a column which is a primary key is dropped the data and constraint are dropped too.
- A.
True
- B.
False
- 10.If the primary key constraint is dropped the column and the data is lost too.
- A.
True
- B.
False
- 11.If today is '2012-1-19' what will be the output of select year(sysdate());
- A.
19
- B.
1
- C.
2012
- D.
'2012-1-19'
- 12.If today is '2012-1-19' what will be the output of select dayofyear(sysdate());
- A.
19
- B.
1
- C.
2012
- D.
'2012-1-19'
- 13.If today is '2012-1-19' what will be the output of select month(sysdate());
- A.
19
- B.
1
- C.
2012
- D.
'2012-1-19'
- 14.In DML M stands for?
- 15.MySql is open source technology?
- A.
True
- B.
False
- 16.Select ascii('100'); will return?
- A.
49
- B.
50
- C.
51
- D.
52
- 17.Select ascii('citrus'); will return;
- A.
98
- B.
99
- C.
100
- D.
101
- 18.What will be the output of the following? select instr('JACKAL',"KAL");
- A.
1
- B.
2
- C.
3
- D.
4
- 19.What will be the output of the following? select right('JACKAL',3);
- A.
Jac
- B.
JAC
- C.
Kal
- D.
KAL
- 20.Which command is used to add delete columns to an existing table?
- A.
Desc
- B.
Alter table
- C.
Drop table
- D.
Create table
- 21.Which command is used to add remove tablefrom a database?
- A.
Delete
- B.
Alter table
- C.
Drop table
- D.
Create table
- 22.Which command is used to delete all rows from a table?
- A.
Drop
- B.
Delete
- C.
Remove
- D.
Flush
- 23.Which command shows the rows of the table emp?
- A.
Select * from emp;
- B.
Show all from emp;
- C.
Desc emp;
- D.
Drop emp;
- 24.Which command shows the table structure of table emp?
- A.
Select * from emp;
- B.
Show all from emp;
- C.
Desc emp;
- D.
Drop emp;
- 25.Which of the following are DDL commands?( Select Two)
- A.
Create table
- B.
Insert
- C.
Update
- D.
Delete
- E.
Drop table
Back to top