Xi Class MySQL

40 Questions | By Myhemant72 | Last updated: Mar 22, 2022 | Total Attempts: 3130

Questions

Settings

Create your own Quiz

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.

Questions and Answers

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