Question

1. Most database applications require a host programming language to communicate with the database using SQL. A wide range of programming languages can be used with SQL,from traditional languages such as COBOL, FORTRAN, and Assembler to more modern languages such as C/C++, Java, and Visual Basic. Your choice of host programming language can impact the way you will have to code SQL.

True or False?

2. It is an entity name guideline:

a. Do not pluralize the name; use singular

b. instead of "employees" use "employee"

c.Use as a name a noun, or adjective

d. Remove process specific artifacts from the entity name

e. All of above

3. The physical review design checks all the data elements such as entities, attributes, descriptions, and relationships

true or false?

4. The fewer DBMS products installed, the less complicated database administration becomes.

true or false?

5.

During which types of design review should denormalization be discussed? (Select all that apply)

Conceptual design review

Logical design review

Physical design review

Organizational design review

SQL and application code review

Pre-implementation design review

Post-implementation design review

6.

Which is NOT a benefit for having application DBAs?

1.When application DBAs implement useful procedures it takes more effort to share these procedures among the other DBAs

2.Application DBAs can better focus on an individual application which can result in better service to the developers of that application

3. The Application DBA is more often viewed as an integral component of the development team and therefore is better informed about new developments plans and changes to plans

4. Because the application DBA consistently works on a specific set of applications he can acquire a better overall understanding of how each application works enabling him to better support application developers

5. All of above

7.

Enterprise DBMS are designed for scalability and high performance, and they are able to support for very large databases. Usually, they runs on a high-end machine, and they are very expensive

true or false?

Answer 1

QUESTION 1 – TRUE

BRIEF JUSTIFICATION -

SQL Database developers have a choice of languages for developing applications—C, C++, Java, COBOL, PL/SQL, and Visual Basic. The entire functionality of the database is available in all the languages. All language-specific standards are supported. Developers can choose the languages in which they are most proficient or one that is most suitable for a specific task. For example an application might use Java on the server side to create dynamic Web pages, PL/SQL to implement stored procedures in the database, on the other hand C++ to implement computationally intensive logic in the middle tier.

Example -

In C / C++ Language

You can code SQL statements in a C or C++ program you can use executable statements.

Every SQL statement in a C or C++ program must start with EXEC SQL and end with a semicolon-;.

The EXEC and SQL keywords must be single line, but the rest of the statement can appear on succeeding lines of the code.

In JAVA

A JDBC program includes the following steps in use SQL in JAVA:

1. Allocate a Connection object, for connecting to the database server.

2. Allocate a Statement object, for holding a SQL command that was created earlier.

3. Now Write a SQL query(statement) and execute the query, via the Statement and Connection created in step 1 and 2.

4. Process the query result.

5. Close the Statement and Connection to free up the resources.

Question 2 It is an entity name guideline:

Answer Option D - All of above

Question 3 - The physical review design checks all the data elements such as entities, attributes, descriptions, and relationships

Answer - False

Brief Justification –

Right Answer would be - Conceptual Data Model

The 3 basic residents of Conceptual Data Model are as follows :

• Entity: A real-world thing
• Attribute: Characteristics or properties of an entity
• Relationship: Dependency or association between two entities

Question 4 The fewer DBMS products installed, the less complicated database administration becomes.

Answer - True

Brief Justification : Due to do that we will have the better chances in terms of providing effective data management resources any organization

Question 5 : During which types of design review should denormalization be discussed? (Select all that apply)

Answer :        Conceptual design review

Logical design review

Question 6 : Which is NOT a benefit for having application DBAs?

Answer : 1. When application DBAs implement useful procedures it takes more effort to share these procedures among the other DBAs

Question 7 : Enterprise DBMS are designed for scalability and high performance, and they are able to support for very large databases. Usually, they runs on a high-end machine, and they are very expensive

Answer : False

Justification

Paid to Free Versions of Enterprise Solutions are available in market

Enterprise database systems come packed with features from backups to high-availability to extensive cloud services. Enterprise database systems range in price from free to tens of thousands of dollars.

Like – AMAZON RDS – It’s Free