Which of the following are the steps of database planning life cycle? Each correct answer represents a part of the solution. (Choose three.) A. Application Design B. Data conversion and loading C. Conceptual database design D. Operational Maintenance

You work as a Database Administrator for Dowtech Inc. A table named StudentInformation exists in a database. The table has columns named student_names, student_marks, and student_courses. Some students who have opted for various courses have got different marks in them.…

Fill in the blank with the appropriate word. The _______________ model for database management is a database model based on first-order predicate logic. A. relational B. traditional C. truncate

You manage a database named Exams accessed via a website. The website is regularly accessed by users in different countries. You are redesigning a table named History that records when users have purchased and taken online exams. You need one…

Which of the following is the process of creating a design for the database that will support the enterprise’s operations and objectives for the required database system? A. Application design B. Database design C. Database planning D. Identifying relationships between…

You are the database administrator for a MySQL database. The database server is installed on a Unix system. The time zone files for the system are located at /usr/share/zoneinfo. You need to ensure that the system and MySQL time zones…

James works as an Administrator for Softech Inc. The company has a SQL Server 2005 computer named SQL1. The company has six departments; Accounting, Sales, Marketing, Manufacturing, Production, and Research. The user accounts of each department are located in a…

You work as a MySQL Database Administrator. Your server crashed and it was recovered and made online within half an hour. What will you do to ensure that the table structure and contents are in a proper state? A. Perform…

What is the ideal time to back up dynamic log files? A. When the server is running. B. You can back up dynamic log files any time. C. When the server is stopped. D. When the server is shut down.

Mark works as a Database Designer for Reon Inc. He is assigned the task to create a database for the company. He issues the following query to create the database: CREATE DATABASE ‘24342’ What will be the output of the…