# قواعد بيانات 2 الفرقة الثالثة العام الجامعى 2012-2013

28 Questions | Total Attempts: 102

Settings

إمتحان أعمال السنة الفرقة الثالثة قواعد بيانات 2 للعام الدراسى 2012 - 2013

• 1.
SQL < select name ,sal from Emp where name like m%;
• A.

True

• B.

False

• 2.
SQL < select name , job from Emp where sal < = 25000 or job = sales ;
• A.

True

• B.

False

• 3.
SQL < select name , job from Emp  where sal < = 25000 or job = 'sales' ;
• A.

True

• B.

False

• 4.
SQL < select * from Emp where sal between 1000 and 2000
• A.

True

• B.

False

• 5.
SQL> select * from emp where job is not in (it_prog , manage);
• A.

True

• B.

False

• 6.
SQL < select  * where sal between 1000 and 2000 ;
• A.

True

• B.

False

• 7.
BETWEEN can be used to refer to a range of values.
• A.

True

• B.

False

• 8.
SQL < select * from Emp where sal  1000 and 2000 ;
• A.

True

• B.

False

• 9.
SQL < select * from Emp where sal between 1000 and 2000 ;
• A.

True

• B.

False

• 10.
SQL < select name ,sal from Emp where name like 'm%';
• A.

True

• B.

False

• 11.
SQL < select name , job from Emp where sal>=  25000 or job =sales ;
• A.

True

• B.

False

• 12.
(IN) Display rows  based on  a list of values
• A.

True

• B.

False

• 13.
SQL < select name , sal from Emp name like '-a%' ;
• A.

True

• B.

False

• 14.
SQL < select name , job , sal from emp where job = 'sales' and sal >1500;
• A.

True

• B.

False

• 15.
SQL < select name , job , sal from emp where (job='sales' or job = 'clerk') and sal < 1700 ;
• A.

True

• B.

False

• 16.
SQL < select name , sal + 300 from emp
• A.

True

• B.

False

• 17.
DDL is SQL commands allows the creating , alteration , and dropping of object from the database.
• A.

True

• B.

False

• 18.
Definition of DML is SQL commands allow the inserting , updating , and deletion of objects from the database.
• A.

True

• B.

False

• 19.
A null is not the same as zero or a blank  space .
• A.

True

• B.

False

• 20.
The ORDER BY clause comes last in the SELECT statement
• A.

True

• B.

False

• 21.
(And) Returns TRUE if either component condition is true
• A.

True

• B.

False

• 22.
[ SELECT DISTINCT JOB FROM EMP;]display all jobs with duplicate
• A.

True

• B.

False

• 23.
[ SELECT * FROM EMP;] Display all employee data
• A.

True

• B.

False

• 24.
(%) denotes
• A.

One character

• B.

Many character

• C.

Three character

• 25.
means not equal
• A.

• B.

=/

• C.

>=