منتدى مدرسة عزيز المصرى الإعدادية للبنين
مرحباً بك فى منتدى مدرسة عزيز المصرى الاعدادية
إدارة بندر كفر الدوار التعليمية

منتدى مدرسة عزيز المصرى الإعدادية للبنين



 
الرئيسيةالبوابةمكتبة الصوراليوميةس .و .جبحـثالتسجيلدخول

شاطر | 
 

 est: Quiz: Managing Constraints

استعرض الموضوع السابق استعرض الموضوع التالي اذهب الى الأسفل 
كاتب الموضوعرسالة
وفاء السيد الابيض



عدد الرسائل : 344
تاريخ التسجيل : 21/03/2009

مُساهمةموضوع: est: Quiz: Managing Constraints    السبت 02 يونيو 2012, 17:28

anaging Constraints

Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Section 1
(Answer all questions in this section)

1. Once constraints have been created on a table you will have to live with them as they are unless you drop and re-create the table. True or False? Mark for Review
(1) Points


True


False (*)



Incorrect. Refer to Section 10 Lesson 3.


2. You can drop a column in a table with a simple ALTER TABLE DROP COLUMN statement, even if the column is referenced in a constraint. True or False? Mark for Review
(1) Points


True


False (*)



Correct


3. What mechamisn does Oracle use in the background to enforce uniqueness in Primary and Unique key constraints? Mark for Review
(1) Points


Ordered Lists


Internal Pointers


Nothing extra is created when Primary Keys and Unique Keys are created


Unique indexes are created in the background by Oracle when Primary and Unique constraints are created or enabled (*)



Correct


4. The command to 'switch off' a constraint is: Mark for Review
(1) Points


ALTER TABLE STOP CHECKING


ALTER TABLE STOP CONSTRAINTS


ALTER TABLE DISABLE CONSTRAINT (*)


ALTER TABLE PAUSE CONSTRAINT



Correct


5. All of a user's constraints can be viewed in the Oracle Data Dictionary view called: Mark for Review
(1) Points


USER_TABLES


USER_CONSTRAINTS (*)


CONSTRAINTS


TABLE_CONSTRAINTS



Correct
الرجوع الى أعلى الصفحة اذهب الى الأسفل
وفاء السيد الابيض



عدد الرسائل : 344
تاريخ التسجيل : 21/03/2009

مُساهمةموضوع: Test: Quiz: Creating Views    السبت 02 يونيو 2012, 17:34


Test: Quiz: Creating Views

Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Section 1
(Answer all questions in this section)

1. What is one advantage of using views? Mark for Review
(1) Points


To provide data dependence


To be able to store the same data in more than one place


To provide restricted data access (*)



Correct


2. Given the following CREATE VIEW statement, what data will be returned?
CREATE OR REPLACE VIEW emp_dept
AS SELECT SUBSTR(e.first_name,1,1) ||' '||e.last_name emp_name,
e.salary,
e.hire_date,
d.department_name
FROM employees e, departments d
WHERE e.department_id = d.department_id
AND d.department_id >=50;

Mark for Review
(1) Points


First character from employee first_name concatenated to the last_name, the salary, the hire_date and department_id of all employees working in department number 50 or higher.


First character from employee first_name concatenated to the last_name, the salary, the hire_date and department_id of all employees working in department number 50.


First character from employee first_name concatenated to the last_name, the salary, the hire_date and department_name of all employees working in department number 50.


First character from employee first_name concatenated to the last_name, the salary, the hire_date and department_name of all employees working in department number 50 or higher. (*)



Correct


3. A view can contain a select statement with a subquery. True or False? Mark for Review
(1) Points


True (*)


False



Correct


4. Views contain no data of their own. True or False? Mark for Review
(1) Points


True (*)


False



Correct


5. A view can contain group functions. True or False? Mark for Review
(1) Points


True (*)


False



Correct


6. Any select statement can be stored in the database as a view. True or False Mark for Review
(1) Points


True (*)


False



Correct
الرجوع الى أعلى الصفحة اذهب الى الأسفل
 
est: Quiz: Managing Constraints
استعرض الموضوع السابق استعرض الموضوع التالي الرجوع الى أعلى الصفحة 
صفحة 1 من اصل 1

صلاحيات هذا المنتدى:لاتستطيع الرد على المواضيع في هذا المنتدى
منتدى مدرسة عزيز المصرى الإعدادية للبنين :: منتديات المدرسة :: الحاسب الآلى-
انتقل الى: