بســم الله الـرحمــن الرحيــم
ارجو الاجابة عن الاسئلة التالية و باسرع وقت :
25. With SQL, how do you select all the records from a table named "Persons" where the "FirstName" is "Peter" and the "LastName" is "Jackson"?
a- SELECT [all]FROM Persons WHERE FirstName LIKE 'Peter' AND LastName LIKE 'Jackson'
b- SELECT FirstName='Peter', LastName='Jackson' FROM Persons
c- SELECT * FROM Persons WHERE FirstName LIKE 'Peter' AND LastName LIKE
'Jackson'
d- none of the above
26. Which SQL statement is used to return only different values?
a- SELECT DIFFERENT
b- SELECT DISTINCT
c- SELECT UNIQUE
d- none of the above
27. With SQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"?
a- SELECT * FROM Persons SORT 'FirstName' DESC;
b- SELECT * FROM Persons ORDER FirstName DESC;
c- SELECT * FROM Persons SORT BY 'FirstName' DESC;
d- SELECT * FROM Persons ORDER BY FirstName DESC;
28. With SQL, how can you insert a new record into the "Persons" table?
a- INSERT INTO Persons VALUES ('Jimmy', 'Jackson');
b- INSERT VALUES ('Jimmy', 'Jackson') INTO Persons;
c- INSERT ('Jimmy', 'Jackson') INTO Persons;
d- none of the above
29. With SQL, how can you delete the records where the "FirstName" is "Peter" in the Persons:
a- DELETE FROM Persons WHERE FirstName = 'Peter';
b- DELETE FirstName='Peter' FROM Persons;
c- DELETE ROW FirstName='Peter' FROM Persons;
d- none of the above
30. With SQL, how can you return the number of records in the "Persons" table?
a- SELECT COLUMNS(*) FROM Persons;
b- SELECT COUNT() FROM Persons;
c- SELECT COLUMNS() FROM Persons;
d- SELECT COUNT(*) FROM Persons;
31. What is the correct output of this statement :
SQL > select ename from emp
where ename like '%S' ;
a- S
b- Stttttt
c- none of the previous
d- All of the previous
32. char(20) , means :
a- minimum length = 20
b- fixed length
c- variable length
d- none of the above
33. create statement , is an example of :
a- DDL
b- DML
c- DCL
d- None of the previous
34. update statement , is an example of :
a- DDL
b- DML
c- DCL
d- None of the previous
35. varchar2(20) , means :
a- minimum length = 20
b- maximum length = 20
c- fixed length
d- b + c
36. What is the correct output of this statement :
SQL > select ename from emp
where ename like 'S%' ;
a- S
b- Stttttt
c- ST
d- All of the previous
37. To give user1 and user2 select and update privileges on each of the fields (university_no and university_name) in table university , we use the SQL
statement ……
a- Grant select,update on emp to user1,user2;
b- Grant select , update (university_no, university_name) on emp to user1,user2;
c- Grant select (university_no, university_name) , update (university_no, university_name) on emp to user1,user2;
d- None of the above
Set_Window_Property(Forms_Mdi_Window,title,'training Centers');
a- form level
b- datablock level
c- item block
d- none of the above
39. What this icon means for you :
a- stop
b- ok
c- run
d- delete
40. What this icon means for you :
a- stop
b- delete
c- ok
d- none of the above