Premium Essay

Sql Final Exam

In: Computers and Technology

Submitted By aminou004
Words 1814
Pages 8
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 |

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 |

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 |

Commands used to modify data are called ____ commands.
A) data control language (DCL)
B) data manipulation language (DML)
C) data modification language (DML)
D) data definition language (DDL) Points Earned: | 2.0/2.0 | | Correct Answer(s): | B |

SQL*Plus can only be accessed via an internet interface.
A) True
B) False Points Earned: | 2.0/2.0 | | Correct Answer(s): | False |

The DISTINCT keyword can be used to indicate that duplicate data should be suppressed in the results of a query.
A) True
B) False Points Earned: | 2.0/2.0 | | Correct Answer(s): | True |

The precision of a NUMBER does not include the decimal point itself in the total number of digits that can be stored in a column.
A) True
B) False Points Earned: | 0.0/2.0 | | Correct Answer(s): | True |

When a role is removed from the database, users will lose any privileges assigned to them through that role.
A) True
B) False Points Earned: | 2.0/2.0 | | Correct Answer(s): | True |

Which command is used to prevent other users from making changes to a table?
D) LOCK TABLE Points Earned: | 2.0/2.0 | | Correct...

Similar Documents

Premium Essay


...also available as a concatenated page, suitable for printing or saving as a PDF for offline viewing. MET CS669 Database Design and Implementation for Business This course uses the latest database tools and techniques for persistent data and object-modeling and management. Students gain extensive hands-on experience with exercises and a term project using Oracle, SQL Server, and other leading database management systems. Students learn to model persistent data using the standard Entity-Relationship model (ERM) and how to diagram those models using EntityRelationship Diagrams (ERDs), Extended Entity-Relationship Diagrams (EERDs), and UML diagrams. Students learn the standards-based Structured Query Language (SQL) and the extensions to the SQL standards implemented in Oracle and SQL Server. Students learn the basics of database programming, and write simple stored procedures and triggers. The Role of this Course in the MSCIS Online Curriculum This is a core course in the MSCIS online curriculum. It provides students with an understanding and experience with database technology, database design, SQL, and the roles of databases in enterprises. This course is a prerequisite for the three additional database courses in the MSCIS online curriculum, which are CS674 Database Security, CS699 Data Mining and Business Intelligence and CS779 Advanced Database Management. By taking these three courses you can obtain the Concentration in Database Management......

Words: 10777 - Pages: 44

Premium Essay


...Database Design – Final Exam Study Guide Name ________________________________________________ Date ___________________ Part I Directions: Answer each question. 1. What are the benefits the Oracle 10g Database Environment provides for business? Oracle's 10g database management system gives businesses the ability to coordinate and share computing, application, data, storage, or network resources across dynamic and geographically dispersed organizations and in turn save time, resources and money. 2. What services and products does Oracle provide? Information Technology services and products. 3. What is a relational database? A relational database is a group of data stored in tables that are related by means of a common field. 4. What is the difference between application and system software? Provide an example. Systems software consists of low-level programs designed to interact with the computer hardware. Application Software is the code that allows end users to interact with computers, like for instance Firefox for browsing the internet, Microsoft Word for writing documents, Application Express for developing applications and also for accessing and manipulating data in an Oracle Database. 5. How is data extracted from the database? Data is extracted from the database by the SELECT statement. 6. Name two benefits of a career portfolio? • To organize the many details of one's experiences • To help with goal setting 7. What is the difference between a projection, a selection,...

Words: 2537 - Pages: 11

Premium Essay


...RYERSON UNIVERSITY Ted Rogers School of Information Technology Management And G. Raymond Chang School of Continuing Education COURSE OF STUDY 2013-2014 (C)ITM 500 – Data and Information Management 1.0 PREREQUISITE The prerequisite for this course is [(C)ITM100 and (C)ITM207] or (C)ITM 305. Students who do not have the prerequisite will be dropped from the course. 2.0 INSTRUCTOR INFORMATION • • • • • Name: Office Phone Number: E-mail address: Faculty/course web site(s): Office Location & Consultation hours: • Your instructor is available for personal consultation during scheduled consultation hours which are posted on their office door or on the course Blackboard site. However, you are advised to make an appointment by e-mail or by telephone before coming to ensure that the professor is not unavoidably absent. • E-mail Usage & Limits: Students are expected to monitor and retrieve messages and information issued to them by the University via Ryerson online systems on a frequent and consistent basis. Ryerson requires that any official or formal electronic communications from students be sent from their official Ryerson Email account. As such emails from other addresses may not be responded to. 3.0 CALENDAR COURSE DESCRIPTION This course provides the students with an introduction to the core concepts in data and information management. It is centered around conceptual data modeling techniques, converting the conceptual data models into......

Words: 1132 - Pages: 5

Premium Essay


...Scheme and Syllabus of B.E. (Computer Science and Engineering) 3rd TO 8th Semester 2013-2014 University Institute of Engineering and Technology, Panjab University, Chandigarh Scheme of Examination of B.E. in Computer Science & Engineering Second Year - Third Semester Subject Title Scheme of Teaching Univesity Sr.No Paper Code External L T P Hour Credits Marks s 1. CSE311 Data Structures 3 1 0 4 4 50 2. 3. 4. 5. 6. 7. 8. 9. Total Second Year -Fourth Semester Sr.No Paper Code 1. 2. 3. 4. 5. 6. CSE411 CSE461 CSE412 CSE462 CSE414 CSE464 Subject Title Scheme of Teaching L 3 0 3 0 3 0 T 1 0 1 0 1 0 P 0 3 0 3 0 3 Hours 4 3 4 3 4 3 Credit 4 2 4 2 4 2 University External Marks 50 50 50 CSE361 CSE313 CSE363 AS301 EC316 EC366 EC317 EC367 Data Structures (Practical) Peripheral Devices & Interfaces Hardware Lab (Practical) Engineering Mathematics – III Digital Electronics Digital Electronics (Practical) Microprocessors Microprocessors (Practical) 0 3 0 3 3 0 3 0 15 0 1 0 1 1 0 1 0 5 3 0 2 0 0 2 0 2 09 3 4 2 4 4 2 4 2 29 2 4 1 4 4 1 4 1 25 50 50 50 50 250 Internal Total Sessional Marks 50 50 50 50 50 50 50 50 50 450 100 50 100 50 100 100 50 100 50 700 7. 8. Total ASC405 CSE 415 Analysis & Design of Algorithms Analysis & Design of Algorithms (Practical) Database Management System Database Management System (Practical) Object Oriented Programming Object Oriented Programming (Practical) Cyber Law & IPR Computer Architecture & Organization Internal Total Sessional Marks......

Words: 14784 - Pages: 60

Premium Essay


...principles to fully utilize the organizational role of information technology. This course provides core skills of data management for the relational database management systems. This course will review the theoretical concepts and applications of a modern relational database management system. In addition to a basic theoretical presentation of the database design concepts, students will be required to design and develop a database application using a modern fourth generation language system. This course teaches students data modeling and design techniques and how to transform data models into database designs. Another basic component of this course is the use of SQL – Structured Query Language. Students will also learn how to create databases, modify databases, and develop queries using SQL. In addition, this course also teaches the management of database resources in an organization. Course Learning...

Words: 1374 - Pages: 6

Premium Essay

Database - Sql

...Final Exam Review Below are the review questions for your final exam. You MUST complete this as it is a part of your final exam equaling total of 10 points. Each question must be answered with at least 3 sentences, clearly demonstrating an understanding of the question asked. This is due on the final day in class prior to the final exam. Questions 1. What is a database? Describe the 3 main types discussed in the book. * Is a collection of related data. * Doesn’t have to be electronic; example : card catalog’s in libraries ; spiral notebook ; phone or address book * Usually mean electronic database that run on computers 2. Why is the relational database model most commonly used today? What impact does it have on data integrity? * The idea came from Edgar F Codd in 1970 he worked for IBM at the time * Advantage is the tables define the relationships among themselves by mean of repeating an attribute or column from one table in another table “called Keys” * One of the problems was data redundancy; means to store the same data in more than place in the database * Codd’s theoretical design minimized redundancy * The impact is; the complexity of the design, its easy to create a hard to use database, or hard to fine the data you entered into the database. So a well-designed database = data integrity and flexibility. 3. Distinguish between data integrity and redundancy. * Data integrity = to the accuracy and quality of the...

Words: 2656 - Pages: 11

Premium Essay

Cscc 640

...Final Exam MSCD650 Name:_________________ True/False Indicate whether the sentence or statement is true or false. ____ 1. The EXECUTE IMMEDIATE statement prepares (parses) and immediately executes a dynamic SQL statement or an anonymous PL/SQL block. ____ 2. The %TYPE feature allows you to anchor variable declarations to a column in a table. ____ 3. COMMIT and ROLLBACK end the active autonomous transaction but do not exit the autonomous routine. ____ 4. The only required sections of a PL/SQL block are BEGIN and END. ____ 5. The EXCEPTION handling section is an optional section in a PL/SQL block. ____ 6. The keyword DEFAULT can be used in place of the := symbol to assign initial values to the variables within the declaration statement. ____ 7. Declaring a table of records variable in a package specification allows it to persist for a user session. ____ 8. Implicit cursors are declared automatically for all INSERT, UPDATE, and DELETE statements issued within a PL/SQL block. ____ 9. You can process multiple rows of data from a database by creating explicit cursors. ____ 10. With an implicit cursor, Oracle closes the SQL cursor automatically after executing its associated SQL statement. As a result, %ISOPEN always yields FALSE. ____ 11. The basic loop uses the LOOP and END LOOP markers to begin and end the loop code. ____ 12. Dynamic SQL lets you write schema-management procedures that can be centralized in one schema, and can be......

Words: 1344 - Pages: 6

Premium Essay


...M I C R O S O F T T E C H N O L O G Y A S S O C I AT E Student Study Guide EXAM 98-364 Database Administration Fundamentals Preparing for MTA Certification for Cert ca n Certification MICROSOFT TECHNOLOGY ASSOCIATE (MTA TECHNOLOGY ASSOCIATE (MTA) ECHNOLOGY C (MTA A) STUDENT STUDY GUIDE FOR DEVELOPERS UDY F DEVELOPERS 98-364 Database Administration Fundamentals Authors Peggy Fisher (Web Development and Database Administration). Peggy teaches computer science at a rural high school in central, Pennsylvania. Indian Valley High School offers courses in programming (C#, VB, and Java for the AP course), and Web design (Expression Web, HTML, JavaScript, and CSS). Peggy worked for a large insurance company outside Philadelphia, Pennsylvania, prior to leaving the corporate world to join the field of education. She has been at IVHS for the past eight years and truly enjoys her new career. Peggy also teaches part-time at Pennsylvania State University in the Continuing Education program. Her goal in teaching is to instill the love of learning so that her students will graduate and become lifelong learners. Peggy is the co-author of the Web Development Exam Review Kit in the MTA Exam Review Kit series. Patricia Phillips (Lead Author and Project Manager). Patricia taught computer science for 20 years in Janesville, Wisconsin. She served on Microsoft’s National K-12 Faculty Advisory Board and edited the Microsoft MainFunction website for technology teachers for two years...

Words: 11425 - Pages: 46

Premium Essay

Cis 336 Academic Professor - Tutorialrank

...CIS 336 Entire Course: Devry University For more course tutorials visit CIS 336 Entire Course: Devry University _________________________________________ CIS 336 Final Exam 1 For more course tutorials visit 1. (TCO 1) Most DBMS are referred to as _____________database management systems. (Points : 4) elemental linked hierarchical relational 2. (TCO 1) Data constitutes the building blocks of _____________. (Points : 4) information processing applications programming 3. (TCO 2) If a foreign key contains either matching values or nulls, the table(s) that make use of such a foreign key is/are said to exhibit __________ integrity. (Points : 4) referential restrictive secondary redundant 4. (TCO 2) In a "one-to-many" relationship, which constraint is usually added to the "many" table? (Points : 4) UNIQUE PRIMARY KEY FOREIGN KEY NOT NULL __________________________________________________ CIS 336 Week 1 iLab 1 Devry University For more course tutorials visit L A B O V E R V I E W Scenario/Summary This lab will introduce you to the processes involved in defining one of the key components of a data model; the relationship diagram (RD). In this lab, you will draw a relationship diagram for two of the steps shown. Keep in mind when you are trying to decide which side of the relationship should be the "one" side and which...

Words: 689 - Pages: 3

Premium Essay

Study Guide

...® OCA Oracle Database 11g: SQL Fundamentals I Exam Guide (Exam 1Z0-051) ABOUT THE AUTHORS John Watson (Oxford, UK) works for BPLC Management Consultants, teaching and consulting throughout Europe and Africa. He was with Oracle University for several years in South Africa, and before that worked for a number of companies, government departments, and NGOs in England and Europe. He is OCP qualified in both database and Application Server administration. John is the author of several books and numerous articles on technology and has 25 years of experience in IT. Roopesh Ramklass (South Africa), OCP, is an independent Oracle specialist with over 10 years of experience in a wide variety of IT environments. These include software design and development, systems analysis, courseware development, and lecturing. He has worked for Oracle Support and taught at Oracle University in South Africa for several years. Roopesh is experienced in managing and executing IT development projects, including infrastructure systems provisioning, software development, and systems integration. About the Technical Editor Bruce Swart (South Africa) works for 2Cana Solutions and has over 14 years of experience in IT. Whilst maintaining a keen interest for teaching others, he has performed several roles including developer, analyst, team leader, administrator, project manager, consultant, and lecturer. He is OCP qualified in both database and developer roles. He has taught at Oracle University...

Words: 150089 - Pages: 601

Premium Essay


...Prerequisites and/or Co-requisites ITD132 – Structured Query Language General Education Core Competencies Supported by this Course • Critical Thinking A competent critical thinker evaluates evidence carefully and applies reasoning to decide what to believe and how to act. Page 1 of 8 • Information Literacy A person who is competent in information literacy recognizes when information is needed and has the ability to locate, evaluate, and use it effectively. Required Course Texts and Software Database Systems, 11th Edition, 2014 ISBN: 978-1285196145 (Premium access version not required) Microsoft Access software – available for use on ATC Lab computers Microsoft Visio software – available for use on ATC Lab computers Microsoft SQL...

Words: 2570 - Pages: 11

Free Essay


...[pic] [pic]   |Department of Information Technology | |WEBD341: Enterprise Data Exchange using XML | |3 Credit Hours | |8 Weeks | |Prerequisite(s): WEBD121: Web Development Fundamentals | |Table of Contents | |Instructor Information |Evaluation Procedures | |Course Description |Grading Scale | |Course Scope |Course Outline | |Course Objectives |Policies | |Course Delivery Method |Academic Services | |Resources |Selected Bibliography | |Appendix A – Professor Biography |Appendix B – Weekly Student Course Guide | |Instructor Information ...

Words: 3056 - Pages: 13

Premium Essay

Nt1230 Syllabus

...ITT Technical Institute NT1230 Client-Server Networking I Onsite Course SYLLABUS Credit hours: 4.5 Contact/Instructional hours: 56 (34 Theory Hours, 22 Lab Hours) Prerequisite(s) and/or Corequisite(s): Prerequisite or Corerequisite: NT1210 Introduction to Networking or equivalent Course Description: This course introduces operating principles for the client-server based networking systems. Students will examine processes and procedures involving the installation, configuration, maintanence, troublshooting and routine adminstrative tasks of popular desktop operating system(s) for standalone and network client computers, and related aspects of typical network server functions. Client-Server Networking I Syllabus Where Does This Course Belong? 1st QTR GS1140 NT1110 GS1145 Problem Solving Theory Computer Structure and Logic Strategies for the Technical Professional 2nd QTR NT1210 Introduction to Networking NT1230 Client-Server Networking I MA1210 College Mathematics I 3rd QTR NT1310 NT1330 MA1310 4th QTR PT1420 NT1430 EN1320 5th QTR PT2520 NT2580 EN1420 6th QTR NT2640 NT2670 CO2520 7th QTR NT2799 SP2750 Physical Networking Client-Server Networking II College Mathematics II Introduction to Programming Linux Networking Composition I Database Concepts Introduction to Information Security Composition II IP Networking Email and Web Services Communications Network Systems Administration Capstone Project Group Theory The follow diagram indicates how this course...

Words: 1834 - Pages: 8

Premium Essay

Databae Concepts Final

...Database Concepts - Final Exam B 1. Redundancy refers to what database condition? The same data is recorded in more than one place in the same database. You have more than one database devoted to the same thing. 2. Which statement best describes the function of a primary key? It uniquely identifies each record. 3. Which statement best describes the function of a foreign key? A foreign key is the primary key of one table repeated in another table in order to create a relationship between the tables. 4. What is SQL? It is the language relational databases use to create database objects and to manipulate and retrieve data. 5. A database entity can best be described as _____________. something the database is concerned with about for which data can be stored 6. Which of the following best defines the term “database requirement”? Something a database must do to fulfill its business function 7. Which of these best defines “data integrity”? The accuracy and correctness of the data in the database 8. A document that has the primary purpose of summarizing and displaying data is called a _____. report 9. The focus of a database, the business problem it is designed to solve, is called _____. the domain of the database 10. Observing people at work to see how they interact with the data is called _____. work shadowing 11. An attribute or combination of attributes that could be used as the primary key......

Words: 314 - Pages: 2

Premium Essay

Biometric Attendance System

...See discussions, stats, and author profiles for this publication at: Biometric-based attendance system with remote real-time monitoring for tertiary institutions in developing countries CONFERENCE PAPER · NOVEMBER 2013 DOI: 10.1109/NIGERCON.2013.6715633 DOWNLOADS VIEWS 86 111 4 AUTHORS, INCLUDING: U. Eze Peter Federal University of Technology Owerri 3 PUBLICATIONS 0 CITATIONS SEE PROFILE Available from: U. Eze Peter Retrieved on: 19 August 2015 Biometric-based Attendance System with Remote Realtime Monitoring for Tertiary Institutions in Developing Countries Eze Peter U., Joe-Uzuegbu C. K. A, Laz Uzoechi, Opara F.K Department Of Electrical/Electronic Engineering Federal University Of Technology, Owerri, Imo State, Nigeria,, class album. The system will easily produce required reports for both lectures and examinations. For the staff, check-in by proxy needs to be eliminated and there should be a way of monitoring and automatically appraising the staff based on check-in/out time for each working day. Remote monitoring is allowed for managers because they may have travelled out of the four walls of the institution but still needs to know what is happening in real time. Remote check-in/out is NOT allowed. One has to be within the campus in order to check-in/out of the system. However, remote monitoring is allowed...

Words: 3263 - Pages: 14