Sample Questions:
Which of the following are the steps of database planning life cycle? Each correct answer represents a part of the solution. (Choose three.)
Application Design
Data conversion and loading
Conceptual database design
Operational Maintenance
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 of the columns in the History table to record what time of day that a user has taken an exam. Additionally, you need this column to have time zone awareness. What data type should you use?
date time offset
datetime
Use two different columns with one column of datetime, and the second column indicating the UTC offset.
datetime2
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?
Application design
Database design
Database planning
Identifying relationships between objects
James works as an Administrator for Soft tech 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 domain group named after the department. James wants to create a separate database on SQL1 for each department which will store the department related information. Users in each department must be able to read and update data in the database belonging to their respective departments. No user must be able to access the database belonging to another department. James wants to configure access to the database to meet these requirements. What should James do to accomplish the task?
James should create a Windows Authentication login for each domain group and configure the logins as database users for the appropriate database. Add each database user to the db_ddladmin database role.
James should create a Windows Authentication login for each domain group and configure the logins as database users for the appropriate database. Add each database user to the db_datareader and db_datawriter database roles.
James should create a Windows Authentication login for each domain user and configure the logins as database users for the appropriate database. Add each database user to the db_ddladmin database role.
James should create a Windows Authentication login for each domain user and configure the logins as database users for the appropriate database. Add each database user to the db_datareader and db_datawriter database roles.
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?
Perform a table optimization operation.
Perform a table repair operation.
Perform a table analysis operation.
Perform a table check operation.
What is the ideal time to back up dynamic log files?
When the server is running.
You can back up dynamic log files any time.
When the server is stopped.
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 query?
A database will be created.
An error will be generated stating that a database name must begin with an alphabet and all the alphabets should be in uppercase.
An error will be generated stating that a database name must begin with an alphabet.
An error will be generated stating that a database name should be a combination of numerals and alphabets.
