今天面试了几道题,大家看看能答对几道哦!!要英文回答哦!!! (刚才帖子忘记给分了,现在补上)
1)Compare 2 DBMS-MS SQL Server and MS Access.How are they similar or different from each other? What kind of software/project you would use SQL Server? What kind of software/project you would use MS Access?2) What's the most popular diagram/model that people use to design Relational DataBase? When the realtionship between two entities is M-to-M(Many-to-Many),how do you design you model to avoid M-to-M relationship? Why?
3)In PowerBuilder,what situation do you create PB User Objects? In Visual C++ and ASP applitions,can you apply the same concept? How?
用中文回答应该是比较简单,主要是英文哦?
看看您能回答几题呢? --------------------编程问答-------------------- 1:sql server 和 access的异同，什么情况下使用sql server？什么情况下使用access?
昏啊。
看明白但是写还真不会~ --------------------编程问答-------------------- 呵呵,现在就是缺少 英语流利 又会编程的哦 --------------------编程问答-------------------- 1:ms sql is a large database, with on the site, mssql generally used for large amounts of data such as regular records of more than hundreds of thousands of Web sites, access general and asp integration for the small amount of data sites.
下面2题飘过。
--------------------编程问答--------------------
三年前还有点戏，三年来就没接触英文的环境，早忘了~
--------------------编程问答--------------------
上面的强人怎么提高英语的啊,分享一下经验撒
--------------------编程问答--------------------
没有人能全答出来吗
--------------------编程问答--------------------
翻译还是可以的，要是用英文解决的话估计.......
--------------------编程问答--------------------
我是中国人，何必学外文…………
--------------------编程问答--------------------
还是不要来献丑了～～汗
--------------------编程问答--------------------
--------------------编程问答--------------------
if the project need a small space ,i will choose access,because this way does not need extra install.
--------------------编程问答--------------------
有点难 帮顶
--------------------编程问答--------------------
...
--------------------编程问答--------------------
使用aceess数据操作简单，灵活。而且成本很低（是免费的）适合中小型企业sql server，适合大容量数据和大流量网站的应用，在性能、安全、功能管理、可扩展性上要比ACCESS强很多适合大型企业使用
--------------------编程问答--------------------
顶 --------------------编程问答-------------------- 还是要学好外语，唉，以前能读懂各大英文报纸呢，现在什么都看不懂了哦。 --------------------编程问答-------------------- UP --------------------编程问答-------------------- 1.
MS Access falls into the desktop category and works best for individuals and workgroups managing megabytes of data. In comparison with SQL Server, Access uses file-server architecture, rather than client-server architecture. Access has many restrictions in comparison with SQL Server and cannot be used in the case who want to build stable and efficient system with many concurrent users.
If the software/project's goal is to make a scalability, security, and robustness system, I would like to use SQL Server instead of Access. Because Access does not support atomic transactions, it does not guarantee that all changes performed within a transaction boundary are committed or rolled back. SQL Server is integrated with Windows NT security, but Access is not.
Access databases cannot be restored to the point of failure, when SQL Server databases can be.
This makes administering Access databases more expensive than administering SQL Server databases.
I would perfer to use Access 2000 database, only when the software/project needs to store a small amount of data in a single user (or few users) environment, or when the deployment enviroment has very low resources, such as memory or disk.
2.
Entity-Relationship Model (ERM) iss the most popular model that people use to design Relational DataBase. Diagrams created using the Entity-relationship modeling process are called entity-relationship diagrams, or ER diagrams or ERDs for short.
I don't think we should avoid M-to-M relationship, many-to-many relationships are normal. The only reason i know that should avoid m:m relationship is about the "performace". having a relationship in the database is good in terms of data integrity, but it's bad in terms of performance, so it's a trade off you will have to consider, and impact on performance really depends on your design and nature of activity...
3.
sorry don't knwow pb.
补充：.NET技术 , ASP.NET
