RDBMS 10 Quiz 8

Welcome to your RDBMS 10 Quiz 8

Name

School Name

Q71. Command to display all the data from the table "emp" is

Select * from emp

Select * from emp;

Select all from emp

Select all from emp;

Q72. Which command is used to create table?

Select

Create

Open

New

Q73. Shortcut to execute query in Create Query in SQL View is ________

F7 Key

F6 Key

F5 Key

F8 Key

Q74. Which command is used to display the salary of all the employees after incrementing by 1000.

Select

Update

Modify

Change

Q75. Select "salary" from emp;

will display all the records of table emp

will display only particular columns of table emp;

will display only salary column of table emp;

None of the above

Q76. Select "empname", "salary" * 3 from emp;

will increase the salary three times of all employees in table

display name and salary three times

give error

None of the above

Q77. To get details about the list of students whose favorite color is blue. Query for this is

select all from SDetails where Color=’Blue’;

select name from SDetails where Color=’Blue’;

select * from SDetails where Color=’Blue’;

select * from SDetails where Color is ’Blue’;

Q78. select * from SDetails order by “Rollno” ASC;

display all the records of table.

display all records in increasing order of roll number.

both of the above

None of the above

Q79. Which command is used to modify data in table?

Delete

Select

Modify

Update

Q80. Which command is used to delete data from table?

Select

Delete

Insert

Remove

Related

Leave a ReplyCancel reply