Which of the following scripts is used to convert Unix-type zone files into SQL statements, and loads the time zone tables in a mysql database? A. mysql_tzinfo_to_sql B. mysql_time_to_sql C. mysql_timezone_to_sql D. mysql_tz_to_sql

You work as a Database Administrator for InfoTech Inc. The company has a database and they want you to create a design for a database that will support the enterprise’s operations and objectives. Which of the following will you use…

Which of the following enables a user to use generic methods to access a database and to focus on the coding rather than the syntax for a specific database API? A. Abstraction B. Database security C. Native auditing D. Authentication

You work as a Database Administrator for DataOneWorld Inc. Management instructs you to remove an object from the relational database management system. Which of the following statements will you use to accomplish the task? A. DROP B. SELECT C. CREATE…

You work as the Database Administrator for www.company.com. All servers on the www.company.com network run Windows Server 2003 and Windows Server 2000, and all client computers run Windows XP professional and Windows Vista. The www.company.com network area consists of a…

Consider the case of a distance education university. The university has many regional centers across the country. Each regional center has a head known as regional manager. Each regional center has allotted more than one study center in its region.…

Suzanne works as a Database Designer for DataOneWorld Inc. She is assigned the task of decomposing the components of a database, but she has to ensure that all the components are decomposed to only some extent. Which of the following…

Which of the following is used to give a default value to a column if the value for that column is unknown? A. Concurrency B. DEFAULT constraint C. Nested transaction D. Transaction

Which of the following is a design of the user interface and the application programs that use and process the database? A. Application Design B. Object Modeling C. Database Design D. Database Planning

Mark works as a Database Administrator for DataOneWorld Inc. Management instructs him to provide an additional security layer to the database to prevent unauthorized viewing of data with the help of an algorithm called cipher. Which of the following will…