1) In a relational models relations are termed as a) Tuples b) Tables c) Rows d) Attributes e) Columns 2) Identify SQL commands used to Create and manipulate Oracle Database Object structures a) DDL b) DML c) DCL d) TCL 3) A key to represent the relationship between tables is called a) Primary key b) Not Null c) Unique Key d) Foreign Key 4) Which is the correct order, if all the six clauses given below appears in a query? a) SELECT, FROM, WHERE, ORDER BY, HAVING, GROUP BY b) SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY c) SELECT, FROM, WHERE, HAVING, ORDER BY, GROUP BY d) SELECT, FROM, WHERE, HAVING, GROUP BY, ORDER BY 5) The term "Data" refers to: a) The electronic representation of data b) Basic information c) Row Facts and figures d) All of the above 6) Which one of the following is a type of Data Manipulation Command? a) Create b) Alter c) Commit d) Insert e) Select 7) The term "TCL" stands for_____. a) Ternary Control Language b) Transaction Control Language c) Transmission Control Language d) None of the above 8) Which of the following commands is used to save any transaction permanently into the database? a) COMMIT b) SAVEPOINT c) SELECT d) INSERT 9) The term "SQL" stands for a) Standard query language b) Sequential query language c) Structured query language d) Server-side query language 10) Which one of the following commands is used to modify a column inside a table? a) DROP b) ALTER c) UPDATE d) SET

Database Overview

door
Afdrukken
Embedden

Scorebord

Visuele stijl

Opties

Template wisselen

Automatisch opgeslagen activiteit "" herstellen?