QUESTION 1 Which relationship type cannot be physically represented in the datab
ID: 3866058 • Letter: Q
Question
QUESTION 1 Which relationship type cannot be physically represented in the database and requires the use of a link table? one-to-one many-to-one one-to-many many-to-many 1.5 points Saved QUESTION 2 Each SQL*Plus command is terminated with a(n) ____. period semicolon colon exclamation mark 1.5 points Saved QUESTION 3 What part of the query contains the join condition when joining two tables (SQL-92)? SELECT FROM WHERE GROUP BY 1.5 points Saved QUESTION 4 First normal form means that the data has been organized in such a manner that it has a primary key and no repeating groups. True False 1.5 points Saved QUESTION 5 What keyword is added to the select command to retrieve only unique data? UNIQUE NODUP DISTINCT ONLY 1.5 points Saved QUESTION 6 The more common name for a natural join is a(n) ____. inner join outer join multi-join bi-join 1.5 points Saved QUESTION 7 What is the difference between deleting all records from a table and truncating the table? Deleting is faster Truncating does not save roll back information while delete does Only a DBA can truncate, anyone can delete Delete does not save roll back information while truncate does 1.5 points Saved QUESTION 8 The purpose of normalization is to store data efficiently in the least possible amount of space. True False 1.5 points Saved QUESTION 9 Assuming a table has several records, if you omit the search condition in the delete query no record will be deleted. True False 1.5 points Saved QUESTION 10 How does Oracle keep sequence information unique for each user? Only one user has access to a sequence Using user session Each user has a private copy of the sequence It is not always unique - there is a possibility that two users may receive the same sequence number 1.5 points Saved QUESTION 11 If a cursor is named location_cursor, and you are using a LOOP . . . EXIT WHEN loop to process the cursor, what is the exit condition for the loop? location_cursor. DONE location_cursor. EOF location_cursor. NOTFOUND location_cursor%NOTFOUND 1.5 points Saved QUESTION 12 Which of the following is true when decreasing the maximum size of a CHAR column? it is an unrestricted action it is only permitted if all values are NULL all values in the column will be truncated to the new size all values larger than the new size will be automatically set to NULL 1.5 points Saved QUESTION 13 To match a null value use ____. <> NULL != NULL IS NULL IS 0 1.5 points Saved QUESTION 14 There are two main tasks involved with the design of a database: developing an entity-relationship (ER) model and regulating the database tables. True False 1.5 points Saved QUESTION 15 In a PL/SQL decision control structure the program code following the ____ statement executes when the condition is false. DONE IF ELSE END IF 1.5 points Saved QUESTION 16 Given: Table - StudentData Field - Name Data - John Smith How would we get only the first name in the Name field above? SELECT Name FROM StudentData; SELECT SUBSTR(Name, 1,INSTR(Name,' ')) FROM StudentData; SELECT LEFT(2,5,NAME) FROM StudentData; SELECT FirstName FROM StudentData; 1.5 points Saved QUESTION 17 ____ constraints define specific data values or data ranges that must be inserted into columns and whether values must be unique or not NULL. Value Integrity Redundancy Range 1.5 points Saved QUESTION 18 The end of each PL/SQL command is marked with a . (period). True False 1.5 points Saved QUESTION 19 What loop control structure uses an automatically incremented numeric counter? Numeric FOR WHILE . . . LOOP LOOP . . . EXIT LOOP . . . EXIT WHEN 1.5 points Saved QUESTION 20 Which of the following is used to represent entities in ER models? squares lines circles diamonds 1.5 points Saved QUESTION 21 A join is normally used to retrieve data from two tables that are related via a foreign key relationship. True False 1.5 points Saved QUESTION 22 Which command is used to give a user permission to alter another user's table? ADD GIVE GRANT ALTER 1.5 points Saved QUESTION 23 When you use the ____ logical operator to create a complex search condition, only one of the conditions must be true for the complex search condition to be true. OR AND XOR NOT 1.5 points Saved QUESTION 24 Which command is used to disable the constraint named faculty_loc_id_fk in the faculty table? MODIFY TABLE CONSTRAINT DISABLE faculty_loc_id_fk; ALTER TABLE faculty DISABLE faculty_loc_id_fk; MODIFY TABLE faculty DISABLE faculty_loc_id_fk; ALTER TABLE faculty DISABLE CONSTRAINT faculty_loc_id_fk; 1.5 points Saved QUESTION 25 In database terminology, a(n) ____ is an object about which you want to store data. component record file entity 1.5 points Saved QUESTION 26 In a subquery, the inner query executes once before the main query? True False 1.5 points Saved QUESTION 27 MIN is a single-row function. True False 1.5 points Saved QUESTION 28 To find all rows with NULL values for the column grade, your where condition would be: WHERE grade EQUALS '' True False 1.5 points Saved QUESTION 29 Which of the following data types is used to store variable length ASCII character data? CHAR NCHAR VARCHAR2 NVARCHAR2 1.5 points Saved QUESTION 30 What keyword comes first in a PL/SQL program? END BEGIN DECLARE EXCEPTION 1.5 points Saved QUESTION 31 When you declare a variable with data type NUMBER, what is the value before you assign a value? 0 -1 1 NULL 1.5 points Saved QUESTION 32 ____ commands are used to add new database objects. DML DDL DCL XML 1.5 points Saved QUESTION 33 What is the term for reversing changes to a database? undo roll back delete backup 1.5 points Saved QUESTION 34 If a = TRUE and b = FALSE, which of the following statements is TRUE? a AND b a OR b NOT a All of the above 1.5 points Save Answer QUESTION 35 Which command would be used to delete table x and all foreign key constraints to x? delete x delete x cascade constraints drop x drop x cascade constraints 1.5 points Saved QUESTION 36 A customer database table with columns first_name, last_name, and phone_number would probably need to use a surrogate key. True False 1.5 points Saved QUESTION 37 You must use a table alias when creating a self-join. True False 1.5 points Saved QUESTION 38 What keyword is not used in a PL/SQL program? UPDATE COMMIT ROLLBACK ALTER 1.5 points Saved QUESTION 39 Which of the following declares a column named "name" that always contains exactly 30 characters? VARCHAR2(30) name CHAR(30) name name VARCHAR2(30) name CHAR(30) 1.5 points Saved QUESTION 40 The ____ data type stores variable-length character data. CHAR VARCHAR VARCHAR2 STRING2 1.5 points Saved QUESTION 41 When you use the insert command, you must specify column names. True False 1.5 points Saved QUESTION 42 Which of the following is not created using an integrity constraint? foreign key primary key composite key a sequence 1.5 points Saved QUESTION 43 Given: sal value is 3000 What will be the result of this statement? SELECT TO_CHAR(sal,'$99,999') Salary FROM table 99,999 $30,000 03,000 $3,000 1.5 points Saved QUESTION 44 The EXECUTION Section of a PL/SQL is required. True False 1.5 points Saved QUESTION 45 What is the preferred data type for primary key fields? text date numeric character 1.5 points Saved QUESTION 46 The = operator is used by an exact search condition. True False 1.5 points Saved QUESTION 47 What is a disadvantage of using a personal database over a network? slow creates a lot of network traffic hard to save data not secure 1.5 points Saved QUESTION 48 Which of the following is false about triggers? Triggers are automatically called by the system. You can call triggers from a stored procedure because they are also stored in the database. Triggers can call other stored PL/SQL procedures or functions. Triggering events include; INSERT, UPDATE, and/or DELETE 1.5 points Saved QUESTION 49 The following search condition would match the column value "Sunday": WHERE value LIKE 'Sun%' True False 1.5 points Saved QUESTION 50 Almost all relational database vendors support the ____ ANSI standard. SQL-88 SQL-92 SQL-93 SQL-99 1.5 points Saved QUESTION 51 Duplicate values will automatically be suppressed from query results unless you specify otherwise. True False 1.5 points Saved QUESTION 52 Which of the following column data type changes is permitted? DATE to CHAR VARCHAR2 to CHAR CHAR to NUMBER NUMBER to DATE 1.5 points Saved QUESTION 53 What loop is a pretest only loop? Numeric FOR WHILE . . . LOOP LOOP . . . EXIT LOOP . . . EXIT WHEN 1.5 points Saved QUESTION 54 Which statement would be used to select all students with more than one grade? WHERE COUNT(grade) > 1 WHERE COUNT(grade) >= 1 HAVING COUNT(grade) > 1 HAVING COUNT(grade) >= 1 1.5 points Saved QUESTION 55 Which of the following is not automatically transferred to a new table name upon renaming a table? indexes constraints views privileges 1.5 points Saved QUESTION 56 A table is in 2NF if it fulfills these two conditions: it is in 1NF, and it has ____ dependencies. no partial no total all partial all total 1.5 points Saved QUESTION 57 Which query is executed first in a nested subquery? The innermost query The outermost query The main query The fastest query 1.5 points Saved QUESTION 58 A ____ key is any column that could be used as the primary key. surrogate foreign possible candidate 1.5 points Saved QUESTION 59 Which of the following LOOPs will be entered at least once? WHILE loop Simple LOOP FOR loop Cursor FOR loop 1.5 points Saved QUESTION 60 The inner query of a subquery must be enclosed in parentheses? True False 1.5 points Saved QUESTION 61 Relationships between entities in database tables are created using integrity constraints. True False 1.5 points Saved QUESTION 62 SQL command words are also known as ____. Java commands terms code words reserved words 1.5 points Saved QUESTION 63 Who typically installs and maintains a database? the project leader a manager a dba any programmer 1.5 points Saved QUESTION 64 A foreign key value must exist in the table where it is a primary key. True False 1.5 points Saved QUESTION 65 In Oracle, you can use a(n) ____ to automatically generate surrogate keys. algorithm generating key link sequence 1.5 points Saved QUESTION 66 Given the character string 'I am a yellow dog" in variable c_str, what would be the expected value of the c_substr variable after the following commands are executed: yellow_pos := instr(c_str, 'yellow'); c_substr := substr(c_str, 1, yellow_pos); 'I' 'I am a y' I am a' 'I am a ' 1.5 points Saved QUESTION 67 To remove trailing spaces, use the ____ function. RTRIM LTRIM RPAD LTRAIL 1.5 points Saved QUESTION 68 The CHAR data type stores fixed-length character data up to a maximum size of ____ characters. 2,000 4,000 10,000 unlimited 1.5 points Saved QUESTION 69 When declaring a variable that has the same data type as a field, use the ____ type. %FIELD %COLUMN %TYPE %ROWTYPE 1.5 points Save Answer QUESTION 70 The ____ constraint specifies whether the user must enter a column for a specific record, or whether the value can be NULL (indeterminate or unknown). INDEF INPUT NULL NOT NULL 1.5 points Save Answer QUESTION 71 A transitive dependency means that the fields within the table are dependent only on part of the primary key. True False 1.5 points Saved QUESTION 72 To declare a variable in PL/SQL use the following: DECLARE myVariable VARCHAR(10) = 'I LUV DB' myVariable VARCHAR(10) =: 'I LUV DB' myVariable VARCHAR(10) :=: 'I LUV DB' myVariable VARCHAR(10) := 'I LUV DB' 1.5 points Saved QUESTION 73 Which of the following sql commands adds a new VARCHAR2 column of length 20 named new_column to table test? ALTER TABLE test ADD (new_column VARCHAR2(20)) ADD column new_column VARCHAR2(20) to TABLE test ADD to TABLE test (new_column VARCHAR2(20)) ALTER TABLE test (new_column VARCHAR2(20)) 1.5 points Saved QUESTION 74 Which of the following pieces of information about a table is not displayed when using the DESCRIBE command? column name column data type not null settings table constraints 1.5 points Saved QUESTION 75 If no candidate keys exist in a table, which of the following is used? surrogate key dummy key primary key index key 1.5 points Saved QUESTION 76 What is the result of selecting CONCAT(s_first, s_last) from student where s_first is "Emily" and s_last is "Smith" Emily Smith EmilySmith Emily Smith 1.5 points Saved QUESTION 77 Which operator is used with a subquery that returns multiple values? = <> IN ON 1.5 points Saved QUESTION 78 It is necessary to use the TO_DATE function and a format model to insert "01-JAN-2005" into a date column. True False 1.5 points Saved QUESTION 79 The ____ TABLE command is used to modify an existing column's data declaration. CHANGE RESET MODIFY ALTER 1.5 points Saved QUESTION 80 To assign a value to a variable, use the ____ operator. = := =: = = 1.5 points Saved QUESTION 81 What would be the value of variable str_length after executing the following: str_length := LENGTH('123345'); 2 3 6 8 1.5 points Saved QUESTION 82 To connect information about different entities, you must create ____, which are links that show how different records are related. relationships records rows foreign keys 1.5 points Saved QUESTION 83 In a SQL query, the search condition begins with ____. WHERE FROM BY COND 1.5 points Saved QUESTION 84 DDL queries may be used in PL/SQL programs. True False 1.5 points Saved QUESTION 85 What will be the results in the Name column: INSERT INTO StudentData VALUES (1,'John Smith','55 Street','Columbus','OH','43215-0984') 55 Street John John Smith John A. Smith 1.5 points Saved QUESTION 86 You must include a ____ at the end of a PL/SQL command. , : ; . 1.5 points Saved QUESTION 87 What section of a PL/SQL program is used for exception handling? BEGIN DECLARE EXCEPTION ERROR Given: CREATE TABLE StudentData ( StudentID NUMBER, Address VARCHAR2(50), Name VARCHAR2(50), City VARCHAR2(50), State CHAR(2), Zip VARCHAR2(10) ) 1.5 points Saved QUESTION 88 The query INSERT INTO student ____ ('abc', '123'); inserts a new row into the student table. VALUE COLS ROWS VALUES 1.5 points Saved QUESTION 89 ____ data takes up extra storage space. Inconsistent Redundant Overused Foreign 1.5 points Saved QUESTION 90 Using the CHAR data type causes a column value to be padded to the maximum declared size of the column. True False 1.5 points Saved QUESTION 91 A ____ key is a unique key that you create by combining two or more columns. composite primary foreign secondary 1.5 points Saved QUESTION 92 ____ relationships are rare in a relational database; usually you work with ____ relationships. One-to-many, one-to-one One-to-one, one-to-many One-to-one, many-to-one Many-to-one, many-to-many 1.5 points Saved QUESTION 93 It is necessary to use the TO_CHAR function and a format model to display"01/01/2007" from an SQL Select Query. True False 1.5 points Saved QUESTION 94 In a subquery, the results of the main query is used by the subquery? True False 1.5 points Saved QUESTION 95 What will happen when the following query is executed: UPDATE student SET s_class='SR'; All records in the student table will be updated No records in the student table will be updated An error will occur The first record in the student table will be updated 1.5 points Saved QUESTION 96 Oracle11g stores character data in VARCHAR2 and CHAR columns using ____ encoding. Unicode ASCII EBCDIC Java 1.5 points Saved QUESTION 97 Which of the following characterizes unnormalized data? does not have a foreign key identified does not have a primary key identified and/or contains repeating groups has transitive dependencies has partial dependencies 1.5 points Saved QUESTION 98 Which of the following does not match the string '_T%' when used with the LIKE operator? MT MTW T MTWRF 1.5 points Saved QUESTION 99 A ____ key is a field in a relational database table whose value must be unique for each row. foreign primary secondary unique 1.5 points Saved QUESTION 100 ____ is the default date format. YY-DD-MON DD-MON-YY DD-MON-YYYY MON-DD-YYYY
Explanation / Answer
Question 1:Which relationship type cannot be physically represented in the database and requires the use of a link table
Ans: many-to-many
Question 2:Each SQL*Plus command is terminated with a(n) ____.
Ans: semicolon
Question 3:What part of the query contains the join condition when joining two tables (SQL-92)? SELECT FROM WHERE GROUP BY
Ans:GROUP BY
Question 4:First normal form means that the data has been organized in such a manner that it has a primary key and no repeating groups
Ans:True
Question 5:What keyword is added to the select command to retrieve only unique data?
Ans: DISTINCT
QUESTION 6: The more common name for a natural join is a(n) ____.
Ans: inner join
QUESTION 7: What is the difference between deleting all records from a table and truncating the table?
Ans: Delete does not save roll back information while truncate does
QUESTION 8: The purpose of normalization is to store data efficiently in the least possible amount of space.
Ans: False.
QUESTION 9: Assuming a table has several records, if you omit the search condition in the delete query no record will be deleted
Ans:False.
QUESTION 10: How does Oracle keep sequence information unique for each user?
Ans:Each user has a private copy of the sequence It is not always unique
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.