Oracle 12c: SQL
3rd Edition
ISBN: 9781305251038
Author: Joan Casteel
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 3, Problem 19MC
Which object in the data dictionary enables you to verify DEFAULT column settings?
- a. DEFAULT_COLUMNS
- b. DEF_TAB_COLUMNS
- c. USER_TAB_COLUMNS
- d. None of the above
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
The INSERT statement needs to specify column names unless _____.
-multiple rows are being inserted into the table with a single statement
-only one row is being inserted into the table
-the values are inserted in the same order as the table's columns
-the values that are being inserted are for columns that are primary keys
What function in the pandas library can display the maximum rows or columns in a table?
A) pd.set_table
B) pd.read_csv
C) pd.set_data
D pd.set_option
Database
Q1:
Which one of the following INSERT statements will successfully insert a single row?
The following table has been created:
CREATE TABLE student_table (
stud_id NUMBER (6),
last_name VARCHAR2 (20),
first_name VARCHAR2 (20),
lunch_num NUMBER (4) ;
a) INSERT VALUES INTO student_table (143354, ‘Roberts’, ‘Cameron’, 6543);
b) INSERT INTO student_table COLMUNS (stud_id, last_name, lunch_num) VALUES (143352,
‘Roberts’, 5543, ‘Cameron’);
c) INSERT TO student_table (stud_id, lunch_num, first_name, last_name) VALUES (143352, 6543,
‘Cameron’, ‘Roberts’);
d) INSERT INTO student_table VALUES (143354, ‘Roberts’, ‘Cameron’, 6543);
Q2:
What does the following SQL statement display:
SELECT EMP_ID, LAST_NAME, SALARY
FROM EMPLOYEES WHERE
SALARY > (SELECT MIN (E. SALARY)
FROM EMPLOYEES E)
ORDER BY SALARY DESC;
a) Employees information who earn less money than the maximum salary
b) Employees information who earn more money than the highest employee salary
c) Employees information who earn…
Chapter 3 Solutions
Oracle 12c: SQL
Ch. 3 - Which command is used to create a table based on...Ch. 3 - Prob. 2RQCh. 3 - What guidelines should you follow when naming...Ch. 3 - What is the difference between dropping a column...Ch. 3 - Prob. 5RQCh. 3 - What happens to the existing rows of a table if...Ch. 3 - Explain the difference between truncating a table...Ch. 3 - Prob. 8RQCh. 3 - What happens if you try to decrease the scale or...Ch. 3 - Are a table and the data contained in the table...
Ch. 3 - Which of the following is a correct statement?
You...Ch. 3 - Prob. 2MCCh. 3 - Which of the following is not a correct...Ch. 3 - Which of the following is not a valid SQL...Ch. 3 - Which of the following is true? a. If you truncate...Ch. 3 - Which of the following commands creates a new...Ch. 3 - Which of the following commands drops any columns...Ch. 3 - Which of the following statements is correct?
A...Ch. 3 - Which of the following commands removes all data...Ch. 3 - Which of the following commands changes a table’s...Ch. 3 - Prob. 11MCCh. 3 - Which of the following is not a valid...Ch. 3 - Which of the following characters can be used in a...Ch. 3 - Which of the following is true?
All data in a...Ch. 3 - Prob. 15MCCh. 3 - Which of the following commands creates a new...Ch. 3 - Which of the following is a valid table name? a....Ch. 3 - Prob. 18MCCh. 3 - Which object in the data dictionary enables you to...Ch. 3 - Prob. 20MCCh. 3 - Create a new table containing the category code...Ch. 3 - Create a new table containing these four columns:...Ch. 3 - Add two columns to the EMPLOYEES table. One...Ch. 3 - Modify the Job_class column of the EMPLOYEES table...Ch. 3 - Prob. 5HOACh. 3 - Rename the EMPLOYEES table as JL_EMPS.
Ch. 3 - Create a new table containing these four columns...Ch. 3 - Prob. 8HOACh. 3 - Truncate the BOOK_PRICING table, and then verify...Ch. 3 - Delete the BOOK_PRICING table permanently so that...
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
- 10. Which of the following PHP statements will execute the query "select * from item": a. $select = mysqli_fetch_array("select * from item"); b. $query = "select * from item"; c. $query = mysqli_num_rows("select * from item"); d. $select = mysqli_query($conn, "select * from item");arrow_forwardWhich of the following is true? (refer to the tables in the JustLee Books database)a. If you truncate a table, you can’t add new data to the table.b. If you change the default value of an existing column, all existing rows containing a NULL value in the same column are set to the new DEFAULT value.c. If you delete a column from a table, you can’t add a column to the table with the same name as the previously deleted column.d. If you add a column to an existing table, it’s always added as the last column of the table.arrow_forwardYou have been instructed to add a new student information to the students table. Because the student is new, he has no marks before, you should not add an amount to the CGPA. The Students table contains these columns: Student_id NUMBER(10) Student_name VARCHAR2(30) Student phone NUMBER(10) CGPA NUMBER(2,2) Which INSERT statements will accomplish your objective? O a. INSERT INTO students VALUES (365, 'Khalil',99554721, 0 ) O b. INSERT INTO students VALUES (365, 'Khalil',99554721, 'NO CGPA' ) O c. INSERT INTO students VALUES (365, 'Khalil',99554721, NULL ) O d. INSERT INTO students VALUES (365, 'Khalil',99554721) Which line of code has an error? 1. CREATE TABLE FRUITS VEGETABLES 2. FRUIT TYPE VARCHAR2, 3. FRUIT NAME CHAR (20), 4. QUANTITY NUMBER (4)); O a. 1 O b. 2 O c. 3arrow_forward
- Create "automatically" the table header represented by the left column, the functions used mysql_list_fields and mysql_field_namearrow_forwardEmployee SearchCreate an application that connects to the Personnel.mdf database that you created in Programming Problem 1. The application's form should display the Employee table in a DataGridView control. The application should let the user specify a name in a text box and then search for that name in the Employee table. The application should display any rows that contain a full or partial match of the specified name. Need help with my code. Not properly pulling up the names. SQL code: SELECT Id, Name, Position, HourlyPay FROM dbo.Employee WHERE Name LIKE '%' C# Code: using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Threading.Tasks;using System.Windows.Forms; namespace Name_Search{public partial class Form1 : Form{public Form1(){InitializeComponent();} private void employeeBindingNavigatorSaveItem_Click(object sender, EventArgs…arrow_forwardQ = insert 5 records into your Courses_xxxx table The fid, rid, aid should not be all the same among the 5 records. The enrollment number should be less than the room size. mysql> select * from Hotel; +---------+---------------+--------+ | hotelno | hotelname | city | +---------+---------------+--------+ | ch01 | Omni Shoreham | London | | ch02 | Phoenix Park | London | | dc01 | Latham | Berlin | | fb01 | Grosvenor | London | | fb02 | Watergate | Paris | +---------+---------------+--------+ 5 rows in set (0.00 sec) mysql> select * from Room; +--------+---------+--------+-------+ | roomno | hotelno | type | price | +--------+---------+--------+-------+ | 501 | fb01 | single | 19.00 | | 601 | fb01 | double | 29.00 | | 701 | ch02 | single | 10.00 | | 701 | fb01 | family | 39.00 | | 801 | ch02 | double | 15.00 | | 901 | dc01 | single | 18.00 | | 1001 | ch01 | single | 29.99 | | 1001 | dc01 |…arrow_forward
- Which of the following data dictionary objects should be used to view information about the constraints in a database? ( refer to the tables in the JustLee Books database). a. USER_TABLES b. USER_RULES c. USER_COLUMNS d. USER_CONSTRAINTS e. None of the above objects should be usedarrow_forwardwith it, paste your code in a text file named Student.txt and save it in your task folder. Write the SQL code to create a table called Student. The table structure is summarised in the table below (Note that STU_NUM is the primary key): STU_NUM Attribute Name STU_SNAME STU_FNAME STU_INITIAL STU_STARTDATE COURSE_CODE PROJ_NUM STU STU_S STU_F STU_INITIAL NUM NAME NAME 01 02 Snow John E CHAR(6) After you have created the table in question 1, write the SQL code to enter the first two rows of the table as below: Stark Arya с VARCHAR(15) VARCHAR(15) CHAR(1) DATE CHAR(3) INT(2) Data Type STU_STARTDATE COURSE_ PROJ_ CODE NUM 05-Apr-14 12-Jul-17 201 305 6 11 Assuming all the data in the Student table has been entered as shown below, write the SQL code that will list all attributes for a COURSE_CODE of 305.arrow_forwardO d. ALTER TABLE tableName MODIFY COLUMN columnName DATATYPE(S) What will be the result after executing this statement: SELECT SUBSTR('International', 6, 6) FROM dual? Oa tional O b. nation O c. Intern O d. national Which of the following is an exnmole of group function?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Np Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage
- A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology PtrCOMPREHENSIVE MICROSOFT OFFICE 365 EXCEComputer ScienceISBN:9780357392676Author:FREUND, StevenPublisher:CENGAGE LProgramming with Microsoft Visual Basic 2017Computer ScienceISBN:9781337102124Author:Diane ZakPublisher:Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
Publisher:Cengage Learning
dml in sql with examples; Author: Education 4u;https://www.youtube.com/watch?v=WvOseanUdk4;License: Standard YouTube License, CC-BY