Database - The Client-Server Database MCQs Part

1. Which of the following statements is true about symmetric multiprocessing?

A.
A single copy of the operating system resides in each processor.
B.
Useful for situations where data must remain in memory to process.
C.
Bottlenecks increase with uniprocessor systems because tasks are not shared.
D.
The problems of memory contention are unlikely.

 Answer Option B

2. Which of the following items are not necessary for client/server?

A.
Assure that tools will connect with middleware.
B.
Understand the requirements.
C.
Determine network bandwidth capabilities.
D.
Include the use of a file server.

 Answer Option D

3. A benefit of the three-tier architecture is which of the following?

A.
New modules can be built to support specific business needs
B.
Performance improves for compiled SQL statements
C.
Results in a thinner client and database server
D.
All of the above.

 Answer Option A

4. Which of the following statements is true concerning JDBC?

A.
It is language independent.
B.
It is similar in concept to ODBC.
C.
It is useful for all object-oriented languages.
D.
It consists of three main layers.

 Answer Option B

5. A characteristic of a file server is which of the following?

A.
Manages file operations and is shared on a network.
B.
Manages file operations and is limited to one PC.
C.
Acts as a fat client and is shared on a network.
D.
Acts as a fat client and is limited to one PC.

 Answer Option A

6. Stored procedures have which of the following advantages?

A. It takes a longer time to write them as compared to writing Visual Basic.
B. Network traffic increases
C. Data integrity improves as multiple applications access the same stored procedure.
D. Result in thicker client and thinner database server.

 Answer Option C

7. Which of the following statements is a true statement concerning the open database connectivity standard (ODBC)?

A. Each vendor desiring to be ODBC-complaint provides an ODBC driver.
B. Requires certain criteria to be met in order to establish an ODBC connection.
C. Provides a programming interface that provides a common language for application programs to access and process SQL databases independent of the RDBMS accessed.
D. All of the above.

 Answer Option D

8. Which of the following is true concerning QBE?

A. An official standard has been defined for QBE.
B. QBE cannot be used for client/server systems.
C. QBE does not give the programmer a visual programming environment.
D. Complete applications can be written using QBE.

 Answer Option D

9. Client/server security includes which of the following?

A. Physical security
B. Change control security
C. Measures taken to secure all systems
D. All of the above.

 Answer Option D

10. An application program interface (API) is which of the following?

A. The same thing as ODBC.
B. Middleware that does not provide access to a database.
C. Middleware that provides access to a database.
D. The same thing as JDBC.

 Answer Option C

11. Three-tier architecture includes which of the following?

A. Three server layers
B. A client layer and two server layers
C. Two client layers and one server layer
D. Three client layers

 Answer Option B

12. Which of the following is true concerning the mainframe?

A. It is the same thing as client/server.
B. Requires someone to decide which code should be on the workstation or the server.
C. Mission-critical systems have tended to remain there.
D. All of the above.

 Answer Option C

13. A server cannot serve on which of the following levels?

A. Client Layer
B. Business Layer
C. Database Layer
D. All of the above.

 Answer Option A

14. The three different application logic components are which of the following?

A. Presentation, Client, and Storage
B. Presentation, Client, and Processing
C. Presentation, Processing, and Storage
D. Presentation, Processing, and Network

 Answer Option C

15. A database server is responsible for which of the following?

A. Database storage
B. Data processing logic
C. Data presentation logic
D. All of the above.

 Answer Option A

6. Stored procedures have which of the following advantages?

A. It takes a longer time to write them as compared to writing Visual Basic.
B. Network traffic increases
C. Data integrity improves as multiple applications access the same stored procedure.
D. Result in thicker client and thinner database server.

 Answer Option C

7. Which of the following statements is a true statement concerning the open database connectivity standard (ODBC)?

A. Each vendor desiring to be ODBC-complaint provides an ODBC driver.
B. Requires certain criteria to be met in order to establish an ODBC connection.
C. Provides a programming interface that provides a common language for application programs to access and process SQL databases independent of the RDBMS accessed.
D. All of the above.

 Answer Option D

8. Which of the following is true concerning QBE?

A. An official standard has been defined for QBE.
B. QBE cannot be used for client/server systems.
C. QBE does not give the programmer a visual programming environment.
D. Complete applications can be written using QBE.

 Answer Option D

9. Client/server security includes which of the following?

A. Physical security
B. Change control security
C. Measures taken to secure all systems
D. All of the above.

 Answer Option D

10. An application program interface (API) is which of the following?

A. The same thing as ODBC.
B. Middleware that does not provide access to a database.
C. Middleware that provides access to a database.
D. The same thing as JDBC.

 Answer Option C

Comments

Post a Comment

Most Popular

PhpStorm, return value is expected to be 'A', 'object' returned

Image
✔ Recommended Answer Has to be because object can be ANY class instance, even B etc. You can annotate the create() method with generics PHPDoc to tell that the return type will be the same as the input parameter class string. It gives more context info to the IDE. /** * @template T * * @param string $class * @return T */ private function create(string $class) : object { return new $class(); } P.S. Instead of create('B'); better use create(B::class) . This way the IDE can track the usages of that class for refactoring/search purposes etc. Source: stackoverflow.com Answered By: LazyOne Method #2 This error message suggests that your code is expecting a value of type 'A' to be returned, but instead, the code is returning an object. This error can occur in PhpStorm, or any other PHP development environment. To resolve this error, you should check the function or method that is returning the object and ensure that it is returning
Read more

Remove Unicode Zero Width Space PHP

✔ Recommended Answer This: $newBody = str_replace("​", "", $newBody); presumes the text is HTML entity encoded. This: $newBody = str_replace("\xE2\x80\x8C", "", $newBody); should work if the offending characters are not encoded, but matches the wrong character (0xe2808c). To match the same character as #8203; you need 0xe2808b: $newBody = str_replace("\xE2\x80\x8B", "", $newBody); Source: stackoverflow.com Answered By: Jef Method #2 To remove Unicode zero width space (ZWSP) from a string in PHP, you can use the str_replace() function to replace the ZWSP character with an empty string. Here's an example: php $str = "Hello​ World" ; // Contains ZWSP after "Hello" // Replace ZWSP with an empty string $str = str_replace ( "\u{200B}" , "" , $str ); echo $str ; // Outputs "Hello World" without ZWSP In this example, the str_replace() functi
Read more

Laravel file upload returns forbidden 403, file permission is 700 not 755

✔ Recommended Answer The issue you are facing could be due to incorrect file permissions for the storage folder. Here are some steps to fix the problem: SSH into your cPanel server. Change the permission of the storage folder to 755: chmod -R 755 storage/ This command will change the permission of the storage folder and all its contents to 755, which should give the web server permission to read and write to the folder. Check the ownership of the storage folder. Ensure that the owner of the folder is the same as the user running the web server (typically www-data on Apache): ls -l This command will list the files and folders in the current directory along with their ownership and permission details. Make sure that the owner of the storage folder is the same as the user running the web server. If the ownership is incorrect, you can change it using the following command: chown -R www-data:www-data storage/ This command will change the ownership of the storage folder and all its conten
Read more