Save
Upgrade to remove ads
Busy. Please wait.
Log in with Clever
or
show password
Forgot Password?
Don't have an account?  Sign up 
Sign up using Clever
or
Username is available taken
show password


Make sure to remember your password. If you forget it there is no way for StudyStack to send you a reset link. You would need to create a new account. Your email address is only used to allow you to reset your password. See our Privacy Policy and Terms of Service.

Already a StudyStack user? Log In

Reset Password
Enter the associated with your account, and we'll email you a link to reset your password.
focusNode
Didn't know it?
click below
 
Knew it?
click below
Don't Know
Remaining cards (0)
Know
0:00
edit
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.

  Normal Size     Small Size show me how

Information LEC[FA3]

CCS0021

QuestionAnswer
A DDL SQL statement that removes all rows from a table, leaving the table empty and the table structure intact TRUNCATE
[True or False] Defining constraint can be done at the column or at the table level True
What data type consists of date and time values date
[True or False] A user can name a constraint or Oracle server generates a name by using the SYS_CN format True
[True or False] One purpose why SQL was standardized was to define data structures and basic operations in SQL. True
What is a data type in SQL that stores a moment and event occurs using a definable fraction of a second precision? Time stamp
[True or False] During the database development process the defining of the database is done in the physical design True
Identify the parts of the SQL worksheet. What is number 7 on the figure 5.1 Execute explain plan
[True or False] You can review the definitions of objects at a glance in the connections navigator of your SQL developer. True
[True or False] In figure 5.2, in number 2, this is where the results of the SQL statement is shown. True
Identify the parts of the SQL worksheet. What is number 2 on the figure 5.1 Run Script
[True or False] To execute a sequence of SQL statements, you should click the run script button instead of the execute statement button. False
[True or False] In 1986, ANSI first released the SQL standard. True
[True or False] Standardization of SQL allows for later growth/enhancement of the standard. True
What is a foreign key constraint keyword the defines the column in the child table at table-constraint level? Foreign key
What statement can you use to put the table into read mode which prevents DDL or DML changes during table maintenance? Read only
What is a data type that has a base of 64 number system representing the unique address of a row in its table row ID
What is a foreign key constraint keyword that deletes the dependent rows in the child table when a row in the parent table is deleted. On delete cascade
What data type consists of date and time values date
[True or False] Some primary keys are composite keys. True
[True or False] You can view a constraint inside a table in the database False
These enforces rules at the table level and prevents the deletion of a table if there are dependencies CHECK
[True or False] In 1988, ANSI first released the SQL standard. False
Identify the parts of the SQL worksheet. What is number 9 on the figure 5.1 Clear
Identify the parts of the SQL worksheet. What is number 1 on the figure 5.1 Execute statement
Identify the parts of the SQL worksheet. What is number 8 on the figure 5.1 Autotrace
[True or False] In 1987, ANSI first released the SQL standard. False
[True or False] IBM created the system R with sequel. True
[True or False] The system R with sequel later became SQL. True
What is a database management system that manages data as a collection of tables in which all relationships are represented by a common values in related tables? RDBMS
[True or False] A table is a basic unit of storage which is composed of rows and columns True
What data type has a variable length character data that is up to two GB long
[True or False] Given the SQL statement: Alter table sample1 drop column ID; , this statement deletes the table sample1. False
[True or False] Constraints prevent the deletion of a table if there are dependencies True
What data type is a binary data stored in external file which is up to four GB Bfile
[True or False] You can define a constraint of the column level only False
[True or False] In naming tables and column names in database it must begin with the letter and must contain only alphanumeric characters, an underscore, a dollar sign or a number sign. True
[True or False] Creating a constraint can be done at the same time as the creation of the table or after the creation of the table True
What is the abbreviation of DDL? data definition language
[True or False] Reduce dependence on single vendor is one of the benefits of a standardized relational language. True
[True or False] The select command is one of the commands of data manipulation language. True
What is a data type that stores string values containing any characters in the character set? Character Varying
What is the language that is standard for relational database management system SQL
What is the structure that contains descriptions of objects created by a user? Schema
[True or False] Relational integrity is enforced via the primary-key to foreign-key match. True**
What data type has a variable length character data varchar2
[True or False] Naming table names and column names should not duplicate the name of another object owned by the same user. True
What statement can you use to put the table back into a read or write mode from a read mode only table? Read Write
[True or False] Given the SQL statement: ALTER TABLE emp2 ADD CONSTRAINT emp_mgr_fk FOREIGN KEY(manager_id) REFERENCES emp2(employee_id);, the statement adds a new constraint to the table emp2 that sets the manager_id to foreign key of the emp2 table. True
Identify the parts of the SQL worksheet. What is number 3 on the figure 5.1 Commit
[True or False] The transaction control has the following commands: commit, rollback and save point. True
What is a data type the store's exact numbers with a defined precision and scale numeric
[True or False] In 1970, the relational database concept was developed. True
What is the datatype that stores binary string values in hexadecimal format? BLOB
[True or False] Dependence on a single vendor is a benefit of a standardized relational languag False
Identify the parts of the SQL worksheet. What is number 6 on the figure 5.1 SQL History
[True or False] The abbreviation of SQL is Standard Query Language. False
[True or False] When you drop a table from the database it moves the table to the recycle bin. True
Given the SQL statement: CREATE TABLE SAMPLE1 (ID NUMERIC(10) NOT NULL PRIMARY KEY, DESCRIPTION VARCHAR2(100), Valueid numeric(10), constraint sam_fk(valueid) references Value(valueid)); , which command sets an attribute to a foreign key? sam_fk(valueid)
[True or False] The table names and column names should have a duplicate name with other tables and other columns False
[True or False] To remove the table and all its data entirely, use purge after the drop table command. True
[True or False] Productivity is one of the benefits of a standardized relational language. True
[True or False] During the maintenance phase of the database development process the controlling of the database is found here, like grant add and revoked commands? True
[True or False] Writing and executing SQL, PL/SQL an SQL *plus statements are done on notepad in SQL developer? False
[True or False] The abbreviation of SQL is Structured Query Language. True
Identify the parts of the SQL worksheet. What is number 5 on the figure 5.1 Cancel
[True or False] Loading the database by inserting data, updating the database, and manipulating the database are parts of the implementation process during the database development process. True
In which year did Oracle markets its first relational database with SQL? 1979
[True or False] The create command is one of the commands of data manipulation language. False**
Identify the parts of the SQL worksheet. What is number 4 on the figure 5.1 Rollback
[True or False] Reduction of training costs is one of the benefits of standardization of SQL. True
[True or False] The flashback table statement enables you to recover tables to a specified point in time with a single statement. True
What SQL statement will change the name of the column salesman_id to Sid? Use the figures 6A and 6B. alter table salesman rename column salesman_id to SId;
What SQL statement will create the entity shown in figure 6.1 Create table employee(employeeId numeric(11,0) not null primary key, firstname varchar(100), lastname (100));
[True or False] Legrant command is one of the commands of the DCL. True
What data type is a fixed length character data car
[True or False] The syntax to create a table is CREATE TABLE [schema.]table (column datatype [DEFAULT expr] [column_constraint], ... [table_constraint][,...]);. True
Which of the following code will create the table salesman in figure 6A and 6B? Create table salesman (salesman_id number(5) not null primary key, sname varchar2(30), city varchar2(15), commission number(5,2), salary number(11,2));
Given the SQL statement: CREATE TABLE SAMPLE1 (ID NUMERIC(10) NOT NULL PRIMARY KEY, DESCRIPTION VARCHAR2(100));, which command that makes an attribute not nullable not null
Created by: AdoKwatro
 

 



Voices

Use these flashcards to help memorize information. Look at the large card and try to recall what is on the other side. Then click the card to flip it. If you knew the answer, click the green Know box. Otherwise, click the red Don't know box.

When you've placed seven or more cards in the Don't know box, click "retry" to try those cards again.

If you've accidentally put the card in the wrong box, just click on the card to take it out of the box.

You can also use your keyboard to move the cards as follows:

If you are logged in to your account, this website will remember which cards you know and don't know so that they are in the same box the next time you log in.

When you need a break, try one of the other activities listed below the flashcards like Matching, Snowman, or Hungry Bug. Although it may feel like you're playing a game, your brain is still making more connections with the information to help you out.

To see how well you know the information, try the Quiz or Test activity.

Pass complete!
"Know" box contains:
Time elapsed:
Retries:
restart all cards