SELECT FNAME, LNAME,SALARY FROM EMP WHERE DNO=1005;
22년 3회
18. SQL에 대한 다음 설명에서 괄호에 들어갈 알맞은 명령어를 쓰시오.
SQL의 하나인 DDL은 DB 구조, 데이터 형식, 접근 방식 등 DB를 구축하거나 수정할 목적으로 사용하는 언어로, 다음 3가지 명령어를 사용하여 표현한다. ( 가 ) : 스키마, 도메인, 테이블 등의 개체를 정의하는 데 사용하는 명령어 ( 나 ) : 개체에 대한 정의를 변경하는 데 사용하는 명령어 ( 다 ) : 스키마, 도메인, 테이블 등의 개체를 삭제하는 데 사용하는 명령어
19. 다음은 Company 테이블을 생성하는 SQL문이다. company 테이블의 TITLE 속성에는 Intern, Staff, Manager, Director, President 값만 허용할 수 있도록 <SQL문> (가) 와 (나)에 적합한 단어를 쓰시오
CREATE TABLE COMPANY(
ID INT NOT NULL,
NAME VARCHAR(20) NOT NULL,
AGE INT NOT NULL,
TITLE VARCHAR(20) (가) (TITLE(나) ('Intern','Staff','Manager','Director','President'))
);
지갑안에 신용카드(credit)와 신분증(id)이 있고 카드(card)를 가지고 있다. 대중교통을 이용하는데 지갑 안에 현급(cash)이 있다면 택시를 이용하고 현금이 없는 경우 카드가 있는지 확인하고 카드가 있다면 버스를 이용한다 만약 현금과 카드 둘다 없다면 도보를 이용한다
class Test {
public static void main(String args[]) {
int a=26;
int b=91;
int g=0;
int c=a<b?a:b;
for(int i=1; i<c;i++){
if(a%i==0 && b%i==0)
g=i;
}
System.out.print(g);
}
}
class Main {
public static void main(String args[]) {
int[] a=new int[8];
int i=0;
int n=11;
while(n>0){
a[i++]=n%2;
n/=2;
}
for(i=7;i>=0;i--)
System.out.print("%d",a[i]);
}
}
public class Main {
static int a = 0;
static int func(int t) {
a = a+t;
return a;
}
public static void main(String[] args) {
for(int i=0; i<5; i++) {
func(i);
}
System.out.print(a);
}
}
class A {
int f(int a, int b) {
return a+b;
}
}
public class Main {
public static void main(String[] args) {
A a = new A();
System.out.print(a.f(25, 25));
}
}
public class Test{
public static void main(String [] args) {
int a[] = {1, 2, 3, 4, 5, 6};
int sum = 0;
for(int i:a) {
sum += i;
}
System.out.print(sum);
}
}
public class Test
{
int A(int a, int b) {
System.out.print(a+b);
return a*b;
}
public static void main(String[] args) {
Test a = new Test( );
System.out.print(a.A(5,5));
}
}
class Printer {
void print(Integer a) {
System.out.print("A" + a);
}
void print(Object a) {
System.out.print("B" + a);
}
void print(Number a) {
System.out.print("C" + a);
}
}
public class Main {
public static void main(String[] args) {
new Collection<>(0).print();
}
public static class Collection<T> {
T value;
public Collection(T t) {
value = t;
}
public void print() {
new Printer().print(value);
}
}
}
#include<stdio.h>
int main() {
int d = 55;
int n = 4;
int r = 0, q = 0;
r = d;
while(r >= 4) {
r = r - n;
q++;
}
printf("%d 그리고 ", q);
printf("%d", r);
}
#include<stdio.h>
int compare(int i, int j, int *ma, int *in) {
if(i>j) {
*ma = j;
*in = i;
}
else {
*ma = i;
*in = j;
}
}
int main() {
int max = 0;
int min = 0;
compare(3, 7, (가), (나));
printf("작은수:%d 큰수:%d", max, min);
}
#include <stdio.h>
struct number {
float i;
float j;
};
int main() {
struct number a = {3.0, 4.0};
struct number b = {4.0, 5.0};
printf("%.2f 그리고 %.2f", a.i+b.i, a.j + b.j);
}
#include <stdio.h>
union Number {
int intV;
int floatV;
};
struct data {
union Number n1;
union Number n2;
char islnt;
};
void func(struct data *a) {
if (a->islnt) {
a->n1.intV +=a->n2.intV;
}
else {
a->n1.floatV += a->n2.floatV;
}
}
int main() {
struct data a = {{.intV = 5}, {.floatV = 3.5}, 1};
func(&a);
printf("%d", a.n1.intV);
return 0;
}
#include <stdio.h>
int factorial(int n, int from, int to, int temp) {
if(n == 0) {
return 0;
}
else {
return factorial(n-1, from, temp, to)+1 + factorial(n-1, temp, to, from);
}
}
int main( ) {
int n = 3;
printf("%d", factorial(n, 3, 2, 1));
return 0;
}
3. 아래의 employee테이블과 project테이블을 참고하여 보기의 SQL명령어에 알맞는 출력 값을 작성하시오.
SELECT
count(*)
FROM employee AS e JOIN project AS p ON e.project_id = p.project_id
WHERE p.name IN (
SELECT name FROM project p WHERE p.project_id IN (
SELECT project_id FROM employee GROUP BY project_id HAVING count(*) < 2
)
);
def fnCalculation(x,y):
result = 0;
for i in range(len(x)):
temp = x[i:i+len(y)]
if temp == y:
result += 1;
return result
a = "abdcabcabca"
p1 = "ab";
p2 = "ca";
out = f"ab{fnCalculation(a,p1)}ca{fnCalculation(a,p2)}"
print(out)
class Main {
static int[] arr() {
int a[]=new int[4];
int b = a.length;
for(int i =0; i<b;i++)
a[i]=i;
return a;
}
public static void main(String args[]) {
int a[]=arr();
for(int i =0; i< a.length; i++)
System.out.print(a[i]+" ");
}
}
class A{
private int a;
public A(int a){
this.a = a;
}
public void display(){
System.out.println("a=" + a);
}
}
class B extends A {
public B(int a){
super(a);
super.display();
}
}
public class Main {
public static void main(String[] args){
B obj = new B(10);
}
}
abstract class Vehicle{
String name;
abstract public String getName(String val);
public String getName(){
return "Vehicle name:" + name;
}
}
class Car extends Vehicle{
private String name;
public Car(String val){
name=super.name=val;
}
public String getName(String val){
return "Car name : " + val;
}
public String getName(byte val[]){
return "Car name : " + val;
}
}
public class Main {
public static void main(String[] args){
Vehicle obj = new Car("Spark");
System.out.print(obj.getName());
}
}
public class Main {
public static void main(String[] args){
int i=0, sum=0;
while (i<10){
i++;
if(i%2 ==1)
continue;
sum += i;
}
System.out.println(sum);
}
}
7번 다음은 변수 n에 저장된 10진수를 2진수로 변환하여 출력하는 java프로그램이다. 프로그램을 분석하여 ( 1번 )( 2번 )빈칸에 알맞은 답을 쓰시오
class Main {
public static void main (String[] args) {
int[]a = new int[8];
int i=0; int n=10;
while ( 1번 ) {
a[i++] = ( 2번 );
n /= 2;
}
for(i=7; i>=0; i--){
System.out.print(a[i]);
}
}
}
public class Main {
public static void main(String[] args) {
int ary[][] = new int[가][나];
for(int i = 0; i <3; i++){
for(int j=0; j < 5; j++){
ary[i][j] = j*3+(i+1);
System.out.print(ary[i][j]+"");
}
System.out.println();
}
}
}
class Parent{
public int compute(int num){
if(num <=1) return num;
return compute(num-1) + compute(num-2);
}
}
class Child extends parent {
public int compute(int num){
if(num<=1) return num;
return compute(num-1) + compute(num-3);
}
}
class Main{
public static void main (String[] args){
Parent obj = new Child();
System.out.print(obj.compute(4));
}
}
public class Main{
public static void main(String[] args){
int arr[][] = new int[][]{{45,50,75},{89}};
System.out.println(arr[0].length);
System.out.println(arr[1].length);
System.out.println(arr[0][0]);
System.out.println(arr[0][1]);
System.out.println(arr[1][0]);
}
}
public class Main {
public static void main(String[] args){
int i, j;
for(j=0, i=0; i<=5; i++){
j+=i;
System.out.print(i);
if(i==5){
System.out.print("=");
System.out.print(j);
} else{
System.out.print("+");
}
}
}
}
public class ovr1 {
public static void main(String[] args){
ovr1 a1 = new ovr1();
ovr2 a2 = new ovr2();
System.out.println(a1.sun(3,2) + a2.sun(3,2));
}
int sun(int x, int y){
return x + y;
}
}
class ovr2 extends ovr1 {
int sun(int x, int y){
return x - y + super.sun(x,y);
}
}
public class Main{
public static void main(String[] args) {
int a = 3, b = 4, c = 3, d = 5;
if((a == 2 | a == c) & !(c > d) & (1 == b ^ c != d)) {
a = b + c;
if(7 == b ^ c != a) {
System.out.println(a);
} else {
System.out.println(b);
}
} else {
a = c + d;
if(7 == c ^ d != a) {
System.out.println(a);
} else {
System.out.println(d);
}
}
}
}
class A {
int a;
int b;
}
public class Main {
static void func1(A m){
m.a *= 10;
}
static void func2(A m){
m.a += m.b;
}
public static void main(String args[]){
A m = new A();
m.a = 100;
func1(m);
m.b = m.a;
func2(m);
System.out.printf("%d", m.a);
}
}
class Car implements Runnable{
int a;
public void run(){
try{
while(++a<100){
System.out.println("miles traveled :" +a);
Thread.sleep(100);
}
}
catch(Exception E){}
}
}
public class Main{
public static void main(String args[]){
Thread t1 = new Thread(new (가)());
t1.start();
}
}
class Main {
public static void main(String args[]) {
int i=3, k=1;
switch(i){
case 1:k+=1;
case 2:k++;
case 3:k=0;
case 4:k+=3;
case 5:k-=10;
default : k--;
}
System.out.print(k);
}
}
class Conv{
public Conv(int a){
this.a=a;
}
int func(){
int b=1;
for(int i =1;i<a;i++){
b=a*i+b;
}
return a+b;
}
}
public class Main {
public static void main(String args[]) {
Conv obj=new Conv(3);
obj.a=5;
int b=obj.func();
System.out.print(obj.a+b);
}
}
public class Exam {
public static void main(String[] args){
int a = 0;
for(int i=1; i<999; i++){
if(i%3==0 && i%2!=0)
a = i;
}
System.out.print(a);
}
}
class Static{
public int a=20;
static int b=0;
}
public class Main {
public static void main(String[] args) {
int a=10;
Static.b=a;
Static st=new Static();
System.out.println(Static.b++);
System.out.println(st.b);
System.out.println(a);
System.out.println(st.a);
}
}
abstract class Vehicle{
String name;
abstract public String getName(String val);
public String getName(){
return "Vehicle name:" + name;
}
}
class Car extends Vehicle{
private String name;
public Car(String val){
name=super.name=val;
}
public String getName(String val){
return "Car name : " + val;
}
public String getName(byte val[]){
return "Car name : " + val;
}
}
public class Main {
public static void main(String[] args){
Vehicle obj = new Car("Spark");
System.out.print(obj.getName());
}
}
public class Main {
public static void main(String[] args) {
A b = new B();
b.paint();
b.draw();
}
}
class A {
public void paint() {
System.out.print("A");
draw();
}
public void draw() {
System.out.print("B");
draw();
}
}
class B extends A {
public void paint() {
super.draw();
System.out.print("C");
this.draw();
}
public void draw() {
System.out.print("D");
}
}
class Person {
private String name;
public Person(String val) {
name = val;
}
public static String get() {
return name;
}
public void print() {
System.out.println(name);
}
}
public class Main {
public static void main(String[] args) {
Person obj = new Person("Kim");
obj.print();
}
}
class classOne {
int a, b;
public classOne(int a, int b) {
this.a = a;
this.b = b;
}
public void print() {
System.out.println(a + b);
}
}
class classTwo extends classOne {
int po = 3;
public classTwo(int i) {
super(i, i+1);
}
public void print() {
System.out.println(po*po);
}
}
public class main {
public static void main(String[] args) {
classOne one = new classTwo(10);
one.print();
}
}
class Main {
public static void main(String[] args) {
int[] a = new int[]{1, 2, 3, 4};
int[] b = new int[]{1, 2, 3, 4};
int[] c = new int[]{1, 2, 3};
check(a, b);
check(a, c);
check(b, c);
}
public static void check(int[] a, int[] b) {
if (a==b) {
System.out.print("O");
}else{
System.out.print("N");
}
}
}
class Main {
public static void main(String[] args) {
String str = "ITISTESTSTRING";
String[] result = str.split("T");
System.out.print(result[3]);
}
}
public class Main{
public static void main(String[] args){
Base a = new Derivate();
Derivate b = new Derivate();
System.out.print(a.getX() + a.x + b.getX() + b.x);
}
}
class Base{
int x = 3;
int getX(){
return x * 2;
}
}
class Derivate extends Base{
int x = 7;
int getX(){
return x * 3;
}
}
public class ExceptionHandling {
public static void main(String[] args) {
int sum = 0;
try {
func();
} catch (NullPointerException e) {
sum = sum + 1;
} catch (Exception e) {
sum = sum + 10;
} finally {
sum = sum + 100;
}
System.out.print(sum);
}
static void func() throws Exception {
throw new NullPointerException();
}
}
class Main {
public static class Collection<T>{
T value;
public Collection(T t){
value = t;
}
public void print(){
new Printer().print(value);
}
class Printer{
void print(Integer a){
System.out.print("A" + a);
}
void print(Object a){
System.out.print("B" + a);
}
void print(Number a){
System.out.print("C" + a);
}
}
}
public static void main(String[] args) {
new Collection<>(0).print();
}
}
