Table, View, Index, Sequence, Synonym.

Question 1

create database command

Answer 1

create database database_name;

Question 2

query to use database

Answer 2

use database_name;

Question 3

query to create table

Answer 3

create table table_name (table_name datatype (size) primary key,…);

Question 4

query to insert values in database

Answer 4

insert into table_name values(val1,val2,…,valn);

Question 5

display all elements of table

Answer 5

select * from student;

Question 6

query syntax for creating view

Answer 6

create view view_name as
(
query
);

Question 7

query for creating index after table creation

Answer 7

create index index_col_name on table_name
(
columns_names for index
)

Question 7

creating index while table creation

Answer 7

create table table_name
(
col1 datatype (size)
col2 datatype (size)
.
index (col1,col2,…)
);

Question 8

how to create synonym in mysql

Answer 8

we cannot create synonym in mysql

Question 9

how to create synonym in oracle

Answer 9

create synonym synonym_name for table_name

Question 10

syntax to create sequence in oracle

Answer 10

create sequence sequence_name
start with start_value
increment by value
minvalue value
maxvalue value
cycle/nocycle;

Question 11

how to use sequence while inserting values into table in oracle

Answer 11

insert into table_name values (col_name.sequence_name,column2, column3 , ………)

Question 12

how to take input from user while insertion in oracle

Answer 12

insert into table_name values(col1 , ‘&col2’,….)

Question 13

how to create sequence in mysql

Answer 13

create table table_name (
col_name INT AUTO_INCREMENT PRIMARY KEY, —other columns
);

Question 14

syntax to view index

Answer 14

show index from table_name;

note : compulsory index not index_name

Question 15

how to use insert while inserting values in mysql by sequence

Answer 15

insert into table_name ( col_2, col_3, … ) values ( col2_value, col3_value);

Question 16

how to get inside sql in ubuntu terminal

Answer 16

sudo su
mysql -u root -p