قواعد بيانات 2 الفرقة الثالثة العام الجامعى 2012-2013
28 Questions
| Total Attempts: 102
إمتحان أعمال السنة الفرقة الثالثة قواعد بيانات 2 للعام الدراسى 2012 - 2013
Questions and Answers
- 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.
>=
اكتب الوصف هنا.
Questions: 5 | Attempts: 269 | Last updated: Mar 21, 2022
-
Sample QuestionYo increase the ability of solar cells on converting energy we use......
Questions: 5 | Attempts: 284 | Last updated: Mar 21, 2022
-
Sample Questionالتسلسل الصحيح لانتشار الموجات الصوتية في قنوات القوقعة
كان هذا العالم يعاني من الفوضى ، ونقص الموارد والخدمات ، مما جعل الناس يهاجرون إلى بلدان مختلفة ، وأماكن مختلفة بحثاً عن حياة...
Questions: 5 | Attempts: 248 | Last updated: Mar 21, 2022
-
Sample Questionمصطلح يكرر حركة واستقرار الأفراد أو الجماعات من بلدهم الأصلي إلى مكان آخر
Back to top