灵川软件面试题.doc

There are one or many answers for each question below. Part A and Part B are compulsory. Part C and Part D are optional, but you have to choose one part to answer. Part A : Database Section Which one belongs to DML? SELECT UPDATE INSERT DELETE The Score table has three columns Stu_No, Subject_No and Score. The data is in the following table. Execute below SQL: SELECT COUNT (DISTINCT Stu_No) FROM Score WHERE Score60 How many records will be displayed in the query result. Stu_No Subject_No Score S1 C1 80 S1 C2 75 S2 C1 Null S2 C2 55 S3 C3 90 A. 1 B. 2 C. 3 D. 4 In the following statements ,which one has error? In table ( have primary key) any of two rows values can not be the same. In table ( have primary key) any of two column values can not be the same. There is not important of the sequence of rows in table. There is not important of the sequence of column in table. In SQL, which statement is used to give privileges to another user. GRANT CREATE REVOKE INSERT What does SQL stand for? Structured Query Language Structured Question Language Strong Question Language None of above Which SQL statement is used to extract data from a database? EXTRACT GET SELECT OPEN Which SQL statement is used to update data in a database? SAVE AS MODIFY UPDATE SAVE With SQL, how do you select a column named “FirstName” from a table named “Persons”? SELECT Persons.FirstName Select FirstName FROM Persons EXTRACT FristName FROM Persons None of above Which of the following statements are correct for primary key? The value of the primary key is unique among differents rows. The primary key can improve the speed of search function. The primary key reduces the performance on INSERT statement None of above Which of the following statements are correct? Equi-join uses equality comparisons in the join.Using other comparison operators (such as ) is also called a join as an equi-join. A cross join or Cartesian join provides the foundation upon which all types of