Question 11 Which of the following is a legal character in the Oracle Naming Sta

Question

Question 11 Which of the following is a legal character in the Oracle Naming Standard? a. % b. ^ c. # d. * 2 points Question 12 ____ commands are used to add new database objects. a. DML b. DDL c. DCL d. XML 2 points Question 13 On which line would a command using the following syntax fail? 1 UPDATE table_name 2 WHERE column-name = condition_to_be_met 3 SET column_name = new_value 4 ; a. 1 b. 2 c. 3 d. 4 2 points Question 14 A user schema contains all database objects created by a user. True False 2 points Question 15 When two fields are combined to form a unique value, this is known as a ____ key. a. double b. composite c. surrogate d. foreign 2 points Question 16 A(n) ____ stores all organizational data in a central location. a. databaseadministrator b. record c. database d. index 2 points Question 17 The CHAR and VARCHAR2 data types store Unicode character data. True False 2 points Question 18 A student can take many different classes in the same term, and each class can be composed of many different students; this is an example of a many-to-many relationship. True False 2 points Question 19 Duplicate values will automatically be suppressed from query results unless you specify otherwise. True False 2 points Question 20 What character is used to retrieve all columns in a table? a. % b. & c. * d. # 2 points Question 21 Which command is used to give a user permission to alter another user’s table? a. ADD b. GIVE c. GRANT d. ALTER 2 points Question 22 Which of the following is not created using an integrity constraint? a. foreign key b. primary key c. composite key d. surrogate key 2 points Question 23 Redundant data is a big problem because it can become inconsistent. True False 2 points Question 24 What is meant by the term "transaction processing"? a. processing over a network b. processing by a bank or other financial institution c. grouping database changes into one unit of work that must succeed or fail together d. pre-processing data with a separate program before it is saved in the database 2 points Question 25 You can choose to increment a sequence by a number other than 1 when each next value is retrieved. True False 2 points Question 26 If no candidate keys exist in a table, which of the following is used? a. surrogate key b. dummy key c. foreign key d. index key 2 points Question 27 What will happen when the following query is executed: UPDATE student SET s_class='SR'; a. All records in the student table will be updated b. No records in the student table will be updated c. An error will occur d. The first record in the student table will be updated 2 points Question 28 The SYSDATE function supplies the current date from the system. True False 2 points Question 29 As a general rule, database developers should use a personal database only for ____ applications. a. business b. experimental c. mission-critical d. non-mission-critical 2 points Question 30 Which of the following is not required when creating a table? a. table size b. table name c. column names d. column data types 2 points Question 31 To view the time to a date on a report/screen, use the format model ____. a. TO_DATE('08/29/2012 6:00 PM', 'MM/DD/YYYY HH:MI PM') b. TO_CHAR('08/29/2012 6:00 PM', 'MM/DD/YYYY HH:MI PM') c. TO_DATE('08/29/2012 6:00 PM', 'MM/DD/YYYY HH:MM PM') d. TO_DATE('6:00 PM', 'HH:MM PM') 2 points Question 32 Which command is used to disable the constraint named faculty_loc_id_fk in the faculty table? a. MODIFY TABLE CONSTRAINT DISABLE faculty_loc_id_fk; b. ALTER TABLE faculty DISABLE faculty_loc_id_fk; c. MODIFY TABLE faculty DISABLE faculty_loc_id_fk; d. ALTER TABLE faculty DISABLE CONSTRAINT faculty_loc_id_fk; 2 points Question 33 The Oracle DBMS stores columns of all data types in the same amount of space. True False 2 points Question 34 To add data to the database, use the ____ command. a. OPEN b. ADD c. ADD_DATA d. INSERT 2 points Question 35 The following search condition would match the column value “Sunday”: WHERE value LIKE ‘Sun%’ True False 2 points Question 36 A ____ key is a field in a relational database table whose value must be unique for each row. a. foreign b. primary c. secondary d. link 2 points Question 37 The Truncate TABLE command does not write any data to the transaction log. True False 2 points Question 38 A composite key only has one column True False 2 points Question 39 Which command would correctly insert the SYSDATE into the table using MM-DD-YYYY format? a. INSERT INTO TABLE (MYDATE) VALUES (TO_CHAR(SYSDATE), 'MM-DD-YYYY')) b. INSERT INTO TABLE (MYDATE) VALUES (TO_DATE(SYSDATE), 'MM-DD-YYYY'); c. INSERT INTO TABLE (MYDATE) VALUE (SYSDATE); d. INSERT INTO TABLE (MYDATE) VALUE (TO_DATE(SYSDATE), 'MM-DD-YYYY')) 2 points Question 40 When declaring a NUMBER data type, scale is the total number of digits both to the left and to the right of the decimal point. True False 2 points Question 41 A personal database like Microsoft Access should only be used for non-mission-critical applications. True False 2 points Question 42 A ____ key is a column that you create to be the record’s primary key identifier. a. foreign b. secondary c. surrogate d. composite 2 points Question 43 What is the correct command used to insert today's date into a date field/type on a table ? a. INSERT INTO TABLE (TODAYSDATE) VALUES (GETDATE()); b. INSERT INTO TABLE (TODAYSDATE) VALUES (SYSDATE); c. INSERT INTO TABLE (TODAYSDATE) VALUES (CURRDATE); d. INSERT INTO TABLE (TODAYSDATE) VALUES (DATE()); 2 points Question 44 A ____ dependency means that a field is dependent on another field within the table that is not the primary key field. a. indirect b. direct c. transitive d. partial 2 points Question 45 How would you tell what constraints exist within your user schema? a. DESCRIBE USER_TABLES; b. DESCRIBE USER_CONSTRAINTS; c. SELECT CONSTRAINT_NAME FROM USER_CONSTRAINTS; d. SELECT CONSTRAINTS FROM USER_OBJECTS; 2 points Question 46 In a data file, fields are also called ____. a. columns b. records c. rows d. entities 2 points Question 47 Which of the following declares a column named “name” that always contains exactly 30 characters? a. VARCHAR2(30) name b. CHAR(30) name c. name VARCHAR2(30) d. name CHAR(30) 2 points Question 48 If you omit the search condition in the delete query no record will be deleted. True False 2 points Question 49 When viewing this date 07/28/2012 on a report/screen, which format model will be used? a. TODATE('07/28/2012', 'MM/DD/YYYY') b. TO_CHAR('07/28/2012', 'MM/DD/YYYY') c. TOCHAR('07/28/2012', 'MM/DD/YYYY') d. TO_DATE('07/28/2012', 'MM/DD/YYYY') 2 points Question 50 Using the CHAR data type causes a column value to be padded to the maximum declared size of the column. True False 2 points Click Save and Submit to save and submit. Click Save All Answers to save all answers.

Explanation / Answer

Question 11 Which of the following is a legal character in the Oracle Naming Standard?

Ans: c. #

Question 12 ____ commands are used to add new database objects.

Ans: DML

Question 14 A user schema contains all database objects created by a user.
Ans: FALSE. It is nothing but subpart of data and consists of defalut objects and data also.

Question 15 When two fields are combined to form a unique value, this is known as a ____ key
Ans: d. foreign

16 A(n) ____ stores all organizational data in a central location
Ans: c. database

Question 17 The CHAR and VARCHAR2 data types store Unicode character data.

Ans: True.

Question 18 A student can take many different classes in the same term, and each class can be composed of many different students; this is an example of a many-to-many relationship.
Ans: True

Question 19 Duplicate values will automatically be suppressed from query results unless you specify otherwise.
Ans: False

Question 20 What character is used to retrieve all columns in a table?

Ans: c.*

Question 21 Which command is used to give a user permission to alter another user’s table?
Ans:c. GRANT

Question 22 Which of the following is not created using an integrity constraint?
Ans: a. foreign key

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.