Database [3i Infotech Placement]: Sample Questions 37 - 38 of 294

Glide to success with Doorsteptutor material for competitive exams : get questions, notes, tests, video lectures and more- for all subjects of your exam.

Question 37

Database
Edit

Describe in Detail

Essay▾

Why does the following command give a compilation error?

DROP TABLE &TABLE_NAME.

Explanation

  • Variable name starts with an alphabet.
  • The table name cannot starts with an ‘&’ symbol.

DROP TABLE:

  • Drop table statement is used to drop an existing table in database.

Syntax:

DROP TABLE table_name;

Parameters:

table_name

  • Table name is removed from the database.

Question 38

Database

Question

MCQ▾

Which of the following is not an advantage of a client/server model?

Choices

Choice (4)

a.

A client/server model allows centralised control of data and centralised implementation of business rules.

b.

A client/server model is suitable for all applications

c.

A client/server model increases developer՚s productivity

d.

All of the above

Answer

b.

Explanation

Client/Server Model

Advantages of Client-Server Model

Centralization

  • Updating data or other resources at central location.
  • Integrity of the data controlled by the dedicated server.

Proper Management

  • The files are stored at the same place- management of files becomes easy.

Suitable for All Application

  • A client-server application is a distributed system made up of both client and server software.
  • Client server application provides a better way to share the workload.

Multitasking

  • Delivers the highest possible degree of concurrency, data integrity, and performance to its client applications.

Developed by: