Oralce-SQL/PLSQL MCQ with Answers SET - 1

1. SQL stands for…..

A) Structured Query
B) Structured and Query Language
C) Both A and B
D) None of the above

ANSWER= (C) Both A and B
Explain:- The SQL stands for Structured Query Language and it is also called as Structured and Query Language
Blogger quiz code

 

2. DDL Stands for…….

A) Data Dictionary Language
B) Data Definition Language
C) Dictionary of Data
D) None of the above

ANSWER= (B) Data Definition Language
Explain:- The DDL is Data Definition Language used to define the table structure
Blogger quiz code

 

3. Which of the following are DDL Queries

A) Create,Insert,update, Alter
B) Select,Insert, modify,
C) Create,Alter, Drop
D) update, set, delete

ANSWER= (C) Create, Alter, Drop
Explain:- The DDL statements are Create, Alter, Drop
Blogger quiz code

 

4. How to display table structure

A) Using select * from query
B)Using select all query
C) Using describe query
D) Using Desc tablename query

ANSWER= (D) Using Desc Tablename query
Explain:- The structure of table is displayed with DESC Tablename query
Blogger quiz code

 

5. What will be the output of given query: Select * from Tablename

A) Select All the rows from tablename
B)Retrieve all the records from the tablename
C) Retrieve the selective data from Tablename
D) Query will not execute

ANSWER= (D) Query will not be execute
Explain:- because query is not terminated with semicolon(;)

 

6. Drop query is used to ….

A) Delete all the records from table
B) Delete all the columns from the table
C) Delete the table permanently from database
D) None of the above

ANSWER= (C) Delete the table permanently from database
Explain:- The Drop query is used to drop or delete table permanently from the database

 

7. Which keyword is used to display the structure of table…….

A) Insert All
B) Describe
C) Display
D) Desc

ANSWER= (D) Desc
Explain:- Desc Keyword is used to display the structure of Created table

 

8.Which of the following syntax is correct

A) desc student;
B) Desc table student;
C) Describe Student;
D) Describe Table Student;

ANSWER= (A)Desc Student;
Explain:- Desc Student is the correct syntax to describe the structure of table

 

9. The table structure is defined with the help of ….. query or keyword

A) desc
B) Create
C) Insert
D) Select

ANSWER= (B)Create
Explain:- The create keyword or Create query is used to create the table or define the structure of table

 

10. ADBMS stands for…

A) Advanced Database Management Software
B) Database Management System
C) Advanced Database Management System
(D) None of above

ANSWER= (C) Advanced Database Management System
Explain:- ADBMS stands for Advanced Database Management System

 

11. What are the DDL Statements in Oracle

A) Insert, Update,Delete
B) Create, Alter, Drop
C) Alter, Modify, Add
(D) Update,Create, Insert

ANSWER= (B) Create, Alter, Drop
Explain:- Create, Alter, Drop are the statements used to define and modify or delete the structure of table

 

12. What are the DML Statements in Oracle

A) Insert, Update,Delete
B) Create, Alter, Drop
C) Alter, Modify, Add
(D) Update,Create, Insert

ANSWER= (A) Insert, Update,Delete
Explain:- Insert, Update,Delete are the statements used to define and modify or delete the structure of table

 

13. What the following query will return: Insert Into Student Values(1,’Sakshi’,’BCAII’,’A’);

A) Insert four rows in student table
B) Insert one row in a table
C) Insert multiple rows in a table
(D) None of the above

ANSWER= (B) Insert one row in a table
Explain:- The given query will return one row table

 

14. Select correct alternative for given query: Create employee (empid varchar(4), empname varchar(15));

A) Employee Table will create
B) Table keyword is missing so it will show error
C) Table will create with all mentioned columns
(D) None of the above

ANSWER= (B) Table keyword is missing so it will show error
Explain:- The syntax is wrong, Table keyword is missing so it will show error

 

15. What is correct syntax for Delete table permanently from database

A) Drop Table Tablename;
B) Drop Tablename
C) Delete Tablename;
(D) Delete Table Tablename

ANSWER= (A) Drop Table Tablename;
Explain:- To remove table permanently from database Drop Table Tablename; query is used