Q10
pdf
keyboard_arrow_up
School
Georgia Gwinnett College *
*We aren’t endorsed by this school
Course
4200
Subject
Information Systems
Date
Feb 20, 2024
Type
Pages
5
Uploaded by jam_1415
1/15/2021 : Quiz Submissions - QUIZ BOWL CHAPTER 10 - Advanced Databases Section 01 Fall 2020 CO - Georgia Gwinnett College Quiz Submissions - QUIZ BOWL CHAPTER 10 X Jamaima Endres (username: jendres) Attempt 1 Written: Nov 11, 2020 8:04 AM - Nov 11, 2020 8:13 AM Submission View Your quiz has been submitted successfully. Question 1 1/ 1 point Which of the following is(are) database object(s)? v | view v J sequence v Create statement v | index Question 2 1/ 1 point Which of the following statements are true concerning Oracle indexes. Select all that apply. v | You need to explicitly create the Primary Key index V| | The purpose of an index on a column is to speed up a query that uses that column \/m An Index is stored in a file separate from the table it indexes v The user must routinely perform maintenance on a table's indexes to keep them running at top performance. Question 3 1/ 1 point A sequence is part of a table https://ggc.view.usg.edu/d2l/Ims/quizzing/user/quiz_submissions_attempt.d21?isprv=&qi=2465980&ai=33683261&isInPopup=0&cfql=0&romQB=0&ou... 1/5
1/15/2021 : Quiz Submissions - QUIZ BOWL CHAPTER 10 - Advanced Databases Section 01 Fall 2020 CO - Georgia Gwinnett College used exclusively to create primary key values is the only way to create primary key values v none of the above W Hide Feedback None of the above. A sequence is a number generator that is useful for populating Primary key values but can be used for any purpose the developer wishes. Question 4 0.75 / 1 point Which of these is a characteristic of a complex view, rather than a simple view? (Choose all that apply.) w3 MAX, MIN, SUM, or COUNT in the SELECT clause = (| A'subquery within the SELECT statement v/ | Aselection of rows with a WHERE clause = /| Join of two or more tables W Hide Feedback Aggregation and joins are two characteristics which will make the view a complex view instead of a simple view. Grouping of data also creates a complex view. Question 5 1/ 1 point Which of the following are legitimate reasons for using views in a database application? (Choose all that are legitimate.) v To give the DBA something to do. /| | To provide an additional level of security. https://ggc.view.usg.edu/d2l/Ims/quizzing/user/quiz_submissions_attempt.d21?isprv=&qi=2465980&ai=33683261&isInPopup=0&cfql=0&romQB=0&ou... 2/5
1/15/2021 : Quiz Submissions - QUIZ BOWL CHAPTER 10 - Advanced Databases Section 01 Fall 2020 CO - Georgia Gwinnett College v | To simplify complex queries. | (] To prevent access to sensitive data by some users. w Hide Feedback Reasons for using views include: to enforce an additional layer of security to simplify SQL for end users to help prevent errors to the underlying data to help make complex data more comprehensible to prevent unauthorized access to sensitive data Question 6 0.75 / 1 point For which of the following, will Oracle automatically create an index? = « (| primary key column = 3 | | column defined as UNIQUE v column defined as NOT NULL v a foreign key column Question 7 1/ 1 point Which of the following statements will define a new index on the Op_key column of the CodeOps table? CREATE CodeOps.Op_Key.idx (Op_Key) References CodeOps; CREATE CodeOps_Op_key_idx ON CodeOps.Op_key; CREATE INDEX CodeOps_Op_key_idx REFERENCES CodeOps.Op_Key; «’ ) CREATE INDEX CodeOps_Op_key_idx ON CodeOps(Op_Key); https://ggc.view.usg.edu/d2l/Ims/quizzing/user/quiz_submissions_attempt.d21?isprv=&qi=2465980&ai=33683261&isInPopup=0&cfql=0&fromQB=0&ou... 3/5
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
1/15/2021 : Quiz Submissions - QUIZ BOWL CHAPTER 10 - Advanced Databases Section 01 Fall 2020 CO - Georgia Gwinnett College Question 8 1/ 1 point The term meta-data means distributed data global data that is accessible throughout the database v data about data data that is automatically updated and maintained Question 9 1/ 1 point One place to get a master list of all of the views that form the data dictionary is: v ) DICTIONARY DATA_DICTIONARY USER_DICTIONARY USER_CATALOG W Hide Feedback It is just plain DICTIONARY. You can issue the command: DESC DICTIONARY to see the columns that form this view and query it for additional information. Question 10 1/ 1 point Which of the following will not cause the contents of the data dictionary to be changed in some way? v create a new table Vv modify the data type of an existing column Vv add a new sequence https://ggc.view.usg.edu/d2l/Ims/quizzing/user/quiz_submissions_attempt.d21?isprv=&qi=2465980&ai=33683261&isInPopup=0&cfql=0&romQB=0&ou... 4/5
1/15/2021 : Quiz Submissions - QUIZ BOWL CHAPTER 10 - Advanced Databases Section 01 Fall 2020 CO - Georgia Gwinnett College v | none of the above W Hide Feedback All of thee will cause some kind of change to the information in the data dictionary. Any DDL that creates or modifies objects will update the object listings in the data dictionary. Attempt Score: 9.5/10-95% Overall Grade (highest attempt): 9.5/10-95% Done https://ggc.view.usg.edu/d2l/Ims/quizzing/user/quiz_submissions_attempt.d2I?isprv=&qi=2465980&ai=33683261&isInPopup=0&cfql=0&fromQB=0&ou... 5/5