Answer the following questions by circling either true (T) or false (F) 1. T Every database has more than one primary data file. 2. Т Transaction log helps to restore the database to the point where it failed. 3. Т F A login name can be disabled temporarily. 4. T The master database is a template for newly created databases. 5. T With INIT is a backup option that indicates that SQL Server will not overwrite any F existing backup on the target media. 6. Т F Under server security, you can create additional Server Roles. 7. T In simple recovery model, no differential backups are performed. 8. T A full backupof a database does not include all objects, system tables, and data. F. Log files are not part of a filegroup and are managed separately from the data space. 9. Т

Answer the following questions by circling either true (T) or false (F) 1. T Every database has more than one primary data file. 2. Т Transaction log helps to restore the database to the point where it failed. 3. Т F A login name can be disabled temporarily. 4. T The master database is a template for newly created databases. 5. T With INIT is a backup option that indicates that SQL Server will not overwrite any F existing backup on the target media. 6. Т F Under server security, you can create additional Server Roles. 7. T In simple recovery model, no differential backups are performed. 8. T A full backupof a database does not include all objects, system tables, and data. F. Log files are not part of a filegroup and are managed separately from the data space. 9. Т

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

1. What are the three stages during the startup of an Oracle database? If a copy of the control file is corrupted, which stage of the startup would fail? Briefly explains why. 2. What are the SQL statements to perform the following tasks? Create a smallfile tablespace Hw2Tbs that contains a 32MB datafile in the directory C:\app\abc\oradata\csc544744\myData Add another 8MB to tablespace Hw2Tbs
Database Transactions can occur concurrently by several users. This can cause issues with data consistency. To help resolve this problem, RDBMS can implement Read Consistency. Q4. What is Read Consistency? Q5. What are two problems that could occur without data/read consistency? 1. 2. Q6. What is Data Locking and how/why is it used? Q7. Please review the following SQL statements and answer the following questions. On which line does the first commit occur? Is this first commit implicit or explicit? Which SQL DML statement is rolled back when line 12 is run? Which SQL DML statement is committed on line 16? Is the commit in line 16 implicit or explicit? Assume 10 of the ‘SA_REP’ employees start with a salary of 1000.00. What is their salary when 17 is run? NOTE: For those of you who are familiar with programming, assume there is no infinite loop here. 1 select * from employees; 2 DROP TABLE Employee_Project_Assignment; 3 UPDATE employees 4 SET salary…
Defintion: What is the purpose of a database audit log? SQL Server uses Extended Events in a way that can be summarised in less than 60 words?
Which of the following are true about primary keys? SELECT ALL THAT APPLY. A) They must reference one or more columns in a single table. B) They are usually implemented using an index. C) They guarantee that no two rows in a table have duplicate primary key values. D) They must be defined for every database table.
1-What are the advantages of having the DBMS between the end user’s applications and the database? 2- Null values sometime can be useful and sometime can create problems. Describe the use of null values in a database. In your opinion, should null values be avoided in the database?
19. What is an indexPath?20. What are the properties of an idexpath object?21. How does a table cell reusability concept work?22. What is NSFIleManager What does insertNewObjectForEntity:inMagedObjectCntext; do?23. What is NSUserDefaults?24. Different between Core Data and Sqlite
Consider the possibility that your database system has crashed. Know how to use write-through and deferred-write database recovery methods.
Computer Science SQL Server instance goes down? How do you go about troubleshooting? Now assume you are trying to start your engine and it fails. As a DBA, what would you recommend? some variables are know to you: As per the SAN engineer, main or primary storage SAN system that contains all the current data files (system and user databases) is unavailable Latest system and user database backups are available on backup SAN system. Backup SAN can be brought online to takeover primary SAN responsibilities. Last backup was completed 30 minutes age (Hint: potential data loss) Database Server is functional and available Management is concerned about system unavailability and at the same time potential data loss
How do you define anomaly? Were there three anomalies that stood out from the others in a database? Analyze the problems and provide a solution to the problems that have been caused by the anomalies you've found.
Consider the following PL/SQL script: SET SERVEROUTPUT ON BEGIN INSERT INTO COURSE (course_no, description, created_by, created-date, modified_by, modified_date) VALUES (course_no_seq.nextval, ‘database development’, USER, SYSDATE); COMMIT DBMS_OUTPUT.PUT_LINE (‘One course has been added’); END; Assumptions: All the COURSE table fields have check constraints defined on them indicating that none can be null. Explain why the script does not execute successfully. Add a user-defined exception to the script, so that the error generated by the INSERT statement is handled. Assign the code 2290 to this exception.
Please help me answer these three questions regarding Oracle database. All are T or F. Explanation is much appreciated as well. Group functions do ignore NULL values Multiple row functions works on each records one by one and they return one result per each record Multiple row functions works on group of records all at once but they also return one result per each data set
What is the difference between SQL performance tuning and database performance tuning?What are the three phases the DBMS processes a query in? What do you do in each phase?Why is an index on every column of a table inappropriate?Where do database statistics come from?Explain what RAID stands for, and describe the levels.What is the difference between a rule-based optimizer and a cost-based optimizer?What are optimizer hints? Give an example of their use.What factors should you take into consideration when creating and using an index?What does the database do differently between optimizing DDL vs DML statements?List and describe 5 things that could cause a delay in query processing.