Questions and Answers of Database Concepts

Define and describe the following:a. Objectb. Attributesc. Object stated. Object ID
Discuss the evolution of object-oriented concepts. Explain how those concepts have affected computer-related activities.
In Oracle, what is a tablespace?
What is the tool used by Oracle to create users?
How have cloud-based data services affected the DBA’s role.?
Identify and explain some of the critical success factors in the development and implementation of a good data administration strategy.
Briefly explain the concepts of information engineering (IE) and information systems architecture (ISA). How do these concepts affect the data administration strategy?
What characteristics do a CASE tool and a DBMS have in common? How can these characteristics be used to enhance the data administration?
Using SQL statements, give some examples of how you would use the data dictionary to monitor the security of the database.
Define the concept of a data dictionary, and discuss the different types of data dictionaries. If you were to manage an organization's entire data set, what characteristics would you look for in the
What are security vulnerabilities? What is a security threat? Give some examples of security vulnerabilities that exist in different IS components.
What are the levels of data confidentiality?
Identify some bottlenecks in DBMS performance, and then propose some solutions used in DBMS performance tuning.
Why are testing and evaluation of the database and applications not done by the same people who are responsible for the design and implementation? What minimum standards must be met during the
Describe the activities that are typically associated with the design and implementation services of the DBA technical function. What technical skills are desirable in the DBA's personnel?
Assume that your company assigned you the responsibility of selecting the corporate DBMS. Develop a checklist for the technical and other aspects involved in the selection process.
Discuss the importance and characteristics of database data backup and recovery procedures. Then describe the actions that must be detailed in backup and recovery plans.
Protecting data security, privacy, and integrity are important database functions. What activities are required in the DBA's managerial role of enforcing these functions?
Explain the DBA's managerial role in the definition and enforcement of policies, procedures, and standards.
What DBA activities are used to support end users?
What are the DBA's managerial roles? Describe the managerial activities and services provided by the DBA.
Describe and characterize the skills desired for a DBA.
Explain how the DBA plays an arbitration role for an organization's two main assets. Draw a diagram to facilitate your explanation.
Explain and contrast the differences and similarities between the DBA and DA.
Explain the DBA department's internal organization, based on the DBLC approach.
Describe and contrast the information needs at the strategic, tactical, and operational levels in an organization. Use examples to explain your answer.
Create a sample XML document and DTD for the exchange of student transcript data. Use your college transcript as a sample.
As a discipline As a discipline, data visualization can be studied as _a group of visual communication techniques used to explore and discover data insights by applying: pattern recognition, spatial
What is data replication, and what are the three replication strategies?
Describe the three data fragmentation strategies. Give some examples of each.
Explain the need for the two-phase commit protocol. Then describe the two phases.
Define and explain the different types of distribution transparency.
List and explain the transparency features of a DDBMS.
What are the components of a DDBMS?
What is a fully distributed database management system?
Explain the difference between distributed database and distributed processing.
What are the disadvantages of the DDBMS?
What are the advantages of the DDBMS?
List and discuss some of the factors that influenced the evolution of the DDBMS.
Describe the evolution from centralized DBMSs to distributed DBMSs.
A table is in ___3rd___ normal form when it is in ___2nd normal form___ and there are no transitive dependencies.
How do you connect to a database in Oracle Database Express Edition 11g Release 2?
What file extension should you use for SQL scripts?
Create a Web page for Heather Sweeney Designs to display data in the SEMINAR,SEMINAR_CUSTOMER, and CUSTOMER tables to list the SEMINARdata and the EmailAddress, LastName, FirstName, and Phone of any
Code two HTML/PHP pages to add a new CUSTOMER to the HSD database. Create data for two new CUSTOMERs and add them to the database to demonstrate that your pages work.
A. You need about 20 SERVICE transactions in the database. Write the needed SQL statements for any needed additional SERVICE transactions and insert the data into your database.B. Design a data
A. Design a data warehouse star schema for a dimensional database named JRJ-DW. The fact table measure will be Retail Price.B. Create the JRJ-DW database in a DBMS product.C. What transformations of
A. Design a data warehouse star schema for a dimensional database named QACS-DW. The fact table measure will be Item Price.B. Create the QACS-DW database in a DBMS product.C. What transformations of
What are the three sources of data for BI systems?
What problems in operational data create the need to clean data before loading the data into a data warehouse
What does it mean to transform data? Give an example other than the ones used in this book.
What is the enterprise data warehouse (EDW) architecture?
Explain two ways that the OLAP report in Figure 8-18 differs from that in Figure 8-17.
What is the relationship between 1 MB of storage and 1EB of storage? FIGURE 8-1 Approximate Value for Reference Name Symbol Actual Value Storage Capacity Terms 8 bits (Store one character] Byte 210 =
What were the first nonrelational data stores to be developed, and who developed it?
As illustrated in Figure 8-21, what is column family database storage and how are such systems organized? How do column family database storage systems compare to RDMS systems? FIGURE 8-21
Explain MapReduce processing. FIGURE 8-22 MapReduce MAP INPUT: DOCUMENT Computer 01: List individual words and count how many times each word appears Document Section 01 REDUCE Computer: Combine
Based on the discussion of the Heather Sweeney Designs operational database (HSD) and dimensional database (HSD-DW) in the text, answer the following questions.A. What transformations of data were
What is SQL Server 2014 Express?
What is the primary advantage of using SQL Server 2014 Express instead of Microsoft Access?
What is the set of Microsoft programs that are recommended as a necessary set of SQL Server 2014 Express Advanced software products? In what order should you install these products?
What is the purpose of Microsoft SQL Server Management Studio?
How do you create a new database in SQL Server 2014?
How do you specify the active database in SQL Server 2014?
How do you specify the active database in SQL Server 2014?
What tool(s) can be used to create a script?
What is the purpose of the Oracle SQL Developer utility?
What file extension should you use for SQL scripts?
How do you open and run a script in SQL Server?
How do you create and run an SQL query in SQL Server?
How do you create and run an SQL query in SQL Server?
Using SQL Server, run the SQL queries in the “SQL for RelationalQueries” section of Chapter 3. Save each query as follows:
Use Microsoft SQL Server Management Studio to run one or more of the saved SQL queries you created in question A.14:
What is Oracle Database Express Edition 11g Release 2?
What is the primary advantage of using Oracle Database Express Edition 11g Release 2 instead of Microsoft Access?
What are the two Oracle programs that are recommended as a necessary set of Oracle Database Express Edition 11g Release 2 software products? In what order should you install these products?
What is the purpose of the Oracle Database 11g XE Web utility?
How do you create a new database in Oracle Database Express Edition 11g Release 2?
How do you connect to a database in Oracle Database Express Edition 11g Release 2?
What tool(s) can be used to create a script?
What file extension should you use for SQL scripts?
How do you create and run an SQL query in Oracle Database Express Edition?
What is MySQL?
What is the primary advantage of using MySQL instead of SQL Server Express Edition?
What are the three MySQL programs that are recommended as a useful set of MySQL software products?
What are two purposes of the MySQL Workbench?
How do you create a new database in MySQL?
What is a MySQL default schema? How do you specify the default schema?
What is an SQL script? What types of SQL statements and commands can be run more efficiently as scripts?
What tool(s) can be used to create an SQL script?
Code an SQL statement that displays the data in OwnerPhoneView, sorted alphabetically by LastName.
What file extension should you use with MySQL scripts?
How do you create, save,and run an SQL script in MySQL?
How does MySQL use the AUTO_INCREMENT keyword? What limitations are there on the use of the AUTO_INCREMENT keyword?
How do you create and run an SQL query in MySQL?
Code an SQL statement to create a view named OwnerPhoneView that shows OwnerLastName, OwnerFirstName and OwnerPhone.
How are views handled in Microsoft Access?
How do you obtain online help when using the MySQL Workbench? Where is the help information displayed?
What is the purpose of the MySQL Connector/OBDC? How do you install it, and where does it appear after it is installed?
What SQL statements are used to create SQL views?

Showing 100 - 200 of 650