Q.1 (a) Write SQL queries based on the statement syntax as well as the data types for the statement. (b) Explain differences between Transaction, ACID properties, and ACID transactions. Explain why it is not possible to use transaction or ACID properties in transactions that do not require ACID transactions. Answer the following question: Is it possible to use ACID transactions for normal transactions as well?
Q.2 (c) Write SQL statements using the IN and NOT IN operators. Explain the differences between these operators and how they will affect your query. Answer the following question: Is it possible to use not IN operators in queries that require IN operators?
Q.3 (d) Understand data structures and data type definition before beginning your work on your DMS exam. Be prepared to write SQL queries according to the data types and the data structures. In addition, have adequate knowledge about the different data types that are used in SQL. Furthermore, you need to understand data type definitions.
Q.4 (e) You will be expected to create and maintain a database for a DMS application. During this part, you should identify what type of database you would like to build. Answer the following questions:
Q.5 (f) If you have a DMS, you will also be expected to maintain the database. You will find a number of DMS management tools available for you to use while maintaining your database.
Q.6 (g) There are two types of database management systems that are available: the on-premises database management systems and the remote database management systems. You should have a good understanding about these two types of systems. You will need to know the advantages and disadvantages of each type of system.
Q.7 (h) In order to pass your DMS exam, you will need to write a simple and effective SQL query. Write the following SQL code:
Q.8 (I) As a professional database manager, you will need to have some knowledge about the SQL query language. SQL is one of the most commonly used database management systems. It is a widely used language in almost all fields of information technology.
Q.9 (j) You will also be required to design an application for managing data for a DMS. You will find an extensive database of data for you to choose from. During your career, you will develop a working relationship with your client and the database.
Q.10 (k) During the test questions, you will be asked to create tables, join tables, and insert and modify records into the tables. You must be able to do the required tasks correctly.
Q.11 (l) You will need to know how to analyze the complexity of a database. Analyze how well a database can be managed and maintained without the help of software applications.
Q.12 (m) During the test questions, you will be asked to do an analysis of data. Your results will determine if you pass or fail your exam.
Q.13 (n) During the DMS database, you will need to understand how to maintain the database by itself. You will learn how to maintain the database using maintenance tools.
Q.14 (o) In this part, you will be given various test questions that will challenge you to show your knowledge of the database management system. These questions are designed to help you prepare you for the exam.
Q.15 (p) You can expect to be given different test questions during the exam. These test questions are based on various topics like how to implement the new changes to the database and how to manage the data.