PBD teorie

Question 1

Question

Comanda DESCRIBE afiseasza toate datele unui tabel.

Answer

True
False

Question 2

Question

Care dintre urmatoarele operatii pot fi executate asupra unei vederi , indiferent de definitia sa?

Answer

INSERT
UPDATE
DELETE
SELECT

Question 3

Question

MERGE este o comanda SQL care se executa asupra mai multor tabele.

Answer

True
False

Question 4

Question

Intr-o interogare SQL in care, in clauza FROM sunt mai multe tabele, pentru realizarea jonctiunii este obligatorie si clauza:

Answer

where
from
group by

Question 5

Question

Operanzii utilizati impreuna cu operatorii pe multimi ( SET) trebuie sa fie compatibili la

Answer

reuniune
intersectie

Question 6

Question

Urmatoarea interogare intoarce eroare: UPDATE angajati SET salariu = ( SELECT salariu FROM angajati WHERE id_angajat IN (100,101,102)) WHERE id_angajat = 110;

Answer

True
False

Question 7

Question

Fie tabelul : Student (matricol ,nume,prenume,cnp,medie_admitere)

Answer

Insert into student values ( 'FIESCC123','Dan','9.30);
INSERT INTO student (nume,prenume,medie_admitere) values ('Popa','Dan',9.30);
INSERT INTO student values ( 'FIESCC123', 'Popa','Dan','2610711335102',9.30);
INSERT INTO student(nume,prenume,medie_admitere) VALUES('Popa','Dan','9.30');

Question 8

Question

Care din operatii pe multimi (SET) este echivalent cu urmatoarea interogare: Select department_id From employees Where departments_id NOT IN (SELECT department_id FROM employees)

Answer

MINUS
INTERSECT
UNION

Question 9

Question

Intr-o instructiune UPDATE se pot folosi exclusiv subinterogari scalare

Answer

True
False

Question 10

Question

Completati urmatoarea interogare SQL: SELECT employee_id, last_name,job_id, manager_id, ..... FROM employees CONNECT BY PRIOR employee_id = manager_id;

Answer

LEVEL
UNION

Question 11

Question

Intr-o interogare SQL , clauza care ne permite sa specificam acele campuri care vor fi afisate in rezultat este:

Answer

SELECT
AS

Question 12

Question

SE doreste afisarea numarul de angajati din fiecare departament. Care din urmatoarele interogari este / sunt corecte? A. Select department_id, count(*) from employees B. SELECT department_id, count(employee_id) FROM employees Group by department_id; C. Select department_id, count(*) From employees Group by department_id; D. SELECT department_id,employee_id,count(employee)id) From employees Group By department_id;

Answer

Question 13

Question

In schema unui utilizator pot exista mai multe obiecte de acelasi tip cu acelasi nume

Answer

True
False

Question 14

Question

Care din urmatoarele instructiuni SQL au efect asupra metadatelor dintr-o baza de date?

Answer

ALTER(tabele),DROP,CREATE
UPDATE(inregistrari)
DELETE(inregistrari)
INSERT(inregistrari)

Question 15

Question

Ce clauza trebuie utilizata intr-o instructiune SELECT pentru a limita afisarea inregistrarilor la acei angajati care au salarii mai mari de 5000?

Answer

Having SALARY>5000
WHERE SALARY>5000
ORDER BY SALARY >5000
GROUP BY SALARY > 5000

Question 16

Question

Operatorul ............. face reuniunea a 2 tabele si elimina eventualele duplicate.

Answer

UNION
INTERSECT

Question 17

Question

Pentru a afisa data intr-o interogare SQL se foloseste functia select ...... from dual

Answer

sysdate
from_dual

Question 18

Question

O Instructiune de manipulare a datelor (UPDATE,INSERT,DELETE) inregistrari:

Answer

valideaza o tranzactie intr-un table
modifica structura unui table fara a afecta datelor continute de acestia
modifica structura datelor dintr-un table
modifica datele unui table fara a afecta structura acesteia.

Question 19

Question

Tabelul pe care trebuie sa il folositi intr-o interogare SQL pentru a afisa data curenta este :

Answer

Tabelul_dual
sys_date

Question 20

Question

Fie urmatoarea declaratie SQL: CREATE VIEW vederea_mea AS SELECT employee_id, first_name, last_name, salary FROM employees; Ce se stocheaza in baza de date in urma executiei acesteia?

Answer

atat metadatele cat si datele rezultate din ececutia declaratiei SELECT
datele rezultate din rezolvarea declaratiei SELECT
metadatele corespunzatoare vederii

Question 21

Question

Urmatoare interogare intoarce eroare? UPDATE angajati SET salariu = ( SELECT salariu FROM angajati WHERE id_angajat =102) WHERE ID_angajat = 110

Answer

True
False

Next up

Description

Resource summary

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7

Question 8

Question 9

Question 10

Question 11

Question 12

Question 13

Question 14

Question 15

Question 16

Question 17

Question 18

Question 19

Question 20

Question 21

Similar

	Created by Emanuel Grigoras over 3 years ago