Sql Final Exam Essay

1826 words - 8 pages

1.
Which of the following SQL statements will create a new role named PRCLERK?
A) CREATE prclerk;
B) CREATE ROLE prclerk;
C) CREATE ROLE prclerk ON payroll;
D) CREATE ROLE prclerk WITH SELECT ANY TABLE PRIVILEGE;
Points Earned: | 2.0/2.0 | |
Correct Answer(s): | B |

2.
The asterisk symbol (*) can be used in a SELECT statement to indicate that all rows in the table should be displayed in the results.
A) True
B) False
Points Earned: | 2.0/2.0 | |
Correct Answer(s): | False |

3.
An index is implicitly created when a NOT NULL constraint is added to a table.
A) True
B) False
Points Earned: | 2.0/2.0 | |
Correct Answer(s): | False |

4.
Commands used to ...view middle of the document...

The ____ constraint prevents the user from adding a NULL value in the specified column.
A) IS NULL
B) NOT NULL
C) NULL
D) NULL KEY
Points Earned: | 2.0/2.0 | |
Correct Answer(s): | B |

11.
The ALTER TABLE command with the ENABLE clause can be used to enable a constraint.
A) True
B) False
Points Earned: | 2.0/2.0 | |
Correct Answer(s): | True |

12.
Which of the following symbols can be used in a column name?
A) %
B) *
C) #
D) '
Points Earned: | 2.0/2.0 | |
Correct Answer(s): | C |

13.
The REFERENCE constraint is used to ensure that a data value meets a specified condition before a record is added to a table.
A) True
B) False
Points Earned: | 2.0/2.0 | |
Correct Answer(s): | False |

14.
To indicate which database table contains the data to be selected by a query, the table name should be listed in the ____ clause.
A) SELECT
B) FROM
C) WHERE
D) HAVING
Points Earned: | 0.0/2.0 | |
Correct Answer(s): | B |

15.
The ALTER TABLE name can be used to rename a table.
A) True
B) False
Points Earned: | 0.0/2.0 | |
Correct Answer(s): | False |

16.
Which of the following are examples of object privileges?
A) SELECT and UPDATE
B) CREATE USER and CREATE TABLE
C) UPDATE ANY TABLE and ALTER ANY TABLE
D) all of the above
Points Earned: | 0.0/2.0 | |
Correct Answer(s): | A |

17.
A database must be shut down before the ALTER TABLE command can be executed.
A) True
B) False
Points Earned: | 2.0/2.0 | |
Correct Answer(s): | False |

18.
The UPDATE command can be used to add data to existing rows in a table.
A) True
B) False
Points Earned: | 2.0/2.0 | |
Correct Answer(s): | True |

19.
When solving arithmetic expressions, Oracle11g always resolves addition and subtraction operations first from left to right in the expression.
A) True
B) False
Points Earned: | 2.0/2.0 | |
Correct Answer(s): | False |

20.
The password for a user can be set with the PASSWORD clause of the CREATE USER command.
A) True
B) False
Points Earned: | 0.0/2.0 | |
Correct Answer(s): | False |

21.
Which of the following sequence settings cannot be changed with the ALTER SEQUENCE command?
A) INCREMENT BY
B) START WITH
C) NOCACHE
D) NOMAXVALUE
Points Earned: | 2.0/2.0 | |
Correct Answer(s): | B |

22.
Which of the following is used to determine the correct organization for data that is to be stored in a database?
A) E-R model
B) normalization process
C) systems implementation and review
D) systems analysis
Points Earned: | 2.0/2.0 | |
Correct Answer(s): | B |

23.
The WITH GRANT OPTION is required to allow a user to grant the specified object privileges to other users.
A) True
B) False
Points Earned: | 2.0/2.0 | |
Correct Answer(s): | True |

24.
Which of the following is the standard abbreviation for the constraint FOREIGN KEY?
A) fkey
B) fk
C) fky
D) frk
Points Earned: | 2.0/2.0 | |
...

Other Papers Like Sql Final Exam

Principles Of Information Security Essay

3291 words - 14 pages Learning reserves the right to remove additional content at any time if subsequent rights restrictions require it. xxviii Preface Special Thanks The authors wish to thank the editorial and production teams at Course Technology. Their diligent and professional efforts greatly enhanced the final product: Natalie Pashoukos, Product Manager Lynne Raughley, Developmental Editor Steve Helba, Executive Editor Brooke Greenhouse, Content

Computer System Security Essay

3291 words - 14 pages Learning reserves the right to remove additional content at any time if subsequent rights restrictions require it. xxviii Preface Special Thanks The authors wish to thank the editorial and production teams at Course Technology. Their diligent and professional efforts greatly enhanced the final product: Natalie Pashoukos, Product Manager Lynne Raughley, Developmental Editor Steve Helba, Executive Editor Brooke Greenhouse, Content

Freedom And Responsibility

2141 words - 9 pages states. For the most part, the protester have their head down as the pepper spray was being sprayed, but eleven students were hit directly in the face with the spray. Two protesters were taken to the hospital and the others were treated on scene. After the pepper spray event, ten people were arrested. (Outcry After Police, 2011) The final precept is “Congress shall make no law abridging to petition the Government for a redress of grievances.” So

Hate Crime Laws

2348 words - 10 pages On June 7, 1998, 49-year-old James Byrd Jr. of Texas accepted a ride from three white men, who then beat him severely, urinated on him, chained him by his ankles to the back of their pick-up truck, dragged him for three miles into the countryside, and dumped his corpse in front of an African-American cemetery (Graczyk). A little over a year later, a jury sentenced ring leader John King to death by lethal injection (“Man Executed for Dragging

Rational Emotional Behavior Therapy Case Study Conceptualization And Treatment Plan

2140 words - 9 pages Rational Emotional Behavior Therapy Case Study of Sarah: A Conceptualization and Treatment Plan Rational emotive behavior therapy, REBT, was developed by Albert Ellis and holds the central belief that the events in our lives do not cause our disturbances but that they are instead caused by our view of the events (Murdock, 2009). Murdock (2009) states that “people are seen as responsible for their behavior” (p. 279) but, because they are

Holidays In Albania

1636 words - 7 pages Have you ever thought about having exciting and incredibly cheap vacations? Albania might be the right choice. According to My Travel Guide, Albania is ranked the fourth among ten places worth visiting in Eastern Europe (“Top 10 Eastern European Destinations”). One can encounter three kinds of vacations in this Mediterranean country: winter, summer, and cultural. The ideal places to spend your winter vacations are the Albanian Alps. They are

A Heart Of Darkness

1748 words - 7 pages In this short story, there are frequent significant subject and ideas that make the story, "A Heart of Darkness," by Joseph Conrad, and haunting novel. The main theme is absolute white power over the natives. The theme validates the corruption, and the dependence caused by the white people as they took over the Congo. White men were giving all the power; they had no self-control, and in the end they did not use wisely. The white men became

The Aspects Of Vulnerability Among The Exploited In Medical Research

2287 words - 10 pages Essentially, everyone is in some state of vulnerability. However, some of us are more susceptible to harm due to our vulnerabilities. The susceptible are the individuals with the greatest risk. These individuals risk the loss of their autonomy, and maybe even their lives. Vulnerable populations can be found in every subset of society. However, as previously mentioned, there are some vulnerable populations that are at an even greater risk than

The Hitchhiker’S Guide To The Galaxy

1171 words - 5 pages The Hitchhiker’s Guide to the Galaxy As the human race makes life-changing discoveries, it is made apparent that there is always more to learn as the universe, instead of becoming familiar, is becoming absurd. The Hitchhiker’s Guide to the Galaxy, written by Douglas Adams, as well as the 2005 film adaption, portrays absurdity to be an all-encompassing system in the universe. Through the introduction and attempt to understand lack of reason, the

The Ford Motor Company Wage Increase Of 1914 And The Theory Of Incentives And Efficiency Wages

1252 words - 6 pages ‘It’s not the employer who pays the wages. Employers only handle the money. It is the customer who pays the wages’ (Henry Ford, cited in Johnson and Weinstein 2004, p. 2). When the Ford Motor Company announced that it would more than double the wages of its workers in January 1914 to a ‘five-dollar day’ minimum, was this a contradiction to Henry Ford’s statement? If customers are actually the ultimate payers of wages, then more than

Historical Analysis Of The Economical Breakthroughs Of The Industrial Revolution

1396 words - 6 pages A Historical Analysis of the Economical Breakthroughs of the Industrial Revolution During the Industrial Revolution, many elements of society experienced huge breakthroughs that would change the way they functioned forever. Economics were definitely one of them. With many new inventions and many factories appearing, many, many, more resources were being created than ever before. Also, all of the revenue from these resources was being given to

Related Essays

Computer Tricks Essay

3238 words - 13 pages activities, and homework assignments along with a final cumulative project. • Final Exam: This exam provides a comprehensive assessment of Web Applications and Data Servers content. Cengage Learning Information Security Community Site This site was created for learners and instructors to find out about the latest in information security news and technology. Visit community.cengage.com/infosec to: • Learn what’s new in information security

Project In Management Essay

4938 words - 20 pages out might want to also consider earning certifications. The entry-level Microsoft Technology Associate credential is available to candidates who pass a database fundamentals exam covering SQL Server 2008. Additionally, prospective SQL programmers will need good communication skills, as well as the ability to work independently or collaborate with team members when necessary. They should also have excellent time management skills and the multi

Information Technology Exam Essay

2665 words - 11 pages SMGT 335 Exam 2 Lorie LaPorta How does a relational database organize data, and how does it differ from on object-orientated database? (10 points) Relational databases are organized into two-dimensional tables called relations with rows and columns. Each business entity will have its own table. For instance, one table is used for suppliers, and another table used for customers. Object orientated databases are more versatile. Not only do

Principles Of Information Security Essay

3241 words - 13 pages production teams at Course Technology. Their diligent and professional efforts greatly enhanced the final product: Natalie Pashoukos, Product Manager Lynne Raughley, Developmental Editor Steve Helba, Executive Editor Brooke Greenhouse, Content Project Manager In addition, several professional and commercial organizations and individuals have aided the development of the textbook by providing information and inspiration, and the authors wish