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

Info Man F3

QuestionAnswer
One purpose why SQL was standardized was to define data structures and basic operations in SQL. True
What is a set of schemas that constitute the description of a database? Catalog
What is the datatype that stores binary string values in hexadecimal format? BLOB
Identify the parts of the SQL worksheet. What is number 1 on the figure 5.1 Execution / Execute statement
Identify the parts of the SQL worksheet. What is number 2 on the figure 5.1 Run Script
Identify the parts of the SQL worksheet. What is number 3 on the figure 5.1 Commit (?)
Identify the parts of the SQL worksheet. What is number 4 on the figure 5.1 Rollback (?)
Identify the parts of the SQL worksheet. What is number 5 on the figure 5.1 Cancel
Identify the parts of the SQL worksheet. What is number 6 on the figure 5.1 SQL history
Identify the parts of the SQL worksheet. What is number 7 on the figure 5.1
Identify the parts of the SQL worksheet. What is number 8 on the figure 5.1 Autotrace
Identify the parts of the SQL worksheet. What is number 9 on the figure 5.1 Clear
Legrant command is one of the commands of the DCL. True
Launching of the SQL worksheet is found in the source tab of the SQL developer. False
What is a data type in SQL that stores a moment and event occurs using a definable fraction of a second precision? Time stamp
What is the language that is standard for relational database management system SQL
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
What data type consists of date and time values date
A table is a basic unit of storage which is composed of rows and columns True
To remove the table and all its data entirely, use purge after the drop table command. True
What is a statement that allows you to rename an existing column in an existing table in any schema rename column
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
The drop table statement allows you to remove tables from your schema. True
What data type has a variable length character data varchar2
Naming table names and column names should not duplicate the name of another object owned by the same user. True
In naming table names and column names,the name should not be an Oracle server reserved word. True
To execute a line of SQL statement, you can use either execute statement or run script provided it is only one SQL line. True
The system R with sequel later became SQL. True
IBM created the system R with sequel. True
In 1988, ANSI first released the SQL standard. False 1986
In 1986, ANSI first released the SQL standard. True
During the database development process the defining of the database is done in the physical design True
Reduction of training costs is one of the benefits of standardization of SQL. True
In which year did Oracle markets its first relational database with SQL? 1979
The abbreviation of SQL is Structured Query Language. True
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
What data type has a variable length character data that is up to two GB long
Which of the following code will change the Sname column to not null in figure 6A and 6B? alter table salesman modify sname varchar(30) not null;
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 data type is a fixed length character data char (formative shows 'car')
What statement can you use to put the table back into a read or write mode from a read mode only table? Read Write
Given the SQL statement: Alter table sample1 drop column ID; , this statement deletes the table sample1. False
Which among the following SQL codes will create these two entities in figure 6.2 (part1) create table employee(employeeid number(10)not null, firstname varchar2(100),lastname varchar2(100),departmentid numeric(11,0), constraint emp_pk primary key(employeeid),constraint emp_fk foreign
(part2) key(departmentid)references department(departmentid));create table department(departmentid numeric(11,0) not null primary key,deptname varchar2(100), roomNo number(10));
What is a foreign key constraint keyword the defines the column in the child table at table-constraint level? Foreign key
The transaction control has the following commands: commit, rollback and save point. True
Productivity is one of the benefits of a standardized relational language. True
The create command is one of the commands of data manipulation language. False
The select command is one of the commands of data manipulation language True
What is a data type that stores exact numbers with a predefined precision and scale of zero Integer
In 1987, ANSI first released the SQL standard. False ,1986
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
A DDL SQL statement that removes all rows from a table, leaving the table empty and the table structure intac TRUNCATE
Relational integrity is enforced via the primary-key to foreign-key match. True
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
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
What is a variable length numeric data kind of data type number
The select command is one of the commands of data manipulation language. True
In 1970, the relational database concept was developed. True
Reduce dependence on single vendor is one of the benefits of a standardized relational language. True
Standardization of SQL allows for later growth/enhancement of the standard. True
To execute a sequence of SQL statements, you should click the run script button instead of the execute statement button. False
These enforces rules at the table level and prevents the deletion of a table if there are dependencies CHECK
The table names and column names should have a duplicate name with other tables and other columns False
A user can name a constraint or Oracle server generates a name by using the SYS_CN format True
What is a foreign key constraint keyword that converts dependent foreign key values to null. On delete set null
What is a data type the store's exact numbers with a defined precision and scale numeric
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)
What statement can you use to put the table into read mode which prevents DDL or DML changes during table maintenance? Read only
Some primary keys are composite keys. True
You can view a constraint inside a table in the database False
Which among the following statements will create a table with two columns CREATE TABLE STUDENT (Studentid numeric(4,2), studentfirstname varchar2(50));
Defining constraint can be done at the column or at the table level True
What is a data type that stores string values containing any characters in the character set? Character Varying
In figure 5.2, in number 2, this is where the results of the SQL statement is shown. True
In figure 5.2, in number 1, this is where the results of the SQL statement is shown. dont know if this is a question but, this is where you put code
In which year was the first available RDBMS system on DOS/VSE 1981
Who is the person who developed the relational database concept? Edgar F. Codd
Change the column name of Sname to SalesmanName. Use figure 6A and 6B. alter table salesman rename column sname to SalesmanName;
The flashback table statement enables you to recover tables to a specified point in time with a single statement. True
When you drop a table from the database it moves the table to the recycle bin. True
You can review the definitions of objects at a glance in the connections navigator of your SQL developer. True
Dependence on a single vendor is a benefit of a standardized relational languag False
Given the SQL statement: CREATE TABLE SAMPLE1 (ID NUMERIC(10) NOT NULL PRIMARY KEY, DESCRIPTION VARCHAR2(100)); ,which command makes an attribute a unique key? primary key
Creating a constraint is only done at the time when the table is created False
Given the SQL statement: Alter table sample1 drop column ID; , this statement deletes the column ID. 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));
The abbreviation of SQL is Standard Query Language. False
The rename and the update are both commands in data definition language. 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 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
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 varchar2(100));
Writing and executing SQL, PL/SQL an SQL *plus statements are done on notepad in SQL developer? False
Constraints prevent the deletion of a table if there are dependencies True
In figure 5.2, in number 1, this is where you enter SQL statements. True
What is a foreign key constraint keyword that identifies the table and column in the parent table. References
Created by: xd-xdd
 

 



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