Sql

[khalid.said]

chapter 1

practice 1

Initiate an SQL* PLUS session using the user ID and password provided by the instructor using-id: Scott

password:tiger

True

2sql*plus commands access the database-

true/false

true

 

  The following select statement executes successfully

select last_name,job_id,salary AS sal

;from employees

true/false

true

 

 

The following select statement executes successfully
* select 

;from job_grades

true/false

false

 

 

 

 

There are four coding errors in this statement can you identify them

select employee_id,   last_name

salx12 ANNUAL SALARY

;from employees

false

 

 

 

show the structure of the departments table,select all data from the table

;desc departments

;select * from departments