DBMS MCQ Test

The syntax for selecting all the columns of the table is:

• SELECT *.* from tablename

• SELECT from tablename

• SELECT * from tablename

• SELECT ALL from tablename

SQL statement that will change the column values in a row.

• SELECT

• UPDATE

• DELETE

• INSERT

Which is the correct syntax for DELETE?

• DELETE FROM <TABLEName> WHERE <Condition>;

• DELETE <Recordname> FROM <TABLEName> WHERE <Condition>;

• DELETE <TABLEName> WHERE <Condition>;

• DELETE FROM <TABLEName> <Condition>;

Table name: PLAYER

NAME(Text)

NUMBER(Number)

POINTS(Number)

Which statement should be executed to return the name and points of the player?

• SELECT * FROM PLAYER;

• SELECT NAME, POINTS FROM PLAYER;

• SELECT NAME, POINTS FROM PLAYER WHERE PLAYER;

• SELECT NAME AND POINTS FROM PLAYER;

Table name: PLAYER

NAME(Text)

NUMBER(Number)

POINTS(Number)

Which statement will successfully append a record from the table?

• INSERT INTO PLAYER VALUES(‘Chong’,’12’,’200’);

• INSERT INTO PLAYER VALUES(Chong,12,200);

• INSERT INTO PLAYER VALUES(“Chong”,’12’,’200’);

• INSERT INTO PLAYER VALUES(‘Chong’,12,200);

Table name: PLAYER

NAME(Text)

NUMBER(Number)

POINTS(Number)

Which statement will successfully edit record of Wayne to Wales from the table?

• UPDATE PLAYER SET NAME=’Wayne’ WHERE NAME=’Wales';

• UPDATE PLAYER SET NAME=’Wayne’;

• UPDATE PLAYER SET NAME=’Wales’ WHERE NAME=’Wayne';

• UPDATE PLAYER SET NAME=’Wales’;

Table name: PLAYER

NAME(Text)

NUMBER(Number)

POINTS(Number)

Which statement should be executed to return the records of the player scoring from 200 above?

• SELECT * FROM PLAYER WHERE POINTS>=200;

• SELECT * FROM PLAYER;

• SELECT * FROM PLAYER WHERE NAME>=WAYNE;

• SELECT * WHERE NAME>=200 FROM PLAYER;

SALES

--------------------------

SALES_DATE DATE

SALES_PERSON CHAR(20)

REGION CHAR(20)

SALES INTEGER

Which of the following SQL statements will remove all rows that had a SALES_DATE in the year 1995?

• DELETE * FROM sales WHERE YEAR(sales_date) = 1995

• DELETE FROM sales WHERE YEAR(sales_date) = 1995

• DROP * FROM sales WHERE YEAR(sales_date) = 1995

• DROP FROM sales WHERE YEAR(sales_date) = 1995

A foreign key

• Links to a primary key in another table. 
• Links to another foreign key. 
• Links to another database system. 
• Should always reference a unique value in the same table. 

An ER diagram shows relationships between:

• Tables in a relational database. 
• Rows in a relational database. 
• Records with foreign keys. 
• Two items about which there is data kept.