Oracle 12c: SQL
3rd Edition
ISBN: 9781305251038
Author: Joan Casteel
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
error_outline
This textbook solution is under construction.
Students have asked these similar questions
Which of the following statements is most accurate? (refer to the JustLee Books database).a. Authentication procedures prevent any data stored in the Oracle 12c database from being stolen or damaged.b. Authentication procedures are used to limit unauthorized access to the Oracle 12c database.c. Oracle 12c authentication doesn’t prevent users from accessing data in the database if they have a valid operating system account.d. Authentication procedures restrict the type of data manipulation operations that a user can perform
31.
Locking may cause which of the following problems?
a.
Erroneous updates
b.
Deadlock
c.
Versioning
d.
All of the above.
Which of the following database encryption techniques makes it difficult to perform database functions (searches, indexing, etc.)?
[A] Application-level encryption
[B] File-level encryption
[C] Transparent encryption
[D] Volume encryption
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
- Which of the statements below is correct? a. Non-Oracle RDBMS use tablespaces as storage independent of database b. In Oracle, all users are given access to Tablespace. c. In Oracle, all instances use the same listener d. In Oracle, users who access the Database can all achieve the same results.arrow_forwardIf there is a database by the name StudentMarks in MongoDB then you can use use StudentMarks command to switch that database and start working on this database. But let’s assume that there is no database by the name StudentMarks in MongoDB. In this case if you still prefer use StudentMarks command than can be still OK and create the database and switch to it or would this command cause an error?Explain what happens in both scenarios?arrow_forward1. If a user has only read authorization for the database, can he modify the data in the database? 2. If a user has only read authorization for the database, can he retrieve data from the database?arrow_forward
- Which of the following statements best expresses your perspective on data security during transit and storage? Which solution provides the best data integrity and user authentication?arrow_forwardWhich of the following is a correct statement? a. A commit is issued implicitly when a user exits SQL Developer or SQLPlus. b. A commit is issued implicitly when a DDL command is executed. c. A commit is issued automatically when a DML command is executed. d. All of the above are correct. e. Both a and b are correct. f. Both a and c are correct.arrow_forwardWhat is the difference between verify and assert commands?arrow_forward
- Which of the following statements retrieves data from the Friends database and stores it in the FriendsDataSet?a. Me.FriendsDataSet.Fill(Friends.accdb)b. Me.TblNamesBindingSource.Fill(Me.FriendsDataSet)c. Me.TblNamesBindingNavigator.Fill(Me.FriendsDataSet.tblNames)d. Me.TblNamesTableAdapter.Fill(Me.FriendsDataSet.tblNames)arrow_forwardThe undo tablespace is optimized with the help of undo statistics. What, if any, value can be gleaned from undo tablespaces? Who may see and analyze statistics for the undo tablespace? Oracle 11g has stringent regulations.arrow_forwardWhat types of privileges are available in Oracle 12c? Define each typearrow_forward
- in sql User_123 has successfully logged on to the database in the past, but today he receives an error message stating that he cannot log on. What is the most likely cause of the problem? Select one: a. User_123's CREATE USER privilege has been revoked. b. User_123 's CREATE SESSION privilege has been revoked. c. User_123's user account has been removed from the database. d. One or more object privileges have been REVOKEd from User_123 .arrow_forward1. 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 Hw2Tbsarrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you